Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am having 2 datasheets in one excel file. i want to import complete columns from one datasheet to another.

Remember i have to import complete columns like column a, b, c etc.

Is there any way to do so without manually copying each and every cell in the datasheets?

Right now I copy one cell at a time, that too manually. And that is a very painful and non efficient method.

thanks!

share|improve this question

migrated from stackoverflow.com Aug 13 '12 at 20:29

This question came from our site for professional and enthusiast programmers.

    
Why don't you just select whole columns and copy-paste? –  Tim Williams Aug 2 '12 at 16:35

1 Answer 1

To select an entire column, simply left-click on the letter of the column you want. To select multiple columns, click and drag over the appropriate columns. The other method is to select the top cell, then press Shift+Ctrl+[Down Arrow], which selects the last occupied row (or the very last row if there's no values in between).

That said, you may want to look up some Excel tutorials since this is pretty basic stuff. It'll boost your confidence and knowledge, and you may even be able to help others!

derp

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.