Learn how to show and hide all formulas in Excel and Google Sheets using shortcut keys and how to hide formulas in Excel using worksheet protection.If you use Excel on a daily basis, then youve probably run into situations where you needed to hide something in your Excel worksheet.Maybe you have some.Updated 5222016 Microsoft Excel 2010 Linking Worksheets Workbooks 1.Topics include inserting, deleting and renaming worksheets linking.Interested in learning more about Excel VBA MrExcel will teach you how to use Microsoft Excel VBA.Check out our site for more information about Excel VBA tutorials.Microsoft Excel Hide Unhide Cells In Excel' title='Microsoft Excel Hide Unhide Cells In Excel' />How to unhide row 1 and column A in an Excel sheet.Hiding and unhiding rows and columns is a straightforward and easy task, unless youre trying to unhide row 1 or column A.When unhiding a row or column, you select the adjacent rows or columns, but theres no row above row 1 or column to the left of column A, which presents a bit of a conundrum.Today, Ill show you how to unhide row 1 and column A.First, lets run through the instructions for hiding and unhiding rows and columns, just in case this task is new to you.To hide a row or column, you click the header to select the entire row or column, right click the selection, and choose Hide from the resulting context menu.To hide multiple noncontiguous rows or columns, select the rows or columns and choose Hide Unhide from the Format dropdown in the Cells group.In Excel 2. 00. 3, choose Column or Row from the Format menu, and then select Hide.You can quickly discern that a row or column is hidden by the missing header.Unhiding is also simple.Select the adjacent columns or rows, right click, and select Unhide from the resulting context menu.In the sheet below, I selected columns C and E to unhide column D.Use the same process to unhide multiple non contiguous rows and columns as you would a single row or column, just select a larger range.Its a simple task, but a problem arises when you want to unhide row 1 or column A because theres no row or column above or to the left, respectively.When row 1 or column A is hidden, enter A1 in the Name Box, and press Enter.Excel will select cell A1, but you wont see that happen, because the cells hidden.Next, click the Format dropdown in the Cells group on the Home tab and choose Hide Unhide.Then, select Unhide and Excel will expose the hidden row or column.In Excel 2. 00. 3, use the Name Box to select cell A1.Then, choose Row or Column from the Format menu, and select Unhide.There are a couple of tricks for unhiding, but Ive found most users forget them because they dont use them often enough to commit them to memory.This technique seems easy for most users to remember.Whats your favorite trick for unhiding row 1 or column AHow to Hide and Unhide Rows and Columns in Excel 2.Software. Microsoft Office.Excel. How to Hide and Unhide Rows and Columns in Excel 2.By Greg Harvey A funny thing about narrowing columns and rows in Excel 2.You can get carried away and make a column so narrow or a row so short that it actually disappears from the worksheetThis can come in handy for those times when you dont want part of the worksheet visible.For example, suppose you have a worksheet that contains a column listing employee salaries you need these figures to calculate the departmental budget figures, but you would prefer to leave sensitive info off most printed reports.Rather than waste time moving the column of salary figures outside the area to be printed, you can just hide the column until after you print the report.Hiding worksheet columns.Although you can hide worksheet columns and rows by just adjusting them out of existence, Excel does offer an easier method of hiding them, via the Hide Unhide option on the Format buttons drop down menu located in the Cells group of the Home tab.Suppose that you need to hide column B in the worksheet because it contains some irrelevant or sensitive information that you dont want printed.To hide this column, you could follow these steps Select any cell in column B to designate it as the column to hide.Click the drop down button attached to the Format button in the Cells group on the Home tab.Excel opens the Format buttons drop down menu.Click Hide Unhide Hide Columns on the drop down menu.Thats all there is to it column B goes poofAll the information in the column disappears from the worksheet.When you hide column B, notice that the row of column letters in the frame now reads A, C, D, E, F, and so forth.You could just as well have hidden column B by right clicking its column letter on the frame and then choosing the Hide command on the columns shortcut menu.Now, suppose that youve printed the worksheet and need to make a change to one of the entries in column B.To unhide the column, follow these steps Position the mouse pointer on column letter A in the frame and drag the pointer right to select both columns A and C.You must drag from A to C to include hidden column B as part of the column selection dont click while holding down the Ctrl key or you wont get B.Click the drop down button attached to the Format button in the Cells group on the Home tab.Click Hide UnhideUnhide Columns on the drop down menu. Download Free Zeit 2 Crack Heads . Excel brings back the hidden B column, and all three columns A, B, and C are selected.You can then click the mouse pointer on any cell in the worksheet to deselect the columns.You could also unhide column B by selecting columns A through C, right clicking either one of them, and then choosing the Unhide command on the column shortcut menu.Hiding worksheet rows.The procedure for hiding and unhiding rows of the worksheet is essentially the same as for hiding and unhiding columns.The only difference is that after selecting the rows to hide, you click Hide Unhide Hide Rows on the Format buttons drop down menu and Hide UnhideUnhide Rows to bring them back.Dont forget that you can use the Hide and Unhide options on the rows shortcut menu to make selected rows disappear and then reappear in the worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |