c0nr4d.technix forum logs
Would you like to react to this message? Create an account in a few clicks or log in to continue.
c0nr4d.technix forum logs

information technology, computer hardware/software, data communications, modding, networking, computer tips, web-log & discussions... archive your brains...
 
HomeGallerySearchLatest imagesRegisterLog in

 

 How to hide tabs, cells, columns, and formulas in Excel

Go down 
AuthorMessage
conrad

conrad


Number of posts : 108
Age : 47
Location : Philippines
Registration date : 2008-09-27

How to hide tabs, cells, columns, and formulas in Excel Empty
PostSubject: How to hide tabs, cells, columns, and formulas in Excel   How to hide tabs, cells, columns, and formulas in Excel Icon_minitimeMon Sep 29, 2008 11:00 am

Excel is the most common application I use in the office suite and
there are many times when I need to hide thing in Excel: tabs, sheets,
columns, cells, etc, etc for whatever reason. In this article, I’ll go
through a comprehensive list of items you can hide in Excel.
If you’re interested, you may also want to check out my previous article on how to hide text in Word. Now let’s talk about all the stuff we can hide in Excel!
How to hide tabs/sheets in Excel


To hide a sheet or tab in Excel, right-click on the tab and choose Hide. Pretty easy eh?

How to hide tabs, cells, columns, and formulas in Excel Hidesheetexcel-thumb
Once hidden, you can right-click on a visible sheet and select Unhide. All hidden sheets will be shown in a list and you can select the one you want to unhide.

How to hide tabs, cells, columns, and formulas in Excel Unhidesheets-thumb
How to hide cells in Excel


Excel does not have the ability to hide cells in the traditional
sense that they simply disappear until you unhide them, like with tabs
I showed above. It can only blank out the cells so that it appears that
nothing is in those cells, but it can’t truly “hide” them because of
the fact that if you hide cells, what would you replace them with?
If you greyed it out, you could easily tell there is something
hidden, defeating the purpose of “hiding” them. If you try to shift
cells up and down, then when you unhide the hidden cells, where should
everything shift? You can hide entire rows and columns in Excel so they
are not visible, but can only blank out individual cells. Here’s how.
Right-click on the group of cells and choose Format Cells.

How to hide tabs, cells, columns, and formulas in Excel Formatcells-thumb
On the Number tab, choose Custom at the bottom and in the Type box, enter three semicolons (;;;), without the parenthesis.

How to hide tabs, cells, columns, and formulas in Excel Hidecellsinexcel-thumb
Click OK and now the data in those cells is hidden. To get it back,
follow the above procedure, but choose the original format of the cells
rather than Custom. Note that if you type anything into those cells, it
will automatically be hidden and it’ll look like you didn’t type
anything into it. However, the original value in that cell will be
replaced with what you typed.
How to hide rows and columns in Excel


If you want to hide an entire row or column, select the row(s) and column(s), right-click and select Hide.

How to hide tabs, cells, columns, and formulas in Excel Hiderowsexcel-thumb

How to hide tabs, cells, columns, and formulas in Excel Hidecolumnexcel-thumb
To unhide a row or column, you need to select the row/column before
and the row/column after the hidden row/column. For example, if Column
B is hidden, to unhide it you would need to select column A and column
C and then right-click and choose Unhide.

How to hide tabs, cells, columns, and formulas in Excel Unhidecolumn-thumb
How to hide formulas in Excel


Hiding formulas is slight more complicated than hiding rows,
columns, and tabs. If you want to hide a formula, you have to do TWO
things: set the cells to Hidden and then protect the sheet.
So, for example, I want to hide my sheet with the following secret formulas on them:

How to hide tabs, cells, columns, and formulas in Excel Hideformulasexcel-thumb
First, I will select three cells in column D, right-click and choose Format Cells. Now click on the Protection tab and check the box that says Hidden.

How to hide tabs, cells, columns, and formulas in Excel Hiddenformulas-thumb
Note that this will not hide anything. You now have to click on the Review tab and then click on Protect Sheet.

How to hide tabs, cells, columns, and formulas in Excel Protectsheetexcel-thumb
You can enter in a password if you want to prevent people from
un-hiding the formulas. Now you’ll notice that if you try to view the
formulas (by pressing CTRL + ~), they will not be visible, however the results of that formula will remain visible.
I’m not sure why you would want to do this, but you can also click on the View tab and click on the Hide button under Split. This will hide the entire workbook in Excel!
So now you’ve learnt how to hide workbooks, sheets, rows, columns, cells, and formulas! That’s it. Enjoy!
Back to top Go down
 
How to hide tabs, cells, columns, and formulas in Excel
Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
c0nr4d.technix forum logs :: c0nr4d.technix - Forum Site :: Tech Speak! (Computers, Techs, Cellphones&Gadgets, Modding, Hacking..etc.)-
Jump to: