Gridlines not printing in excel 2007 full#

The Header/ Footer tab in the Page Setup dialog lets you configure headers and footers for the worksheet. You may find that the margins tool in the Print Preview gives better visual feedback as to how the margins will affect the final printed copy than other options. Use the margin markers to adjust the margins to a smaller size and use the column markers to adjust the column widths without needing to return to the worksheet to do this.

To do this, click the Show Margins button to see the margin markers on the preview. In addition to setting the margins by typing values into the boxes you can also set them in the Print Preview area. Use the Margins tab to set the margins on the page and to center the printout horizontally and vertically between these margins. The Show Margins option in the print preview dialog helps you see where the margins are going to occur and gives you the option of adjusting them. These options are often better choices than trying to specify exactly how many pages wide and tall you want the printed document to be. You can also specify the number of pages tall leaving the number of pages wide blank if you want to limit the vertical size of the printed copy but flexible as to its width.

Gridlines not printing in excel 2007 full#

Delete the figure in the Tall box and Excel will reduce the width of the printed area to one page wide but use as many pages as it needs to print the full length of the worksheet. So, for example, if your worksheet is just a bit too wide to print one sheet wide, you can reduce by selecting Fit To and then type 1 in the Pages Wide box.

The Fit To option lets you preset how many pages wide and/or tall the worksheet will print. To do this, click Adjust to and then set the percentage to increase or decrease the worksheet size. This tab also has a tool for shrinking or expanding the worksheet for printing. On the Page tab you can select Landscape or Portrait orientation - some worksheets can print on a single sheet of landscape paper where they may require two sheets in portrait orientation. In the Print Preview dialog click the Page Setup icon to configure the way your worksheet prints. Another option is to select the data area before selecting Print and then choose to Print the Selection from the Print dialog. To locate and delete a cell that is causing excessive pages to print try deleting rows and columns between the bottom of your data and the end of the worksheet. If you check the number of pages that will print, you will see you have a problem and will have time to fix it. If you have a rogue cell buried deep in the sheet even if it only has a space in it, Excel will print everything up to and including this cell, resulting in sheets of wasted paper. When you print a worksheet, Excel prints everything on it. This could indicate a simple problem such as the worksheet printing two sheets wide instead of one or something more complex - a cell with something in it somewhere well out of the way of the data on the sheet, for example. If this is extraordinarily high then troubleshoot the problem before pressing the print button. The print preview dialog shows the number of pages that will print in the bottom left of the screen. Tens of thousands of sheets of paper could be saved by this simple technique. The Page tab allows you to configure a large worksheet so that it prints more efficiently.īefore you print, preview the print job.