Suppose you right-click and drag the fill handle in the lower right corner of a cell. When you release the right mouse button, what option appears?
Question
Suppose you right-click and drag the fill handle in the lower right corner of a cell. When you release the right mouse button, what option appears?
Solution
When you right-click and drag the fill handle in the lower right corner of a cell in Excel, a context menu appears when you release the right mouse button. This context menu provides several options for how Excel should fill the selected cells. These options include:
-
Copy Cells: This option will simply duplicate the content of the original cell(s) in the selected cells.
-
Fill Series: This option will fill the selected cells with a series that follows from the original cell(s). For example, if the original cell contained the number 1, the filled cells could contain the numbers 2, 3, 4, etc.
-
Fill Formatting Only: This option will apply the formatting of the original cell(s) to the selected cells, but it will not copy the actual content of the original cell(s).
-
Fill Without Formatting: This option will copy the content of the original cell(s) to the selected cells, but it will not apply the formatting of the original cell(s).
-
Fill Days, Fill Weekdays, Fill Months, Fill Years: These options will fill the selected cells with a series of days, weekdays, months, or years that follows from the date in the original cell.
-
Series: This option opens the Series dialog box, which provides more detailed options for filling the selected cells with a series.
Similar Questions
What does clicking and dragging the fill handle indicated by the cursor below do?
Which technique for dragging and inserting a column of cells displays a dialog box asking you how you want the cells shifted?
Which key do you hold down when selecting cells that are in different areas of a worksheet?
Looking at the Menu options, where would you click first if you want to add a column to the right of your selected column in Google Sheets?
To activate the previous cell in a pre-selected range, press The Alt key The Tab key The Enter key None of the above
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.