Note: Calculated fields can only operate on their own row, so you can't reference a value in another row, or columns contained in another list or library.Lookup fields are not supported in a formula, and the ID of newly inserted row can't be used as the ID doesn't exist when the formula is processed.

Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in PivotTable reports.

In Windows 10, you can share your printer with many PCs on your network. To share a printer from the PC that the printer is connected to (the primary PC) with secondary PCs that the printer is not connected to, you must set up sharing settings for the printer, connect the printer to the primary PC (either wirelessly or by using a USB cable), and then turn on the printer.

To find Sync settings, select Start , then select Settings > Accounts > Sync your settings . Choose from settings such as language preferences, passwords, and color themes. If you turn on Other Windows settings, Windows also syncs some device settings (for things like printers and mouse options), File Explorer settings, and notification preferences.

In Outlook, you have the option to: Snooze or dismiss events or tasks | Turn the notifications on or off | Add reminders to events | Add reminders to tasks | Troubleshoot notifications. Snooze or dismiss an event or task. With the reminders window, you can select to snooze calendar events and tasks, join a Teams meeting, or dismiss events and tasks.

Whether you’re starting from a Microsoft template or updating one of your own, Word's built-in tools help you update templates to suit your needs. To update your template, open the file, make the changes you want, and then save the template. In Microsoft Word, you can create a template by saving a document as a .dotx file, .dot file, or a .dotm fie (a .dotm file type allows you to enable ...

Take a picture of some printed data Maybe you’d like to get data from your previous tax returns into Excel and you only have printed copies.Just take a picture of each one, transfer the pictures to your computer (OneDrive is great for this). Then, click Data > From Picture > Picture From File and follow the on-screen instructions to convert picture to data.

Training: Learn how to use Outlook in Windows, MacOS, iOS or Android, and Outlook on the web through a series of Outlook training courses.

If you open an Office file from your recent files list via the Taskbar or the Office app, you will need to open the file as described above to enable AutoSave.. To check, hover your mouse over the recent list: Files that begin C:\Users\ in their path will not open with AutoSave, but files with https:// will.. Close and re-open the file from within the Microsoft 365 app, not the recent file list.

Note: In earlier versions of Outlook, IMAP accounts also used an Outlook Data File (.pst).In Outlook 2016 and Outlook for Microsoft 365, IMAP accounts use Offline Outlook Data Files (.ost). You can also use an Outlook Data File (.pst) to backup or export items from any type of email account.