Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 268
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 299
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
key board short cut for insert cut cells R. D. Childers Excel Discussion (Misc queries) 3 February 8th 06 08:45 PM
insert picture to a specfic range of cells CORY Excel Discussion (Misc queries) 8 February 3rd 06 06:50 PM
Macro to insert copied cells [email protected] Excel Discussion (Misc queries) 17 January 18th 06 11:40 AM
How do I insert a symbol BEFORE text for multiple cells in Excel? amspalinger Excel Worksheet Functions 6 May 17th 05 07:26 PM
How can I Insert a Comment into multiple cells in Excel 2003? Lance Excel Discussion (Misc queries) 1 May 9th 05 11:09 PM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"