Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy formula down 1000,s of lines
I need to copy items dow as many as 100,000 rowes is there an easy way
like a/c |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy formula down 1000,s of lines
Assume you want to copy a formula that is in H2 down to H10000
in the name box (above the header in column A), type H2:H10000 and press enter, then press Ctrl + D If you have a formula in H2 and all the cells in G2:G10000 are filled then you can also move the cursor to the lower right corner in H2 and when it changes from thick to thin double click -- Regards, Peo Sjoblom "gfj" wrote in message ... I need to copy items dow as many as 100,000 rowes is there an easy way like a/c |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy formula down 1000,s of lines
If you don't know the last row number then you can
1. Select H2 2. Press SHIFT-CTRL and press DOWN ARROW. If you do not have blank rows in between then it will select Col H from H2 to the last row If there are a few blanks then you can press DOWN ARROW till you reach the last row... 3. Press CTRL-D OR 1. you can select the whole column H 2. Press SHIFT-CTRL and press UP ARROW 3. Press CTRL-D "Peo Sjoblom" wrote: Assume you want to copy a formula that is in H2 down to H10000 in the name box (above the header in column A), type H2:H10000 and press enter, then press Ctrl + D If you have a formula in H2 and all the cells in G2:G10000 are filled then you can also move the cursor to the lower right corner in H2 and when it changes from thick to thin double click -- Regards, Peo Sjoblom "gfj" wrote in message ... I need to copy items dow as many as 100,000 rowes is there an easy way like a/c |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-copy of formula on inserted lines | Excel Discussion (Misc queries) | |||
1000+$K$5/1000 -what does $ indicate in formula | Excel Worksheet Functions | |||
how do i plot data consisting of 1000 lines in excel sheet | Charts and Charting in Excel | |||
how do i comment 1000 lines of code at once in vba for excel? | Excel Worksheet Functions | |||
Why does excel not see more than 1000 lines in filter mode? | Excel Discussion (Misc queries) |