Office & Productivity Software forum

General discussion

excel copy paste special - formulas

by Rob Kormoski / May 3, 2006 2:16 AM PDT

I am using excel 2002 SP3.

basically I have a sheet that has my data going down in column C by month c1 = jan values, c2 = feb values, etc.

In another worksheet, I need to reference those cells, but going across. in other words my 2nd worksheet will have in cell a1 = sheet1!c1, b1= sheet1!c2, etc...

because I have about 1000 rows of data, is there any easy way to do this using copy paste special formulas (with transpose) ?

t i a


Discussion is locked
You are posting a reply to: excel copy paste special - formulas
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: excel copy paste special - formulas
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
by Kees Bakker / May 3, 2006 4:29 AM PDT

The TRANSPOSE function. But note that 1000 rows will become 1000 columns.


Collapse -
1000 Columns
by entrecon / May 4, 2006 12:23 AM PDT
In reply to: Try:

Kind of hard to get 1000 columns in a sheet when Excel only has 256!

Collapse -
by MarkFlax Forum moderator / May 4, 2006 8:08 PM PDT
In reply to: 1000 Columns

250 columns on each of 4 separate sheets?


Popular Forums
Computer Newbies 10,686 discussions
Computer Help 54,365 discussions
Laptops 21,181 discussions
Networking & Wireless 16,313 discussions
Phones 17,137 discussions
Security 31,287 discussions
TVs & Home Theaters 22,101 discussions
Windows 7 8,164 discussions
Windows 10 2,657 discussions


Help, my PC with Windows 10 won't shut down properly

Since upgrading to Windows 10 my computer won't shut down properly. I use the menu button shutdown and the screen goes blank, but the system does not fully shut down. The only way to get it to shut down is to hold the physical power button down till it shuts down. Any suggestions?