0
Hide and unhide literally do what they say. They enable you to hide and unhide rows and columns on a worksheet. Sometimes you may have some data on a worksheet that is needed, but does not have to be seen, so it can be hidden. A formula that is important on the sheet may be based on another formula, that does not need to be displayed. You may want to hide data that supports a formula. There may be data that you do not want users to see, which will prevent them from editing it or even deleting it, which may affect other formulas. For these and lots of other reasons, sometimes it is useful to be able to hide rows and columns in a worksheet, so this option is available.
What else can I help you with?
How do you collapse rows in Excel?
There is no function to collapse rows in Excel, but you can hide rows you do not want to display. Highlight the rows you would like to hide and select Format | Hide and Unhide | Hide Rows.
How do you unhide and hide rows and columns in excel 2007?
Click home tab, click hide and unhide, click unhide sheet. Click home tab, click hide and unhide click hide sheet.
To hide a column in Excel begin by selecting the column and then what?
You can press Ctrl and the zero key. Ctrl-Shift-0 will unhide it. There is also the column options which include hiding and showing columns.
How do you unhide someone on Skype?
i hide my friend.but now i want add him
How can hide the virus from mobile memory card by using Unhide software?
By files virus
What is the word keyboard shortcut to hide text?
Pressing and holding the Ctrl key and holding the Shift key and pressing the 8 key on the main keyboard will show what are known as the special characters. This will include spaces, tabs, paragraph marks and hidden text. It will appear with a dotted line under it. Pressing the same combination again will hide them again.
How do you unhide your clothes on imvu?
If the person hides their outfit, you cannot view it at all.
How can you hide or unhide a disk drive in Windows XP?
my desk top c & d drives hide (dont show in C & D drive )but system is working how un hide my C & D drives
How to hide columns of a spreadsheet in Microsoft Excel 2007 with the steps?
To hide columns of a spreadsheet in Microsoft Excel 2007 simply select the columns and click on the hide option.
How do you get back the hide lines in Google sketch up?
click on then as they will be visible to you outside final redfering and right click to access unhide
How do you unhide the files on computer?
in windows open folder options click the views tab and uncheck the box that says "hide extensions for known file types"
What does alt f1 do in excel 2007?
Hide The menu Options.
