ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cannot print gridlines in worksheet even tho they show on screen (https://www.excelbanter.com/excel-discussion-misc-queries/29294-cannot-print-gridlines-worksheet-even-tho-they-show-screen.html)

papadip

Cannot print gridlines in worksheet even tho they show on screen
 
Print preview and printout do not show gridlines/cell borders. Relative
selections are correctly made inPrint dialogue and in tools/options. Borders
show on normal screen

Mangesh Yadav

That just for a view. If you want to show the gridlines, then select all the
cells, or the part you want to print, click on Format Cells Border,
click on boxes for outline and inside

Mangesh



"papadip" wrote in message
...
Print preview and printout do not show gridlines/cell borders. Relative
selections are correctly made inPrint dialogue and in tools/options.

Borders
show on normal screen




Debra Dalgleish

Choose FilePage Setup
Select the Sheet tab
Add a check mark to Gridlines
Remove the check mark from 'Draft quality'
Click OK

papadip wrote:
Print preview and printout do not show gridlines/cell borders. Relative
selections are correctly made inPrint dialogue and in tools/options. Borders
show on normal screen



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


DNA

Also, you may want to look at:

Tools Options View Tab. Enusre Gridlines is checked and possibly the
color is not set to white or some other color...



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

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