How To Use Excel Without A Mouse

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.

How to use excel without a mouse. For example to insert text without formatting i d just go alt e s enter. Put right hand on the mouse. Episode 958 shows various attempts to solve the problem without using the mouse. Alt tab will also allow you to switch between programs and get back to the desktop. Dave from san francisco suggests you should use excel without the mouse and challenges you to convert a formula to values in three keystrokes.

From this point forward do not use your mouse 1. Ctrl s with your left hand on the keyboard. Never use the mouse. 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. 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.

Alt f4 will allow you to close programs. Make your data visually obvious. There are a few other basic keyboard shortcuts you can step 2 make sure your computer has a number pad. If you don t have a grid of number keys on. This video is the podcast companion to the book learn excel 97 2007.

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. Open microsoft excel if it is not already open. In microsoft excel access word powerpoint and other office programs there are a number shortcuts you can use when navigating and selecting in the ribbon without using a mouse. The keyboard is much faster. 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.

You can always import it. Step 1 try using basic keyboard shortcuts. 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. Never type in data.