Shift Columns

DigDB

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

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.

Click a single cell in the table area, then invoke 'DigDB->Column->Shift...'

Practice file - shift-columns-demo.xls (16k)
The table will be automatically selected. Now you can select how to shift columns.
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'.

After the shift
Shift 'Col5' and 'Col3' to be before 'Col1'

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

After the shift:

Need more?

Browse the complete list of DigDB's powerful features listed on the front page.
If you see errors or things not working, check out our error reference page.

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 and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.