| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I lock columns together in a single row for sorting purpos.
I have a worksheet with 10 columns for various information per row per
customer. I need to sort the rows at times and need the columns to stay with the rows. Is there a way to lock them? Thanks for help. |
|
#2
|
|||
|
|||
|
Don't just select a single column before you sort.
Select the whole range (all 10 columns), then do data|sort. S.J.Michael wrote: I have a worksheet with 10 columns for various information per row per customer. I need to sort the rows at times and need the columns to stay with the rows. Is there a way to lock them? Thanks for help. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split a single column into 2 separate columns | Excel Worksheet Functions | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
| Convert one row and 50 columns of info to a single printable page | Excel Worksheet Functions | |||
| The $ thing to lock cells at rows or columns | Excel Discussion (Misc queries) | |||
| print 1 long row(20 columns) in excel to one single page | Excel Worksheet Functions | |||
Linear Mode
