0
Click home tab, click hide and unhide, click unhide sheet. Click home tab, click hide and unhide click hide sheet.
Wiki User
∙ 12y ago
Wiki User
∙ 9y agoCtrl - 9 hides a row. Ctrl - Shift - 9 unhides a row.
Ctrl - 0 hides a column. Ctrl - Shift - 0 unhides a column.
Add your answer:
Earn +20 pts
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.
What does hide and unhide do in Excel?
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.
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 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.
What does alt f1 do in excel 2007?
Hide The menu Options.
How do you unhide someone on Skype?
i hide my friend.but now i want add him
I have created a worksheet in Excel and only want to print Columns A and G. How do I do this?
To set the area of an Excel worksheet that will be printed select the range that you want to print and go to the File... Print Area... Set Print Area menu. You can also hide columns that you don't want to see on a print-out by right clicking on the column header and selecting Hide.
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.
Can you hide columns and rows in Excel?
Yes you can. Ctrl - 9 hides a row. Ctrl - 0 hides a column. Add the Shift key to those combinations and they can be unhidden.
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
