Excel. How to hide all unused cells in all columns and all rows. Now updated for all versions.

This video will demonstrate the procedure to hide all unused cells in all columns and rows.
Now updated to cover all Excel versions from Excel 2000 onwards.

Screen recording software: Camtasia for Windows 18.00
Hardware: Dell 24 2700 all-in-one 1tb hd 8mb RAM 23.8" touch screen
Operating system:Windows 10

[hafizurrahman]

Thank you for your short and Clear Explanation.
Could not find a word more than thank you

[teeteechau]

WOW, THANK YOU. I’ve been going crazy trying to figure this out

[everlineobonyo]

thank you sir, was in a business analysis class and my tutor was so fast - got to learn faster here, thank you

[lainerafie]

Tq so much....ur explanation is clear .May God bless you

[littlemeowmin]

U save my life thanks for the tutorial

[KevinHeiden-wjir]

Thank You, it works great!! Wish I had found you sooner!!

[stevena]

Thank you !!! I could not figure this out, very helpful video 👌🏻

[sunshined.micabani]

THANK YOU SO MUCH! THAT HELPED A LOT!!!!

[seanneas]

Thanks for the video. Is there a way to change the colour of the unused space?

[MelanieRothwell]

Hi, when I hide columns & rows the backgound of the workbook is white & not grey, so does not look any different. Is there somthing else I can do? Thanks

[shineshinenarayanan]

Pls tell me how to delete these unused blank columns on right to reduce the file size..

[SGTrainingStable]

Your directions did not work for me—got an error message: “Can’t push objects off the sheet.”