1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel view selection

Discussion in 'Business Applications' started by StoryAngel, Feb 11, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. StoryAngel

    StoryAngel Thread Starter

    Joined:
    May 29, 2002
    Messages:
    101
    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.
     
  2. rbeaufor

    rbeaufor

    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???
     
  3. StoryAngel

    StoryAngel Thread Starter

    Joined:
    May 29, 2002
    Messages:
    101
    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.
     
  4. rbeaufor

    rbeaufor

    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.
     
  5. StoryAngel

    StoryAngel Thread Starter

    Joined:
    May 29, 2002
    Messages:
    101
    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?
     
  6. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    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
     
  7. rbeaufor

    rbeaufor

    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
     
  8. Sponsor

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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/118250

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice