Text editing shortcuts. Dialog box shortcuts. Virtual Desktop shortcuts. File Explorer shortcuts. Command prompt shortcuts. Taskbar shortcuts. Copy, paste and other basic shortcuts. Select the option (s) below to see the list of associated shortcuts.

In the search box on the taskbar, type file explorer, and then select it from the list of results. Right-click the file you want to zip, and then select Send to > Compressed (zipped) folder . To decompress files. Open File Explorer and find the compressed folder. To unzip the entire folder, right-click to select Extract All, and then follow the ...

Select Start > All apps and search for the app in the list shown. Press and hold (or right-click) on the app, then select Uninstall. Uninstall in Settings. Select Start > Settings > Apps > Apps & features . Find the app you want to remove, select More > Uninstall. Note: Some apps can't be uninstalled from the Settings app right now.

On the Formulas tab, click More Functions, point to Statistical, and then select one of the following functions: COUNTA: To count cells that are not empty. COUNT: To count cells that contain numbers. COUNTBLANK: To count cells that are blank. COUNTIF: To count cells that meets a specified criteria. Tip: To enter more than one criterion, use the ...

Word 2019 gives you new ways to work with documents, like improved digital pen features, book-like page navigation, Learning Tools, and translation. Here are highlights of what's new since Word 2016. See others' changes in real time. When someone else is working with you on a document, you'll see their presence and the changes they're making.

In File Explorer under View, in the Show/hide group, select the File name extensions check box. Below is a list of common Windows file name extensions and formats. Extension. Format. aac, adt, adts. Windows audio file. accdb. Microsoft Access database file. accde.

Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

To the right of it, select Run as administrator > Yes. At the command prompt, run the following commands in the listed order, and then check to see if that fixes your connection problem: Type netsh winsock reset and select Enter. Type netsh int ip reset and select Enter. Type ipconfig /release and select Enter.

A 3-D reference includes the cell or range reference, preceded by a range of worksheet names. Excel uses any worksheets stored between the starting and ending names of the reference. For example, =SUM(Sheet2:Sheet13!B5) adds all the values contained in cell B5 on all the worksheets between and including Sheet 2 and Sheet 13.

Templates. A list of Excel training, from entry level to advanced skills, plus templates and other resources.