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.
Create and save all your macros in a single workbook
Create and save all your macros in a single workbook by creating them in Personal.xlsb, a hidden workbook that opens every time you open Excel.
Manage data source settings and permissions (Power Query) - Microsoft …
When you need to view or manage an external data source, it pays to know the right dialog box for your needs: Use the Recent Sources dialog box to display frequently used data sources that you have already imported and as a convenient list for making changes to the connection information of each data source.
Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
Run a macro - Microsoft Support
There are several ways to run a macro in Microsoft Excel. A macro is an action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language. You can always run a macro by clicking the Macros command on the Developer tab on the ribbon.
Find what you need with search in Microsoft 365 apps
At the top of your Microsoft 365 apps on Windows you'll find the Microsoft Search box. This powerful tool helps you quickly find what you're looking for, from text to commands to help and more. Let's take a look at what it can do for you.
Tutorial: Import Data into Excel, and Create a Data Model
In these tutorials you learn how to import and explore data in Excel, build and refine a data model using Power Pivot, and create interactive reports with Power View that you can publish, protect, and share. The tutorials in this series are the following: In …
Digitally sign your VBA macro project - Microsoft Support
This article describes how you can digitally sign a macro project on Windows by using a certificate. If you don't already have a digital certificate, you'll need to get one. Tip: To use or test macro projects on your own computer, you can create your own self-signing certificate by using the Selfcert.exe tool.
Add, remove, or change a trusted location in Microsoft Office
You should use a trusted location to store a file when you don't want that file to be checked by the Trust Center, or if you don't want it to open in Protected View. Especially files with macros, data connections, or ActiveX controls (what we call active content).
Keyboard shortcuts in Excel - Microsoft Support
To quickly find a shortcut in this article, you can use the Search. Press Ctrl+F, and then type your search words. If an action that you use often does not have a shortcut key, you can record a macro to create one. For instructions, go to Automate tasks with the Macro Recorder. Download our 50 time-saving Excel shortcuts quick tips guide.
Cancel printing - Microsoft Support
You can attempt to stop printing either directly from Excel or from Windows. However, you can cancel printing from your computer only if the job hasn’t been entirely sent to the printer. When you choose Print in Excel, the following dialog box briefly appears.