Headings are the letters across the tops of the columns and the numbers down he left hand side of the rows.įrom the picture above you can see that you are also able to scale your spreadsheet by a percentage to fit your paper. Next to it you will also see you have the same choices with headings. They show on screen by default but are not always automatically printed.īelow you can see that if you navigate to Page Layout / Sheet Options you can choose whether to view and print your gridlines. Gridlines make reading and making sense of a large amount of data far easier. However you can adjust it any way you like – here I have chosen the top line of my data. To print them on every sheet do the following:Įxcel will auomatically put row 1 in this section. If you have a long spreadsheet, trying to remember what all of the column headings are can be quite confusing. When printing long spreadsheets Excel will only print column headings on the 1st page by default.
If you wish them to be more transparent you will need to have them ready like that before inserting. They are inserted at their default size and cannot be adjusted once they have been inserted. If you fancy a change you can insert graphics/ photographs / company logo pictures into the background. The background is the area behind any data or charts that you add to a worksheet and is white by default. Here is a preview of the print on each page with the page break. From here you are able to drag the thick blue lines with your mouse to reset the page breaks. If you wish to see an overview of the breaks navigate to view/ page break preview. You can see beneath the insert choice there is a remove Page Break and reset all Page Breaks choice too. However you can choose to insert your own.įor this I have selected the line of data beginning with Sochi. Here is a preview of the print with the selection shown.įor more ways to show your information in Excel clearly, read our guide on Creating Flowcharts In Excel here!Įxcel will create it’s own page breaks, based on the size paper you have selected. It is right next to the command to set the print area. To clear the print area, see the 1st picture in this section and you will see where to do this. Ideal if you want to print a specific column of your data, but wanted to keep all the other data. Once this is set the data can be filtered, sorted. The area will then have a thinner line around it. To do this highlight the data you want to print, click on the page layout, print area, set print area. Unless you have set up your pages this can make for a very confusing pile of paper, especially if you have lots of columns.Īnother way is to set the print area. The default print area for Excel is ALL of the data. There are a wide variety of standard paper sizes to choose from when you click the ‘Size’ button, and you also have the opportunity to set your own custom size. You will also see in the top picture in this section you have the opportunity to decide which way round you want your paper. When you have centred both, it will look similar to below. You will see on the lower left-hand side the options to centre horizontally and / or vertically. This will open the box you see in the picture below. To centre it on the page we need to product the Page Setup dialog box again as before. If you want it to print elsewhere you need to tell it to do so. If you make a mistake, just hit CTRL-Z to undo it.Ĭentring On a Page, Paper Orientation & Setting Paper Sizeīy default Excel will print in the top left hand corner of the page. When you have got a hold of it, you will see a thin dotted line, wherever you let o of it, that is where the new margin will be. With your mouse you can then grab the margins and move them around.
Please see picture below for how to get to the correct place: View/Page layout. There is a tab called Page Layout we have been using so far, but we do not want this. To do this you need to go to the ‘Page ‘Layout’ view.
View our comprehensive guide to Drop Down menus here. You are also able to centre your image on the page here, either horizontally, vertically or both.Īnother great way to control your page layout in Microsoft Excel is by using Drop Down Menus. Here you are able to adjust the margins to your exact requirements. If you take a look at the picture above, you will see that right at the bottom of the drop down list is a ‘Custom Margins’ choice (4)Ĥ) The Custom Margins button will produce the Page Setup Dialog Box, with the Margins tab highlighted.
There is a choice of three built-in margin settings: Normal, narrow and wide.