Hi, i'm constantly creating reports and i always have to insert a blank row
after every subtitle row (My supervisor wants it like that dont ask me why)
and it can get very time consuming. Does anyone know an easier way to insert
a blank row after each subtitle row in a report. it would save me tons of
time. Thanks in advance



--
thanks in advance

If it's just to make the data look prettier, then don't do it!

Instead just change the rowheight (double it???) of the rows with subtotals.

Did you use Data|Subtotals (in xl2003 menus) to create the subtotals?

If yes, you can use the outlining symbols to hide the details.
Then select the range/rows you want double the height
Edit|goto|special|visible cells only
Format|row|height (and type in a number twice as big)
Then
format|cells|alignment tab|Text alignment section|vertical dropdown|select Top

Then show the details.

ps. You could even change the font color for those visible total rows to red,
bold to make them stand out better. Maybe drop the rowheight thing completely.

jcontrer wrote:

Hi, i'm constantly creating reports and i always have to insert a blank row
after every subtitle row (My supervisor wants it like that dont ask me why)
and it can get very time consuming. Does anyone know an easier way to insert
a blank row after each subtitle row in a report. it would save me tons of
time. Thanks in advance

--
thanks in advance

--

Dave Peterson

Brilliant! I was thinking only a macro can solve this problem this is much
easer, and keeps my work book small.

"Dave Peterson" wrote:

If it's just to make the data look prettier, then don't do it!

Instead just change the rowheight (double it???) of the rows with subtotals.

Did you use Data|Subtotals (in xl2003 menus) to create the subtotals?

If yes, you can use the outlining symbols to hide the details.
Then select the range/rows you want double the height
Edit|goto|special|visible cells only
Format|row|height (and type in a number twice as big)
Then
format|cells|alignment tab|Text alignment section|vertical dropdown|select Top

Then show the details.

ps. You could even change the font color for those visible total rows to red,
bold to make them stand out better. Maybe drop the rowheight thing completely.

jcontrer wrote:

Hi, i'm constantly creating reports and i always have to insert a blank row
after every subtitle row (My supervisor wants it like that dont ask me why)
and it can get very time consuming. Does anyone know an easier way to insert
a blank row after each subtitle row in a report. it would save me tons of
time. Thanks in advance

--
thanks in advance

--

Dave Peterson

And you could make this into a macro if you really wanted to!

Esrei wrote:

Brilliant! I was thinking only a macro can solve this problem this is much
easer, and keeps my work book small.

"Dave Peterson" wrote:

If it's just to make the data look prettier, then don't do it!

Instead just change the rowheight (double it???) of the rows with subtotals.

Did you use Data|Subtotals (in xl2003 menus) to create the subtotals?

If yes, you can use the outlining symbols to hide the details.
Then select the range/rows you want double the height
Edit|goto|special|visible cells only
Format|row|height (and type in a number twice as big)
Then
format|cells|alignment tab|Text alignment section|vertical dropdown|select Top

Then show the details.

ps. You could even change the font color for those visible total rows to red,
bold to make them stand out better. Maybe drop the rowheight thing completely.

jcontrer wrote:

Hi, i'm constantly creating reports and i always have to insert a blank row
after every subtitle row (My supervisor wants it like that dont ask me why)
and it can get very time consuming. Does anyone know an easier way to insert
a blank row after each subtitle row in a report. it would save me tons of
time. Thanks in advance

--
thanks in advance

--

Dave Peterson


--

Dave Peterson