0
You can drag while a filter is active, but only visible cells will have data put into them. So when the filter is removed, there may be gaps in the set of cells that have data in them. Any cells that were not visible when the filter was active will not have had the data dragged into them.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
How do you highlight in Excel?
You need to click on a cell and hold on, then drag it to another cell.
How can you drag an Excel cell without mouse or in keyboard?
You can not use the keyboard to drag in Excel, but you can use cut and paste. Go to the starting cell and press Crtl-X to cut, then use the arrow keys to move to the cell where you would like to move the contents of the first cell and press Crtl-V.
Which key do i use in excel to drag and copy info into new location?
First put the cursor on the edge of the cell. Then press and hold the Ctrl key. If you have done it right, just above the arrow you will see a small cross. You can then drag while continuing to hold the Ctrl key and the cell or cells that are selected can be copied to another place.
When the active cell contains the formula dragging the fill handle causes Excel to?
Copy the forumula to the cells where you drag the fill handle.
When the active cell contains a formula dragging the fill handle causes excel to?
Copy the forumula to the cells where you drag the fill handle.
Is there any other way to move things into a cell beside copy and paste in Excel?
You can drag things or use the Fill Handle.
What is a drag-and-drop method in Excel?
To drag and drop is a way of moving something with the mouse. You are effectively dragging it from its current position and moving it and then dropping it into its new position. It is done visually, so you can see it happening, unlike when you do the same thing using Cut and Paste commands.
How to repeat a formula in new cells on an Excel document?
Either drag the formula cell down the column, or copy (right-click) the cell then paste (right-click) in other cells.
How do you select cells A3 through F3 in excel?
In Excel, cell selection is accomplished by highlighting the desired cells. This is done by bringing the cursor to the desired cell, left clicking and holding the button down while dragging the mouse. So click on A3 and drag down to F3.
How to enable fill handle in Excel?
Click the Microsoft Office Button. Then click Excel Options. In the Advanced category, under Editing options, select the Enable fill handle and cell drag-and-drop check box to turn drag-and-drop editing on. The Fill Handle will now be enabled when you return to the worksheet.
Is copy and paste same as drag and drop in excel?
no
What does SHIFT 4 do in Excel?
IT GIVES YOU $ BUT WHAT DOES IT DO IN EXCEL? The dollar signs $ can make the cell reference absolute =$A$1 is absolute reference, if you dragged the formula it will always be A1 =A1 is relative reference if you drag the formula the reference will change accordingly
