Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Clearing/Removing Empty Cells

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Warrington
    Posts
    201
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way I can instantly clear/remove/empty cells? I just want Excel to show the cells that contain data. It is possible to hide all the cells to the left and the cells to the base but this takes time. Does anybody know a quick solution to this? Also, what is the key press to go directly to the bottom of the spreadsheet with out scrolling all the way down.

    Thanks

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    I am a bit confused by your statement "instantly clear/remove/empty cells" if they are empty what will you clear or remove?

    To move to the end of you Sheet use: Ctrl+End or do move to the first blank cell in any Column, select a cell in the Column and push Ctrl+Down arrow



  3. #3
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-12 00:12, Mattrixdesign wrote:
    Is there a way I can instantly clear/remove/empty cells? I just want Excel to show the cells that contain data. It is possible to hide all the cells to the left and the cells to the base but this takes time. Does anybody know a quick solution to this? Also, what is the key press to go directly to the bottom of the spreadsheet with out scrolling all the way down.

    Thanks
    To goto the end of the cell range column or row

    Press End key
    The hold Shift and press the directional arrow keys that you want to goto.

    Then just hide the columns/rows

    Ivan

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Select a row ,place your cursor against the bottom of that row until it changes to a white arrow. Now hold down Contol+Shift and press the down direction. That will select to the bottom, now select hide. Similar process with columns.
    regards
    Derek

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Warrington
    Posts
    201
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thank you!!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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