| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy to bottom of sheet quickly
Is there a way to copy a formula to the bottom of a worksheet without copying
down by selecting the black cross??? Thanks Mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy to bottom of sheet quickly
If the formula is in the first row (say in column A) then select column A
(click on A in column header), Edit/Fill-down If the formula is in (say) the 2nd row then Edit/Jump(Ctrl-G), enter in Reference field A2:A65536, click OK, then Edit/Fill-down Regards, Stefi €˛santaviga€¯ ezt Ć*rta: Is there a way to copy a formula to the bottom of a worksheet without copying down by selecting the black cross??? Thanks Mark |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy to bottom of sheet quickly
I cant see the edit/jump on the edit menu?
M "Stefi" wrote: If the formula is in the first row (say in column A) then select column A (click on A in column header), Edit/Fill-down If the formula is in (say) the 2nd row then Edit/Jump(Ctrl-G), enter in Reference field A2:A65536, click OK, then Edit/Fill-down Regards, Stefi €˛santaviga€¯ ezt Ć*rta: Is there a way to copy a formula to the bottom of a worksheet without copying down by selecting the black cross??? Thanks Mark |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy to bottom of sheet quickly
Hi, Done it, sorry for being a clown.
Regards. Mark "Stefi" wrote: If the formula is in the first row (say in column A) then select column A (click on A in column header), Edit/Fill-down If the formula is in (say) the 2nd row then Edit/Jump(Ctrl-G), enter in Reference field A2:A65536, click OK, then Edit/Fill-down Regards, Stefi €˛santaviga€¯ ezt Ć*rta: Is there a way to copy a formula to the bottom of a worksheet without copying down by selecting the black cross??? Thanks Mark |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy to bottom of sheet quickly
You are welcome! Thanks for the feedback!
Stefi €˛santaviga€¯ ezt Ć*rta: Hi, Done it, sorry for being a clown. Regards. Mark "Stefi" wrote: If the formula is in the first row (say in column A) then select column A (click on A in column header), Edit/Fill-down If the formula is in (say) the 2nd row then Edit/Jump(Ctrl-G), enter in Reference field A2:A65536, click OK, then Edit/Fill-down Regards, Stefi €˛santaviga€¯ ezt Ć*rta: Is there a way to copy a formula to the bottom of a worksheet without copying down by selecting the black cross??? Thanks Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy information from the bottom | Excel Discussion (Misc queries) | |||
| Macro to go quickly to a sheet | Excel Programming | |||
| How can I unmerge the merged cells in a Excel sheet quickly? | Excel Programming | |||
| Copy and Paste to Bottom Row? | Excel Programming | |||
| Macro - copy entire row and paste at bottom of another sheet | Excel Programming | |||
Linear Mode
