Excel Tips - Hide or Remove All Unused Rows and Columns in Excel

Hey team,
This quick video will show you how to hide or remove all unused columns or rows in Excel to create a clean view for your users. We will also cover how to unhide or restore the hidden columns and rows.

[@aeyeieNdKay20]

OMG!!!! Finally!!!! This is exactly what I was looking for. Not the stupid blank-page-view or the special-blanks-deleted method that requires 5-6 steps just to SIMPLY delete unused rows and columns.

[@CareerSolutionsforToday]

Thank you!

[@Falcon-ae96]

Hi Thanks for the amazing tutorial but is it also possible to hide the grey area or center the excel sheet?

[@candacetracy7472]

Thank you for your knowledge. This is exactly what I was looking for. You made it nice and easy for us.

[@CareerSolutionsforToday]

Happy the video helped =)

[@sabinamorgan6882]

Thanks a brief and useful video.

[@CareerSolutionsforToday]

Thank you as well =)

[@hanhtrinh9184]

great tips, thanks

[@CareerSolutionsforToday]

Thank you so much =)

[@thelovelyvalc]

Loved it! Thank you so much!

[@CareerSolutionsforToday]

Thank you!

[@teetee5010]

Thank you very much, this was very helpful👍🏽

[@CareerSolutionsforToday]

Thank you so much!

[@bulelwatofu]

Oh thank you I’ve looking for this🙌🏻. Now how do I insert a comma between 4 digit, eg 5099 to be 5,099?

[@biswadeepsarkar5724]

Hi is it possible to put formula only first line of the cell?
For example
1. Balance as on 30-9-23
2. Abc..............
3.Abc.............
First line i want to Formulalise in order to change the date automatically in every month.

[@mianarshed]

how can we shift whole column filled with entries from one location to another location within the same worksheet?
for example if we want to move whole column of B adjacent to column J or H ?

[@CareerSolutionsforToday]

Check out this video for how to do that ruclips.net/video/XZ3eanIpxF8/видео.htmlsi=D-1D1r6OopbXHbTk

[@lokuuproductions985]

How to change color hire area

[@CareerSolutionsforToday]

Hey there, the background is just based on my Excel theme and that is how you can change it, by adjusting the theme. Let me know if this helps =)

[@dedeepyagamingchanel2444]

Super

[@CareerSolutionsforToday]

Thanks!

[@mansipandit6310]

But i want to also not add data in those unused rows and then sort it is it possible?

[@CareerSolutionsforToday]

Hey there, so Excel will not sort by hidden rows. Let me know if this helps =)

[@markcollins6578]

but how to hide permanently - everytime I go back in the columns & rows reappear

[@CareerSolutionsforToday]

Hey there, I have tested and they stay hidden for me. Do you maybe have a setting enabled to show them or perhaps an older version of Excel?

[@user-er8kh3wh5d]

Can you do it on the android mobile app?

[@CareerSolutionsforToday]

Great question. Looking into it, it doesn't seem like completing these steps in the mobile app would be easy or intuitive. I think it is something Microsoft is looking into for the future. I will keep looking though and if anyone has suggestions let me know.