PC Review


Reply
Thread Tools Rate Thread

copy formulas from horizontal cells into vertical cells.

 
 
Little Penny
Guest
Posts: n/a
 
      26th Oct 2006
How do I copy horizontal cell into vertical cells?

I tried copying my cells horizontally selecting cell where I want them
to go. I use paste special and transpose. Its paste the info but
changed my formulas I want to keep formulas as is.



Thanks

 
Reply With Quote
 
 
 
 
=?Utf-8?B?SkxHV2hpeg==?=
Guest
Posts: n/a
 
      26th Oct 2006
If your formulas referenced other cells and did not have absolute references,
then Excel will attempt to change them to the relative references based on
their new cell location. That is the way it is designed.

"Little Penny" wrote:

> How do I copy horizontal cell into vertical cells?
>
> I tried copying my cells horizontally selecting cell where I want them
> to go. I use paste special and transpose. Its paste the info but
> changed my formulas I want to keep formulas as is.
>
>
>
> Thanks
>
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
taking numbers in vertical cells putting them in horizontal cells jhawk22 Microsoft Excel Worksheet Functions 3 28th Apr 2010 08:37 PM
need to paste link from 4 vertical cells to 4 horizontal cells? =?Utf-8?B?Y2lvYW5nZWw=?= Microsoft Excel Misc 6 8th Jun 2009 06:44 PM
PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS =?Utf-8?B?THVpcyBQLg==?= Microsoft Excel Misc 2 9th Aug 2007 04:20 PM
Linking a horizontal set of cells to a vertical sets of cells =?Utf-8?B?UnVzc2VsbC1zdGFuZWx5?= Microsoft Excel Charting 2 21st Oct 2005 03:19 PM
link from horizontal cells to vertical cells cuongvt Microsoft Excel Worksheet Functions 0 15th Oct 2004 06:42 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:19 AM.