Readers like you help support MUO. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.
I have a list that contains a column with groups of numbers. I want to put a divider between each group. I usually just manually insert a row, but I'm looking for a way to use a rule or macro or something to do this quicker. Here's an example:
12345
12345
12345
23456
23456
34567
34567
I want a divider between "12345" and "23456" and "34567". It can be a row inserted, or divided by color, or whatever to distinguish one group from another. Thank you.
2011-12-11 03:05:00
is it in word, excel...?
2011-12-12 04:17:00
I'm sorry, it's about Excel.
2011-12-12 05:38:00
May be first you do it and record the Macro then use it later for other work.How to Automate Tasks with Macros in Excel 2007http://www.dummies.com/how-to/content/how-to-automate-tasks-with-macros-in-excel-2007.htmlExcel 2002: insert rows automationhttp://forums.techguy.org/business-applications/260300-excel-2002-insert-rows-automation.htmlAdding a divider to an add-in using vba in excel 2007http://www.pcreview.co.uk/forums/adding-divider-add-using-vba-excel-2007-a-t3477933.htmlyou can do so by choosing Rows from the Insert menu. This works for inserting single rows.Then you simply press F4 repeat the command and keep inserting rows.This method involves selecting rows before inserting. if you want to insert 10 rows, select 10 existing rows in the worksheet, then choose Rows from the Insert menu. Excel inserts 10 rows in your worksheet, just before the first row you selected.