Which if the following is true when you copy and paste formulas using the fill handle?

Auto Fill is a great way to enter sequential numbers, months or days quickly. Auto Fill looks at cells that you have already filled in and makes a guess about how you want to fill in the rest of the series. For example, if you enter January, Auto Fill will fill in the following months for you. Additionally, you can use Fill to copy formulas to adjacent cells.

Copy Data Using Auto Fill

You can also use Auto Fill to simply copy and paste a value to other cells.

1. Select the cell that contains the data you want to copy.
2. Position the mouse over the bottom-right corner of the cell.

   Before clicking and dragging, make sure you see a black plus symbol.

3. Click and drag down or across the cells you want to fill.
   

   Double-click the bottom right corner of the selected cell(s).

The column is instantly populated with the value in the first cell.

Enter a Series of Values with Auto Fill

Auto Fill can also complete a series of values once a pattern has been established. For example, if you enter January, Auto Fill will fill in the following months for you.

1. Select the cells that contain the first value of a series.
2. Click and drag down or across the cells you want to fill.
   

   Double-click the bottom right corner of the selected cell(s).

   If you don't double-click the square (fill handle), the fill will not work correctly.

The column is filled all the way down, following the pattern that was established in the first few cells.

Auto Fill Options

If Fill doesn't enter cell content the way you expected, you can correct the content using Auto Fill Options. This button appears after using the Fill command, and it offers valuable control over how the Fill command works.

1. Use Auto Fill to paste a series of values.

   A small Auto Fill Options button will appear at the bottom of the pasted values.

2. Click the Auto Fill Options button.

   A list of ways you can control the cell content that is entered appears.

3. Select a Fill option.
   

The cell content is changed according to the Fill option you chose.

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.

There are a few different ways to copy formulas in Excel using a pattern. One way is to use the fill handle. The fill handle is the small square in the bottom-right corner of a selected cell. When you hover over the fill handle, the cursor changes to a crosshair. To copy a formula using the fill handle, do the following:

1. Select the cell with the formula you want to copy.
2. Position the cursor over the fill handle until the cursor changes to a crosshair.
3. Drag the fill handle down or across to the cells you want to fill.

Another way to copy formulas is to use the Copy and Paste commands. To copy a formula using these commands, do the following:

1. Select the cell with the formula you want to copy.
2. On the Home tab, in the Clipboard group, click Copy.
3. Select the cell or range of cells where you want to paste the formula.
4. On the Home tab, in the Clipboard group, click Paste.

• basic editing operations
  • Keyboard shortcuts
  • Keyboard shortcuts
  • Keyboard shortcuts
  • Copy/paste data, undo/redo your actions
  • Copy/paste text passages, undo/redo your actions
  • Cut/copy/paste data
  • Undo/redo your actions
  • Spell-checking
  • Spell-checking
  • Spell checking
  • Manage files
  • Open or create new files and folders
  • Share files and folders
  • Navigate through your document
  • Select, cut, copy, paste text
  • Undo/redo your actions
  • Navigate through your spreadsheet
  • Select, cut, copy, paste data
  • Undo/redo your actions
  • Navigate through your presentation
  • Select, cut, copy, paste text and objects
  • Undo/redo your actions
  • Manage files
  • Open or create new files and folders
  • Share files and folders
  • Navigate through your document
  • Select, cut, copy, paste text
  • Undo/redo your actions
  • Navigate through your spreadsheet
  • Select, cut, copy, paste data
  • Undo/redo your actions
  • Navigate through your presentation
  • Select, cut, copy, paste text and objects
  • Undo/redo your actions
  • Manage files
  • Open or create new files and folders
  • Share files and folders
  • Navigate through your document
  • Select, cut, copy, paste text
  • Undo/redo your actions
  • Navigate through your spreadsheet
  • Select, cut, copy, paste data
  • Undo/redo your actions
  • Freeze panes
  • Navigate through your presentation
  • Select, cut, copy, paste text and objects
  • Undo/redo your actions
  • Navigate through your presentation
  • Select, cut, copy, paste text and objects
  • Undo/redo your actions
  • Manage files
  • Open or create new files and folders
  • Share files and folders
  • Navigate through your document
  • Select, cut, copy, paste text
  • Undo/redo your actions
  • Navigate through your spreadsheet
  • Select, cut, copy, paste data
  • Undo/redo your actions
  • Freeze panes
  • Navigate through your presentation
  • Select, cut, copy, paste text and objects
  • Undo/redo your actions

