amerilat.blogg.se

1. #Windows excel 2015 custom keyboard shortcuts software
2. #Windows excel 2015 custom keyboard shortcuts windows

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. If you change your mind simply go back to the Properties window and delete the range you. (However the Edit menu does show that Cmd+C does "copy to scrapbook".) Keyboard Shortcut - Insert or Delete a Row or Column in Excel. 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.) With Excel Viewer, you can open, view, and print Excel workbooks, even if you don't have Excel installed.

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.

#Windows excel 2015 custom keyboard shortcuts software

Fill Down copies contents and format of the topmost cell in the column.įor more productivity-related software tips check out PCWorld’s Max Productivity blog.[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. Ctrl + D: Launches the Fill Down command for the selected cells below.Switch input language and keyboard layout. Move an app or window in the desktop from one monitor to another. Macro shortcuts, which are completely customized. For example, pressing Alt > N > T will select the Insert tab on the Ribbon, followed by the Table option. Alt shortcuts, where you press the Alt key to activate shortcuts for Ribbon items.

#Windows excel 2015 custom keyboard shortcuts windows

Ctrl + PgDn: Switch between worksheet tabs, moving left to right.

Pressing a letter launches the corresponding menu item. When Key Tips appears by pressing Alt the Ribbon menu is overlaid with letters. Keyboard access to the ribbon: Similar to the Vim-inspired add-ons for Chrome and Firefox, Excel 20 have a feature called Key Tips.