Gabriel has attended:
Excel Advanced course
Shortcut for dragging cells horizontally.....
Is there a keyboard shortcut for dragging active cells horizontally instead of using the mouse?
RE: 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
RE: shortcut for dragging cells horizontally
sorry, i should've been more specific, i was talking about dragging a formula horizontally accross a number of cells (akin a to double clicking a formula in a coulmn and it copying to the end of the column)
RE: shortcut for dragging cells horizontally
Hmm, I THINK I know what you mean.
For example, say the formula you want to end up with is =SUM(A1:D1)
Type in =SUM(
Then use your arrow keys to go to the first cell. Now hold SHIFT and continue using the arrow keys to make your selection. Once you're done, type the closing bracket ) and then press Enter to finish the formula.
If you're editing a formula, press F2 on the cell you want to edit, delete the middle part between the brackets, make sure your cursor is within the brackets, then press F2 again... now you can go and make your selection using the keyboard and SHIFT key.
Does this answer your question? I hope so. If not, get back to me and I'll try to help or ask one of our Excel experts. If it does answer your question, please mark this question as resolved.
Regards, Rich