Help - I've lost my Excel cell indicator bars 1

[Shinken]

aaarrrrggggghhhhhhh

The horizontal and vertical cell identifier bars have disappeared from the perimeter of all but the first sheet of a multilayered Excel XP (2002) spreadsheet. Does anyone know why this happened and/or how to retrieve them?

FYI, this was originally a QuattroPro file which I imported into Excel. The bars were there last week, but were gone when I loaded the file earlier today.

Thanks,

 

[Zathras]

Check out Tools/Options and look on the View tab for "Row & column headers" to see whether it got unchecked somehow.

 

[Shinken]

Excellent, thanks.

Now, if I can only figure out why all of the gridlines have disappeared. I checked Tools/Options and the gridlines box is checked. I tried unchecking and rechecking it, with no change. Any ideas?

 

[xlbo]

Maybe your gridlines colour has been set to white ??

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[KenWright]

Or the cells have a fill colour of white which will obliterate the gridlines also.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[Shinken]

In FORMAT | BORDERS, the inside lines are not set except for areas where I explicitely set them to define an area.

I had thought that checking gridlines in TOOLS | OPTIONS | VIEW would automatically redisplay the gridlines, but apparently not. I've even tried unchecking and rechecking the gridlines checkbox, without any change.

Is there a way to globally set a color for all gridlines in a file, or at least on a worksheet, without changing specific area borderlines that I have set?

If not, I'll probably have to <Ctrl+A> to select all, format the inside lines to a light grey, and then re-highlight selected areas to set double and thick lines as appropriate for area borders.

Thanks

 

[KenWright]

Gridlines will ONLY show through if you have no borders set and no fill colours set. A white fill colour will prevent any gridlines showing. Borders are things you set manually and are not related to gridlines.

If you want just certain cells bordered visually then you would either turn off grid lines and put borders around the cells you want, or you might fill all the cells with a specific colour and then again border the cells you want.

Turning off grid lines allows you to have a white background plus borders of whatever colour you specify but you have to set them manually, whereas filling the cells with colour allows you to choose something other than white if you wish, but again you need to use borders set manually to get the effect you want.

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------