ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   gridlines won't display (https://www.excelbanter.com/excel-discussion-misc-queries/212718-gridlines-wont-display.html)

bobm

gridlines won't display
 
I converted a spreadsheet from Lotus 1-2-3 (release 5) to .xlw (Excel 4.0)
format by doing "save as xlw". When I opened it with Excel 2003 everything
was okay, except there were no gridlines.

In Tools/Options the gridlines box was checked. The background color for
cells was "no fill". I've tried saving it as Excel 2003 and reloading,
toggling the toos/options gridline box, and everything else I can think of,
but can't get gridlines to display.


Pete_UK

gridlines won't display
 
Perhaps you have borders around each cell using white lines. Click on
the intersection of the row and column identifiers to highlight every
cell, then on Format | Cells | Borders tab, and click None.

Hope this helps.

Pete

On Dec 6, 5:41*pm, bobm wrote:
I converted a spreadsheet from Lotus 1-2-3 (release 5) to .xlw (Excel 4.0)
format by doing "save as xlw". When I opened it with Excel 2003 everything
was okay, except there were no gridlines.

In Tools/Options the gridlines box was checked. The background color for
cells was "no fill". I've tried saving it as Excel 2003 and reloading,
toggling the toos/options gridline box, and everything else I can think of,
but can't get gridlines to display.




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

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