Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
We are ignorant.. and I apologize for such a trivial question.
I've been with this company for about 4 years, and we use excell for many reasons and one is a log of customers job orders. name, date, part#, order#, engr, dept, qty, description (in each row). We continually add and update this spreadsheet. The problem is sorting the data, maybe to see if a same item was used for several customers. THE PROBLEM IS: The columns get mixed up and don't go back to normal, say if I were to click on the A column and put things back to normal (alphabetical order, by customer). Is there a way to freeze or lock all the data in each row across? Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lock Row after Data Entry | Excel Discussion (Misc queries) | |||
Lock the cell once enter the data | Excel Worksheet Functions | |||
Lock Data in Cell after entered | Excel Discussion (Misc queries) | |||
Lock Cell After Data Entry | Excel Discussion (Misc queries) | |||
How do I lock columns together in a single row for sorting purpos. | Excel Discussion (Misc queries) |