Posted to microsoft.public.excel.worksheet.functions

Alex[_3_]

external usenet poster

Posts: 1

Auto Fill help. Thanks in advance

I would like to auto fill the following formula ex: A1*B1, A2*B1, A3*B1. The
auto Fill automatically changes the B column with the same number as the A.
Is there a way to keep the second number static?

Thanks.

Alex

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
auto fill	Tanya	Excel Discussion (Misc queries)	2	February 22nd 09 11:09 AM
auto fill or auto search from a list or drop-down list???????	Joe H.[_2_]	Excel Discussion (Misc queries)	9	August 29th 08 12:56 AM
Auto-populate, Auto-copy or Auto-fill?	Jay S.	Excel Worksheet Functions	4	August 10th 07 09:04 PM
Auto advance after scanning	Carll1058	Excel Worksheet Functions	0	September 26th 06 10:32 PM
using auto fill edit or fill handel	fill handle or auto fill	Excel Worksheet Functions	0	February 10th 06 07:01 PM

All times are GMT +1. The time now is 02:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us