Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
PT
 
Posts: n/a
Default 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


  #2   Report Post  
garfield-n-odie
 
Posts: n/a
Default

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?




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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I copy an entire worksheet to another with text & format? kb Excel Discussion (Misc queries) 15 July 4th 08 09:25 PM
How do I change format of all comments in worksheet? Clare Castle Excel Discussion (Misc queries) 1 January 19th 05 04:54 PM
Format a worksheet to carry out all calculations to 2 decimal plac Phill Barrett Excel Discussion (Misc queries) 2 January 5th 05 02:07 PM
Format a worksheet to carry out all calculations to 2 decimal plac Phill Barrett Excel Discussion (Misc queries) 4 January 5th 05 02:07 PM
How can I format a worksheet to carry out all calculations to 2 d. Phill Barrett Excel Discussion (Misc queries) 2 January 5th 05 02:05 PM


All times are GMT +1. The time now is 01:37 AM.

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

About Us

"It's about Microsoft Excel"