excel 2011 for mac how to hide a sheet based on a cell value

Excel 2011 Hide A Sheet Based On A Cell Value How To Get View

Either of these two methods will work for hiding overflow text.

Maybe you have some extra data worksheets that are referenced, but dont need to be viewed.

Or maybe you have a few rows of data at the bottom of the worksheet that need to be hidden.

Excel 2011 Hide A Sheet Based On A Cell Value How To Get View

In this article, Ill walk you through the different content that can be hidden in Excel and how to get view the hidden data at a later time.

All hidden sheets will be shown in a list and you can select the one you want to unhide.

It can only blank out a cell so that it appears that nothing is in the cell, but it cant truly hide a cell because if a cell is hidden, what would you replace that cell with.

Right-click on a cell or multiple selected cells and then click on Format Cells.

You can click on the cell and you should see the cell remains blank, but the data in the cell shows up in the formula bar.

Note that if you type anything into those cells, it will automatically be hidden after you press Enter.

Also, whatever original value was in the hidden cell will be replaced when typing into the hidden cell.

To hide a row or multiple rows, you need to right-click on the row number at the far left.

To hide a column or multiple columns, you need to right-click on the column letter at the very top.

If you want to hide a formula, you have to do TWO things: set the cells to Hidden and then protect the sheet.

Now click on the Protection tab and check the box that says Hidden.

You can do this by clicking on the Review tab and then clicking on Protect Sheet.

Now youll notice that if you try to view the formulas, by pressing CTRL or by clicking on Show Formulas on the Formulas tab, they will not be visible, however, the results of that formula will remain visible.

When you hover over the cell or select it, the comment will appear in a pop up window automatically.

The comment will still remain and can be viewed by simply going to the Review tab and clicking on Show All Comments.

There you will see an option called No comment or indicators under the For cells with comments, show: heading.

In the example below, the text only exists in cell A1, but it overflows to other cells so that you can see it all.

If you want this behavior without having to type anything into the adjacent cell, you can right-click on the cell, choose Format Cells and then select Fill from the Horizontal Text alignment drop down box.

Note that this is kind of a hack, but it works most of the time.

To get around that, you could simply right-click on the row number and then click on Row Height to adjust the height back to its original value.

Excel 2011 For Mac How To Hide A Sheet Based On A Cell Value