• copy and paste data
  • Copy/paste data, undo/redo your actions
  • Copy/paste text passages, undo/redo your actions
  • Cut/copy/paste data
  • Select, cut, copy, paste text
  • Select, cut, copy, paste data
  • Select, cut, copy, paste text and objects
  • Select, cut, copy, paste text
  • Select, cut, copy, paste data
  • Select, cut, copy, paste text and objects
  • Select, cut, copy, paste text
  • Select, cut, copy, paste data
  • Select, cut, copy, paste text and objects
  • Select, cut, copy, paste text
  • Select, cut, copy, paste data
  • Select, cut, copy, paste text and objects

Use basic clipboard operations

To cut, copy and paste data in the current spreadsheet make use of the right-click menu or use the corresponding icons of the Spreadsheet Editor available on any tab of the top toolbar,

• Cut - select data and use the Cut option from the right-click menu, or the Cut icon on the top toolbar to delete the selected data and send them to the computer clipboard memory. The cut data can be later inserted to another place in the same spreadsheet.
• Copy - select data and either use the Copy icon at the top toolbar or right-click and select the Copy option from the menu to send the selected data to the computer clipboard memory. The copied data can be later inserted to another place in the same spreadsheet.
• Paste - select a place and either use the Paste icon on the top toolbar or right-click and select the Paste option to insert the previously copied/cut data from the computer clipboard memory to the current cursor position. The data can be previously copied from the same spreadsheet.

In the online version, the following key combinations are only used to copy or paste data from/into another spreadsheet or some other program, in the desktop version, both the corresponding buttons/menu options and key combinations can be used for any copy/paste operations:

• Ctrl+X key combination for cutting;
• Ctrl+C key combination for copying;
• Ctrl+V key combination for pasting.

Note: instead of cutting and pasting data within the same worksheet you can select the required cell/cell range, hover the mouse cursor over the selection border so that it turns into the Arrow icon and drag and drop the selection to the necessary position.

To enable / disable the automatic appearance of the Paste Special button after pasting, go to the File tab > Advanced Settings and check / uncheck the Show the Paste Options button when the content is pasted checkbox.

Use the Paste Special feature

Note: For collaborative editing, the Paste Special feature is available in the Strict co-editing mode only.

Once the copied data is pasted, the Paste Special button appears next to the lower right corner of the inserted cell/cell range. Click this button to select the necessary paste option.

When pasting a cell/cell range with formatted data, the following options are available:

