ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Curious Worksheet Format (https://www.excelbanter.com/new-users-excel/4620-curious-worksheet-format.html)

PT

Curious Worksheet Format
 
I was e-mailed a worksheet which contains some (to me) unusual features.

It covers cells A1 to M25. The rest of the worksheet is blank - by which I
mean nothing - no cell outlines, just a gray undistinguished area.

It contains a large watermark type "Page 1" in enormous size, covering most
of the worksheet.

If I enter anything in one of the grayed out cells, say in A30, the
worksheet "expands", that is normal appearance is restored, so the worksheet
now displays cells A1:M30.

How was this worksheet formatted/created?

Can I restore the appearance to that of a normal worksheet?



--
PT



garfield-n-odie

Hi, PT. You are in Page Break view. To switch back to the Normal view
that you seem to be more familiar with, click on View | Normal.

PT wrote:

I was e-mailed a worksheet which contains some (to me) unusual features.

It covers cells A1 to M25. The rest of the worksheet is blank - by which I
mean nothing - no cell outlines, just a gray undistinguished area.

It contains a large watermark type "Page 1" in enormous size, covering most
of the worksheet.

If I enter anything in one of the grayed out cells, say in A30, the
worksheet "expands", that is normal appearance is restored, so the worksheet
now displays cells A1:M30.

How was this worksheet formatted/created?

Can I restore the appearance to that of a normal worksheet?






All times are GMT +1. The time now is 08:16 AM.

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