Hide all unused rows or columns in Excel example

Hide all unused rows or columns in Excel example

There are cases where user want to display only area where data is populated. In this article I will explain how you can hide all unused rows and columns step by step:

Hide all unused columns

Step 1: Select first column from which you want to hide the columns

Step 2: Press CTRL + SHIFT + RIGHT ARROW key from keyboard to make sure you selected upto last column

Step 3: Right click over the Column header and choose Hide from the popup as shown below or Select Hide Columns by Locating Format dropdown button on Home Tab under Cells group:

Result

Hide Unused Rows

Step 1: Select first row from which you want to hide the rows

Step 2: Press CTRL + SHIFT + DOWN ARROW key from keyboard to make sure you selected upto last row

Step 3: Right click over the Row header and choose Hide from the popup as shown below or you can choose Hide Rows from Home Tab under Format dropdown button under Cells group:

Output

Hide unused Rows and Columns

By applying above steps the final outcome will look like as below:

Leave a Reply

Your email address will not be published.