![](/uploads/1/2/5/4/125462284/136815634.jpg)
Select the columns before and after the hidden columns (like columns C and F in our example). Right-click the selected column headers and pick Unhide Columns. Select the rows before and after the hidden rows (rows 2 and 4 in our example). Right-click the selected row headers and pick Unhide Rows. Excel: How to use a checkbox form marco to hide column on MAC. Ask Question Asked 5 years, 10 months ago. But when I try to do it on Mac, it doesn't work since Mac doesn't have activeX support. Unhide/Hide rows in excel with a form checkbox. Hot Network Questions.
![Excel Excel](http://www.wikihow.com/images/2/22/Unhide-Columns-in-Excel-Step-6-Version-4.jpg)
Shutterstock. You can hide and unhide rows in by right-clicking, or reveal all hidden rows using the „Format“ option in the „Home“ tab.
Hiding rows in is especially helpful when working in large documents or for concealing information you won’t need until later.Just as you can quickly, you can hide or reveal hidden rows in your spreadsheet as well.In addition to, you may find it helpful to conceal rows you are no longer using without permanently deleting the data from your spreadsheet. To later reveal the hidden cells, you can right-click to unhide individual rows.You can also navigate to the „Format“ option to unhide all hidden rows. This feature is especially helpful if you’ve hidden multiple rows throughout a large spreadsheet.Here’s how to do both. Check out the products mentioned in this article: How to hide individual rows in1.
Open Excel.2. Select the row(s) you wish to hide. Select an entire row by clicking on its number on the left hand side of the spreadsheet. Select multiple rows by clicking on the row number, holding the „Shift“ key on your or keyboard, and selecting another.3. Right-click anywhere in the selected row.4. Click „Hide.“Right-click to hide rows.
Marissa Perino/Business Insider How to unhide individual rows in Excel1. Highlight the row on either side of the row you wish to unhide.2. Right-click anywhere within these selected rows.3.
Click „Unhide.“Highlight adjacent cells to unhide a hidden row. Marissa Perino/Business Insider4. You can also manually click or drag to expand a hidden row. Hidden rows are indicated by a thicker border line.
Move your cursor over this line until it turns into a double bar with arrows. Double click to reveal or click and drag to manually expand the hidden row or rows.
(If you’ve hidden multiple rows, you may have to do this multiple times.) How to unhide all rows in Excel1. To unhide all hidden rows in, navigate to the „Home“ tab.2. Click „Format,“ which is located towards the right hand side of the toolbar.3. Navigate to the „Visibility“ section. You’ll find options to hide and unhide both rows and columns.4. Hover over „Hide & Unhide.“5. Select „Unhide Rows“ from the list.
This will reveal all hidden rows, a feature especially helpful if you’ve hidden multiple rows throughout a large spreadsheet.How to unhide rows in Excel Marissa Perino/Business Insider Related coverage from:.
Hide/unhide rows or columns with plus or minus signPlease do as follows to hide or unhide rows or columns with plus or minus sign in Excel.1. Select the entire rows or columns you need to hide or unhide with plus or minus sign, then click Group in the Outline group under Data tab. See screenshot:2. Then the minus sign is displayed on the left of selected rows, or displayed at the top of the selected columns. Click the minus sign, the selected rows or column are hidden immediately.
And click the Plus sign, the hidden rows or columns are showing at once.Note: For removing the plus or minus sign, please select the rows or columns which you have added plus or minus sign into, then click Ungroup button under Data tab. The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%. Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails. Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range. Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.
![](/uploads/1/2/5/4/125462284/136815634.jpg)