On Apple computers, the keyboard shortcut for print is Command + P. Now column A should be unhidden in your Excel spreadsheet.Īlternatively referred to as Control+P and C-p, Ctrl+P is a keyboard shortcut most often used to print a document or page. Select Cells > Format > Hide & Unhide > Unhide Columns. Select the Home tab from the toolbar at the top of the screen. If this doesn't work, then right-click on a row or column identifier and select Unhide. Press Ctrl + Shift + 9 to unhide all rows or Ctrl + Shift + 0 (zero) to unhide all columns. How do I unhide all columns and rows in Excel? To unfreeze rows or columns, click the Freeze Panes command, then select Unfreeze Panes from the drop-down menu. If you want to select a different view option, you may first need to reset the spreadsheet by unfreezing panes. Related Question What is the shortcut key to unhide columns in Excel? How do you unfreeze columns and rows in Excel? Now you should be able to see column A in your Excel spreadsheet. Press and hold down the Ctrl key on the keyboard.ĬTRL+0 hides the selected columns in Excel. Click on a cell in the column you want to hide to make it the active cell. The keyboard key combination for hiding columns is Ctrl+0. Hide Columns in Excel Using a Keyboard Shortcut What is the shortcut key to hide columns in Excel? Using Excel Keyboard ShortcutsĮxcel has provided embedded keyboard shortcut feature for hiding and unhiding rows and columns in excel.What Is The Shortcut Key To Unhide Columns In Excel? On December 13, 2021 Similarly, you can perform steps to unhide the column. Release the mouse click, once you have an appropriate row height. And drag it downward.Īs a result, you would notice that row 4 is gradually visible. Therefore, we would place our mouse cursor between row 3 and row 5.Īdjust your mouse cursor till your mouse cursor converts into a double line with arrow on either side of the line as demonstrated in the screenshot below : Step 1 : Take your mouse cursor at the place in the row heading which has hidden row.
You can perform similar steps to hide the column.įollow the below steps to unhide the row in excel : You would notice that the row number hides as shown in the screenshot below : Release the mouse cursor when the row is invisible. Step 2 : Left click on your mouse and drag the mouse upwards towards the upper line of the row. Your mouse cursor would convert to a line with arrows on both its side as shown in the screenshot below : Step 1 : Take your mouse cursor at the bottom line of the row heading number (which you want to hide). One of the disadvantage of this method is that you can hide only one row/column at a time.įollow the below steps to hide the row in excel : This is the easiest method to hide and unhide row or column in excel worksheet.
Now click on the “Unhide Columns” option from the list. Navigate to the “Hide & Unhide” option from “Format” drop down list as demonstrated above. Similarly, to unhide the column, select the column on the either side of the hidden column. Now select the “Unhide Rows” option from the list as shown in the screenshot below : Navigate your mouse to the option “Hide & Unhide”. Under the group “Cells”, click on the option “Format”. Step 1 : Select the row(s) that you want to hide. Click on the option “Unhide” from this drop-down list.Įxcel has also provided options on the Menu Bar to hide and unhide columns in excel worksheet. You would notice that the hidden row number 4 is now visible with all its data. This would open a list of options.įrom the list of option, select the option “Unhide”. Therefore, we need to select the rows from row number 3 to row number 5. In our case, row number 4 is the hidden row. Step 1 : Select the rows on either side of the hidden row. In order to unhide or show the hidden row or column in excel, follow the below procedure : The data in the row or column does not delete. Click on the option “Hide” from the list of available options.Īs mentioned above, when you hide any row or column in excel worksheet, it is just not visible. Similarly, to hide the column, select the column (that you want to hide). It has just hidden the row (It is just not visible). You would notice that Row number 4 hides in the excel worksheet. From the list of available options, click on the option “Hide”.