Excel view selection

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

StoryAngel

Thread Starter
Joined
May 29, 2002
Messages
102
I have a small spreadsheet which doesn't fill the screen, but I don't want to save all the white space around it. I've seen Excel sheets before where just the relevant cells were saved and the rest of the page was greyed out, a bit like "no background" in an image file.

Any suggestions where I can set this up in Excel? Thanks.
 
Joined
Feb 7, 2003
Messages
163
Just for clarification, by "save" what do you mean?

If you mean for printing purposes, excel traditionally prints only the active cells of a worksheet. If you end up with alot of extra cells, then there is usually a character (like a space) in a distant cell that you're unaware of.

Such is also the case with simply 'saving' (eg just the active cells).

Or do you mean for web publishing purposes???
 

StoryAngel

Thread Starter
Joined
May 29, 2002
Messages
102
OK let's say "view" rather than save? So that when I, or anyone else, opens the worksheet, there aren't millions of white cells - i.e. the worksheet JUST consists of the cells which have something in them. It's hard to explain but I have seen it done.
 
Joined
Feb 7, 2003
Messages
163
under the <view> menu is <page break preview>.

Than adjust the percentage to fill you window to your desire.

If you save here, the next time you or anyone opens the file, it will be in page break preview.
 

StoryAngel

Thread Starter
Joined
May 29, 2002
Messages
102
Yeah I know what you're saying but what I'm talking about is actually removing all the extra white space from the worksheet, not just a question of not viewing it on screen. I'm not explaining myself very clearly am I! Any other ideas?
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Explained very well...but only for those that realize it, LOL!

Select the first blank column by clicking its letter.
Hit Shift+Ctrl+Right arrow.
Hit Format-Column-Hide.

Select the first blank row by clicking its number.
Hit Shift+Ctrl+Down arrow.
Hit Format-Row-Hide.

Hit Ctrl+Home.
Save.

:D
 
Joined
Feb 7, 2003
Messages
163
sorry, didn't proofreed my post....some of the words were cut

Go under the view menu and select page break preview .

then adjust your window size

you'll get that "greyed out" effect you like with only the active cells showing up
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top