Apply shading to alternate rows or columns in a worksheet
Highlight alternate rows or columns of data with colors or patterns to improve the readability of your Excel worksheets.
Change the colors in a text box or shape - Microsoft Support
Here's the same shape after we changed the border to orange, the fill to a light green, and the text to black. We used the Shape Outline, Shape Fill, and Text Fill commands, available on the Format tab under Drawing Tools.
Using wildcard characters in searches - Microsoft Support
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 (~).
Apply or remove cell shading - Microsoft Support
You can add shading to cells by filling them with solid colors or specific patterns. If you have trouble printing the cell shading that you applied in color, verify that print options are set correctly. Select the cells that you want to apply shading to or remove shading from.
Change a theme and make it the default in Word or Excel
Document themes make it easy to coordinate colors, fonts, and graphic formatting effects across your Word, Excel, and PowerPoint documents and update them quickly. This video show you how-to change the entire theme, read below to just customize theme fonts, colors, or effects.
Create, load, or edit a query in Excel (Power Query)
Create, load, or edit a query in Excel (Power Query) Power Query offers several ways to create and load Power queries into your workbook. You can also set default query load settings in the Query Options window.
Customize the Quick Access Toolbar - Microsoft Support
If a custom group on the Quick Access Toolbar displays a green or blue ball for an icon, it means that an icon has not been selected for that custom group. You can add an icon for a custom group after the group has already been created and displays on the Quick Access Toolbar.
Hide error values and error indicators in cells - Microsoft Support
Let's say that your spreadsheet formulas have errors that you anticipate and don't need to correct, but you want to improve the display of your results. There are several ways to hide error values and error indicators in cells. There are many reasons why formulas can return errors.
Use conditional formatting to highlight information in Excel
The examples shown here work with examples of built-in conditional formatting criteria, such as Greater Than, and Top %. This formats cities with a population greater than 2,000,000 with a green background and average high temperatures in the top 30% with orange.
Insert images, icons, and more in Microsoft 365
Choose from thousands of royalty-free images, including stock images, icons, videos, and stickers that you can insert in your Office files.
Add a list box or combo box to a worksheet in Excel
When you want to display a list of values that users can choose from, add a list box to your worksheet. Create a list of items that you want to displayed in your list box like in this picture. Click Developer > Insert. Note: If the Developer tab isn't visible, click File > Options > …