Hello
I am using Excel 2007. I have a table from which I have created two dynamic tables based on a value in a specific column. I am doing this using pivot table.
I am wondering if there is a way I can automatically apply the gridlines only to rows that have contents, as the two tables are dynamic and based on the value in a specific column the rows in one table increases and same number of rows in the second table decreases.
Both these table are placed in the same worksheet below one another. When I initially place them, I have left 3 blank rows, but when I change options in columns and the number of rows changes in the two tables, the gap (number of rows) between the two tables increases or decreases. Also, the grip lines dont change with this.
Can someone please help?
TIA
I am using Excel 2007. I have a table from which I have created two dynamic tables based on a value in a specific column. I am doing this using pivot table.
I am wondering if there is a way I can automatically apply the gridlines only to rows that have contents, as the two tables are dynamic and based on the value in a specific column the rows in one table increases and same number of rows in the second table decreases.
Both these table are placed in the same worksheet below one another. When I initially place them, I have left 3 blank rows, but when I change options in columns and the number of rows changes in the two tables, the gap (number of rows) between the two tables increases or decreases. Also, the grip lines dont change with this.
Can someone please help?
TIA