The Personal Macro Workbook (PMW) is a great place to store the macros you use often. #2 – Store Your Macros in The Personal Macro Workbook Some laptops have a Fn Lock feature that makes the function keys primary, which means you won't have to press the Fn key when pressing F1-F12.Ĭheckout my article on the Best Keyboards for Excel Keyboard Shortcuts to learn more. The function keys on laptops are typically multi-use keys, and require the Fn key to be pressed to activate the function keys ( F1– F12). If you are using a laptop keyboard then you might also need to press & hold the Fn key before pressing F11. If you don't see the Developer tab in the Ribbon, click the image to learn how to enable it: The Fn (Function) Keys on Laptops The shortcut in the Mac version is Opt+ F11 or Fn+ Opt+ F11. The keyboard shortcut to open the VB Editor in any Windows version of Excel is Alt+ F11. It can be opened by clicking the Visual Basic button on the Developer tab in Excel.
The VB Editor is the application we use to write macros and create userforms. Ctrl+J Opens the Intellisense Drop Down.Automate Repetitive Tasks with The For Next Loop.Store Your Macros in The Personal Macro Workbook.
18-Excel-VBA-Macro-Shortcuts-for-2018-Excel-Campus.pdf Download Page Index
0 kommentar(er)
