When you are in a cell that is pulling data from another tab or another section within the tab you are in, press Control + [ to jump to that cell. The $ keeps the cell from moving when copying formulas down or across.
MOUSELESS EXCEL TRAINING CODE
View the Code section of the DATA tab within my spreadsheet to see further. Based on how many times you press, you will receive varying functions, ex: $C$2, $C2, C$2. Use the F4 function to create absolutes on formulas within cells.
To enter a cell to adjust a formula or just to view which cells are in use, press F2. The more you familiarize yourself with these letters, (ex: Alt + H + D + R, which deletes row in Excel 2007), the quicker they will be. In order to use the toolbar at the top, press ALT, which will then highlight all the functions at the top. Use Alt+tab to move between different programs (word, internet, excel, etc.) … After doing either of those, press Control and + to add a column (or row). To highlight this data, press control + shift and left or right, down or up.Ĭontrol + space bar highlights entire column You may have to press twice or more depending on if there is empty data in between the beginning and end. This will shoot you to the end of the data.
To navigate to the end of a column or row, press control and left or right, down or up. Here are some quick tips to help with not using a mouse. Please view the formulas in the cells highlighted and the other notes in the spreadsheet.Īs you get better at this, you should not need to use a mouse to navigate through the model at all. I have attached a spreadsheet with various functions already created within it. Because of this, I have created a brief tutorial on some basic functions of Excel which we use every day. Moderator note (Andy) This was originally posted on 7/9/12Īs summer has been moving along, I begin to notice more and more the inefficiencies out interns have with using Excel properly.
0 kommentar(er)
