Monday, June 20, 2011

How to Delete Print Lines in Excel 2007


1. Select the worksheet or worksheets you want to print without the lines. To select one sheet, click on the tab at the bottom of the workbook. Select two or more sheets that are next to each other by clicking the first sheet, holding down the 'Shift' key and then clicking the last sheet. Select two or more sheets that are not next to each other by clicking the first sheet, holding down the 'Control' key and then clicking the tabs of the other worksheets.
2. Click the 'Page Layout Tab' on the ribbon at the top of the window. In the 'Sheet Option' group, click the box in front of the 'Print' option to remove the checkmark. The lines do not print when this is selected. If the option appears dimmed, you might have a spreadsheet or graphic in one of the worksheets selected. You will need to deselect it before you can change this option.
3. Print the gridlines by clicking in the box again if you change your mind about printing the lines. This will cause the lines to print on the spreadsheet.

Blogger news