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

Shift Columns

A wide table with many columns will make it hard to shift columns around. It often takes a lot of copy and cut and paste and scrolling and is often error prone. DigDB allows you shift columns within a table easily.
  1. Click a single cell in the table area, then invoke 'DigDB->Column->Shift...'

    Shift Columns
    Practice file - shift-columns-demo.xls (16k)

    The table will be automatically selected. Now you can select how to shift columns.

    Shift Columns

  2. Shift 'Col5' to be after 'Col2' - use the upper dropdown to select 'Col5', use '<- Add' button to add the colum to the column-to-shift pool; click radion button 'After'; use the lower dropdown to select 'Col2'.

    Shift Columns

    After the shift

    Shift Columns

  3. Shift 'Col5' and 'Col3' to be before 'Col1'

    Shift Columns

    After the shift

    Shift Columns

  4. Shift columns to reverse order - that's the equivalent of shifting Col5, Col4, Col3, Col2 (in this order) to before Col1.

    Shift Columns

    After the shift:

    Shift Columns

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.