|
Hide Column and Print / Hide Column and Print Preview |
Top Previous Next |
|
This DM command is currently being debugged. Both of these commands hide all of the rows in the current column with a value of 0. The print command sends the result immediately to the printer. The print preview command does a print preview, allowing you to examine the results before printing it. This function is useful when you have a workbook where a large quantity of values are 0's. For example, your cost estimate might include a row for each possible breaker size. As breakers are added and subtracted from the project, the quantities are updated automatically. However, most of the quantities are 0.
If you place your cursor in the quantity column as show above and run one of these commands, it will remove all of the rows with a quantity of 0 before printing. The output is much shorter, saving paper and making it easier to read.
|
| Page url: http://www.designmaster.biz/support/electrical/documentation/index.html?excel_add_in_hide_column_and_print.htm |