---
title: "Editing and filling practice exercises | PracticeExcel"
description: "Practice the Excel shortcuts for editing and filling: F2, Esc, Ctrl+D, Ctrl+R, AutoSum, undo and redo."
canonical_url: "https://practiceexcelonline.com/practice/editing-and-filling"
locale: en
meta:
  "og:description": "Practice the Excel shortcuts for editing and filling: F2, Esc, Ctrl+D, Ctrl+R, AutoSum, undo and redo."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_Editing%2Band%2Bfilling%2Bpractice%2Bexercises%2Cdescription_~UHJhY3RpY2UgdGhlIEV4Y2VsIHNob3J0Y3V0cyBmb3IgZWRpdGluZyBhbmQgZmlsbGluZzogRjIsIEVzYywgQ3RybCtELCBDdHJsK1IsIEF1dG9TdW0sIHVuZG8gYW5kIHJlZG8u%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiTW9udGgiLCJTYWxlcyJdfSx7Im4iOjIsImNlbGxzIjpbIkphbnVhcnkiLCIxMjAiXX0seyJuIjozLCJjZWxscyI6WyJGZWJydWFyeSIsIjk1Il19LHsibiI6NCwiY2VsbHMiOlsiTWFyY2giLCIxNDAiXX1dfX0%2Cp_Ii9wcmFjdGljZS9lZGl0aW5nLWFuZC1maWxsaW5nIg%2Cs_3tv7fl02efWi_Ci3.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Editing and filling practice exercises | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_Editing%2Band%2Bfilling%2Bpractice%2Bexercises%2Cdescription_~UHJhY3RpY2UgdGhlIEV4Y2VsIHNob3J0Y3V0cyBmb3IgZWRpdGluZyBhbmQgZmlsbGluZzogRjIsIEVzYywgQ3RybCtELCBDdHJsK1IsIEF1dG9TdW0sIHVuZG8gYW5kIHJlZG8u%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiTW9udGgiLCJTYWxlcyJdfSx7Im4iOjIsImNlbGxzIjpbIkphbnVhcnkiLCIxMjAiXX0seyJuIjozLCJjZWxscyI6WyJGZWJydWFyeSIsIjk1Il19LHsibiI6NCwiY2VsbHMiOlsiTWFyY2giLCIxNDAiXX1dfX0%2Cp_Ii9wcmFjdGljZS9lZGl0aW5nLWFuZC1maWxsaW5nIg%2Cs_3tv7fl02efWi_Ci3.png"
---

> Index of every page on this site: [llms.txt](https://practiceexcelonline.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://practiceexcelonline.com/practice/editing-and-filling/edit-a-cell)

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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.com/learn/how-to-learn-excel)
- [**Excel keyboard shortcuts worth learning, and how to make them stick**](https://practiceexcelonline.com/learn/excel-keyboard-shortcuts)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.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 exercises","url":"https://practiceexcelonline.com/practice/editing-and-filling","@type":["WebPage","CollectionPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/practice/editing-and-filling#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/editing-and-filling"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/editing-and-filling#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://practiceexcelonline.com/practice","position":2},{"@type":"ListItem","name":"Editing and filling practice exercises","position":3}]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```

## Sitemap

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