How to Hide Columns and Rows in Excel

While working with the large Excel sheets, it might be challenging to go through the countless columns and rows of the data in Excel.

But Microsoft Excel permits you to hide the unnecessary columns and let you work with the larger documents easily. This article will teach you how to hide columns and rows in Microsoft Excel.

Steps to hide columns and rows in Excel using the hide option

·       Choose the column and row which you wish to hide.

·       In case you wish to choose the many columns and rows, then you need to pull the mouse cursor above them.

·       Keep pressing on the “Left Shift” key.

·       Press on every column which you wish to hide.

·       You need to right-click on the given column and rows.

·       You need to pull the mouse cursor above the right column and row.

·       Choose the Hide option.

·       This procedure will hide the chosen columns and rows.

Steps to hide columns and rows by decreasing the width

·       Choose the columns and rows which you wish to hide.

·       You need to right-click on the chosen columns and rows.

·       Select the “Column Width” option.

·       You will get a new window on the screen.

·       Change the width of the column and row into 0.

·       Press on the OK button.

·       The chosen column and row will get hidden from the screen.

Steps to hide columns through the hotkey

·       Choose the columns with the mouse and keyboard.

·       Click on the Control and Space keys.

·       It will choose all the columns and rows.

·       Choose all the columns and rows.

·       Choose the adjacent column and row through this procedure.

·       Click on the Control and nine keys together.

 Steps to hide columns through the hotkey

·       Choose the columns and rows with the mouse and keyboard.

·       Click on the Control and Space keys together.

·       It is given on the system keyboard.

·       Choose all the columns and rows of keys together.

·       It is provided on the system keyboard.

·       Choose the adjacent columns and rows through this procedure.

·       Click on the Control and nine keys together on the system keyboard.

Steps to hide columns through the visual basic

·       Press on the Developer option.

·       It is located on the upper side of the menu.

·       Choose the Visual Basic option.

·       Click twice on the Sheet 1 option.

·       Choose the Insert option.

·       Press on the Procedure option.

·       Enter in the name of the procedure.

·       Enter the below-mentioned code:

Worksheets(“Sheet1”).Columns(“C”).Hidden = True

·       Start saving the sheet and name it as the .xlsm file.

·       Choose the ‘Run’ option.

·       It is located in the VBA menu.

·       Press on the Run Sub or User Form option.

·       It will hide the C column, which is given on Sheet 1.

·       If you want to hide each column, you need to follow the same procedure.

·       Start replacing the row by going to the code.

Leave a Reply

Your email address will not be published. Required fields are marked *