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?
What is method of hiding worksheet in excel 2013?
In Excel 2013, you can hide a worksheet by right-clicking on the tab of the worksheet you want to hide and selecting "Hide" from the context menu. To unhide a worksheet, right-click on any visible worksheet tab, choose "Unhide," and then select the worksheet you want to display again. Alternatively, you can use the Ribbon by going to the "Home" tab, clicking on "Format" in the Cells group, and selecting "Hide & Unhide" to hide or unhide sheets.
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 hide and redisplay a column?
To hide a column in a spreadsheet program like Excel, right-click on the column header and select "Hide." To redisplay the hidden column, select the columns on either side of the hidden column, right-click, and choose "Unhide." In Google Sheets, you can similarly right-click the surrounding column headers to find the "Unhide" option. Alternatively, you can use keyboard shortcuts or the menu options for hiding and unhiding 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 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 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.
