Make or find pictures to insert in Office documents
See all the options to create or add illustrations and images to your documents.
Create a SmartArt graphic from scratch - Microsoft Support
SmartArt graphics can be created in Excel, Outlook, PowerPoint, and Word, and they can be used throughout Office. For an overview of SmartArt graphics, including considerations for choosing the best graphic and layout type to display your data or convey a …
Start a new line of text inside a cell in Excel - Microsoft Support
To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press CONTROL + OPTION + RETURN to insert a line break. Press CONTROL+OPTION+RETURN to insert the line break. Double-click the cell in which you want to insert a line break (or select the cell and then press F2).
Crop a picture to fit in a shape - Microsoft Support
This article applies to steps you can use to crop images in different Microsoft 365 applications. You can use the same steps in PowerPoint, Word, Outlook, or Excel. When you crop a picture to a certain shape, it'll change size to match that shape while keeping its proportions the same.
Insert a caption for a picture - Microsoft Support
The Insert Caption feature in Word makes it easy to systematically add captions to pictures in a document. In other Office apps, such as PowerPoint, you manually add a text box near the image and then group the text box and image. See the instructions below. If you have multiple pictures in a series, you have to manually number them.
Change the column width or row height in Excel - Microsoft …
You can manually adjust the column width or row height or automatically resize columns and rows to fit the data.
Sum values based on multiple conditions - Microsoft Support
Let's say that you need to sum values with more than one condition, such as the sum of product sales in a specific region. This is a good case for using the SUMIFS function in a formula. Have a look at this example in which we have two conditions: we want the sum of Meat sales (from column C) in the South region (from column A).
Create a drop-down list - Microsoft Support
You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create. In a new worksheet, type the entries you want to appear in your drop-down list. Ideally, …
Filter by using advanced criteria - Microsoft Support
When two values are compared by using these operators, the result is a logical value—either TRUE or FALSE. Because the equal sign (=) is used to indicate a formula when you type text or a value in a cell, Excel evaluates what you type; however, this may cause unexpected filter results.
Accessibility best practices with Excel spreadsheets
You learn, for example, how to work with the Accessibility Checker to tackle accessibility issues while you're creating your spreadsheet. You'll also learn how to add alt texts to images so that people using screen readers are able to listen to what the image is all about.
Add or remove items from a drop-down list - Microsoft Support
If the Source box contains drop-down entries separated by commas, then type new entries or remove ones you don't need. When you're done, each entry should be separated by a comma, with no spaces. For example: Fruits,Vegetables,Meat,Deli.