ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Add gridlines (NOT print or display) for Excel 2007 (https://www.excelbanter.com/new-users-excel/229743-add-gridlines-not-print-display-excel-2007-a.html)

Charbonne

Add gridlines (NOT print or display) for Excel 2007
 
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.

Roger Govier[_3_]

Add gridlines (NOT print or display) for Excel 2007
 
Hi

Press the Round Office buttonExcel OptionsAdvancedDisplay Options for
this WorksheetShow Gridlines

If you want to add an icon to your QAT to toggle display on and off, then
Round Office buttonExcel OptionsCustomiseAll CommandsView GridlinesAdd
--
Regards
Roger Govier

"Charbonne" wrote in message
...
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.




All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com