MS Excel Tip: Printing Gridlines

Published: 06 December 2018
on channel: Summit Solutions Excel Training

138

By default, the greyed-out gridlines in Microsoft Excel are not printed. What many people do, to “show” these gridlines on a printed spreadsheet, is to add cell borders.

However, there is a simpler and more effective way of printing gridlines on Excel;

Go to the Page Layout Ribbon and in the Excel Sheet Options group, check the Gridlines Print option. This option can also be accessed using Print Titles under the Page Setup group.

Over and above being simpler to implement, Printed Gridlines are a lot finer and subsequently more subtle then cell borders. As a result, the data is easier to read with the Printed Gridlines still sufficient to enable one to track a line item.

Watch video MS Excel Tip: Printing Gridlines online, duration hours minute second in high quality that is uploaded to the channel Summit Solutions Excel Training 06 December 2018. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 138 times and liked it 2 visitors.

11,720

318