| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
prevent sorting from moving rows/colums out of order
A shared excel sheet gets a daily addition by each of the shared users.
After the information is added, the sheet is sorted. Can the excel sheet be locked so that if someone sorts the sheet and accidentally does not include a column, it will not sort the sheet until all columns are included in the sort. Example: Columns A-E and Rows 1-10 are used, but when sorted, user did not include all Columns and only sorted with B-E, now Column A does not line up with correct rows after sort. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| moving data from numerous colums into one colum | Excel Discussion (Misc queries) | |||
| sorting rows without changing order of my values! | Excel Discussion (Misc queries) | |||
| EXCEL SORT - How do I prevent 'frozen' rows from sorting? | Excel Discussion (Misc queries) | |||
| moving alternating rows to a column with the order staying the sam | Excel Discussion (Misc queries) | |||
| moving alternating rows to a column with the order staying the sam | Excel Discussion (Misc queries) | |||
Threaded Mode
