| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transposing Cells which contains formula
If we want to transpose a range of cells in a row which contains "sum"
formula, the values in the row change after transpose. One olution is to use "paste link". However the "paste link" is disabled when the transpose checkbox is checked. Is there any way out to retain the cell values the same while transposing the range of cells? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
Threaded Mode
