Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
key board short cut for insert cut cells | Excel Discussion (Misc queries) | |||
insert picture to a specfic range of cells | Excel Discussion (Misc queries) | |||
Macro to insert copied cells | Excel Discussion (Misc queries) | |||
How do I insert a symbol BEFORE text for multiple cells in Excel? | Excel Worksheet Functions | |||
How can I Insert a Comment into multiple cells in Excel 2003? | Excel Discussion (Misc queries) |