W
wijimbo
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.
somehow i need to freeze the results of the formulas first.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul Sheppard
wijimbo said:i have a col of totals in the form of formulas. i want to sort this co
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 d
need the formulae, then do the Paste Special Values into a new column
do the sort and then delete the new colum
D
Dave O
Not sure I follow your intent: what is about the formulas that you need
to sort?
to sort?
W
wijimbo
thats it. thank you
Paul Sheppard said: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