This is a bit of a weird one in that I don't know how I did what I did by accident, but it would be useful to know...
My spreadsheet contains a (fairly standard) set of data of Surname (col A) Forename (col B) and more info in col c, d, e etc.
I was using the keyboard to select the first 5 cells of data from one row (ie one persons surname, forename etc).
Using the keyboard I navigated to the correct row and moved far left into col A. then using a combination of shift, arrow keys, control+c and Home to copy the cells I wanted.
having fat fingers and it being late in the day I hit a number of keys as well as some of the above and not necessarily in the right order.
what I achieved was to swap the forename and surname cells of that particular row around. True, this is not at all what I wanted to do but with a few seconds of key pressing, I would love to be able to do this at other times. (like when someone enters forename surname in the surname forename cells.
***Have I discovered a keyboard shortcut for swapping cells***?
I only thought this was possible using vba or a new column and copying and pasting into that new column etc.
it would be very useful if someone could tell me how I did what I did. it would be a great shortcut.
thanks in advance.
My spreadsheet contains a (fairly standard) set of data of Surname (col A) Forename (col B) and more info in col c, d, e etc.
I was using the keyboard to select the first 5 cells of data from one row (ie one persons surname, forename etc).
Using the keyboard I navigated to the correct row and moved far left into col A. then using a combination of shift, arrow keys, control+c and Home to copy the cells I wanted.
having fat fingers and it being late in the day I hit a number of keys as well as some of the above and not necessarily in the right order.
what I achieved was to swap the forename and surname cells of that particular row around. True, this is not at all what I wanted to do but with a few seconds of key pressing, I would love to be able to do this at other times. (like when someone enters forename surname in the surname forename cells.
***Have I discovered a keyboard shortcut for swapping cells***?
I only thought this was possible using vba or a new column and copying and pasting into that new column etc.
it would be very useful if someone could tell me how I did what I did. it would be a great shortcut.
thanks in advance.
