microsoft excel training london - Shortcut for dragging cells horizontally.....

Hi Gabriel,

If you mean drag the actual contents of the cell to another, you can use cut and paste shortcut commands. Make your selection then use Control+X or Shift+Delete to CUT, move the cursor to your desired new cell and use Control+V or Shift+Insert to PASTE.

If you're talking about resizing the actual column width with the keyboard, I'm pretty sure the only way is to use the menu commands and type in the new width value, like so this:
Select the cell/column. Go to Format (Alt+O) -> Column (C) -> Width (W) -> Type the new width value -> Press Enter.

Or, to adjust the column width to fit your selection, instead of pressing (W) for width, press (A) for Autofit Selection. This way you won't need to guess the width value.

You may also find you could create a macro and assign a shortcut, but you'd probably need to enter a value anyway, so better of using the above method.

I've also searched around to see if there are any keyboard shortcuts of dragging active cells, but can't find any.

Regards, Rich