excel keyboard shortcut change hard reference

Imagine using your arrow keys to move up, down, left and right through that many cells! You may want to quickly go to the beginning of your data (the first entry) and back down to the last entry to add more data.ġ. * Shortcuts for Moving to the Beginning and End of Your DataĪ worksheet can contain hundreds and even thousands of rows and columns of data. Using these shortcut keys allow for efficient data entry as you do not need to take your hands off the keyboard. To move “backwards” or one cell to the left of the selected cell, press Shift+Tab. When entering data in a cell, use the Tab key to move to the next cell on the right.

Holding down the right, left, up or down pointing arrow will allow you to move through multiple cells.ĥ. The orange highlighted number 10 on the left-hand side of the screenshot and the orange highlighted G at the top of the screenshot indicate the row and column in which the selected cell is positioned.Ĥ. The cell with the black border around it in the screenshot above, indicates the currently selected cell.ģ. Use the arrow keys on your keyboard to move up, down, left or right.Ģ. To navigate around cells in a worksheet is really simple. A worksheet may be likened to a beehive which consists of cells that contain different elements but collectively make up the hive.ġ. Each cell is an individual entity but cells work together to make up a worksheet. It is important to understand that Excel is a grid containing cells that are separated from one another. One of the first problems when using Excel most people face, is “how do I move around”. * Keyboard Shortcuts for Moving Around Cells

Test your Excel skills with the corresponding FREE Online Multiple ChoiceĮxcel Keyboard Shortcuts for Worksheets Test Learn Excel Shortcut Keys with our free online tutorial. Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to move and make selections in the worksheet. * Shortcuts for Selecting Rows and Columns * Shortcuts for Moving to the Beginning and End of Data Keyboard Shortcuts * Shortcuts for Moving Around Cells Excel Shortcuts for Worksheets Tutorial – (Excel Keyboard Shortcuts) Free Excel Training – Excel 2010 & Excel 2013 Excel Shortcuts for Worksheets Tutorial (Excel Keyboard Shortcuts – Excel Hotkeys)

Excel keyboard shortcut change hard reference