Excel 2000 Gridlines.

  TonyV 19:00 02 Feb 06
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 06

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

  TonyV 19:20 02 Feb 06

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 06

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

  VoG II 19:27 02 Feb 06

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 06

Not to my knowledge!

TonyV

  mammak 19:39 02 Feb 06

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 06

That has done it!

Many thanks

TonyV

  TonyV 20:15 02 Feb 06

I will now tick this as resolved. Thanks fellas!

TonyV

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

Hands-on: Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos