The most common type is a physical, external keyboard that plugs into your PC. But Windows has a built-in Accessibility tool called the On-Screen Keyboard (OSK) that can be used instead of a physical keyboard. You don’t need a touchscreen to use the OSK.

If a check is not visible, Scroll Lock does not appear in the Excel status bar. Simply check the box to have the status appear on the status bar. If Scroll Lock is on, your cursor moves between columns and rows, not cells. Here's how to turn off Scroll Lock.

This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows. Notes: To quickly find a shortcut in this article, you can use the Search. Press Ctrl+F, and then type your search words.

Office 2019 Office 2016 Office 2016 for Mac Office 2013. If this is the first time you're installing Microsoft 365 you may have some setup steps to do first. Expand the learn more section below. However, if you're reinstalling Microsoft 365, and you've already redeemed a product key and have an account associated with Microsoft 365, then go to ...

SharePoint is a browser-based app that you connect to through your web browser, like so: Go to office.com, and sign in to your work or school account. In the upper left corner of the window, select the app launcher > All apps > SharePoint.

Learn how to add user accounts in Windows 10 and Windows 11. With an account, each person has separate files, browser favorites, and a private desktop.

There are four ways to open Snipping Tool: Select the Start button, enter snipping tool, then select Snipping Tool from the results. Press Windows logo key + Shift + S for a static image snip. Press Print Screen ( PrtSc ) for a static image snip. Press Windows logo key + Shift + R for a video snip.

If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add an item, go to the end of the list and type the new item. To remove an item, press Delete.

The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.

If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro.