How To Use Excel Without A Mouse

Never use the mouse.

How to use excel without a mouse. Alt f4 will allow you to close programs. Let s look at rule 1. If you don t have a grid of number keys on. Put right hand on the mouse. Never use the mouse.

Open a new workbook. There are a few other basic keyboard shortcuts you can step 2 make sure your computer has a number pad. The keyboard is much faster. Alt tab will also allow you to switch between programs and get back to the desktop. Make your data visually obvious.

This video is the podcast companion to the book learn excel 97 2007. Using the keyboard can be 10 times faster than the mouse. For example to insert text without formatting i d just go alt e s enter. Use your up down left right arrows to adjust the window size. Press ctrl f10 works only in excel how do i resize the current window without using the mouse.

Open microsoft excel if it is not already open. It takes time to move one hand from the keyboard to the mouse locate the item you want to click at move the mouse there adjust it finely so it s pointing at the exact spot and then click it. Obviously the first step to navigating without a mouse is using the arrow keys and pressing enter and tab to move between and open items. Press shift alt spacebar then press s move the window using two of the up down left right arrows then press enter or press ctrl f8 works only in excel. Ctrl s with your left hand on the keyboard.

Use excel to automate the task. It takes time to move one hand from the keyboard to the mouse locate the item you want to click at move the mouse there adjust it finely so it s pointing at the exact spot and then click it. From this point forward do not use your mouse 1. You can use your computer s arrow keys and the enter key to move the selection around the currently open window and select things respectively and typing a letter when on the desktop or in a windows app e g file explorer will cause the selection to jump to an item starting with that letter. Never type in data.