How to Print Excel Worksheets with Gridlines
Because they don’t print by default, we’ll show you how to print Excel worksheets with gridlines using both the desktop application and Microsoft Excel on the web.
If you’re printing an Excel spreadsheet with a lot of data, you may want to include the gridlines. These provide you with subtle borders around your cells without having to manually add them, thus making the data easier to read.
Gridlines Versus Cell Borders in Excel
The advantage tousing gridlinesversus cell borders when you print in Excel is that they appear around your data automatically when you mark the option as described below.
By default, the gridlines encompass only the data in your sheet. This means if you add or remove data later, the gridlines automatically accommodate those changes.
When you apply cell borders to your data for printing instead, those lines do not update automatically. So, if you add or remove data later, you must manually adjust those cell borders before printing.
If you do add cell borders to your sheet for another reason and also want to print the gridlines, both display when you print the sheet. The borders you apply simplyappear as bolder lineswhen you print (or in color per your border settings) as shown below.
How to Print Excel With Gridlines on Desktop
You can print gridlines in Excel on Windows and Mac by adjusting the same setting. However, Excel on Windows does provide another way to add gridlines when you’re ready to print.
If you want to print the entire workbook with gridlines, you’ll need to add them to each individual sheet first by following the above steps.
If you forget to mark the Print option for gridlines on the Page Layout tab as described above and are already in the print preview, you can add the lines there if you’re using Excel on Windows.
Follow these same steps if you want to print other sheets in the workbook with gridlines.
How to Print Excel With Lines on the Web
If you’re using Excel on the web, you can easily print the gridlines for your worksheet.
Like in the desktop application, if you want to print the whole workbook with gridlines, you’ll need to add them to each sheet individually using the above steps.
Gridlines for Easy Reading in Excel
Not only can printing your sheet with gridlines in Excel save you time from manually adding cell borders, but gridlines can accommodate any changes you make to your data automatically. Plus, they make your printed data easier to read.
Now that you know how to print in Excel with lines, look athow to get rid of dotted lines in Exceltoo.
Sandy Writtenhouse is a freelance technology writer and former Project, Department, and Program Manager. She turned her education, job experience, and love of technology into a full-time writing career. With all sorts of gadgets in her home and her hands, she seeks to help others make life easier through technology.Read Sandy’s Full Bio
Welcome to Help Desk Geek- a blog full of tech tips from trusted tech experts. We have thousands of articles and guides to help you troubleshoot any issue. Our articles have been read over 150 million times since we launched in 2008.
HomeAbout UsEditorial StandardsContact UsTerms of Use
Copyright © 2008-2024 Help Desk Geek.com, LLC All Rights Reserved
