Posted to microsoft.public.excel.misc

Jimmy

Posts: n/a

autofill

Thank you very much!!!

"bpeltzer" wrote:

Try entering =OFFSET($AM$20,1-ROW(),0) in cell A1. When you drag that down,
the ROW() function result increases so that the row of the source cell
decreases.

"Jimmy" wrote:

how do I autofill in the reverse direction?

for example,
cell A1=AM20

I want to drag cell A1 down so that A2=AM19. Currently if I drag down,
A2=AM21.

Thanks,
Jimmy

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
Multi-sheet autofill	RichH	Excel Discussion (Misc queries)	2	December 20th 05 03:39 PM
autofill	Anders	Excel Discussion (Misc queries)	0	December 8th 05 04:03 PM
More- AutoFill with Non-Seqeuntial Cell References ?	[email protected]	Excel Worksheet Functions	4	June 23rd 05 02:42 AM
Autofill: Need to autofill one week block, (5) weekday only into cells.	dstock	Excel Discussion (Misc queries)	1	June 17th 05 08:21 PM
Relative reference autofill increment other than +1	SteveB	Excel Discussion (Misc queries)	3	June 14th 05 07:40 PM

All times are GMT +1. The time now is 01:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us