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.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,722
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!
 

Forum statistics

Threads
1,171,650
Messages
5,876,664
Members
433,205
Latest member
jabin1991

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top