Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patti
 
Posts: n/a
Default GRIDLINES ON SOME OF SHEET AND NOT ON OTHR PARTS EXCEL

How do you show gridlines on part of a sheet and hide the gridlines on other
parts of the same sheet?
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default GRIDLINES ON SOME OF SHEET AND NOT ON OTHR PARTS EXCEL

Remove all the gridlines
(Tools|Options|View tab)

Then add borders where you want them:
format|Cells|border tab


Patti wrote:

How do you show gridlines on part of a sheet and hide the gridlines on other
parts of the same sheet?
Thanks


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default GRIDLINES ON SOME OF SHEET AND NOT ON OTHR PARTS EXCEL

Patti

Select some cells and FormatCellsPattern set to "white".

The gridlines in that area will be covered over.


Gord Dibben MS Excel MVP

On Tue, 17 Jan 2006 12:15:03 -0800, "Patti"
wrote:

How do you show gridlines on part of a sheet and hide the gridlines on other
parts of the same sheet?
Thanks


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



All times are GMT +1. The time now is 07:51 AM.

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

About Us

"It's about Microsoft Excel"