| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dragging a formula in a column
I have a formula in a cell that I need to drag down, the spreadsheet itself is very big and dragging it is a pain. Tried double clicking the lower right corner but it wont work because the column to the right of it also has blanks in it. Any suggestions?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dragging a formula in a column
on 27/02/2013, RB supposed :
I have a formula in a cell that I need to drag down, the spreadsheet itself is very big and dragging it is a pain. Tried double clicking the lower right corner but it wont work because the column to the right of it also has blanks in it. Any suggestions? You could select the first cell containing the formula along with all the other cells you want to copy the formula to, then press 'F2' to enter EditMode in the cell containing the formula, then press 'Ctrl+Enter' to put the formula into all the other cells simultaneously. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dragging across columns: I want column constant, but row increment | Excel Worksheet Functions | |||
| Problem with dragging formula down a column | New Users to Excel | |||
| Code for dragging the last column | Excel Worksheet Functions | |||
| Excell dragging formula to change sheet/tab not column/row | Excel Worksheet Functions | |||
| dragging a formula down a column | Excel Worksheet Functions | |||
![RB[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
