A macro is a series of commands and instructions that you group together as a single command to accomplish a task automatically. Windows Web. To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then you can run the macro by clicking a button on the Quick Access Toolbar or pressing a combination of keys.

Ctrl+Shift+N. Increase the paragraph indent. Alt+Shift+Right arrow key or the Tab key when at the beginning of a line. Decrease the paragraph indent. Alt+Shift+Left arrow key or Shift+Tab when at the beginning of a line. Align the paragraph to the left. Ctrl+L. Align the paragraph to the right. Ctrl+R.

Press Ctrl+A, and press Delete again. If you're using a device that doesn't have a keyboard, try removing the PivotTable like this: Pick a cell anywhere in the PivotTable to show the PivotTable Tools on the ribbon. Click PivotTable Analyze > Select, and then pick Entire PivotTable. Pick a cell anywhere on the PivotTable for the " Delete ...

Create a PivotTable to analyze external data. Create a PivotTable to analyze data in multiple tables. Sort data in a PivotTable. Group or ungroup data in a PivotTable. In Excel, use slicers and other ways to filter large amounts of PivotTable data to show a smaller portion of that data for in-depth analysis.

On the File tab, choose Options > Trust Center. Under Microsoft Outlook Trust Center, click Trust Center Settings. Clear the Don't download pictures automatically in HTML e-mail messages or RSS items check box. Or, if you're using Outlook in Microsoft 365, on the Automatic Download tab, select or clear the options as you see fit.

Create a PivotChart. Select a cell in your table. Select Insert and choose PivotChart. Select where you want the PivotChart to appear. Select OK. Select the fields to display in the menu. Household expense data. Corresponding PivotChart.

In People, in the folder pane, click the contact folder that you want to share with a person outside your organization. Click Home. Then, in the Share group, click Share Contacts. In the To box, enter the name of the recipient for the sharing invitation message. If you want to, you can change the Subject.

On the File tab, go to Options > Customize Ribbon. Under Customize the Ribbon and under Main Tabs, select the Developer check box. After you show the tab, the Developer tab stays visible, unless you clear the check box or have to reinstall a Microsoft Office program. Show the Developer tab in a Word document so you can write macros or add ...

With Word for the web, collaborate with others no matter where you are. Share your document. Select Share to share your document with someone first. Type a name or email, and select Send. Now, you can make edits at the same time as others. Use comments, @mention, and Track Changes. Choose content to comment on.

This article describes the formula syntax and usage of the COUNTA function in Microsoft Excel.. Description. The COUNTA function counts the number of cells that are not empty in a range.. Syntax. COUNTA(value1, [value2], ...) The COUNTA function syntax has the following arguments: