Home |
Search |
Today's Posts |
#1
|
|||
|
|||
AutoFIll -by dragging the bottom-right corner of the cell
Hi,
Take an Example: the follwoing cells in an excel sheet contain the below values. Cell E5 =1, cell F5=2 Cell E6 =3, cell F6=4 Cell E7 =5, cell F7=6 Cell E8 =7, cell F8=8 Now, select the row named: A10. write the formula as "=E5" Result is 1 select the row named: A11. write the formula as "=F5" Result is 2. now select A10 & A11. Hold the mouse pointer at the bottom-right corner of hte cell A11 and drag it to two or more cells. I want the result to be A12=E6 A13=F6 A14=E7 A15=F7 A16=E8 A17=F8 and so on... Thanks in advance for your solutions Venkatesh V |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofill macro | Excel Discussion (Misc queries) | |||
Greybar at the bottom of the page | Excel Discussion (Misc queries) | |||
how to paste data from top to bottom to bottom to top | Excel Discussion (Misc queries) | |||
cell height changing when using autofill | Excel Discussion (Misc queries) | |||
how to print a row on the bottom of every page | Excel Discussion (Misc queries) |