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.

[aeyeieNdKay]

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.

[candacetracy]

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

[Falcon-ae]

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

[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?

[teetee]

Thank you very much, this was very helpful👍🏽

[biswadeepsarkar]

Hi is it possible to put formula only first line of the cell?
For example
1. Balance as on 30-9-23
2.

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 ?

[mansipandit]

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

[erkhwhd]

Can you do it on the android mobile app?

[markcollins]

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