Ms Excel Print Gridlines How To Print Gridlines

In this article youll learn how to print gridlines in Excel and get these faint lines brighter on a hard copy by changing the default gridline color.

Luckily, Excel 2010 and 2013 allow you to preview and print your files in one location -- on the Print tab in the Backstage view.

When you go there, you may find that Excel wont print gridlines in your sheet.

As the result, you will get a stack of papers with the data that can be difficult to separate visually.

So if you, as many other users, want to do it faster, read this article and find out how to print lines in Excel without drawing cell borders.

Just go to the Sheets Options group on the PAGE LAYOUT tab and check the Print box under Gridlines.

Sheets Options to select the Print checkbox under Gridlines titleGo to PAGE LAYOUT - Sheets Options to select the Print checkbox under Gridlines.

Here are easy-to-follow steps to print gridlines in Excel keeping the Print Preview pane open.

If you want to include blank rows and columns into printing as well, just use the Print Area icon to set the range.

If youre printing your sheet with grid on a color printer, you can change the lines color for something more attention-getting.

They will help you read information on the paper copy of your spreadsheet, keeping rows and columns with data visually organized.

I hope youll find these simple tricks helpful, and your colleagues will appreciate your friendly way of printing out data.

I am glad that the steps in my article helped you to solve the task.

So I use the default setting 5 of the time and have to manually override it 95 of the time.

Thats a great tip in itself, even if youre having no printing problems.

It seems to involve printer drivers, so is outside the control of anything you do in Excel.

As all the cells are empty in what I was trying to print, nothing else worked.

I have random gridlines printing in worksheets and all options for printing gridlines are not selected to print.

Ideas.

Just select the range where the issue occurs (the entire worksheet) and press Ctrl 1.

Move to the Border tab and click on the None icon, then press OK.

Go to Options, then Printing Shortcut, Print Quality and Select Best.

It may take longer for the document to print, but you get the gridlines.

Ms Excel For Mac Print Gridlines