» 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:
- The Analysis and Use of Financial Statements
- Microsoft Windows XP Inside Out
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Retire Young, Retire Rich
- Guide to Financial Reporting and Analysis
No comments have been submitted.
