Podcast
Questions and Answers
What is the shortcut to enter the same data into multiple cells?
What is the shortcut to enter the same data into multiple cells?
How do you fill in data on adjacent cells in Excel?
How do you fill in data on adjacent cells in Excel?
What type of data can Microsoft Excel automatically continue in a series?
What type of data can Microsoft Excel automatically continue in a series?
What happens when you type the first few characters of an existing entry in a column?
What happens when you type the first few characters of an existing entry in a column?
Signup and view all the answers
What is the result of pressing ENTER when Excel completes an entry?
What is the result of pressing ENTER when Excel completes an entry?
Signup and view all the answers
How do you fill in a series of numbers in increasing order?
How do you fill in a series of numbers in increasing order?
Signup and view all the answers
What happens when you leave the second cell blank in a series?
What happens when you leave the second cell blank in a series?
Signup and view all the answers
What type of entries are not completed by Excel?
What type of entries are not completed by Excel?
Signup and view all the answers
What is the purpose of the fill handle?
What is the purpose of the fill handle?
Signup and view all the answers
What is the result of dragging the fill handle to the left?
What is the result of dragging the fill handle to the left?
Signup and view all the answers
Study Notes
Entering Data into Multiple Cells
- Select multiple non-adjacent cells using CTRL
- Type the data and press CTRL+ENTER to enter the same data into all selected cells
Filling in Data on Adjacent Cells
- Select the cell(s) containing the starting values
- Drag the fill handle over the range of cells to fill
- To fill in increasing order, drag down or to the right
- To fill in decreasing order, drag up or to the left
Examples of Filling in Series
- Enter 2 and 3 in the first two cells to fill in the series 2, 3, 4, 5, ...
- Enter 2 and 4 in the first two cells to fill in the series 2, 4, 6, 8, ...
- Enter 2 in the first cell and leave the second cell blank to fill in the series 2, 2, 2, ...
Automatically Filling in Repeated Entries
- If the first few characters typed in a cell match an existing entry in that column, Excel fills in the remaining characters
- Excel completes only entries that contain text or a combination of text and numbers
- Press ENTER to accept the completed entry
- The completed entry exactly matches the pattern of uppercase and lowercase letters of the existing entries
- Continue typing to replace the automatically entered characters
- Press BACKSPACE to delete the automatically entered characters
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Learn about editing shortcuts in Microsoft Excel, including entering data into multiple cells and filling in series of numbers or dates. This quiz is ideal for Excel users looking to improve their productivity.
