When I open a new worksheet in an old file, it comes up without gridlines,
even thought the gridlines option is checked.

When I click on the gridlines option it only puts grid lines on data that
was copied from another area on the spreadsheet.

Byron

Sounds like you have borders that are the same as the back ground color or
there is a fill color in the cell. Select three or four cells in the problem
area and goto formatcellborders and clear any that might be there, and do
the same thing with any fill in the "patterns" tab.

Mike Rogers

"Byron" wrote:

When I open a new worksheet in an old file, it comes up without gridlines,
even thought the gridlines option is checked.

When I click on the gridlines option it only puts grid lines on data that
was copied from another area on the spreadsheet.

Byron

Could be that the cells are colored white which hides the gridlines.

Select all cells and FormatCellsPatternsNo Color.


Gord Dibben MS Excel MVP

On Thu, 11 Jan 2007 16:21:00 -0800, Byron
wrote:

When I open a new worksheet in an old file, it comes up without gridlines,
even thought the gridlines option is checked.

When I click on the gridlines option it only puts grid lines on data that
was copied from another area on the spreadsheet.

TRY GOING INTO THE BORDERS AND CLICK INSIDE LINES

"Byron" wrote:

When I open a new worksheet in an old file, it comes up without gridlines,
even thought the gridlines option is checked.

When I click on the gridlines option it only puts grid lines on data that
was copied from another area on the spreadsheet.