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.

image120

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.

image121


Page url: http://www.designmaster.biz/support/electrical/documentation/index.html?excel_add_in_hide_column_and_print.htm