Repair a corrupted workbook - Microsoft Support
When Microsoft Excel detects a corrupted workbook upon opening, it automatically starts File Recovery mode and attempts to repair the workbook. If File Recovery mode doesn’t start, try using this manual process to recover your workbook: Click File > Open. Click the location and folder that contains the corrupted workbook.
Cloud fonts in Office - Microsoft Support
Jun 11, 2024 · 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).
Recover an earlier version of an Office file - Microsoft Support
Go to File > Info. Under Manage Workbook or Manage Presentation, select the file labeled (when I closed without saving). In the bar at the top of the file, select Restore to overwrite any previously saved versions. Tip: In Word, you can also compare …
Change the appearance of your worksheet - Microsoft Support
To change the text fonts, colors, or general look of objects in all worksheets of your workbook quickly, try switching to another theme or customizing a theme to meet your needs. If you like a specific theme, you can make it the default for all new workbooks.
Download free, pre-built templates - Microsoft Support
You can download free, pre-built document templates with useful and creative themes from Office when you click File > New in your Office app. Templates can include calendars, business cards, letters, cards, brochures, newsletters, resumes, cover letters, presentations, social media and much more.
Manage workbook links - Microsoft Support
There is no automatic way to find all workbook links in a workbook. You need to look differently in formulas, defined names, objects (like text boxes or shapes), chart titles, and chart data series.
Add alternative text to a shape, picture, chart, SmartArt graphic, …
You can create alternative text (Alt text) for shapes, pictures, charts, SmartArt graphics, or other objects in your Microsoft 365 documents. Alt text helps people with visual disabilities understand pictures and other graphical content. When someone using a screen reader comes across a picture in a document, they will hear the alt text ...
Change the date system, format, or two-digit year interpretation
Change the date system in Excel. The date system changes automatically when you open a document from another platform. For example, if you are working in Excel and you open a document that was created in Excel for Mac, the 1904 date system check box is …
Find or replace text and numbers on a worksheet
Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else.
Count how often a value occurs - Microsoft Support
There are several ways to count how often a value occurs. Count how often a single value occurs by using the COUNTIF function. Count based on multiple criteria by using the COUNTIFS function. Count based on criteria by using the COUNT and IF functions together.
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)