Append Data To Column In Excel
How do you append data to cells in a whole column in Excel? There are many ways to do this, including creating your own custom macro or formula. However, the easiest way is to use the free Excel Add-In called DigDb. Here’s how:
Step 1: Load the DigDb add-in for Excel
Download the add-in here (which claims to be free for 15 days, but I haven’t seen any problems yet): http://www.digdb.com/download/
Extract the zip file that is provided.
Double click the “DigDB.xlam” file and Excel should automatically open. If it does not, open the file in Excel by using Office Button->Open.
Step 2: Use the Add-In
You may get a message asking you to enable macros. Do so accordingly.
VERY IMPORTANT: AT THIS STAGE SAVE YOUR WORK. IN CASE DIGDB DOES NOT WORK THE WAY YOU EXPECTED IT TO, YOU MAY NOT BE ABLE TO UNDO THE CHANGE.
Then simply go to the Add-Ins tab, and you see the DigDb Add-in menu.
First select the column that you need to append data to, then click the Add-Ins->DigDB->Column->Append.
If you use “Enter Value(s) by text”, a bit of text which you enter will be added before or after each cell in the column.
If you use “Enter Values by Range”, you can select a range of data to append to column.
Step 3: You’re done!
That’s it! DigDB might take a while depending on how much data you are processing. It will create a new column to the right of the column you are appending data to.