How to Hide Unused Rows and Columns in Excel

This post will guide you how to hide all unused rows and columns in Excel. How do I grey out unused cells in Excel 2013/2016. How to hide all blank columns in Excel.

Hide Unused Rows and Columns


Assuming that the current working area is A1:C5 in your worksheet, and you need to hide all unused cells, rows and columns in Excel. You can use Hide Rows and Hide Columns command to hide rows and columns. Here are the steps to hide unused rows and columns:

#1 select the row header A6 to select the entire row.

hide unused rows and columns1

#2 press Ctrl + Shift + Down Arrow keys on your keyboard, and you can select all rows but working rows.

hide unused rows and columns2

#3 go to HOME tab, click Format command under cells group. And select Hide & Unhide menu from the drop down menu list, and then select Hide Rows.

hide unused rows and columns3

#4 All selected rows except working area are hidden.

hide unused rows and columns4

#5 select the column header D to select the entire column.

hide unused rows and columns5

#6 press Ctrl + Shift + Right Arrow keys on your keyboard, and all columns but working area are selected.

hide unused rows and columns6

#7 go to HOME tab, click Format command under cells group. And select Hide & Unhide menu from the drop down menu list, and then select Hide Columns.

hide unused rows and columns7

#8 All selected columns except working area are hidden.

hide unused rows and columns8

 

Leave a Reply