![]() They will make the work of creating charts, formatting workbooks and analyzing data really easy and comfortable for the excel users. Some of the best Excel shortcuts keys which are most essential are mentioned below. While preparing any report or dashboard, if we use shortcut keys then the task would be completed in less time than expected. (You can get transpose if you use the Home tab's Paste ribbon pull-down but I'm trying to avoid mousing.) I might have to make a macro for it.If you are using Microsoft Excel in your daily life, you can use excel shortcuts to save time. I still haven't found a way to make a transpose tool bar shortcut, although I read in another forum that Cmd-E is supposed to paste->transpose, but it doesn't for me. Therefore, the above may or may not work for you. I checked it and the shortcuts continue to work and hovering over an icon displays what function it's supposed to perform. So I exited Excel 2011 and went back in and all the shortcuts are again working and "Show ScreenTips for toolbar commands" is un-checked. (However the Edit menu does show that Cmd+C does "copy to scrapbook".) And after more experimentation no matter if I check or un-check "Show ScreenTips for toolbar commands" I can't get Cmd-C to copy. I went back in and checked "Show ScreenTips for toolbar commands" and Cmd-C started working again. Now as I wrote this posting I found out that Cmd-C stopped working again. Once I UNchecked that box the shortcuts started working again (after "OK" dismissing the window) and the shortcut keys were displayed in the menus.īTW, " Show shortcut keys in ScreenTips" is checked for me. (That setting is supposed to show what an icon is supposed to do if you hover the mouse-pointer over it.) In the window that appears the Toolbars and Menus "tab" is displayed (for me).Ĭheck or un-check "Show ScreenTips for toolbar commands". I had flakey results: go to menu View -> Toolbars -> Customize Toolbars and Menus. (In addition, selecting an area and hitting Cmd-C did not display the crawling-ants indication around the selection.) ![]() I found the problem using Excel with Office 2011, but it may apply to Word too.)Ĭmd-C, Cmd-V, Cmd-X and maybe others stopped working and the shortcuts weren't displayed in the menu after I was messing around trying to add Paste->Transpose to the tool bar. [Note: I'm using Cmd- the same as Cmd+ as you don't actually type the hyphen or plus, and Cmd is the "command" keyboard key. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |