Send to a Friend

winblowzxp's avatar

Omitting columns in Excel 2010 sort?

Asked by winblowzxp (498points) February 10th, 2013

I made a spreadsheet for a convenience store for their beer prices. I have columns which are only calculated values based on formulas and I have them protected so that they can’t be disturbed.

I want them to be able to sort by the name and all user modifiable data to change with it, and leave the calculated columns out of the sort. I thought there was a way to do this, but I haven’t messed with anything like that since before the Ribbon.

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.