Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joy Joy is offline
external usenet poster
 
Posts: 29
Default How do you show/hide individual cell gridlines in Excel 2007?

I do not want to use border. I want to show or hide gridlines instead. I
went to Page Layout and chose Show/Hide Gridlines, only after I had selected
my cells I wanted to change and it changes the whole document and not just
those cells selected. What am I doing wrong? Thanks anyone!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default How do you show/hide individual cell gridlines in Excel 2007?

First, Word has "documents", Excel has "spreadsheets", and Gridlines are
set at the Worksheet level. If you want finer control, borders are provided.

Joy wrote:

I do not want to use border. I want to show or hide gridlines instead. I
went to Page Layout and chose Show/Hide Gridlines, only after I had selected
my cells I wanted to change and it changes the whole document and not just
those cells selected. What am I doing wrong? Thanks anyone!


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default How do you show/hide individual cell gridlines in Excel 2007?

Gridlines apply to the whole spreadsheet.

To hide just a bunch of cells, set the fill colour to white.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Joy" wrote in message
...
I do not want to use border. I want to show or hide gridlines instead. I
went to Page Layout and chose Show/Hide Gridlines, only after I had
selected
my cells I wanted to change and it changes the whole document and not just
those cells selected. What am I doing wrong? Thanks anyone!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i get my office enterprise 2007 excel gridlines to show up George Excel Discussion (Misc queries) 0 December 27th 07 11:22 PM
Apply conditional formatting to individual cell Excel 2007 James D Excel Worksheet Functions 3 June 3rd 07 09:59 PM
Show gridlines or cell borders on top of a picture sukey51 Excel Discussion (Misc queries) 0 March 24th 07 04:55 AM
Row colors overlay the gridlines...how do I show gridlines? RickToo11 Excel Discussion (Misc queries) 2 September 13th 06 03:46 PM
How do I hide gridlines from all new Excel files? HBD Setting up and Configuration of Excel 1 March 14th 05 12:44 PM


All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"