---
title: "Moving and selecting practice: 3 exercises with answers"
description: "Practice the Excel shortcuts for moving and selecting: Ctrl+Arrow, Ctrl+Shift+Arrow, Ctrl+Home, Shift+Space and more."
canonical_url: "https://excelsavvy.com/practice/moving-and-selecting"
meta:
  "og:description": "Practice the Excel shortcuts for moving and selecting: Ctrl+Arrow, Ctrl+Shift+Arrow, Ctrl+Home, Shift+Space and more."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~TW92aW5nIGFuZCBzZWxlY3RpbmcgcHJhY3RpY2U6IDMgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~UHJhY3RpY2UgdGhlIEV4Y2VsIHNob3J0Y3V0cyBmb3IgbW92aW5nIGFuZCBzZWxlY3Rpbmc6IEN0cmwrQXJyb3csIEN0cmwrU2hpZnQrQXJyb3csIEN0cmwrSG9tZSwgU2hpZnQrU3BhY2UgYW5kIG1vcmUu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiSW52b2ljZSIsIkFtb3VudCJdfSx7Im4iOjIsImNlbGxzIjpbIklOVi0xMDEiLCIxMjAiXX0seyJuIjozLCJjZWxscyI6WyJJTlYtMTAyIiwiODUiXX0seyJuIjo0LCJjZWxscyI6WyJJTlYtMTAzIiwiMjQwIl19LHsibiI6NSwiY2VsbHMiOlsiSU5WLTEwNCIsIjYwIl19LHsibiI6NiwiY2VsbHMiOlsiSU5WLTEwNSIsIjMxMCJdfV19fQ%2Cp_Ii9wcmFjdGljZS9tb3ZpbmctYW5kLXNlbGVjdGluZyI%2Cs_iyf1lLmpnMsu0ZSz.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Moving and selecting practice: 3 exercises with answers"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~TW92aW5nIGFuZCBzZWxlY3RpbmcgcHJhY3RpY2U6IDMgZXhlcmNpc2VzIHdpdGggYW5zd2Vycw%2Cdescription_~UHJhY3RpY2UgdGhlIEV4Y2VsIHNob3J0Y3V0cyBmb3IgbW92aW5nIGFuZCBzZWxlY3Rpbmc6IEN0cmwrQXJyb3csIEN0cmwrU2hpZnQrQXJyb3csIEN0cmwrSG9tZSwgU2hpZnQrU3BhY2UgYW5kIG1vcmUu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiSW52b2ljZSIsIkFtb3VudCJdfSx7Im4iOjIsImNlbGxzIjpbIklOVi0xMDEiLCIxMjAiXX0seyJuIjozLCJjZWxscyI6WyJJTlYtMTAyIiwiODUiXX0seyJuIjo0LCJjZWxscyI6WyJJTlYtMTAzIiwiMjQwIl19LHsibiI6NSwiY2VsbHMiOlsiSU5WLTEwNCIsIjYwIl19LHsibiI6NiwiY2VsbHMiOlsiSU5WLTEwNSIsIjMxMCJdfV19fQ%2Cp_Ii9wcmFjdGljZS9tb3ZpbmctYW5kLXNlbGVjdGluZyI%2Cs_iyf1lLmpnMsu0ZSz.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **Moving and selecting practice exercises**

Stop scrolling and dragging. Jump to the end of your data, go back to A1 and select whole tables, rows and columns from the keyboard, the way fast Excel users do.

[**Start the first exercise**](https://excelsavvy.com/practice/moving-and-selecting/jump-to-the-end-of-your-data)

## **How to move and select with the keyboard**

Moving and selecting from the keyboard is one of the quickest ways to speed up in Excel, and it takes only a handful of shortcuts. `**Ctrl+Arrow**` jumps to the edge of a block of data, and adding Shift selects everything on the way. `**Ctrl+Home**` takes you back to A1, and `**Ctrl+End**` to the last cell you've used. `**Shift+Space**` selects the row you're in, `**Ctrl+Space**` the column, and `**Ctrl+A**` the table or the whole sheet.

Say a list of invoices fills A1:C500. From A1, `**Ctrl+Down**` lands on A500 in one jump. `**Ctrl+Shift+Right**` and then `**Ctrl+Shift+Down**` select the whole table, A1:C500, however long it grows. `**Ctrl+Home**` brings you back to A1.

A blank cell stops `**Ctrl+Arrow**`, so if a jump ends halfway down, there is a gap in your data. `**Ctrl+End**` goes to the last cell Excel counts as used, which can sit below your data if formatting is left behind. On a Mac, use Cmd instead of Ctrl for the arrow keys. The exercises below cover jumping to the end of a list, selecting a whole table, and selecting rows, columns and the whole sheet.

1. [**1****Jump to the end of your data**Move around a list of invoices with the keyboard instead of scrolling.](https://excelsavvy.com/practice/moving-and-selecting/jump-to-the-end-of-your-data)
2. [**2****Select a whole table**Select a table of any size with two shortcuts.](https://excelsavvy.com/practice/moving-and-selecting/select-a-whole-table)
3. [**3****Select rows, columns and everything**Select a whole row, a whole column and the whole sheet from the keyboard.](https://excelsavvy.com/practice/moving-and-selecting/select-rows-and-columns)

## **Read the guide**

- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://excelsavvy.com/learn/how-to-learn-excel)
- [**Pivot tables explained, and the formulas that do the same job**](https://excelsavvy.com/learn/pivot-tables)
- [**Excel keyboard shortcuts worth learning, and how to make them stick**](https://excelsavvy.com/learn/excel-keyboard-shortcuts)

## **Questions**

<details>

<summary>

### How do I select a whole column in Excel with the keyboard?

</summary>

Click any cell in the column and press Ctrl+Space. For a whole row, press Shift+Space. To add the next columns, hold Shift and press the right arrow after Ctrl+Space. If you only want the filled part of the column, press Ctrl+Shift+Down from the first cell instead, and Excel stops at the end of the data.

</details>

<details>

<summary>

### What is the difference between Ctrl+Down and Ctrl+End?

</summary>

Ctrl+Down jumps down the column you are in, to the end of the block of data. If you start in a blank cell, it jumps to the next filled cell. Ctrl+End goes to the bottom-right corner of the used area of the whole sheet, whatever column you are in. Use Ctrl+Down to move around a table and Ctrl+End to see how far the sheet reaches.

</details>

<details>

<summary>

### How do I select a large range without dragging?

</summary>

Click the first cell, scroll to the last one, hold Shift and click it. Or type the range, for example A1:C500, in the Name Box left of the formula bar and press Enter. If the data has no gaps, Ctrl+Shift+Right and Ctrl+Shift+Down from the first cell select the whole table without any scrolling.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/moving-and-selecting#webpage","description":"Practice the Excel shortcuts for moving and selecting: Ctrl+Arrow, Ctrl+Shift+Arrow, Ctrl+Home, Shift+Space and more.","name":"Moving and selecting practice: 3 exercises with answers","url":"https://excelsavvy.com/practice/moving-and-selecting","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/moving-and-selecting#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/moving-and-selecting#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/moving-and-selecting#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/moving-and-selecting#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/moving-and-selecting"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/moving-and-selecting#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"Moving and selecting practice: 3 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/moving-and-selecting#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I select a whole column in Excel with the keyboard?","acceptedAnswer":{"@type":"Answer","text":"Click any cell in the column and press Ctrl+Space. For a whole row, press Shift+Space. To add the next columns, hold Shift and press the right arrow after Ctrl+Space. If you only want the filled part of the column, press Ctrl+Shift+Down from the first cell instead, and Excel stops at the end of the data."}},{"@id":"https://excelsavvy.com/practice/moving-and-selecting#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"What is the difference between Ctrl+Down and Ctrl+End?","acceptedAnswer":{"@type":"Answer","text":"Ctrl+Down jumps down the column you are in, to the end of the block of data. If you start in a blank cell, it jumps to the next filled cell. Ctrl+End goes to the bottom-right corner of the used area of the whole sheet, whatever column you are in. Use Ctrl+Down to move around a table and Ctrl+End to see how far the sheet reaches."}},{"@id":"https://excelsavvy.com/practice/moving-and-selecting#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I select a large range without dragging?","acceptedAnswer":{"@type":"Answer","text":"Click the first cell, scroll to the last one, hold Shift and click it. Or type the range, for example A1:C500, in the Name Box left of the formula bar and press Enter. If the data has no gaps, Ctrl+Shift+Right and Ctrl+Shift+Down from the first cell select the whole table without any scrolling."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
