You can tell cells or the entire sheet (as in the screenshot above) is selected as the selected area or section will be shaded in blue.ĥ. To do this press Ctrl+a to select all the cells in the worksheet.Ĥ. Select All, also known as the “Power drunk shortcut” can be used if you wish to apply formatting to the entire worksheet, for example to change the font or some other element. To quickly select the entire column in which your cursor is positioned, press Ctrl+Space.ģ. To quickly select the entire row in which your cursor is positioned, press Shift+Space.Ģ. Shortcut keys allow you to do this quickly and seamlessly without the need to take your hands off the keyboard in order to do this.ġ. You are probably familiar with using your mouse to select rows and columns or entire sections of data in your worksheet. * Keyboard Shortcuts for Selecting Rows and Columns Use Ctrl+End to quickly move your selection to the last cell in your data and Ctrl+Home to move back to the first cell in your data section. These allow you to move to the beginning and end of the data contained in a worksheet respectively. Possibly the hippest shortcuts for moving around a worksheet are the Ctrl+Home and Ctrl+End combinations. You use the Page Up key to move a screen size towards the top of your worksheet and Page Down to move a screen size down towards the bottom of your worksheet.Ĥ. To move a screen size upwards or downwards through a worksheet, use the Page Up and Page Down keys located on the top right-hand side of a standard keyboard. When viewing a worksheet you are restricted to the size of your screen. To move to the end of the row in which you are currently positioned, hold down the Ctrl key and press the right arrow on your keyboard to go to the end of a row.ģ. You can also hold down the Ctrl key and press the left arrow on your keyboard to go to the beginning of a row.Ģ. The Home key is usually located on the top right-hand side of a standard keyboard. To move to the beginning of the row in which you are currently positioned, press the Home key on your keyboard. 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
![excel keyboard shortcut strikethrough excel keyboard shortcut strikethrough](https://cdn-7dee.kxcdn.com/wp-content/uploads/2017/08/how-to-strikethrough-excel-2013-4.jpg)
#Excel keyboard shortcut strikethrough free#
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.
#Excel keyboard shortcut strikethrough pro#
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
![excel keyboard shortcut strikethrough excel keyboard shortcut strikethrough](https://www.it24hrs.com/wp-content/uploads/2019/05/ipad-screenshot-keyboard-shortcuts-c.jpg)
* 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)