remove grids

[1qazxc]

Hi,
Simple one for you all; I cant for the life of me remember - its been a long day! how to select cells in Excel (XP) and remove the grids. You know to leave the area blank without lines - as if to enter text.

Thank you - sooo much

 

[foundryqa]

Tools:Options:View:Gridlines

 

[GlennUK]

There's also a toolbar button for toggling the view of gridlines to be on/off.

Customize toolbars ( right click your mouse over any toolbar and choose Customize from the shortcut menu ), and in the Commands tab choose a category of Forms, and scroll to the button/command called Toggle Grid and drag the button onto one of your toolbars.



Cheers, Glenn.

My grandfather was ill, and my grandmother smeared goose-grease on his back. He went downhill very quickly after that.

 

[EgWeb]

You can also fill the cells white, this will hold up on other computers that have gridlines on.

 

[AnotherHiggins]

EgEweb,

Using Tools>Options>View>Gridlines will also, "hold up on other computers...." The option is specific to that workbook, not your session of Excel. Filling multiple entire worksheets with white can add to the file size. So using the option under Tools is, IMHO anyway, a better and more elegant solution.

John

That which does not kill me postpones the inevitable.