sorting columns when cell results based on other cells

D

Dawn

is it possible to sort colums when the results of the cells in the column are
dependent on a formula that includes another cell?

Can I somehow "lock" the rows together?
 
F

Fred Smith

Highlight the group of cells you want to sort before you execute the sort.
Then the rows will stay together.

Regards,
Fred.
 

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

Hide columns based on row values 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
HELP: Selecting Non-Visible (Hidden) Cells when AutoFilter is Appl 2
How do I get "auto sum" to subtract hidden cell values from total 3
How do I link 4 columns to each other 5
lock cell based on a condition 22
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Select a range not equal to: 4

Top