Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to apply a formula to an entire column.
I keep a running checkbook balance in a worksheet. Can I apply the formula
to the entire column (which has an alpha header) without having to drag the fill handle down manually? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to apply a formula to an entire column.
Here is one I have used.
Sub balance() [a7].Select Sort [h7] = [d7] Set frng = Range("h8:h" & Range("a65536").End(xlUp).Row) With frng .Formula = "=h7+d8" .Formula = .Value End With End Sub -- Don Guillett SalesAid Software "kitcox" wrote in message ... I keep a running checkbook balance in a worksheet. Can I apply the formula to the entire column (which has an alpha header) without having to drag the fill handle down manually? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to apply a formula to an entire column.
kit
If you have data in an adjacent column you can just double-click on the fill handle of the formula cell and the formula will be copied down to end of data. Alternative......... Enter the formula in A1. In namebox type A1:A1234 and ENTER. EditFillDown Gord Dibben Excel MVP On Sat, 26 Nov 2005 08:07:03 -0800, kitcox wrote: I keep a running checkbook balance in a worksheet. Can I apply the formula to the entire column (which has an alpha header) without having to drag the fill handle down manually? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to apply a formula to an entire column.
Thank you, Gord.
I had not known about the double-clicking-on-the-fill-handle business. It doesn't really appply to this issue but it's helpful to know. Your second suggestion worked with a minor modification. I entered the range of cells in the namebox to highlight them, then entered the formula in the top cell, and pressed ctrl-enter. -Kit "Gord Dibben" wrote: kit If you have data in an adjacent column you can just double-click on the fill handle of the formula cell and the formula will be copied down to end of data. Alternative......... Enter the formula in A1. In namebox type A1:A1234 and ENTER. EditFillDown Gord Dibben Excel MVP On Sat, 26 Nov 2005 08:07:03 -0800, kitcox wrote: I keep a running checkbook balance in a worksheet. Can I apply the formula to the entire column (which has an alpha header) without having to drag the fill handle down manually? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How do I apply a function to an entire column? | New Users to Excel | |||
How do I create a formula for an entire column | New Users to Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula for a column | Excel Discussion (Misc queries) |