How To Use Excel Without A Mouse

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.

How to use excel without a mouse. 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. 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. Never type in data. Ctrl s with your left hand on the keyboard. Let s look at rule 1.

For example to insert text without formatting i d just go alt e s enter. Never use the mouse. Using the keyboard can be 10 times faster than the mouse. Alt tab will also allow you to switch between programs and get back to the desktop. Use your up down left right arrows to adjust the window size.

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. 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. Dave from san francisco suggests you should use excel without the mouse and challenges you to convert a formula to values in three keystrokes. There are a few other basic keyboard shortcuts you can step 2 make sure your computer has a number pad. Press ctrl f10 works only in excel how do i resize the current window without using the mouse.

You can always import it. Episode 958 shows various attempts to solve the problem without using the mouse. Open a new workbook. Open microsoft excel if it is not already open. The keyboard is much faster.

If you don t have a grid of number keys on. 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. Using the keyboard can be 10 times faster than the mouse. This video is the podcast companion to the book learn excel 97 2007. Make your data visually obvious.