Omitting columns in Excel 2010 sort?
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.
This question is in the General Section. Responses must be helpful and on-topic.