Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |