This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 2ae49f5f60acbccdfe1cf74e4cef2660dc4bdf45.xls 12/20/2011 Hiding/Unhiding and Working with Visible Cells Sample Worksheets in this Workbook Sample Data, Hidden Data and Calculations, Hidden Data and Charting Hiding Excel Elements Hiding Workbooks and Worksheets Hiding Rows and Columns Adding a Protective Password Hiding Window Elements When you hide parts of a workbook, the data is removed from view but is not deleted from the workbook. If you save and close the workbook, the hidden data remains hidden the next time the workbook is opened. If you print a range with hidden data, Excel doesn't print the hidden cells. Hide workbooks or work sheets to reduce the number of windows and sheets on the screen or to prevent changes. For example, hide sheets that contain sensitive data or hide a workbook containing macros so that the macros can run but the macro workbook isn’t visible. A workbook or worksheet you hide remains open, and other documents can use the information. Choose Window, Hide to hide the current workbook. To display a hidden workbook, open Excel, choose Window, Unhide and choose the hidden workbook from the dialog that displays. Choose Format, Sheet, Hide from the menus to hide a worksheet. To unhide the worksheet, choose Format, Sheet, Unhide and choose the sheet name to unhide. Hide selected rows and columns of data that you aren't using or to simplify or condense. Protect a hidden workbook, worksheet or sheet elements with a password. Add a password by choosing File, Save As and clicking the Tools drop-down menu at the upper right of that dialog. From the drop down list that displays, choose General Options and then complete the password information. You can hide most window elements including the Windows taskbar and the Excel title bar, toolbars, the formula bar, and the status bar. These elements are hidden as long as the workbook is open. If you close and reopen the workbook they’re redisplayed. Use the commands View, Full Screen. As ignm ent 1 Level 1Task 3 output. Sample Data Because this data is in Excel list form at, it's easy to hide selected cel s by ap lying subtotals or grouping or by using one of Excel's filtering to ls. Sale s D ivisio n M arke t It e m U nit Vo lu m e C entral C olum bus Flow er Pots 2,767 C entral C olum bus Flow er Pots 2,857 C entral D etroit Flow er Pots 76 C entral D etroit Flow er Pots 19 C entral Wichita Flow er Pots 8,2 3 C entral Wichita Flow er Pots 5,348 C entral Wichita Flow er Pots 7,795 C entral Wichita Flow er Pots 3,718 C entral Indianapol is Bat eries 3,706 C entral C olum bus C urtains 4,3 6 C entral D etroit C urtains 4,840 C entral Wichita D uct Tape 4,963 C entral C hicago Flo r Lam ps 45,3 6 C entral C hicago Flo r Lam ps 63,019 C entral C hicago Flo r Lam ps 27,057 C entral C hicago Flo r Lam ps 17,97 C entral C hicago Flo r Lam ps 1 ,635 C entral C hicago Flo r Lam ps 9,508 C entral C hicago Flo r Lam ps 5,457 C entral C hicago Flo r Lam ps 5,085 C entral C hicago Flo r Lam ps...
View Full Document
- Spring '01
- Massachusetts Bay Transportation Authority, Amtrak, Back Bay, MBTA Commuter Rail, Downeaster