Forum Discussion

Deleted's avatar
Deleted
Jan 11, 2018
Solved

Need help with Excel

I made an Excel worksheet database, but the dumb thing is way to long and deep - how do I control unused rows and columns since Excel fabricates thousands of these? I haven't used Excel much so I'm just learning.

  • Hi Ronald

     

    Try this to remove unwanted rows and columns.

     

    Remove rows

    1. Go to the row of your sheet that you want to remove (e.g. Row 13).

     

     

    2. Press Ctrl + Shift + Down Arrow to select all rows from your starting point to last (e.g. Row 1048576).

     

    3. Go to your Home tab menu, under the Cells section, open Format > Hide & Unhide > Hide Rows. This will now hide all the rows that you have selected.

      

     

    4. Now select the last column of your spreadsheet (e.g. Column F).

     

     

    5. Press Ctrl + Shift + Right Arrow to select all columns from your starting point to the last column (e.g. Column XFD).

     

    6. Go to your Home tab menu, under the Cells section, open Format > Hide & Unhide > Hide Columns. This will now hide all the columns that you have selected.

     

     

    If you ever need to unhide the rows and columns, just go to the Format menu item and choose Unhide Rows and Unhide Columns.

     

    I hope that helps!

     

    Cheers

    Damien

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor

    Hi Ronald

     

    Try this to remove unwanted rows and columns.

     

    Remove rows

    1. Go to the row of your sheet that you want to remove (e.g. Row 13).

     

     

    2. Press Ctrl + Shift + Down Arrow to select all rows from your starting point to last (e.g. Row 1048576).

     

    3. Go to your Home tab menu, under the Cells section, open Format > Hide & Unhide > Hide Rows. This will now hide all the rows that you have selected.

      

     

    4. Now select the last column of your spreadsheet (e.g. Column F).

     

     

    5. Press Ctrl + Shift + Right Arrow to select all columns from your starting point to the last column (e.g. Column XFD).

     

    6. Go to your Home tab menu, under the Cells section, open Format > Hide & Unhide > Hide Columns. This will now hide all the columns that you have selected.

     

     

    If you ever need to unhide the rows and columns, just go to the Format menu item and choose Unhide Rows and Unhide Columns.

     

    I hope that helps!

     

    Cheers

    Damien

    • Don Buelke's avatar
      Don Buelke
      Copper Contributor

      I previously hid unwanted rows and columns on my worksheets, but now have the need to add more rows on some. Unhiding columns worked as described by selecting column J in my application and with Ctrl-shift-right arrow marked all the columns to hide and they unhid when I made that selection. However, with the rows. nothing transpired until I selected the green arrow at the top of the rows column and then they were replaced.

      • Damien_Rosario's avatar
        Damien_Rosario
        Silver Contributor

        Hi Don

         

        To unhide rows, try these instructions.

         

        1. Highlight the row above and below where the hidden row/s are.

         

        Note the hidden rows between rows 4 and 8. 

        2. Right click onto the row number (e.g. 4) and click onto Unhide.

         

         

        3. This will unhide your hidden rows.

         

         

        If you are looking to just add a blank row and not unhide them, then just right click onto a row number and click onto Insert.

         

        How that is what you are after. Please let me know if it's not?

         

        Cheers

        Damien

         

    • Deleted's avatar
      Deleted

      Thank you Damien - Def helped

      • Damien_Rosario's avatar
        Damien_Rosario
        Silver Contributor
        Awesome Ronald. Could you mark it as the best response so that other users will know we have resolved this?

        Have a great weekend.

        Cheers
        Damien

Resources