To select multiple contiguous rows, drag across the row headings using a mouse or select the first row and then Shift-click the last row.To select one row, click its heading or select a cell in the row and press Shift + Spacebar.To select non-contiguous columns, click the heading of the first column and then Ctrl-click the headings or the other columns you want to select.To select multiple contiguous columns, drag across the column headings using a mouse or select the first column and then Shift-click the last column.To select one column, click its heading or select a cell in the column and press Ctrl + spacebar.It's important to be able to quickly select columns or rows in Excel if you want to hide them. Recommended article: How to Lock and Protect Excel Worksheets and Workbooks Selecting columns or rows in Excel You will not be able to hide or unhide rows or columns if the worksheet has been protected with a password (and you don't have the password to unprotect it), if content has been disabled or if the file is read only. Some users may want to hide all of the unused columns to the right and unused rows below the data to clean up the workspace and display only relevant information to team members or clients. You can quickly unhide all columns or rows as well. You can hide or unhide columns or rows in Excel using the context menu, using a keyboard shortcut or by using the Format command on the Home tab in the Ribbon. Hide and Unhide Rows and Columns in Microsoft Excel (with Shortcuts)īy Avantix Learning Team | Updated January 29, 2022Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019 and 365 (Windows)

Jow to unhide a column in excel