Search results
Results from the WOW.Com Content Network
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
You can make data entry easier by letting users choose a value from a combo box. A combo box combines a text box with a list box to create a drop-down list. You can add a Form Control or an ActiveX Control combo box. If you want to create a combo box that enables the user to edit the text in the text box, consider using the ActiveX Combo Box.
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly—in a matter of seconds. And with certain versions of Excel, you'll see other people's selections in different colors.
To include structured references in your formula, select the table cells you want to reference instead of typing their cell reference in the formula. Let’s use the following example data to enter a formula that automatically uses structured references to calculate the amount of a sales commission.
Try a training template to learn more about Word, Excel and PowerPoint. Or choose from thousands of free Microsoft templates for any project. Welcome to Word. Learn by doing in Word — instructions you can edit, share, and print. Download. Welcome to Excel. Get up and running with Excel — these 10 quick steps are all it takes. Download.
A data table is a range of cells in which you can change values in some of the cells and come up with different answers to a problem. A good example of a data table employs the PMT function with different loan amounts and interest rates to calculate the affordable amount on a home mortgage loan.
To see the list of files that were shared with you, sign into your Microsoft account, or a work or school account, then follow the steps in the appropriate tab below. To see the files that others have shared with you: Open Word, Excel, PowerPoint, or Visio. If you already have a document or workbook open, select File.
You can use a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes. Note: This feature is available if you have a Microsoft 365 subscription.
Depending on the map chart type, you can change the following Series options: Map projection - Change the cartographic projection of the map. The available projections are Mercator, Miller, Albers and Robinson. Map projections are methods of displaying a spherical object (the Earth) on a flat plane.
Use cloud fonts to make sure your slides and documents look the same, no matter where you open them or who else views them. Cloud fonts are fonts hosted in the cloud by Microsoft 365, and are available in the latest versions of Office applications (see the Cloud fonts availability table, below).
To learn how you can delete a version, all versions, or just minor versions of an item or file if your list or library is configured for it, see Delete a previous version on an item or file in SharePoint. For info about turning versioning on, see Turn on version history in SharePoint.