FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -To locate the last cell that contains data or formatting, click anywhere in the worksheet, and then press CTRL+END.

Detailed explanation-2: -Finally, if you want to quickly move to the first or last sheet in a workbook, you can press Ctrl+Home or Ctrl+End, respectively. These shortcuts will take you to the first or last cell in the worksheet, but you can press Ctrl+PgUp or Ctrl+PgDn to move to the first or last sheet, respectively.

Detailed explanation-3: -CTRL+END Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column. PAGE DOWN Move down one screen. PAGE UP Move up one screen. ALT+PAGE DOWN Move one screen to the right.

Detailed explanation-4: -Press CTRL+HOME to select the first cell on the worksheet or in an Excel list. Press CTRL+END to select the last cell on the worksheet or in an Excel list that contains data or formatting.