Automatically start an Office program when you turn on your …
Autostart an Office program you use every day by adding a shortcut to the Windows Startup folder. Open the Windows Run dialog (Windows Key + R). Copy the following path to the Run dialog, and then press Enter. Open the Start Screen, right-click the Office program you want to automatically start, and click Open file location.
Automatically run a macro when opening a workbook
You might want a macro you recorded to run automatically when you open a specific workbook. The following procedure uses an example to show you how that works. You may also want to run macros automatically when Excel starts. Before you get started, make sure the Developer tab is shown on the ribbon. For more information, see Show the Developer tab.
Command-line switches for Microsoft Office products
You can add options like this by using subcommands called command-line switches to an Office app's startup command. If you want to use the customization just one time, you can type the command and switch in the Run dialog box (Start menu) in Microsoft Windows.
Customize how Excel starts - Microsoft Support
Excel defaults to showing the Start screen with recent workbooks, locations, and templates upon starting. This setting can be changed to instead bypass this screen and create a blank workbook. To do so: Click File > Options.
Quick start: Create a macro - Microsoft Support
How to create, edit, and run Excel macros to automate data entry and tasks.
Automate tasks with the Macro Recorder - Microsoft Support
To automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single format to all of them. A macro can do that for you. You can record a macro applying the format you want, and then replay the macro whenever needed.
Assign a macro to a Form or a Control button - Microsoft Support
You can use a Form control button or a command button (an ActiveX control) to run a macro that performs an action when a user clicks it. Both these buttons are also known as a push button, which can be set up to automate the printing of a worksheet, filtering data, or calculating numbers.
Create, load, or edit a query in Excel (Power Query)
Create, load, or edit a query in Excel (Power Query) Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in the Query Options window.
Run a macro - Microsoft Support
To run a macro from a button on the Quick Access toolbar, you first have to add the button to the toolbar. To do that, see Assign a macro to a button. You can create a custom group that appears on a tab in the ribbon, and then assign a macro to a button in that group.
View, manage, and install add-ins for Excel, PowerPoint, and Word ...
View, manage, and install add-ins for Excel, PowerPoint, and Word. When you enable an add-in, it adds custom commands and new features to Microsoft 365 programs that help increase your productivity. Because add-ins can be used by attackers to do harm to your computer, you can use add-in security settings to help protect yourself.
Keyboard shortcuts in Excel - Microsoft Support
If you're using Excel for the web on a Mac computer, press Control+Option to start. To get to the ribbon, press Alt+Windows logo key, or press Ctrl+F6 until you reach the Home tab.