Posted to microsoft.public.excel.misc

dan

external usenet poster

Posts: 866

Excel Fill issue

Excel 2007

When I fill down the following formula
=A2&","&C2&","&Q2

I get
=A2&","&C2&","&Q3
=A2&","&C2&","&Q4
=A2&","&C2&","&Q5
=A2&","&C2&","&Q6
=A2&","&C2&","&Q7

Instead of what I wanted
=A3&","&C3&","&Q3
=A4&","&C4&","&Q4
=A5&","&C5&","&Q5
=A6&","&C6&","&Q6
=A7&","&C7&","&Q7
--
Any help?
Thanks,
Dan

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
Issue with 'Fill Series' feature	Sudesh	Excel Discussion (Misc queries)	3	April 3rd 08 05:30 PM
Cell fill color conversion issue	GKnospam	Excel Discussion (Misc queries)	0	February 26th 07 06:06 AM
Import External Data -- Fill down formulas Issue	Jonathan	Excel Worksheet Functions	0	July 12th 06 04:17 PM
Auto Fill Series issue...	e3donald	Excel Discussion (Misc queries)	3	April 26th 06 08:08 PM
The fill feature in Excel that gives option to fill or copy	KAHelman	New Users to Excel	1	July 29th 05 07:47 PM

All times are GMT +1. The time now is 11:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us