【1️⃣】 How to drag formulas in Excel

Web School of Informatics There are posts: How to drag formulas in Excel Dragging formulas in Excel is the familiar Fill down operation when we process data tables that use formulas or functions in Excel.

Dragging formulas in Excel is the familiar Fill down operation when we deal with data tables that use formulas or functions in Excel. Dragging this formula will help the Excel formula be applied to all data cells and display the correct results, instead of doing it manually one by one. The following article will guide you to drag formulas in Excel.

Instructions for dragging formulas in Excel

Step 1:

First, you create an Excel data table as usual and then in the first result cell, we use a function or formula to produce the result.

Later Click on the result box here it is hover down the last right edge of the cell as shown below.

How to drag formulas in Excel

Step 2:

Then you left click and then drag down the remaining cells and the results will be displayed immediately with the same formula used.

How to drag formulas in Excel

How to use the shortcut to drag the Excel formula

In addition to using the mouse, you can also use keyboard shortcuts in Excel to drag formulas.

First, we also need to have the result cell to fill the remaining cells. Press the Shift key and then select to the last cell position in the area containing the formula to be dragged. Then the whole area will be selected as shown below.

Later press Ctrl + EASY to drag the formula. Immediately afterwards also display the results as shown below.

How to drag formulas in Excel

The direction of dragging formulas in Excel not only drags from top to bottom, but you can drag with all different dimensions including:

  • Fill Down: from top to bottom
  • Fill Up: from bottom to top
  • Fill Right: from left to right
  • Fill Left: from right to left

Keyboard shortcuts for dragging formulas include Ctrl + R to drag the formula from left to right and Ctrl + D to drag the formula from the top.

In addition, we can also use the formula drag option available right on Excel. In the Editing group you will see the Fill tool with options to drag the formula as shown below.

How to drag formulas in Excel

How to fix the error that cannot drag Excel formulas

Drag formula is an operation and tool available in Excel, very easy to do. In case you can’t drag the formula, the reason comes from the Excel default setting.

On Windows, you access mục File > Options to enter the interface to customize the settings for Excel. Next we click on Advanced and then look at the content next to it, you tích chọn vào Enable fill handle and cell drag-and-drop and Check Alert before overwriting cells (warn when overwriting existing cells) .

How to drag formulas in Excel

With the Mac version of Excel, click on Excel and select Preferences… Now you click on Exit and then select the checkbox for Enable fill handle and cell drag-and-drop and tick Alert before overwriting cells.

How to drag formulas in Excel

  • How to manage conditional shaping rules in Excel
  • How to merge data from sheets in Excel
  • Instructions for inserting PDF into Excel
  • How to calculate percentage in Excel
  • How to use chart filters in Excel
  • How to generate random numbers in Excel

drag formula in Excel, how to drag formula in Excel, how to drag formula in Excel, shortcut to drag formula in Excel, how to drag formula in Excel

Content How to drag formulas in Excel Collected and edited by: School of Informatics. Any comments please send Contact to truongtin.top to adjust. truongtin.top tks.

The source: https://nguyendiep.com
Category: SEO

Thanks for Reading

Enjoyed this post? Share it with your networks.

Get more stuff

Subscribe to our mailing list and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

Leave a Feedback!