Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Insert row if condition met
I need to insert a row after totaling several rows above it. The number of
rows vary, there are several spreadsheets and I update these spreadsheets a couple of times a month. Is there way with a macro to do this and like to bold my total line as well. |
#2
|
|||
|
|||
Inserting additional rows into your data is usually a bad thing.
How about an alternative. You used Data|subtotal, right? click on the outlining symbols to the left to just show the rows you want to be "double spaced" Then select your rows in that range Edit|goto|special click visible cells only Adjust the rowheight for those visible rows And then one more step... Format|cells|alignment tab Text alignment section|Vertical dropdown--choose Top. It'll look "double spaced", but you don't have the clutter of empty rows. Acct Supr - DCTC wrote: I need to insert a row after totaling several rows above it. The number of rows vary, there are several spreadsheets and I update these spreadsheets a couple of times a month. Is there way with a macro to do this and like to bold my total line as well. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a reference to lookup and insert a name | New Users to Excel | |||
insert picture | Excel Discussion (Misc queries) | |||
Insert Line Macro | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |