» Hiding Data Before Printing
CATEGORY - Excel Printing
VERSION - All Microsoft Excel Versions
Hiding a column(s) and/or row(s):
To hide a column(s), select it and press Ctrl+0; to hide a row(s, select it and press Ctrl+9. (To select a row(s) or column(s).
To hide data within the cells:
Change the font color to white.
To hide numbers:
Use Custom Formatting, for example, to eliminate the display of negative figures, use "#,##0 ; ; " for the format (see Tip #58 for the symbols used in Custom Formatting).
To hide areas:
Adding a white text box with clear borders from the Drawing toolbar.
Book Store:
Recommended Books:
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Marketing Plan: A Handbook with Marketing Plan
- Business Analysis with Microsoft Excel (2nd Edition)
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
