Filter the data you import into Power Pivot - Microsoft Support
On the Select Tables and Views page, select a table, and then click Preview & Filter. To exclude columns, clear the boxes next to the columns that you don’t want to import. To reduce rows, locate the column that contains the criteria you want to filter on, and then click the down arrow at the right of the column heading.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Change text alignment, indentation, and spacing in PowerPoint
To change the spacing above and within a paragraph, use the Line Spacing options: Single, 1.5 Lines, or Double.Or select Exactly and then add a point value (between 0 and 1584) in the At box. (The bigger the point value, the wider the spacing.) Or select Multiple and add a value to the At box. (Use any number less than or equal to 9.99: A value of 1 would equal single-spacing, while a value of ...
Applies To: PowerPoint for Microsoft 365, PowerPoint for the web, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016, PowerPoint 2013, PowerPoint for Mac 2011
Create and save a custom color scheme - Microsoft Support
Note: Your custom color scheme is now the default color scheme. The colors that you selected can now be used as the scheme colors when selecting colors throughout your publication. For instance when selecting the fill color for table cells, shapes, page backgrounds or font colors.
Applies To: Publisher for Microsoft 365, Publisher 2021, Publisher 2019, Publisher 2016, Publisher 2013, Publisher 2010
Add or remove shading in a table - Microsoft Support
The easiest way to add colored shading to a table is to use the Shading menu. Add shading to a table. Select the cells you want to change. To select an entire table, click in the table, and then click the Table Move Handle in the upper-left corner.
Applies To: Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, OneNote for Microsoft 365, Word 2021, Outlook 2021, PowerPoint 2021, OneNote 2021, Word 2019, Outlook 2019, PowerPoint 2019, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, InfoPath Filler 2013
Power Pivot: Powerful data analysis and data modeling in Excel
Filter data and rename columns and tables while importing. Read about Get data using the Power Pivot add-in. Create tables. Tables can be on any worksheet in the workbook. Worksheets can have more than one table. Tables are organized into individual tabbed pages in the Power Pivot window. Edit data in a table. Can edit values in individual ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Add WordArt to a slide - Microsoft Support
PowerPoint training. Text and tables. Text and tables Add WordArt to a slide. Add WordArt to a slide Video; Add hyperlinks to slides Video; Import a Word outline Video; Check spelling Video; Add a table Video; Insert Excel data Video; Split a table Video; Next: Pictures and graphics
Applies To: PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016
Work with gridlines and use snap-to-grid in PowerPoint
Gridlines help give you visual cues when you're formatting in PowerPoint. The default horizontal and vertical gridlines make a grid of one-inch squares. You can't change that grid size. You can change the spacing between the dots that comprise each gridline by using the Spacing option. This setting allows you to adjust the precision of object ...
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint 2021, PowerPoint 2021 for Mac, PowerPoint 2019, PowerPoint 2019 for Mac, PowerPoint 2016
Format Objects or Text with Glow or Soft Edges - Microsoft Support
Glow. Presets — To apply one of the most common Glow Variations, click Presets, and then click the variation that you want.. Color — To create a custom color for the glow, click Color, and then click the color that you want.To change to a color that is not in the theme colors, click More Colors, and then either click the color that you want on the Standard tab, or mix your own color on the ...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Excel 2019, Word 2019, PowerPoint 2019, Excel 2016, Word 2016, PowerPoint 2016
Change the numbering in a numbered list - Microsoft Support
Tip: Tempting as it is to manually change the numbers in a list, don’t do it.Always use the command options to make the changes. If Word loses track of what you’ve done, problems can pop up when you want to make other list changes later.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013
Find and replace text - Microsoft Support
In the upper-right corner of the PowerPoint window, click the arrow next to Search in Presentation. Select Replace. In the Find What box, enter the text you want to search for, and in the Replace With box, enter the text you want to use as the replacement.
Applies To: PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, PowerPoint 2021, PowerPoint 2021 for Mac, PowerPoint 2019, PowerPoint 2019 for Mac, PowerPoint 2016