Consolidate multiple worksheets into one PivotTable. Consolidating data is a useful way to combine data from different sources into one report. For example, if you have a PivotTable of expense figures for each of your regional offices, you can use a data consolidation to roll up these figures into a corporate expense report. This report can ...

Install and use a scanner in Windows 10. Windows 10. When you connect a scanner to your device or add a new scanner to your home network, you can usually start scanning pictures and documents right away. If your scanner doesn't automatically install, here's some help to get things working. Select one of the following sections, or select Show all.

In Outlook on your desktop, choose File > Open & Export > Open Outlook Data File. Choose the Outlook data file you want to open. Expand the top level of the Outlook data file in the Outlook Navigation pane to see the subfolders in the file. Click each subfolder to see the contents. To search for a specific email, use Outlook's built-in search ...

You can delete specific files or photos on Microsoft OneDrive, or you can delete entire folders and all the items in them. If you need to, you might be able to restore deleted files from the OneDrive recycle bin. Windows macOS OneDrive website. On your taskbar, select File Explorer . Select your OneDrive folder, select the items you want to ...

Get started with Chat. Chat lets you connect with others, stay up to date on projects, and express yourself, whether you're in the office, at home, or on the go with the Microsoft Teams app. In Teams, you'll see three types of chats: One-on-one chats: to connect with people individually. Group chats: to speak with a group of people at the same ...

When using the OneDrive app, you can download a local copy of a file to your device. In the OneDrive app, open the folder that has the files you want to download. Make sure the folder contents appear in List view, not as thumbnails. Tap More next to the file you want to save and then tap Save. You can also select multiple files by pressing and ...

The good news is you can probably free up a lot of space on your PC running Windows by following the tips here. But if you keep getting messages about low drive space, you might want to consider other options, including adding additional removable storage. To get the most out of these tips, do them in order from top to bottom.

DATE function. Returns the serial number of a particular date. DATEDIF function. Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. DATEVALUE function. Converts a date in the form of text to a serial number. DAY function.

Select your account and then select Sign in to sync. To enter a new account, select Add Account and follow the prompts. When you’re signed in, Microsoft Edge syncs your favorites, passwords, history, open tabs, autofill form entries (such as your name, address, and phone number), and other data types across the devices you use with this account.

Get help with a damaged or unreadable code. If you’re unable to read all 25 characters of your digital code, you’ll need to request a replacement code by contacting aka.ms/contactxboxsupport. When you contact support, make sure to provide the proof of purchase, the serial number, and a picture of the damaged code.