SUBSCRIBE FOR FREE EXCEL TIPS

MS Excel Tip: Printing Gridlines

By default, the greyed-out gridlines in 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. Go to the Page Layout Ribbon and in the 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. Discover more useful Excel tips on printing her

Training Offices:

Johannesburg

106 Johan Avenue, Sandton

Durban

1 Tamarind Close, Umhlanga

Pietermaritzburg

400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923

Email: info@summitsolutions.co.za 

Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions