Excel 2000 Gridlines.

  TonyV 19:00 02 Feb 2006
Locked

On a particular workbook I have, there are a number of cells that have some of the grid lines missing. In Tools/Options/View Gridlines is checked but there are some cells that do not have all the grid lines showing.

How do I get those missing elements to show? It may be something to do with Security, but I have checked all those areas and cannot come up with an answer.

Thanks.

TonyV

  Big Elf 19:03 02 Feb 2006

Select the whole worksheet then use the Format, Cells, Border option to insert the style you want.

  TonyV 19:20 02 Feb 2006

Thanks for your response, but I'm not referring to the lines within the Work Sheet Cells that I have Formatted, but the actual Grid Lines of the Work Sheet. In other words, the grey outline of all the cells in a Workbook.

TonyV

  mammak 19:26 02 Feb 2006

Hi just a thought but have the cells been
merged mabye?.Regards Mammak

  VoG II 19:27 02 Feb 2006

Select those cells and a few around them. Format|Cells, Patterns tab, No Color, Click OK.

That's for Excel 2003 - it might be No Fill in Excel 2000.

  TonyV 19:28 02 Feb 2006

Not to my knowledge!

TonyV

  mammak 19:39 02 Feb 2006

If VoG™ suggestion is not the answer you could try and check this, select the aera the cells that are missing gridlines "format cells > alignment check If there is a check in the merge cells check box.

  TonyV 20:13 02 Feb 2006

That has done it!

Many thanks

TonyV

  TonyV 20:15 02 Feb 2006

I will now tick this as resolved. Thanks fellas!

TonyV

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Converse draws on iconic heritage for a fresh brand identity

Mac power user tips and hidden tricks

Comment lancer Windows 10 en mode sans échec ?