How do I get the grey gridlines on screen to diplay again on one of my spreadsheets? I have no problem getting them on to print and they appear on other spreadsheets but I cannot find a way to get them to display in the way they used to on one particular sheet.
Most of them have disappeared as a result of me clicking on the numbers on the far left of screen and then clicking on colour-fill (paint-pot icon) to highlight a line in one colour. As I did this one or two lines at a time over a number of days using different highlighting colours, I cannot "undo". I failed to notice that when I had returned to "no fill" using the same method, the gridlines, horizontal and vertical were missing in all the affected rows.
Angela Williams
Replies (6)
Please login or register to join the discussion.
Gridlines
Hi Angela
Assuming you're using xl2003 or below, go Tools>Options>View tab and make sure that "Gridlines" under Window Options is checked.
Hope this helps!
Richard
While you're in that tab
Make sure that the gridlines colour is set to something visible like 'Automatic'.
Thanks pal!
Thank you Richard, for the info on retrieving gridlines in Excel. It helped me as I use lot of Excel at office.
Cheers :)
Regards,
Manoj