Forum Discussion
Deleted
Jan 11, 2018Need 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_RosarioSilver 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 BuelkeCopper 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_RosarioSilver 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
Thank you Damien - Def helped
- Damien_RosarioSilver ContributorAwesome 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