excel won't save the border lines

[Julie]

I'm using Excel 2003 and having a prblen with the border lines. The border
lines show up when I hit ok. I then view the sheet on print preview an dthe
lines are there. Then I save the sheet and the lines just disappear. The
funny thing is, is that the border lines save and stay on sheet 3, but not on
sheet 1 0r 2. I have set margins the same on all three sheets as well. Any
suggestions? I would hate to re-do this entire project.

 

[Spiky]

I'm using Excel 2003 and having a prblen with the border lines. The border
lines show up when I hit ok. I then view the sheet on print preview an dthe
lines are there. Then I save the sheet and the lines just disappear. The
funny thing is, is that the border lines save and stay on sheet 3, but not on
sheet 1 0r 2. I have set margins the same on all three sheets as well. Any
suggestions? I would hate to re-do this entire project.

Make new sheets for 1 and 2. Copy/paste formulas over, but not
formats. Then redo your formats. And delete the original sheets once
it is safe.

There is probably a way to figure out what exactly Excel has done to
those and fix it, but I find it better just to start fresh when
worksheets appear corrupted.

 

[Julie]

This is weird.....I copied and pasted into a new document. After I changed
margins, headers, column and row sizes, etc, the sheet looked great. Even
though the lines were not showing on my orginal doc, they copied and pasted
to the new doc. Then I saved the doc- no lines again in the bottom half. I
am having the same problem with a new sheet. Any other suggestions?

 

[Spiky]

Well, I recommended not copying the formats, it sounds like you did.

Sometimes Fill formatting gets in the way of Border formatting. You
could try changing the affected area to No Fill, even if it doesn't
look like there is a Fill currently formatted.

Or, on files that have been passed from older versions of Excel, the
borders can be transferred as a light gray, nearly invisible. Changing
them to black is the solution in that case. And it will often make the
gray a default, so simply clicking on the Borders Toolbar button won't
work, as that still gives gray. You'd have to go into the Format Cells
window to change this.

 

[Gord Dibben]

Julie

To get things straight...............

By "border lines" do you mean the normal gridlines or actual borders from
Format>Cells>Borders?


Gord Dibben MS Excel MVP