Add gridlines (NOT print or display) for Excel 2007

C

Charbonne

I know how to add gridlines for Excel 2003. However, someone in their
infinite wisdom (yeah?!) decided to make Office 2007 products difficult to
use, hard to find icons, unable to set up personal toolbars with favorite
icons, etc.

I can't find how to ADD gridlines. Through a search of Help, they show you
how to display/hide/print/not print, etc. but NOT how to add them. I copied
part of a spreadsheet from a 2003 Excel file. BUT, when I add new rows, none
of the new rows have gridlines. I can't find how to add thjem.
 
R

Roger Govier

Hi

Press the Round Office button>Excel Options>Advanced>Display Options for
this Worksheet>Show Gridlines

If you want to add an icon to your QAT to toggle display on and off, then
Round Office button>Excel Options>Customise>All Commands>View Gridlines>Add
 

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

Sheet format questions -- Excel 2007 2
Excel 2007 Need to permanently change Normal settings for gridlines 2
Why do gridlines not print in Excel spreadsheet? 5
Gridline box checked or unchecked. Gridlines do not print. 3
I do not know how to get my gridlines to stay 3
Gridlines Printing from embedded Excel File in Word 2007 3
Gridlines won't show up in excel 2007 6
Setting Gridlines - Excel 2007 6

Top