Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data depiction/transpose and retain formulas
Hi, I have data in a particular form. One of the rows in this is using formula. I need to depict this data in a different form and still retain the formulas. Is there a way to do it? I have attached the word document with excel embedded. Any help appreciated. Regards Aravind G +-------------------------------------------------------------------+ |Filename: transposeHelp.doc | |Download: http://www.excelforum.com/attachment.php?postid=4695 | +-------------------------------------------------------------------+ -- aravindvin ------------------------------------------------------------------------ aravindvin's Profile: http://www.excelforum.com/member.php...o&userid=13586 View this thread: http://www.excelforum.com/showthread...hreadid=536133 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data depiction/transpose and retain formulas
One approach is to convert the formulae to text - highlight the cells
contianing the formulae then Edit | Replace (or CTRL-H) then in the Find What panel enter = and in the Replace With panel enter zz=, then click Replace All. You can then transpose these cells by clicking <copy, move the cursor to where you want them to start, then Edit | Paste Special | Transpose (check) and OK. Then with the cells still highlighted you can do CTRL-H in reverse, i.e. Find zz= and Replace With = then click Replace All. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I retain old data after importing? | Excel Discussion (Misc queries) | |||
Update and Retain Prior Data | Excel Worksheet Functions | |||
Excel retain data and date | Excel Discussion (Misc queries) | |||
Retain PivotTable formatting after "Refresh Data" | Excel Discussion (Misc queries) | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel |