MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Using the keyboard instead of the mouse


Posted by Sam Marx on January 17, 2002 9:04 AM

Is there any way in Excel 2002 that I can use the keyboard instead of the mouse for certain tasks such as copying blocks of cells.
When I used Symphony (similar to Lotus 1-2-3) I could copy a block of data for example that started at cell b3 at the UL, and ended at d12 at the LR, and copy it into a block starting at g4 at the UL, by typing the following:
F10 c(for copy) b3..d12 (hit)Enter g4 (hit)Enter

Also, when using a mouse, is there some way to designate a block of data to be moved or copied by clicking on its UL corner and then its LR corner, and then entering the copy and paste commands


Posted by Juan Pablo G. on January 17, 2002 9:08 AM

> I could copy a block of data for example that started at cell b3 at the UL, and ended at d12 at the LR, and copy it into a block starting at g4 at the UL, by typing the following:

Press F5, type B3:D12, [Enter], Ctrl C, type G4, [Enter], [Enter] or Ctrl V.

Select B3, press and hold SHIFT, select D12. This will select B3 through D12

Juan Pablo G.

Posted by Sam Marx on January 17, 2002 3:58 PM

:Thank you very much for you assistance. Under what topic or heading would I find this explained in a book on Excel ?

Posted by Sam marx on January 17, 2002 6:51 PM

:to Juan Pablo G.
The solution to designating an array by the keyboard works. But the first solution of copying an array with the keyboard doesn't. After Ctrl C when I type G4 that designation appears in cell B3 instead of highlighting G4. I think that there's something missing in your "formula" between "Ctrl C" and "type G4". Would you please check it out.

Posted by Juan Pablo G. on January 17, 2002 11:59 PM

Yes, forgot another F5, after Ctrl C and before G4.

Juan Pablo G.