• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel Questions.

I

IceT

Senior member
I have got three Excel questions:

1. How do I lock a column of cells so that the user can't change it unless the user unlocks the protection by entering the password?

2. How do I alphabetically organize the data inside a column of cells? i.e. Apple, Ballon, Cake (all in alphabetical order).

3. How do I ask Excel to notify me if a data in a specific cell is let say <10?


Thanks in advance.
 
1. right click on cell/row/column -> format cell and go to protection.


2. go to data on the top and click on sort.


3. dont know, you can set up some formula or something




dam()
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top