+ Reply to Thread
Results 1 to 3 of 3

Is there a way to cut off unused cells on a sheet

  1. #1
    newbie
    Guest

    Is there a way to cut off unused cells on a sheet

    It seems there are an infinite number of cells on a sheet. As I really dont
    have much info to enter on each sheet I was hoping there was a way I could
    somehow cut off all the extra stuff to the sides and bottoms. It is a hassle
    because everytime I scroll, it will scroll off the side or bottom way past
    what I was looking for.

    Thanks!

  2. #2
    Don Guillett
    Guest

    Re: Is there a way to cut off unused cells on a sheet

    A manual way is to goto the last used row and delete all rows below. Do the
    same with columns. SAVE

    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "newbie" <newbie@discussions.microsoft.com> wrote in message
    news:469AABE7-8D17-4B72-91C1-34E61A7993F8@microsoft.com...
    > It seems there are an infinite number of cells on a sheet. As I really

    dont
    > have much info to enter on each sheet I was hoping there was a way I could
    > somehow cut off all the extra stuff to the sides and bottoms. It is a

    hassle
    > because everytime I scroll, it will scroll off the side or bottom way past
    > what I was looking for.
    >
    > Thanks!




  3. #3
    Ron de Bruin
    Guest

    Re: Is there a way to cut off unused cells on a sheet

    Maybe you must save/close/re-open

    More info here
    http://www.contextures.com/xlfaqApp.html#Unused

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "Don Guillett" <donaldb@281.com> wrote in message news:eJJkSqEmFHA.1480@TK2MSFTNGP10.phx.gbl...
    >A manual way is to goto the last used row and delete all rows below. Do the
    > same with columns. SAVE
    >
    > --
    > Don Guillett
    > SalesAid Software
    > donaldb@281.com
    > "newbie" <newbie@discussions.microsoft.com> wrote in message
    > news:469AABE7-8D17-4B72-91C1-34E61A7993F8@microsoft.com...
    >> It seems there are an infinite number of cells on a sheet. As I really

    > dont
    >> have much info to enter on each sheet I was hoping there was a way I could
    >> somehow cut off all the extra stuff to the sides and bottoms. It is a

    > hassle
    >> because everytime I scroll, it will scroll off the side or bottom way past
    >> what I was looking for.
    >>
    >> Thanks!

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1