That works fine until you try to unhide column A, as there’s only one. To do: Select a cell that you want to hide its row or columns, then use the following keyboard shortcut keys.Ĭtrl + Shift + (: Unhide the hidden rows within the selection.Ĭtrl + Shift + ): Unhide the hidden columns within the selection. After selecting the hidden column and its adjacent columns, choose Column from the Format menu and then select Unhide. Note: The double line between two columns is an indicator that youve hidden a column. The hidden column(s) display again highlighted along with the columns on either side. You can quickly unhide all columns or rows as well. To unhide the hidden columns, just like with hidden rows, select the columns both to the right and left of the hidden columns, right-click on one of the column headers, and select Unhide from the popup menu.
Right-click the selected columns, and then select Hide. Applies to: Microsoft Excel 2013, 2016, 2019 and 365 (Windows) 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.
Unhide a column in excel 2013 Pc#
PC Shorcut:Ctrl+0 Mac Shorcut:+0 Hide Row This Excel Shortcut hides a row or rows from a worksheet.
Unhide a column in excel 2013 how to#
How to hide or unhide rows or columns using shortcut key Select one or more columns, and then press Ctrl to select additional columns that arent adjacent. Hide Column This Excel Shortcut hides a column or columns from a worksheet. Step 3: Under Visibility, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns. Or press Ctrl+A to select all cells on a worksheet. Option 2: Show all hidden rows and columns at the same time. When you find there is a row or column hidden, you can simply drag the gridline to show it. Option 1: Unhide a row or column by dragging the gridline. Option 2: Go to the Home tab, click Format, point to Hide & Unhide, then click Hide Rows or Hide Columns. Option 1: Right-click and select Hide row or Hide column from the menu that appears, To hide rows or columns in Excel worksheet, select the rows or columns that you want to hide. In this guide, you will learn several ways to show or hide a row or column, and display all hidden rows and columns at the same time. This is a quick guide on how to hide a row or column in Excel. How to Hide or Unhide Rows or Columns in Excel How to Hide and Unhide Columns and Rows in Excel: You can easily hide columns when working within an Excel spreadsheet and just as easily unhide them.
0 kommentar(er)
