Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collapsing a table
I have an Excel table, defined as "database" that contains 100 rows, followed
by a totals line. My problem is this: Sometimes I will need to use all 90 rows in the table, but quite often, there will be a need for considerably fewer rows, and I wind up wasting paper printing all the blank rows in the table that contain no data. Is there a was to collapse the table so that it does NOT show all the blank record lines? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collapsing a table
I would set up a macro or script that would check each line in the table and
hide the row if it is blank. Do your printing, then unhide the hidden rows later. "jayceejay" wrote: I have an Excel table, defined as "database" that contains 100 rows, followed by a totals line. My problem is this: Sometimes I will need to use all 90 rows in the table, but quite often, there will be a need for considerably fewer rows, and I wind up wasting paper printing all the blank rows in the table that contain no data. Is there a was to collapse the table so that it does NOT show all the blank record lines? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collapsing a table
Record the steps as you select a cell in the table, and choose
DataFilterAutoFilter. Then, filter one of the columns for Non-blanks. Print the sheet Choose DataFilterAutoFilter, to remove the filter jayceejay wrote: I have an Excel table, defined as "database" that contains 100 rows, followed by a totals line. My problem is this: Sometimes I will need to use all 90 rows in the table, but quite often, there will be a need for considerably fewer rows, and I wind up wasting paper printing all the blank rows in the table that contain no data. Is there a was to collapse the table so that it does NOT show all the blank record lines? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collapsing a table
That's a great idea, but it's the code I am struggling with. The number of
blank rows is going to be different each time, and I am probably making this harder than it needs to be. The only macro's I have ever done are of the point & click variety. "Martin" wrote: I would set up a macro or script that would check each line in the table and hide the row if it is blank. Do your printing, then unhide the hidden rows later. "jayceejay" wrote: I have an Excel table, defined as "database" that contains 100 rows, followed by a totals line. My problem is this: Sometimes I will need to use all 90 rows in the table, but quite often, there will be a need for considerably fewer rows, and I wind up wasting paper printing all the blank rows in the table that contain no data. Is there a was to collapse the table so that it does NOT show all the blank record lines? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop pivot table fields from collapsing in 2007? | Excel Discussion (Misc queries) | |||
collapsing rows together | Excel Worksheet Functions | |||
collapsing rows | Excel Worksheet Functions | |||
Expanding and Collapsing | Excel Discussion (Misc queries) | |||
Collapsing Rows | Excel Discussion (Misc queries) |