Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
copy a function to a whole column
I am entering a figure in column A, i want column B to automatically work out
the vat element of the figure in column A. Then i want column c to add the 2 figures together and display the answer. No problem i can write the formulae but i want it to apply to every row on the worksheet (and there could be thousands) and do not want to write it for every one. Ive tried to copy and paste but it doesnt seem to work, please please please can any one shed some light on this for me .... thanks |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
copy a function to a whole column
Several methods to copy a formula down a column.
If there is continuous data in Column A, write the formulas in B1 and C1 then select both B1 and C1. Hover the cursor over the lower right corner of C1 until you see a small black cross. Double-click on that cross and the formulas in B1 and C1 will be copied to end of data. You could select B1 and C1 and left-click on the black cross and drag down as far as you wish. You can select B1 and C1 and in the name box enter B1:C345 or somesuch address in C. Hit ENTER then CTRL + D Note: ToolsOptionsEditAllow drag and drop must be enabled. Gord Dibben MS Excel MVP On Wed, 14 Jun 2006 12:51:02 -0700, chelseafc19692006andon m wrote: I am entering a figure in column A, i want column B to automatically work out the vat element of the figure in column A. Then i want column c to add the 2 figures together and display the answer. No problem i can write the formulae but i want it to apply to every row on the worksheet (and there could be thousands) and do not want to write it for every one. Ive tried to copy and paste but it doesnt seem to work, please please please can any one shed some light on this for me .... thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Naming column in Index Function | Excel Worksheet Functions |