#How to unhide first column in excel mac how to
If you'd rather not take your hands off the keyboard, you can quickly hide the selected row(s) by pressing this shortcut: Ctrl + 9 How to unhide rows in ExcelĪs with hiding rows, Microsoft Excel provides a few different ways to unhide them. In case you don't want to bother remembering the location of the Hide command on the ribbon, you can access it from the context menu: right click the selected rows, and then click Hide. Under Visibility, point to Hide & Unhide, and then select Hide Rows.Īlternatively, you can click Home tab > Format > Row Height… and type 0 in the Row Height box.Įither way, the selected rows will be hidden from view straight away.Go to the Home tab > Cells group, and click the Format button.If you enjoy working with the ribbon, you can hide rows in this way: With the rows selected, proceed with one of the following options. To select non-contiguous rows, click the heading of the first row and hold down the Ctrl key while clicking the headings of other rows that you want to select.Or select the first row and hold down the Shift key while selecting the last row. To select multiple contiguous rows, drag across the row headings using the mouse.To select one row, click on its heading.Cannot unhide rows in Excel - solutions to common problemsĪs is the case with nearly all common tasks in Excel, there is more than one way to hide rows: by using the ribbon button, right-click menu, and keyboard shortcut.Īnyway, you begin with selecting the rows you'd like to hide:.
Tips and tricks for hiding and showing rows.This article will teach you both options. On the other hand, when updating your own sheets or exploring inherited workbooks, you would certainly want to unhide all rows and columns to view all data and understand the dependencies. This technique is often used to conceal sensitive data or formulas, but you may also wish to hide unused or unimportant areas to keep your users focused on relevant information. If you want to prevent users from wandering into parts of a worksheet you don't want them to see, then hide such rows from their view. It also explains how to show hidden rows in Excel and how to copy only visible rows. 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.The tutorial shows three different ways to hide rows in your worksheets. How to hide or unhide rows or columns using shortcut key 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
0 kommentar(er)
