Excel 2002 : Can I speed fill from left to right ?

  • Thread starter Thread starter Mr. Low
  • Start date Start date
M

Mr. Low

Dear Sir,

I could speed fill B1 downwards (B1:B50) in a table by clicking the bottom
right corer of that cell as illustrated below:

A B
1 XXX XXX
2 XXX
3 XXX
4 XXX
50 XXX


May I know if it is possible for me to speed fill the content of cell A3
from left to right ? (A3: DJ3)

A B C D E DJ
1 XXX XXX XXX XXX XXX XXX
2 XXX XXX XXX XXX XXX XXX
3 XXX
4
5



Thanks

Low
 
Hi,

Nothing like as quick as the double click to fill down but you can do this

Enter your formula in A3 and tap F5
enter your range (say) A3:Z3
click OK
Tap F2
Ctrl + Enter will fill the formula

Mike
 
Back
Top