Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Deleting unused col and rows (Excel 2000)

    I have lost it, but the other day I found a quick way to delete all rows and columns that are unused in a spreadsheet, and now I can't find it anywhere.
    I'm trying the old fashioned way, highlight col and rows unused and press delete, but some reason they aren't disappearing...and my tools tracking is not on, so don't know why the old fashioned way ain't doing it...does anyone know the short cut I'm talking about? I have searched wopr before asking and around on the Internet this morning but can't place where I saw it...had to be hear or on one of the MVP webs as that is where all the good stuff I find is.
    NMP
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Deleting unused col and rows (Excel 2000)

    Usually, Excel will reset the last used row/column when you save the workbook.

    Pressing the Delete key does not delete rows or columns, just their contents. If you have selected rows or columns you want to delete, select Edit | Delete, or right-click and select Delete from the popup menu.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Deleting unused col and rows (Excel 2000)

    Then it must have been a shortcut to Hide all columns and rows except any area that I might have selected, e.g. A1:I25, and all else hides. I suppose I'll run across it somewhere. If I do, I will post it.
    Thanks HansV
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Deleting unused col and rows (Excel 2000)

    Found it:

    http://www.beyondtechnology.com/tips003.shtml

    Hiding rows and columns does not just have to be for concealing data or formulas. If your spreadsheet only uses a small area of the 16,777,216 available cells in an Excel worksheet, maybe it would be nice to hide some of that vast unused region to keep users from scrolling off the edge of your working area.

    Here are the simple steps to accomplish this task:


    Select the row header just beneath the used area of your spreadsheet, where you want to start hiding rows.


    Press Ctrl + Shift + Down Arrow. This will highlight everything from your selected row through the bottom of the worksheet.


    From the worksheet's Format menu, choose Row, then Hide.
    Follow the same basic steps to hide columns. The difference will be that you should begin by selecting a column header in the first empty column to the right of your used area, then press Ctrl + Shift + Right Arrow.

    Finally, from the worksheet's Format menu, choose Column, then Hide.


    Thanks to Karen Alston and Bill Irwin for appreciated contributions.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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