SHOW GRIDLINES ON SPREADSHEETS IN EXCEL?

G

Guest

I'm trying to create a spreadsheet but I can't get the gridlines to show.
How can I get the gridlines to show on all new spreadsheets? Have done the
page setup thing but it only puts lines on where there is type. I want it to
show on the complete page at all times. Thanks
 
A

Alan

Go 'File',' Page Set Up', on the 'Sheet' tab check in the 'Print' section
'Gridlines'
Regards,
Alan.
 
G

Guest

You need to do two things:

Tools > Options > View and make sure gridlines color is not the same as the
background color

Select all the cells. then:
Format > Cells... > Patterns and make sure no color is selected
 

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

Top