ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   remove view format (https://www.excelbanter.com/excel-discussion-misc-queries/118133-remove-view-format.html)

Gina_Louisville

remove view format
 
I have inherited some spreadsheets from an idividual who is no longer here
and who does his spreadsheet formatting much differently from how I do mine.
I need to know how to remove the formatting that blocks off the unused rows
and columns from the 'active' part of the spreadsheet and shows 'page 1',
'page 2' etc as a watermark across the viewable page? Thanks, Gina

Raffael

remove view format
 
"View" menu "normal"


"Gina_Louisville" wrote:
I have inherited some spreadsheets from an idividual who is no longer here
and who does his spreadsheet formatting much differently from how I do
mine.
I need to know how to remove the formatting that blocks off the unused
rows
and columns from the 'active' part of the spreadsheet and shows 'page 1',
'page 2' etc as a watermark across the viewable page? Thanks, Gina




Gord Dibben

remove view format
 
Gina

You are in Page Break View.

Go to ViewNormal


Gord Dibben MS Excel MVP

On Thu, 9 Nov 2006 06:03:01 -0800, Gina_Louisville
wrote:

I have inherited some spreadsheets from an idividual who is no longer here
and who does his spreadsheet formatting much differently from how I do mine.
I need to know how to remove the formatting that blocks off the unused rows
and columns from the 'active' part of the spreadsheet and shows 'page 1',
'page 2' etc as a watermark across the viewable page? Thanks, Gina




All times are GMT +1. The time now is 05:35 AM.

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