DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Insert, Delete, Copy, Select by Row Intervals

  1. Insert - insert a blank row or a selected range before or after the rows after each interval.
  2. Copy out - rows after each interval will be copied to a new sheet.
  3. Select - rows after each interval will be selected and highlighted.
  4. Mark - rows after each interval will be marked by a 'x'
  5. Delete - rows after each interval will be deleted
You will need to set 2 parameters to decide which rows to apply the action:
  1. Starting row number
  2. Interval
Action will take place on the starting row and the rows after each interval. For example, If this is confusing to you, apply 'DigDB->Row Interval->Select...' action on your data first. This action will not change anything, it only selects the rows after each interval, thus showing you the rows that other actions will act on. Below is a demo of the Select by Row Interval action:
  1. Click a single cell in the table area, then invoke 'DigDB->Row Interval->Select...'

    Row Intervals - Insert, Delete, Copy
    Practice file - row-intervals-demo.xls (16k)

    The table will be automatically selected. Now you can set the intervals for action.

    Row Intervals - Insert, Delete, Copy

    Staring from Row 1, after an interval of 2, rows to act will be 1, 4, 7, 11 ...

    Row Intervals - Insert, Delete, Copy

    This action shows what rows will be affected under the starting row and interval settings. You can run this action to verify the settings, then do the Insert, Copy out, Mark, Delete.

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact | Excel Resume Examples ( wehtwrjw )

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.