Protecting and Sorting Cells
Posted by Brian Halcrow on May 29, 2001 2:11 AM
I have a spreadsheet that in the first seven or eight cells of a row I have input cells and in the remaining cells are formulaes. There can be up to 700 rows of data in each sheet.
I can protect the formulaes so that they cannot be deleted or altered but I cannot then sort the rows in to a specific order.
Does anyone know how I would be able to sort as and when required but still have certain cells protected?