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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002: How to fill group of of odd number in sequence ? 9
Excel 2002: Any button to insert blank rows at specific interval? 5
Excel 2002 : How to move to the next cell with content ? 2
Excel 2002 : How to insert a bank row between different codes ? 4
Excel 2002 : Is there any active row bar to aid data entry ? 3
Excel 2002: How to sort row totals in Pivot Table ? 5
Excel 2002: How to sum up base on date parameters ? 4
Excel 2002: Any quick way for transposing formulas? 4

Back
Top