To hide a row or rows using a keyboard shortcut: Select the row or rows you want to hide.When the mouse pointer turns into a split two-headed arrow, double-click.Hover the mouse over the hidden column headings.Select the column headings to the left and right of the hidden columns(s).To unhide a column or columns by double-clicking: Click Visibility, select Hide & Unhide and then Unhide Columns.To select all columns, click the box to the left of the A and above the 1 on the worksheet or press Ctrl + A (twice if necessary). Select the column headings to the left and right of the hidden column(s).To unhide a column or columns using the Ribbon: If this doesn't work, use one of the other methods. To unhide all columns, click the box to the left of the A and above the 1 on the worksheet or press Ctrl + A (twice if necessary). Select the column headings to the left and right of the hidden column(s) by dragging.To unhide a column or columns using a keyboard shortcut: Right-click and select Unhide from the drop-down menu.
To unhide a column or columns by right-clicking:
You can also use the Ribbon method or the right-click method to hide columns.
To hide a column or columns using the Ribbon: To hide a column or columns using a keyboard shortcut: Right-click and select Hide from the drop-down menu.Select the column or columns you want to hide.To hide a column or columns by right-clicking: Click in the intersection box to the left of the A and above the 1 on the worksheet.Press Ctrl + A (press A twice if necessary).To select non-contiguous rows, click the heading of the first row and then Ctrl-click the headings of the other rows you want to select.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.
HOW DO I HIDE COLUMNS IN EXCEL HOW TO
Recommended article: How to Lock and Protect Excel Worksheets and Workbooks Selecting columns or rows in Excel
HOW DO I HIDE COLUMNS IN EXCEL PASSWORD
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)
0 kommentar(er)
