ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing gridlines with empty cell (https://www.excelbanter.com/excel-discussion-misc-queries/87220-printing-gridlines-empty-cell.html)

nickjohn

Printing gridlines with empty cell
 
I am trying to print an order from where I need the gridlines to print. I've
checked the print gridlines box but it just prints the gridlines for the
cells with text in them. How do I print the sheet with all gridlines showing?

Dave Peterson

Printing gridlines with empty cell
 
Excel will show the gridlines for the cells it thinks it should be printing.

You could put
=""
in the bottom right corner of the range and excel will include that cell in the
print range (well, unless you do something to change the print range).

nickjohn wrote:

I am trying to print an order from where I need the gridlines to print. I've
checked the print gridlines box but it just prints the gridlines for the
cells with text in them. How do I print the sheet with all gridlines showing?


--

Dave Peterson

Mike

Printing gridlines with empty cell
 
Alternatley you could select the range of cell you would like to print and
click
Format - Cells - Boarder - and selecto Outline and inside and click OK

"Dave Peterson" wrote:

Excel will show the gridlines for the cells it thinks it should be printing.

You could put
=""
in the bottom right corner of the range and excel will include that cell in the
print range (well, unless you do something to change the print range).

nickjohn wrote:

I am trying to print an order from where I need the gridlines to print. I've
checked the print gridlines box but it just prints the gridlines for the
cells with text in them. How do I print the sheet with all gridlines showing?


--

Dave Peterson



All times are GMT +1. The time now is 08:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com