Transposing Cells... (Drag & Drop Taking Forever!)

Smythe22

New Member
Joined
Nov 14, 2005
Messages
5
Hi,

I'm after some direction on how I can take a group of formulas running right to left, and paste them running top to bottom, basically rotating the table 90 degrees ->.

If I paste special, with transpose checked, my formulas pick up different data.

All help greatly appreciated.
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
Without seeing the formulae, being able to spot what's going wrong is going to be a bit difficult. Please post examples of formulae, and post a snap-shot of the table "before" and "after" transposing.
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
You need to make the cell references absolute, but adding $ in front of the Column reference and in front of the row reference.

E.g. If you have A1 in the formula you have to change it to $A$1. The easiest way is to place you curser at each occurrence of a cell reference and hit F4. This will automatically convert to an absolute reference. Then do the transpose.
 

Smythe22

New Member
Joined
Nov 14, 2005
Messages
5
Thanks for the advise, I've used a transpose formula and Ctrl+Shift+Enter command which is doing the trick!

If I were to create absolute references I could be here all day, lots of data.

Thanks guys, great website... no doubt I'll be back soon!
 

Smythe22

New Member
Joined
Nov 14, 2005
Messages
5
Forgot to say thanks for your help! - Transpose with an Array was the solution I went for. Thanks all for your assistance!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,798
Messages
5,574,372
Members
412,589
Latest member
ArtBOM
Top