Mouseless Dragging of the topmost cell to cells below

Long route: Copy the cell (CTRL+C) and then select the range by holding the shift key and paste it((CTRL+V).

Short route: No need to copy the cell. Just select the range including the topmost cell by holding the shift key and hit CTRL+D.

Recent Comments

David Clark: TOTALLY USEFUL. a lot easier than writing CODE

federico: Thanks for the tip this help me figured out a way to make a list of a karaoke collection the easy ...

John: The only problem with this method is if your data will be used in a Pivot Table. The Pivot Table wi...

Nirmala: Good marco. Something that I was trying to figure out for a long time. Thanks. It helped me a lot.. ...

KRISS: Thank you for filling in one of many gaps in Microsoft's "help" information.

iceman: This is nice

judgepax: Thank you for the wonderful macro! No one else seemed to know how to do this, so you just saved me ...

Riddha: This is cool! Really helped me to move my excel skills a notch up! Thanks!

malcolm: thank you massivley. that little problem was truley annoying.

JT: THANK YOU!!!!!!!!!!!!!!!!

Nicki Soules: Thank you for this information. Sounds like we are not the only computer people that have had this ...

Daniel: Another method is Data - Text to Columns - Choose Fixed Width you can do more than 2 splits this...

Most Popular Posts