How To Use Excel Without A Mouse
You can always import it.
How to use excel without a mouse. Make your data visually obvious. Never use the mouse. Put right hand on the 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. Alt f4 will allow you to close programs.
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. Using the keyboard can be 10 times faster than the mouse. Never type in data. From this point forward do not use your mouse 1. Open a new workbook.
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. Step 1 try using basic keyboard shortcuts. Dave from san francisco suggests you should use excel without the mouse and challenges you to convert a formula to values in three keystrokes. Press ctrl f10 works only in excel how do i resize the current window without using the mouse. The keyboard is much faster.
This video is the podcast companion to the book learn excel 97 2007. Let s look at rule 1. 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. There are a few other basic keyboard shortcuts you can step 2 make sure your computer has a number pad. 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.
Never use the mouse. Using the keyboard can be 10 times faster than the mouse. Use excel to automate the task. Use your up down left right arrows to adjust the window size. For example to insert text without formatting i d just go alt e s enter.