| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I lock or freeze cells
I have alpha data A1-A99, on B1-B99 numbers. I would like to sort the imput
numbers in "B" BUT, keep A1-99 & B1-99 tied together i.e. A1 & B1 next A2 & B2 ect, ect. If I add a third column "C" I would eventually want to insure I could lock the data as well within i.e. A1, B1, & C1. How can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I lock or freeze cells
Just make sure all columns are selected prior to sorting on column B
Gord Dibben MS Excel MVP On Thu, 16 Apr 2009 13:42:07 -0700, grunt_02_gunny wrote: I have alpha data A1-A99, on B1-B99 numbers. I would like to sort the imput numbers in "B" BUT, keep A1-99 & B1-99 tied together i.e. A1 & B1 next A2 & B2 ect, ect. If I add a third column "C" I would eventually want to insure I could lock the data as well within i.e. A1, B1, & C1. How can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to lock row 1 in Excel. Why is "Freeze Panes" grayed out? | Excel Discussion (Misc queries) | |||
| Is it possible to lock-in or freeze formatting? | Excel Worksheet Functions | |||
| How to freeze cells to always remain the same value | Excel Worksheet Functions | |||
| Enhancement Request: Give us ability to lock/freeze tabs in Excel | Excel Worksheet Functions | |||
| How do I freeze or lock cells to show up on each page without typ. | Excel Discussion (Misc queries) | |||
Hybrid Mode
