Printing Gridlines in Excel





It is much easier to type in Excel when you see the grid lines to demark lines & columns.  However if you print your beautiful Excel file, it may not seem easy to read, because the lines that separate the rows and columns are not printed by default.Now there has always been a way to get the grid lines to print, since Excel 2000, and it is still available in Microsoft Excel 2003 in the same place. In  Excel 2007, you have many ways to get to the Print Grid lines option.

Go to Print > Print Preview & Click on Page Setup

You will see a popup box come up. Click on the 4th tab and select Sheet. You should see something like this screen shot below.

As you can see, there is a checkbox which says – Gridlines in the Print section. Select the Checkbox, and then click OK.

You will see tiny gridlines appear on the screen. Now when you print the sheet, you will see gridlines being printed, and it is much easier to view the figures on the printed sheet with gridlines printed.

Hope you find this tiny tip useful…


Leave a Comment

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!