Forum Discussion

Anonymous

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 j...

excel

Excel Online

Damien_Rosario
Jan 11, 2018
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

Silver Contributor

Jan 11, 2018

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

Jptrotter45

Copper Contributor

Jul 07, 2025

Damien,

The Control, Shift, Right Arrow does not highlight the columns I want to hide. If I sit and highlight all the columns and use the hide command under the cell tab it works, but the right arrow business does not highlight the columns.