Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i sort a col of formulas in excel
i have a col of totals in the form of formulas. i want to sort this col but
somehow i need to freeze the results of the formulas first. |
#2
|
|||
|
|||
wijimbo Wrote: i have a col of totals in the form of formulas. i want to sort this col but somehow i need to freeze the results of the formulas first. Hi wijimbo If you don't need the formulae anymore highlight the column and Copy Paste Special Values on the same column then do the sort. If you do need the formulae, then do the Paste Special Values into a new column, do the sort and then delete the new column -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=398485 |
#3
|
|||
|
|||
Not sure I follow your intent: what is about the formulas that you need
to sort? |
#4
|
|||
|
|||
thats it. thank you
"Paul Sheppard" wrote: wijimbo Wrote: i have a col of totals in the form of formulas. i want to sort this col but somehow i need to freeze the results of the formulas first. Hi wijimbo If you don't need the formulae anymore highlight the column and Copy Paste Special Values on the same column then do the sort. If you do need the formulae, then do the Paste Special Values into a new column, do the sort and then delete the new column -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=398485 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
Provide a way to turn off auto-checking excel formulas as I type t | Excel Discussion (Misc queries) | |||
Excel Error when copying formulas | Excel Worksheet Functions | |||
How do I get to master Excel functions and formulas? | Excel Worksheet Functions |