You are here: HOME >>> Excel Invoice Manager

Reports - Setting Visible Columns

Click the Columns button on any report worksheet to display the Columns window, which lists all available columns on the current report worksheet, and allows you to set the visible columns for that report.

For example, below is the Columns window displayed by clicking the Columns button on the Sales Report worksheet.

(Click to enlarge)

To hide a column, clear the checkbox before the column name. There is ONE exception: The first column on each report worksheet is the key column to sort and group the report data. DO NOT hide or delete the first column of each report.

In general, the number of available columns is sufficient. Most of the time, you will want to hide some of the columns. This is not a problem unless you want to send the report to someone else. You must carefully review those hidden columns when sending out report worksheets. Be very careful that these hidden columns do NOT provide information that you do NOT wish to share with others.

The Settings window provides a Remove Hidden Rows and Columns after Extracting Report option to help you remove those hidden columns automatically. If you need to send out an extracted report, DO NOT clear that checkbox.

Excel Invoice Manager Free Download and Try (5.13 MB)

Learn More Excel Invoice Manager Home What's New Difference between Editions Quick Start Introduction Before Using Invoice Template Working with Excel 2007 Installing / Upgrading Settings Workbook Taxes Misc Data Interface Database In-Cell Lookup Print Customers Creating Customer Editing Customer Customer Detail Products Creating Product Editing Product Product Detail Invoices Creating Invoice Editing Invoice Invoice Detail Payments Adding Payment Editing Payment Payment Detail Reports Generating & Printing Reports Setting Visible Columns Extracting Reports Common Tasks Using the Search Bar Using Data List Windows Importing Data into Excel Invoice Manager Networking Working with Form Properties File Free Invoice Form with Support for Incomplete Lines on Invoice Body Using Credit Note or Credit Memo Custom Fields Custom Fields - Overview Custom Invoice Fields - Tutorial Customizing the Invoice Template Customizing the Invoice Template Tutorial: Adding Extra Rows to Invoice Body Tutorial: Adding a Notes Field to Your Invoice Template Tutorial: Adding or Removing the "Same As Bill To" Button Tutorial: Adding a Clear button to the Report Worksheets Tutorial: Displaying Summary Information on Customer Statement Tutorial: Creating a Receipt Form Using Multiple-Line Address in Invoice Form Printable Invoice - Invoice Printing in a Flexible Way More Topics Registration and Services Reference

Online-Only Articles Billing Software Powered by Excel Buttons in the Template Don't Work Sample Invoice Template: Using handwriting Signature Sample Invoice Template: Using Drop-Down List Sample Invoice Template: Long Product Descriptions Sample Invoice Template: Using Line# as Product IDs How to: Password-Protecting an Invoice Template How to: Transferring Excel Invoice Manager to a New System How to: Removing Auto-created Macros from Your Invoice Template Creating a Packing Slip Template Modifying Standard Fields with Database Designer How Do I Replace the Product IDs with Line Numbers Invoice Template with Support for Product-Type Specific Tax Rates Editing Paid Invoices Working with Multiple Companies or Currencies Tutorial: Adding New Fields to Reports Sample Invoice Template: Displaying 'FREE' for Zero Values Customizing Header and Footer of Printed Invoices

Home	Contact Us	Privacy	Link to Us
copyright © Office-Kit.com, all rights reserved