Deleting Columns
Hi,
I often have to take a whole column in an excel sheet and move its content to another place in the worksheet.
Is there a formula or any other function to activate so that after I transfer the content of the column to its new place, the empty place will be deleted?
For example, I want to take column D, which is between C and E, cut it and paste it in column G and while I do that, the space that exists now between C and E will be deleted.
Is it possible?
Thank you
Raphi Duani
»
- raphiduani's blog
- Login or register to post comments
- 2843 reads
Suggestion from bionicle
Hello,
You can try to use "drag and drop" method while holding SHIFT key and the entire column will be moved to the desired location
Best regards,