ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   removing cell pattern (https://www.excelbanter.com/excel-discussion-misc-queries/219387-removing-cell-pattern.html)

yogart

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

Paul Wilson

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




Mike Rogers[_2_]

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





yogart

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






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

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