Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Why would gridlines be missing if they are switched on under
TOOLS/OPTIONS/VIEW/GRIDLINES and their colour is set to AUTOMATIC (black)
Because someone has higlighted the whole sheet and formatted the borders white?
on the screen, or on a printout?
on the screen
Fill colour set to white?
Humour me - try removing all borders.
there are no cell borders. The whole sheet is blank (It came like this from a workmate)
I want to switch on gridlines to a worksheet I've added, but despite being switched on they are invisible.
Any chance there's an object e.g. textbox covering the cells?
It's not the answer but can you colour borders in specific areas of the sheet?
Yes - I've put "borders" on a load of cells just so I can see where to type.
Tools>Options>View>Gridlines Color ???
Change the fill on the cells to none.
Not something I've ever encountered if gridlines are on as you say, and borders haven't been formatted white then I haven't got a clue.... ask your colleague what the fwck they've done?
Tools>Options>View>Gridlines Color ??? = automatic (black)
tragically1969 [i]Change the fill on the cells to none.[/i]
That does it!
Is that what you meant too ian-r?
Cheers guys.