How to lock calculated data before a sort?

S

Sam Bede

Hi

I'm wanting to sort a spreadsheet of cheque (check) records where the cheque
number is calculated from the first cell in the column.

I'm planning to sort it by a different sequence but don't want to screw up
the cheque numbers.

Is there some way of locking the calculated cells or converting the
calculations to data so that it can be sorted?

Any helpful suggestions would be greatly appreciated.

Thanks
Sam
 
R

Rob

Sam,

You could convert the formula to a value by copying the appropriate cells
and then choose from the Edit Menu, Paste Special and select Values. Then
the cheque numbers for that selection will not change any more.

Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to show the next number depending on other data 13
Sort function? 2
how to change a calculated cell to = the calculated value 4
can a linked spreadsheets sort automatically when data is added 2
Using PRODUCT in Calculated Field 3
data, sort option is grayed. how to sort on a column? 1
Data Validation in Calculated Cells 14
Using a variable for range of cells 3

Top