How To Use Excel Without A Mouse

Open a new workbook.

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. 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. There are a few other basic keyboard shortcuts you can step 2 make sure your computer has a number pad. Step 1 try using basic keyboard shortcuts. Make your data visually obvious.

You can always import it. Never use the 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. 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. Never use the mouse.

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. Using the keyboard can be 10 times faster than the mouse. This video is the podcast companion to the book learn excel 97 2007. 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. 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. Alt f4 will allow you to close programs. If you don t have a grid of number keys on. Open microsoft excel if it is not already open.

Let s look at rule 1. Alt tab will also allow you to switch between programs and get back to the desktop. Using the keyboard can be 10 times faster than the mouse. Put right hand on the mouse. Use excel to automate the task.