Alt + Shift + F1: Insert a new worksheet tab.Shift + Arrow key: Extends your current cell selection by one addition cell in the direction specified.F4: Repeats the last command or action, if possible.Ctrl + Shift + “ ” : Insert current date.Ctrl + Shift + “ :”: Insert current time.Ctrl + Shift + #: (Excel 2016) Current cell formatted as date with day, month, year.Ctrl + Shift + %: (Excel 2016) Current cell formatted as percentage with no decimal places.Ctrl + Shift + $: (Excel 2016) Current cell formatted as currency, with two decimal places and negative numbers in parentheses.Ctrl + PgUp: Switch between worksheet tabs, moving right to left.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. Previously on keyboard shortcuts & mouse shortcuts.Keyboard access to the ribbon: Similar to the Vim-inspired add-ons for Chrome and Firefox, Excel 20 have a feature called Key Tips. Let us make this the biggest thread (and page) on excel short cuts… Please use comments and share the shortcuts you use on regular basis. Useful to add cell-comments so that my colleagues can take note of certain cells. SHIFT+F2: Add a comment or Edit comment.F9: When debugging formulas, I can select a portion of the formula and press F9 to see the result of that.ALT+Down arrow: Shows a small in-cell drop down with previously entered values, Useful when I am typing some data.F2: Edit a cell, places cursor at the end.CTRL+Arrow Keys: To navigate to last cell in a row, column, first cell in a row, column.Helps me remove formulas, formatting etc. ALT+ESV : Paste Special > Values only.F4: to repeat last action, like adding rows or adjusting formats.F4: while editing formulas, to change the type of cell reference from relative to absolute or semi-absolute.I use this to set borders, fills, cell-formats, alignment etc. I will start by listing down all the excel keyboard shortcuts I use regularly, So, let us have an open thread on Excel Shortcuts. (I don’t know, but I feel a bit low, may be it is all the snow around and constant work due to excel school and day job). Okay, this is a cop-out, but I have been busy and not-in-a-mood-for-writing in the last 2 days.
0 kommentar(er)