• Paste (Ctrl+P) - allows you to paste all the cell contents including data formatting. This option is selected by default.
• The following options can be used if the copied data contains formulas:
  • Paste only formula (Ctrl+F) - allows you to paste formulas without pasting the data formatting.
  • Formula + number format (Ctrl+O) - allows you to paste formulas with the formatting applied to numbers.
  • Formula + all formatting (Ctrl+K) - allows you to paste formulas with all the data formatting.
  • Formula without borders (Ctrl+B) - allows you to paste formulas with all the data formatting except the cell borders.
  • Formula + column width (Ctrl+W) - allows you to paste formulas with all the data formatting and set the source column`s width for the cell range.
  • Transpose (Ctrl+T) - allows you to paste data switching them from columns to rows, or vice versa. This option is available for regular data ranges, but not for formatted tables.
• The following options allow you to paste the result that the copied formula returns without pasting the formula itself:
  • Paste only value (Ctrl+V) - allows you to paste the formula results without pasting the data formatting.
  • Value + number format (Ctrl+A) - allows to paste the formula results with the formatting applied to numbers.
  • Value + all formatting (Ctrl+E) - allows you to paste the formula results with all the data formatting.
• Paste only formatting (Ctrl+R) - allows you to paste the cell formatting only without pasting the cell contents.
  
  1. Paste
     • Formulas - allows you to paste formulas without pasting the data formatting.
     • Values - allows you to paste the formula results without pasting the data formatting.
     • Formats - allows you to apply the formatting of the copied area.
     • Comments - allows you to add comments of the copied area.
     • Column widths - allows you to set certal column widths of the copied area.
     • All except borders - allows you to paste formulas, formula results with all its formatting except borders.
     • Formulas & formatting - allows you to paste formulas and apply formatting on them from the copied area.
     • Formulas & column widths - allows you to paste formulas and set certaln column widths of the copied area.
     • Formulas & number formulas - allows you to paste formulas and number formulas.
     • Values & number formats - allows you to paste formula results and apply the numbers formatting of the copied area.
     • Values & formatting - allows you to paste formula results and apply the formatting of the copied area.
  2. Operation
     • Add - allows you to automatically add numeric values in each inserted cell.
     • Subtract - allows you to automatically subtract numeric values in each inserted cell.
     • Multiply - allows you to automatically multiply numeric values in each inserted cell.
     • Divide - allows you to automatically divide numeric values in each inserted cell.
  3. Transpose - allows you to paste data switching them from columns to rows, or vice versa.
  4. Skip blanks - allows you to skip pasting empty cells and their formatting.
  

When pasting the contents of a single cell or some text within autoshapes, the following options are available:

• Source formatting (Ctrl+K) - allows you to keep the source formatting of the copied data.
• Destination formatting (Ctrl+M) - allows you to apply the formatting that is already used for the cell/autoshape where the data are to be inserted to.

Paste delimited text

When pasting the delimited text copied from a .txt file, the following options are available:

The delimited text can contain several records, and each record corresponds to a single table row. Each record can contain several text values separated with a delimiter (such as a comma, semicolon, colon, tab, space or other characters). The file should be saved as a plain text .txt file.

• Keep text only (Ctrl+T) - allows you to paste text values into a single column where each cell contents corresponds to a row in the source text file.
• Use text import wizard - allows you to open the Text Import Wizard which helps to easily split the text values into multiple columns where each text value separated by a delimiter will be placed into a separate cell.

  When the Text Import Wizard window opens, select the text delimiter used in the delimited data from the Delimiter drop-down list. The data split into columns will be displayed in the Preview field below. If you are satisfied with the result, click the OK button.

If you pasted delimited data from a source that is not a plain text file (e.g. text copied from a web page etc.), or if you applied the Keep text only feature and now want to split the data from a single column into several columns, you can use the Text to Columns option.

To split data into multiple columns:

1. Select the necessary cell or column that contains data with delimiters.
2. Switch to the Data tab.
3. Click the Text to columns button on the top toolbar. The Text to Columns Wizard opens.
4. In the Delimiter drop-down list, select the delimiter used in the delimited data.
5. Click the Advanced button to open the Advanced Settings window in which you can specify the Decimal and Thousands separators.
   

6. Preview the result in the field below and click OK.

After that, each text value separated by the delimiter will be located in a separate cell.

If there is some data in the cells to the right of the column you want to split, the data will be overwritten.

Use the Auto Fill option

To quickly fill multiple cells with the same data use the Auto Fill option:

1. select a cell/cell range containing the required data,
2. move the mouse cursor over the fill handle in the right lower corner of the cell. The cursor will turn into the black cross:
3. drag the handle over the adjacent cells to fill them with the selected data.

Note: if you need to create a series of numbers (such as 1, 2, 3, 4...; 2, 4, 6, 8... etc.) or dates, you can enter at least two starting values and quickly extend the series selecting these cells and dragging the fill handle.

Fill cells in the column with text values

If a column in your spreadsheet contains some text values, you can easily replace any value within this column or fill the next blank cell selecting one of already existing text values.

Right-click the necessary cell and choose the Select from drop-down list option in the contextual menu.

Select one of the available text values to replace the current one or fill an empty cell.

Return to previous page

Which of the following is true when you copy and paste formulas using the fill handle quizlet?

Which of the following can you use to copy the formula to an adjacent cell?

When you paste formula cells using the Paste button?

When you copy and paste a formula with absolute cell references Excel substitutes NEW references?