quick analysis tool excel keyboard shortcut

#Quick analysis tool excel keyboard shortcut how to#
#Quick analysis tool excel keyboard shortcut windows#

One thing to remember when you are searching for the Quick Analysis Tool is it’s only available in Excel 2013 and later versions. When you select a type of data, for example, dates, text, or numbers, the tool also shows you the options based on your supplied criteria. Options for limited formatting are found in the tool, along with sparklines, charts, and pivot tables. Instead of searching for various options, the tool contains them in one spot. The Quick Analysis Tool contains some of the options you use to analyze data.

What Is the Quick Analysis Tool in Excel? We’ll cover this and more in the following paragraphs. The tool isn’t listed on the ribbon, so where is it and how do you use it? You can’t perform these actions in the Excel Quick Analysis Tool, but there are plenty of others you can tackle.

It lists some of your options in one convenient place, except for add and delete. Keyboard Locker is a great utility for those of us with curious creatures and inquisitive infants.The Quick Analysis Tool in Excel can simplify data analysis. Once the shortcut is in place, Keyboard Locker will run automatically when you start Windows. You can do this by dragging the file to the startup folder with your right mouse button and choosing “Create shortcut here” or by right-clicking anywhere in the startup folder and choosing New > Shortcut from the context menu.

#Quick analysis tool excel keyboard shortcut windows#

Open the Run dialog by pressing Windows+R, type “shell:startup,” and then click “OK.”Ĭreate a shortcut to the “KeyboardLocker.exe” or “KeyboardLocker.ahk” file-whichever you use-in the Windows startup folder. In short, though, just store your AutoHotKey folder wherever you want.

#Quick analysis tool excel keyboard shortcut how to#

Hit up our guide on how to add programs, files, and folders to system startup in Windows for the full instructions. It’s easy enough to run Keyboard Locker when you need it, but you can also have it run automatically when Windows starts by adding it to the Windows startup folder. RELATED: How to Add Programs, Files, and Folders to System Startup in Windows How to Start Keyboard Locker when Windows Starts Note: On on some PCs we’ve tested running Windows 10, when you unlock your keyboard while notifications are turned on, it sometimes can take several seconds after typing “unlock” for keyboard functionality to return. If you prefer not seeing notifications, you can also get a reminder of the shortcuts for locking and unlocking your keyboard by hovering your mouse over the Keyboard Locker icon. Keyboard Locker will now show notifications when you lock or unlock your keyboard. If you’d like to see them, right-click the Keyboard Locker icon in the notification area and choose “Show tray notifications.” How to Show Balloon Notification Remindersīy default, Keyboard Locker does not display notifications when you lock or unlock your keyboard. When you want re-enable keyboard input, simply type in the word “unlock.” The Keyboard icon changes back to normal again to show that the keyboard is unlocked. There are a few key combinations that will still work, such as Ctrl+Alt+Delete and Win+L, but those are extremely unlikely for a paw or tiny hand to hit by accident. To lock your keyboard, press Ctrl+Alt+L. The Keyboard Locker icon changes to indicate that the keyboard is locked.Īlmost all keyboard input is now disabled, including function keys, Caps Lock, Num Lock, and most special keys on media keyboards. When you launch Keyboard Locker, you’ll see a small keyboard icon appear in your notification area.