Free Excel Tutorial for Engineers : Excel Functions

End Functions: When we have lengthy worksheets it becomes very difficult to navigate quickly within the worksheet. There are a lot of keyboard shortcuts in excel which help you to navigate within a worksheet or select required cells using a few key strokes. Some of the most used shortcuts are listed in the table below:

KEY DESCRIPTION
Ctrl + Arrow key Allows you to navigate to the last non-blank cell of the row or column
Shift + Arrow key Allows you to select multiple cells one by one
Ctrl + Shift + Arrow key Allows you to select cells to the last non-blank cell of the row or column
Ctrl + End Allows you to navigate to the last non-blank cell of the worksheet
Ctrl + Shift + End Allows you to select all cells from the active cell to the last non-blank cell of the worksheet
Ctrl + Home Allows you to navigate to the first cell of the worksheet
Ctrl + Shift + Home Allows you to select data from the active cell to the first cell of the worksheet

Most of the options in the second and third chapters are explained using the mouse. But, it is important to know some of the basic keyboard shortcuts to speed up your work process. Listed below are a few of the standard keyboard shortcuts:

Key Description
Edit Button Opens the right click options on the worksheet
Ctrl + C Allows you to copy data to the clipboard
Ctrl + X Allows you to cut data to the clipboard
Ctrl + V Allows you to paste data into the worksheet from the clipboard
Ctrl + A Allows you to select all the data on your worksheet
Ctrl + S Allows you to save your workbook
Ctrl + Z Allows you to delete your last entry (undo)