Posted to microsoft.public.excel.misc

external usenet poster

Posts: 47

absolute reference

when using an absolute refrence say a$1 , is it possible to have the a
change to b c d e ect when pasting the formula down the col rather than
accross the row,

im aware that by pasting accross the A would auto move but with the current
set up it dosnt move when pasting down the col

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
absolute reference	cholder	Excel Discussion (Misc queries)	2	June 9th 07 03:26 AM
Absolute Reference	Rebecca	Excel Discussion (Misc queries)	4	August 30th 06 01:36 PM
Absolute Reference	Alain	Excel Worksheet Functions	3	July 14th 05 04:53 PM
absolute reference	Dano	Excel Discussion (Misc queries)	2	May 13th 05 03:33 PM
absolute reference	Dano	Excel Discussion (Misc queries)	1	February 25th 05 09:28 PM

All times are GMT +1. The time now is 11:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us