How to show gridlines - tried tools menu options

H

Horsingaround

I have a spreadsheet another person sent me. It does not show the gridlines
and I need the gridlines to be visible. I tried Tools, Options, view, etc.
Help!
 
G

George Gee

The cells may be filled with white colour!


Select all the cells in the sheet, by clicking on the square to the left of
the column letters, and at the top of the row numbers, then:
Format > Cells > Patterns tab > 'No colour' > OK.

See if that helps

George Gee
 
C

Cutter

Check to see if the cell background has been filled with white instead
of the default setting of 'no fill'.

To do this select a range of cells that appear to have no formatting
and go to Format>Cells>Pattern and click on the area above the colour
palette where it says No colour.
 
A

Annette

Hi
I would go to print preview, setup, worksheet tab then tick gridlines, at
least you can see them then. It wont help on an active worksheet however.
regards
 
G

Gary''s Student

Additionally, the gridlines themselves may be the same color as the background.


Tools > Optioms > View > set gridline color to automatic
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top