Thursday, July 26, 2012

How to Print the Gridlines of an Excel Worksheet


1. Start Microsoft Excel, and open a spreadsheet that you would like to print, having the gridlines appear on the printed copy of the spreadsheet.
2. Choose the 'File' menu and click on 'Page Setup...' to open the 'Page Setup' dialog box. Within the 'Page Setup' dialog box you can choose settings that apply to your whole Excel spreadsheet.
3. Click on the 'Sheet' tab at the top of the 'Page Setup' dialog box to display the sheet settings for the Excel spreadsheet you have open.
4. Find the 'Print' section of the 'Sheet' tab in the 'Page Setup' dialog box, located in the middle of the dialog box.
5. Use your mouse to click the check box in front of the option 'Gridlines' to add a check mark to the box. This will make sure that the gridlines will print when you print your current spreadsheet.
6. Press the 'OK' button with your mouse to close the 'Page Setup' dialog box and set your current spreadsheet to print with gridlines.
7. Print your spreadsheet by choosing the 'File' menu, clicking on 'Print' and then selecting the settings you wish to apply to your printed spreadsheet. When your spreadsheet prints, you will notice that the gridlines have printed, as well.

Blogger news