I'm using Excel 2016.
I'm using Excel 2016.
One way would be to use the {End}(Home} keys to jump to the last used cell and move one cell to the right.
Then hold the shift key down and {End} (Right} to select all the unused columns, then choose Format..Hide & Unhide and pick the hide columns
Now move one cell down
Then hold the shift key down and {End} (Down} to select all the unused rows, then choose Format..Hide & Unhide and pick the hide rows.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
These were my step:
For columns
- Ctrl + End
- →
- Shift + End, →
- Ctrl + 0
For rows
- Ctrl + End
- ↓
- Shift + End, ↓
- Ctrl + 9
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks