---
title: "Editing and filling practice: 5 exercises with answers"
description: "Practice the Excel shortcuts for editing and filling: F2, Esc, Ctrl+D, Ctrl+R, AutoSum, undo and redo."
canonical_url: "https://excelsavvy.com/practice/editing-and-filling"
meta:
  "og:description": "Practice the Excel shortcuts for editing and filling: F2, Esc, Ctrl+D, Ctrl+R, AutoSum, undo and redo."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~RWRpdGluZyBhbmQgZmlsbGluZyBwcmFjdGljZTogNSBleGVyY2lzZXMgd2l0aCBhbnN3ZXJz%2Cdescription_~UHJhY3RpY2UgdGhlIEV4Y2VsIHNob3J0Y3V0cyBmb3IgZWRpdGluZyBhbmQgZmlsbGluZzogRjIsIEVzYywgQ3RybCtELCBDdHJsK1IsIEF1dG9TdW0sIHVuZG8gYW5kIHJlZG8u%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiTW9udGgiLCJTYWxlcyJdfSx7Im4iOjIsImNlbGxzIjpbIkphbnVhcnkiLCIxMjAiXX0seyJuIjozLCJjZWxscyI6WyJGZWJydWFyeSIsIjk1Il19LHsibiI6NCwiY2VsbHMiOlsiTWFyY2giLCIxNDAiXX1dfX0%2Cp_Ii9wcmFjdGljZS9lZGl0aW5nLWFuZC1maWxsaW5nIg%2Cs_ef45hE4mSZqhm6e-.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Editing and filling practice: 5 exercises with answers"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~RWRpdGluZyBhbmQgZmlsbGluZyBwcmFjdGljZTogNSBleGVyY2lzZXMgd2l0aCBhbnN3ZXJz%2Cdescription_~UHJhY3RpY2UgdGhlIEV4Y2VsIHNob3J0Y3V0cyBmb3IgZWRpdGluZyBhbmQgZmlsbGluZzogRjIsIEVzYywgQ3RybCtELCBDdHJsK1IsIEF1dG9TdW0sIHVuZG8gYW5kIHJlZG8u%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiTW9udGgiLCJTYWxlcyJdfSx7Im4iOjIsImNlbGxzIjpbIkphbnVhcnkiLCIxMjAiXX0seyJuIjozLCJjZWxscyI6WyJGZWJydWFyeSIsIjk1Il19LHsibiI6NCwiY2VsbHMiOlsiTWFyY2giLCIxNDAiXX1dfX0%2Cp_Ii9wcmFjdGljZS9lZGl0aW5nLWFuZC1maWxsaW5nIg%2Cs_ef45hE4mSZqhm6e-.png"
---

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

# **Editing and filling practice exercises**

Edit a cell without retyping it, fill a formula down a column, add a total in one keystroke and undo your way out of mistakes.

[**Start the first exercise**](https://excelsavvy.com/practice/editing-and-filling/edit-a-cell)

## **How to edit and fill cells with shortcuts**

`**F2**` opens the cell you're in for editing, so you can fix a typo without retyping. `**Esc**` backs out and keeps the old content, `**Enter**` confirms and moves down, and `**Tab**` confirms and moves right. `**Ctrl+D**` copies the top cell of a selection down, `**Ctrl+R**` copies the leftmost cell to the right, and `**Alt+=**` adds a SUM total. `**Ctrl+Z**` undoes and `**Ctrl+Y**` redoes.

Say C2 holds `**=B2*0.25**`. Select C2:C20 and press `**Ctrl+D**`, and the formula fills every row, and the references adjust as it goes. If the formula points to a rate in F1, press `**F4**` while the cursor is on F1 to turn it into `**$F$1**`, so it stays put when you fill: `**=B2*$F$1**`.

`**F4**` only cycles through $F$1, F$1 and $F1 while you are editing a formula, and on some laptops you need to hold Fn. To fill a whole selection at once, type the formula and press `**Ctrl+Enter**` instead of Enter. The exercises below cover F2 and Esc, filling down and right, AutoSum with undo and redo, locking a reference with F4 and Ctrl+Enter.

1. [**1****Edit a cell without retyping it**Open a cell for editing, back out of it, and move on with Enter and Tab.](https://excelsavvy.com/practice/editing-and-filling/edit-a-cell)
2. [**2****Fill a formula down and right**Copy a formula to the rows below and the column next to it without retyping it.](https://excelsavvy.com/practice/editing-and-filling/fill-down-and-right)
3. [**3****AutoSum, undo and redo**Add a total with one shortcut, then undo and redo it.](https://excelsavvy.com/practice/editing-and-filling/autosum-undo-redo)
4. [**4****Lock a reference with F4**Fix a formula so it can be filled down, without retyping it.](https://excelsavvy.com/practice/editing-and-filling/lock-reference-f4)
5. [**5****Fill every selected cell with Ctrl+Enter**Put one formula into a whole selection at once.](https://excelsavvy.com/practice/editing-and-filling/ctrl-enter-fill-selection)

## **Read the guide**

- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://excelsavvy.com/learn/how-to-learn-excel)
- [**Excel keyboard shortcuts worth learning, and how to make them stick**](https://excelsavvy.com/learn/excel-keyboard-shortcuts)

## **Questions**

<details>

<summary>

### How do I fill a formula down to the last row without dragging?

</summary>

Double-click the fill handle, the small square in the bottom-right corner of the cell. Excel fills down as far as the column next to it has data. You can also click the formula cell, hold Shift and click the last row you need, then press Ctrl+D. The second way works even when the neighboring column has gaps.

</details>

<details>

<summary>

### What is the AutoSum shortcut in Excel?

</summary>

Press Alt+= in the cell below or to the right of your numbers. Excel types a SUM formula and guesses the range, so check the highlighted cells before you press Enter. Select several cells first and one press adds a total under every column in the selection. Alt+= works the same for a row of numbers.

</details>

<details>

<summary>

### How do I undo more than one step in Excel?

</summary>

Press Ctrl+Z once for each step you want to undo. To go back several steps in one go, click the small arrow next to the Undo button at the top of the window and pick the step in the list. Everything above it is undone too. Ctrl+Y redoes the steps you undid, as long as you haven't made a new change.

</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/editing-and-filling#webpage","description":"Practice the Excel shortcuts for editing and filling: F2, Esc, Ctrl+D, Ctrl+R, AutoSum, undo and redo.","name":"Editing and filling practice: 5 exercises with answers","url":"https://excelsavvy.com/practice/editing-and-filling","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/editing-and-filling#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/editing-and-filling#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/editing-and-filling#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/editing-and-filling#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/editing-and-filling"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/editing-and-filling#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":"Editing and filling practice: 5 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/editing-and-filling#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I fill a formula down to the last row without dragging?","acceptedAnswer":{"@type":"Answer","text":"Double-click the fill handle, the small square in the bottom-right corner of the cell. Excel fills down as far as the column next to it has data. You can also click the formula cell, hold Shift and click the last row you need, then press Ctrl+D. The second way works even when the neighboring column has gaps."}},{"@id":"https://excelsavvy.com/practice/editing-and-filling#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"What is the AutoSum shortcut in Excel?","acceptedAnswer":{"@type":"Answer","text":"Press Alt+= in the cell below or to the right of your numbers. Excel types a SUM formula and guesses the range, so check the highlighted cells before you press Enter. Select several cells first and one press adds a total under every column in the selection. Alt+= works the same for a row of numbers."}},{"@id":"https://excelsavvy.com/practice/editing-and-filling#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I undo more than one step in Excel?","acceptedAnswer":{"@type":"Answer","text":"Press Ctrl+Z once for each step you want to undo. To go back several steps in one go, click the small arrow next to the Undo button at the top of the window and pick the step in the list. Everything above it is undone too. Ctrl+Y redoes the steps you undid, as long as you haven't made a new change."}},{"@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.
