Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas to end of Column
Hi,
Quick question- how can I quickly copy a formula to the end of an entire column (without having to scroll all the way down)?? Cheers, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas to end of Column
CTRL+C
Down Arrow Press and hold Shift End Down Arrow Release Shift Ctrl+V Steve On Wed, 31 Jan 2007 16:59:01 -0000, kippers wrote: Hi, Quick question- how can I quickly copy a formula to the end of an entire column (without having to scroll all the way down)?? Cheers, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas to end of Column
Hi,
Try this: select the cell you wish to copy down then hold the Shift+Ctrl and hit the down arrow key to select the rest of the column, next hit the F2 key to go into the edit mode then hold the Ctrl key and hit Enter. HTH Jean-Guy "kippers" wrote: Hi, Quick question- how can I quickly copy a formula to the end of an entire column (without having to scroll all the way down)?? Cheers, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas to end of Column
Do you really want a formula that extends to row 65536(entire column)?
Is the formula in a column adjacent to a column with data? If so, double-click on the fill handle of the cell with the formula to fill down to bottom of data in adjacent column. Gord Dibben MS Excel MVP On Wed, 31 Jan 2007 08:59:01 -0800, kippers wrote: Hi, Quick question- how can I quickly copy a formula to the end of an entire column (without having to scroll all the way down)?? Cheers, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Macro Help | Excel Discussion (Misc queries) | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions |