ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How to remember shortcuts in excel? (https://www.excelbanter.com/new-users-excel/103783-how-remember-shortcuts-excel.html)

Mr.Cools

How to remember shortcuts in excel?
 
Shortcuts keys in Excel are always assigned based on the first letter
of the menu item.
For example. to open a new file the shortcut is CTRL + N, N is the
first letter of the new command.

For more details, see this post
http://xlmaster.blogspot.com


SteveW

How to remember shortcuts in excel?
 
Agreed for New, Open, Save, Print

but don't forget
Control + C is Copy
and Paste is Ctrl + V
Cut is C...

I shan't go on, there aren't any general rules


Steve

On Tue, 08 Aug 2006 10:11:42 +0100, Mr.Cools
wrote:

Shortcuts keys in Excel are always assigned based on the first letter
of the menu item.
For example. to open a new file the shortcut is CTRL + N, N is the
first letter of the new command.

For more details, see this post
http://xlmaster.blogspot.com




--
Steve (3)

Gilles Desjardins

How to remember shortcuts in excel?
 
Ctrl + Z is undo, Ctrl + ; is insert time, so much for your rule.

"Mr.Cools" wrote in message
ups.com...
Shortcuts keys in Excel are always assigned based on the first letter
of the menu item.
For example. to open a new file the shortcut is CTRL + N, N is the
first letter of the new command.

For more details, see this post
http://xlmaster.blogspot.com




SteveW

How to remember shortcuts in excel?
 
Ctrl + ; is Date
Ctrl + : is Time

Steve

On Tue, 08 Aug 2006 11:27:45 +0100, Gilles Desjardins
wrote:

Ctrl + Z is undo, Ctrl + ; is insert time, so much for your rule.

"Mr.Cools" wrote in message
ups.com...
Shortcuts keys in Excel are always assigned based on the first letter
of the menu item.
For example. to open a new file the shortcut is CTRL + N, N is the
first letter of the new command.

For more details, see this post
http://xlmaster.blogspot.com






--
Steve (3)

David McRitchie

How to remember shortcuts in excel?
 
Look again at the underscores on the menu items.
Gets complicated when you add your own menus and they
aren't made unique with the underscores. But then they
aren't really the documented keyboard shortcuts, unless you
see the shortcut also written on the menu item. For keyboard shortcuts
see help, or http://www.mvps.org/dmcritchie/excel/xlshortx2k.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mr.Cools" wrote in message ups.com...
Shortcuts keys in Excel are always assigned based on the first letter
of the menu item.
For example. to open a new file the shortcut is CTRL + N, N is the
first letter of the new command.

For more details, see this post
http://xlmaster.blogspot.com




SteveW

How to remember shortcuts in excel?
 
Always awkward, ie Ctrl+Z is the same as F10 E U
But we don't really call the F10 apporach a shortcut do we ?

Steve

On Tue, 08 Aug 2006 23:07:39 +0100, David McRitchie
wrote:

Look again at the underscores on the menu items.
Gets complicated when you add your own menus and they
aren't made unique with the underscores. But then they
aren't really the documented keyboard shortcuts, unless you
see the shortcut also written on the menu item. For keyboard shortcuts
see help, or http://www.mvps.org/dmcritchie/excel/xlshortx2k.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mr.Cools" wrote in message
ups.com...
Shortcuts keys in Excel are always assigned based on the first letter
of the menu item.
For example. to open a new file the shortcut is CTRL + N, N is the
first letter of the new command.

For more details, see this post
http://xlmaster.blogspot.com


Gilles Desjardins

How to remember shortcuts in excel?
 
DOH!
"SteveW" wrote in message
news:op.tdyqctwtevjsnp@enigma03...
Ctrl + ; is Date
Ctrl + : is Time

Steve

On Tue, 08 Aug 2006 11:27:45 +0100, Gilles Desjardins
wrote:

Ctrl + Z is undo, Ctrl + ; is insert time, so much for your rule.

"Mr.Cools" wrote in message
ups.com...
Shortcuts keys in Excel are always assigned based on the first letter
of the menu item.
For example. to open a new file the shortcut is CTRL + N, N is the
first letter of the new command.

For more details, see this post
http://xlmaster.blogspot.com






--
Steve (3)




All times are GMT +1. The time now is 12:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com