Once done the rows or columns that you selected will now be hidden. For an even quicker option, simply right click and select hide. Click Format > Hide & Unhide > Hide Rows or Hide Columns. With your selection made, navigate to the Cells group on the Home tab. If the desired areas are not next to each other you can hold down the Control key (Command if on a Mac) and make your selection. To select consecutive rows or columns simply hold down the Shift key and select or use the mouse to highlight the options you wish to hide. Selections can be next to each other, though this is not mandatory. You can select a single row or column or multiple rows or columns. How to Hide Rows and Columns in Excelįirst, select the rows or columns that you would like to hide. This quick guide will explore a few methods that can be used to hide and unhide rows and columns in Excel. This allows you to focus on only the data that is necessary for you to complete the task at hand. When dealing with large data sets in Excel it can be useful to hide rows and columns.
