ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Gridline (https://www.excelbanter.com/excel-discussion-misc-queries/92545-gridline.html)

Scott

Gridline
 
In my spreadsheet I use color background on certain part. That part does
not have gridline when print. I need to have gridline on whole spreadsheet.
Can someone advise me how to accomplish it.

Thanks,

Scott



Roger Govier

Gridline
 
Hi Scott

Mark the whole range of cells containing your data and apply a border.
Select the drop down from the border button on the toolbar and choose
the option that looks like a grid.

--
Regards

Roger Govier


"Scott" wrote in message
...
In my spreadsheet I use color background on certain part. That part
does not have gridline when print. I need to have gridline on whole
spreadsheet. Can someone advise me how to accomplish it.

Thanks,

Scott




Scott

Gridline
 
Roger,

Thanks for your useful advice.

Scott

"Roger Govier" wrote in message
...
Hi Scott

Mark the whole range of cells containing your data and apply a border.
Select the drop down from the border button on the toolbar and choose the
option that looks like a grid.

--
Regards

Roger Govier


"Scott" wrote in message
...
In my spreadsheet I use color background on certain part. That part does
not have gridline when print. I need to have gridline on whole
spreadsheet. Can someone advise me how to accomplish it.

Thanks,

Scott







All times are GMT +1. The time now is 11:13 PM.

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