Insert copied cells
 

Hope someone can help here, I have a spreadsheet which I use several time a day cutting and pasting rows as I shuffle production priorites.

I use the keyboard shortcut CTRL + X to cut a selected row but have to right mouse click and select "insert cut cells" sub menu option to put it back in.

Is there some way of programming a shortcut so the "insert cut cells" can be selected with the keyboard?

Might seem trival but when you have to do it time and time again day after day believe me it'll make a difference

Thanks in anticipation

Martin

Insert copied cells
 

<Ctrl<Shift<+ will do it for you

"Martin B" wrote:

Hope someone can help here, I have a spreadsheet which I use several time a day cutting and pasting rows as I shuffle production priorites.

I use the keyboard shortcut CTRL + X to cut a selected row but have to right mouse click and select "insert cut cells" sub menu option to put it back in.

Is there some way of programming a shortcut so the "insert cut cells" can be selected with the keyboard?

Might seem trival but when you have to do it time and time again day after day believe me it'll make a difference

Thanks in anticipation

Martin

Insert copied cells
 

You can record a macro, if you open a new workbook, create a dummy cell with
some contents, let's say A1, then press ctrl + X, now click
toolsmacrorecord new macro, select a shortcut to use, give it a name and
under store macro select personal workbook, click OK, then select a cell
let's say D1, right click the mouse and select insert cut cells, once you
have done that stop the macro recording (in the little macro recording
floating toolbar click the little blue button). Press Alt + F8, select the
macro, select edit macro, then remove this part

Range("D1").Select

then press Alt + Q to close the editor, close Excel and when prompted to
save changes to the personal.xls select yes

Now when you start Excel again you should have this option

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)


"Martin B" wrote in message
...
Hope someone can help here, I have a spreadsheet which I use several time a
day cutting and pasting rows as I shuffle production priorites.

I use the keyboard shortcut CTRL + X to cut a selected row but have to right
mouse click and select "insert cut cells" sub menu option to put it back in.

Is there some way of programming a shortcut so the "insert cut cells" can be
selected with the keyboard?

Might seem trival but when you have to do it time and time again day after
day believe me it'll make a difference

Thanks in anticipation

Martin

Insert copied cells
 

thanks for the advise, the macro solution works a treat

Martin
"Martin B" wrote in message ...
Hope someone can help here, I have a spreadsheet which I use several time a day cutting and pasting rows as I shuffle production priorites.

I use the keyboard shortcut CTRL + X to cut a selected row but have to right mouse click and select "insert cut cells" sub menu option to put it back in.

Is there some way of programming a shortcut so the "insert cut cells" can be selected with the keyboard?

Might seem trival but when you have to do it time and time again day after day believe me it'll make a difference

Thanks in anticipation

Martin