 that training video, we're going to look at freeze pains applied to Excel, and then print in with freeze pains on. So, we've got free paint applied to this worksheet right now. So, I want to look at, print in the receipts for all the single rooms, down to Ms Aeneas, as well as the turn off information. ond oedd yn gofynol y nifer lle i'r mwynt. I'n gweithio'r lluniau meddwl ar y lluniau. Mae'n gweithio'r lluniau mewn meddwl ar y dweud. Ac mae'n rhai i'ch bwysig ym mwynt o'r ysgolol a'r mwynt o'r mwynt i'ch beth yna mwynt. Yn gofynol lluniau meddwl hefyd, yw'n gofyn nhw'n gofyn ar y pryd. We're going to file print and look at the preview, what it's showing, it's showing January, February, March, so the print is not in effect mirroring the freeze panes that is in excel right now, so print is working very very different and this would now print all of excel because the sixth page is done at the bottom here and here's page one for example, January, February, March, roi 450 bom Quite then you go through more months may to September and is just more and more information which is not relevant to what I want to print in this example. So, I want to print the information for the last three months as I've got on screen ready in Flee's Pines now this is where a feature called page set up is really really useful and depends on the version you've got. there will be on the view tab there's Mae'r rŵel mewn llawer yn y dweud, mae'r ddaf i'r ddweud yn y dyfodol... ...a'r ddweud o'r ddweud. Mae hwn yn y ddiwrnod yng Nghargoedd Llywodraeth Llywodraeth... ..y'r ddweud y dyfodol, mae'r ddweud... ..on y ddweud o'r ddweud o'r ddweud. Ydw i ddweud o'r ddweud. Felly rwy'n meddwl na'r ddweud o'r ddweud, mae'n meddwl o'r ddweud o'r ddweud. Ac rwy'n dweud y cwyddo'r cywaint. Mae'n rhaid i'w rhaid i'w ddechrau cwyddo'r cywaint, gyda drooddau, mawr cymans, mae'r gweithio popolaeth o'r cymans. Rydyn ni'n gofio'r cymans a mae'n cael. Mae ni ddechrau'r cymans. Mae'r cymans o'r cymans a mae'n gweithio i gweithio i gweithio. Mae'n gweithio i gweithio. Mae'n gweithio i gweithio. Mae gweithio i'w gwneud. I can see it's already been added on mine, so that's all I did, I found page setup, added it, and now I can use it. So some of the features on Microsoft which you can't maybe find which you might have used, because different versions take things in and out of Microsoft, I've always used this for printing and I find it very, very useful. So it's not in the latest version that I'm looking at, so I've added it to the Quick Access Toolbar but I find it's extremely useful for printing. So I'm going to cancel this now and I'm going to use it. So here's page setup, and this box is how I find printing, to how I have to manage printing easiest using this box. And that's just through my own preference, but this is where I advise people to use it, and this might have different ways. So I'm going to use page setup. Now I want the print to be in Lans in portrait, I'll keep it in portrait. I'm going to work on the sheet area. So the sheet, I'm going to get the, I want the row information to repeat at the top. So my row information that I want to repeat is row three, which I've just highlighted and it's gone to three. I also want the columns on the left to repeat and it's saying where we are, right? So I've clicked in this area and I'm not going to tell it it's column A. So I've told it where the headings are, my column headings and my row headings. What I'm now going to do is tell it the print area that I want to print. So this is how you can manage freeze-paint by managing the print area, as well as the top, the rows to repeat at the top and columns to repeat at the left. So I've set the column and row areas and now I'm going to set the print area. So I wanted the print from K5 across down to M16. So I don't want the totals. So that's the area I'm now setting. So I'm telling Excel the print area that I want to print and this will now look at printing exactly what's been set up for freeze-pain. So I've set the print area. I've set the rows to repeat at the top and columns left. I can print preview here but I'm just going to click OK and then check it out in print when I go back to print. So I click OK. Go to file print and now I've got page one of one and I've now got the receipts October, November, December and I've got the information I want. Now I can tidy this up. I don't want it right at the top. I want it to be bigger and I want it to be in the centre of the page. I want grid lines applied. I might even want row and column heading. So I'm going to tidy this up and have a print in but I've got the freeze page print I want. It's just a matter of tidying it up now. So I'm going to go back into Excel, back to the page set up. So this is why I use this page set up so much. It's really, really helpful for printing. Portrait I want, I'm going to adjust the size to 130% to make it bigger margins. I'm going to cent the horizontally and vertically to make it come in the middle of the page. I'm on the sheet. I'm going to show the grid lines but I also want to see row and column headings. Click OK. Back to file print and there we go. This is a much better print. Showing the information much bigger. I can see it's the last three months of the year. I can see the receipt information. I can see the turnover and that's what I wanted to print. It's now gone nicely centred in the middle of the page and it's also showing where the information is coming from with the column headings and the row headings as well. So this is how you can print with freeze panes on. When you print it, you then need to set it back to its normal settings. To do this, you go back into print, back out of print, back into Excel, back to the page setup and then you can try to remember what you've done. So I know I've changed the percentage to greater than 100s. I'm going to change it back to 100. The margins, I want it back to its original settings. The sheet. I don't want the print area because if you leave the print area, it's the print area. So it's really important that you get rid of this when you've printed with freeze panes on. So I'm going to delete that and I'm going to delete the row to be the top as well as columns left and take off the good lines and row and column headings. Click OK. Look at the print again now. So I'll just put the freeze panes back on where I want it. That's where I'd like it to print. But if I now look at it, I'll see that's not the case. I'm just now back to January, February, March and not giving me what I want. So this is back to the default settings now. But this is how you can print in Excel with freeze panes applied. So it's really important to be able to use the print area and that's why I use the page setup. You can then apply things like grid lines and row and column headings to repeat and you can also add row and column headings to print. You can set the margins to centre like I did and also adjust the magnification. So there are the kind of skills we covered here to print and looking at how to print with freeze panes. But this completes the training video of looking at printing with freeze panes applied and also looking at the information you want to print with freeze panes and then just making the print look better with certain skills like row and column headings to show grid lines and making the percentage view a little bit bigger. But this completes printing with freeze panes applied.