Skip to main content

Posts

Showing posts from March, 2019

Excel Shortcuts Cheat Sheet, Used in Automation

 F1 Displays the Office Assistant or (Help > Microsoft Excel Help)  F2 Edits the active cell, putting the cursor at the end  F3 Displays the (Insert > Name > Paste) dialog box  F4 Repeats the last worksheet action (Edit > Repeat)  F5 Displays the (Edit > GoTo) dialog box  F6 Moves to the next pane in a workbook (if the window is split)  F7 Displays the (Tools > Spelling) dialog box  F8 Toggles whether to extend a selection with the arrow keys  F9 Calculates All the worksheets in All the open workbooks  F10 Toggles the activation of the Menu Bar  F11 Displays the (Insert > Chart) dialog box that creates a chart (on a chart sheet) using the highlighted range  F12 Displays the (File > Save As) dialog box. --------------------------------------------------------------------------------------------------------------------------  Shift + F2 Inserts or edits a cell comment (Insert > Comment)  Shift + F3 Displays the (Insert > Functio...