| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing cell pattern
When looking at a spreadsheet it shows the light colored cell borders for
navagating purpures (they don't show when printing). Is there a way to remove these cell borders when looking at the sheet (I'm not talking about Print Preview - I'm talking about removing the cell patterns/boraders on the working sheet) Please advise. -- John 3:16-19 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing cell pattern
TOOLSOPTIONSVIEW then uncheck Gridlines.
This applies only to the active sheet. You will have to do this in turn to other sheets. Record a macro to automate the process. Paul "yogart" . wrote in message ... When looking at a spreadsheet it shows the light colored cell borders for navagating purpures (they don't show when printing). Is there a way to remove these cell borders when looking at the sheet (I'm not talking about Print Preview - I'm talking about removing the cell patterns/boraders on the working sheet) Please advise. -- John 3:16-19 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing cell pattern
Unless you "Group" all your sheets first!!! Don't forget to "Ungroup"...
Mike Rogers "Paul Wilson" wrote: TOOLSOPTIONSVIEW then uncheck Gridlines. This applies only to the active sheet. You will have to do this in turn to other sheets. Record a macro to automate the process. Paul "yogart" . wrote in message ... When looking at a spreadsheet it shows the light colored cell borders for navagating purpures (they don't show when printing). Is there a way to remove these cell borders when looking at the sheet (I'm not talking about Print Preview - I'm talking about removing the cell patterns/boraders on the working sheet) Please advise. -- John 3:16-19 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing cell pattern
Thank you Paul and Mike and may God bless your day.
-- John 3:16-19 "Mike Rogers" wrote: Unless you "Group" all your sheets first!!! Don't forget to "Ungroup"... Mike Rogers "Paul Wilson" wrote: TOOLSOPTIONSVIEW then uncheck Gridlines. This applies only to the active sheet. You will have to do this in turn to other sheets. Record a macro to automate the process. Paul "yogart" . wrote in message ... When looking at a spreadsheet it shows the light colored cell borders for navagating purpures (they don't show when printing). Is there a way to remove these cell borders when looking at the sheet (I'm not talking about Print Preview - I'm talking about removing the cell patterns/boraders on the working sheet) Please advise. -- John 3:16-19 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To format a cell pattern by VBA | New Users to Excel | |||
| Removing (deleting, filtering) lines in a pattern . . . | Excel Discussion (Misc queries) | |||
| Cell pattern | Excel Discussion (Misc queries) | |||
| Cell pattern | Excel Discussion (Misc queries) | |||
| Cell Pattern | Excel Discussion (Misc queries) | |||
Hybrid Mode
