Hiding&ProtectionNotes - cells only" entry like...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Hide Columns B and C. The "report" content should remain visible even though the THE REPORT numbers the report depends on are hidden. Numbers: 182.35 167.35 197.35 164.8 Sum: 711.85 Text: Banana Selected #: 167.35 Add protection to the worksheet, with or without a password, if you My favorite fruit is Banana. Protect sheet.  The sum of numbers is 711.85. The Selected number is 167.35.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: cells only" entry. like. Use Tools, Protection, To make the chart visible even when the data it depends on is hidden, open the "Options" dialog and make the "Chart" tab current. With the chart selected, un check the "Plot visible 1 2 3 4 140 160 180 200 220 A chart that stays visible even though the data it depends on is hidden....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online