Need Excel Help!!
| Posted By | Message |
|---|---|
|
Need Excel Help!! Hiiii |
|
Posted 10/3/14 11:26 AM
|
|
|
Long Island Weddings
Long Island's Largest Bridal Resource
| |
|
Re: Need Excel Help!! You would have to right click on the entire column and hit 'format cells' and then go to the protection tab and make sure 'locked' is checked. Then go to the other columns and do the same thing and uncheck the 'locked'. You would then need to go ahead and Protect the sheet by going to the Review tab and clicking 'Protect Sheet'. You can input a password on the box that comes up. Every time someone tries to edit that column a warning will display that they need to first unprotect the sheet. The columns which are unlocked will not display that warning HTH! |
|
Posted 10/3/14 11:41 AM
|
|
|
Re: Need Excel Help!! - Highlight the column that CAN be edited |
|
Posted 10/3/14 11:42 AM
|
|
|
Re: Need Excel Help!! Yes - that I did - but I was hoping for a password prompt right there when a cell in that column is clicked... instead of having users go thru the steps to unprotect the sheet |
|
Posted 10/3/14 11:45 AM
|
|
|
Re: Need Excel Help!! NM I got it!! |
|
Posted 10/3/14 12:11 PM
|
|
Potentially Related Topics:
| Topic | Posted By | Started | Replies | Forum |
|---|---|---|---|---|
| Microsoft Excel. .. question about the program | KittyCat | 7/25/13 | 8 | Families Helping Families ™ |
| Anyone know how to transfer addresses from Microsoft excel.... | jlk51496 | 1/29/12 | 2 | Families Helping Families ™ |
| Can a Word doc be merged into an Excel doc? NFT | Smileyd17 | 7/9/09 | 1 | Families Helping Families ™ |
| Excel Wizards... nevermind! | Lucky09 | 5/10/08 | 0 | Families Helping Families ™ |
| can you format a table in Word, the same way you can in Excel? | randella | 6/13/07 | 3 | Families Helping Families ™ |
| my excel freaking crashed- I lost 2 hours worth of work! | Beth | 1/24/07 | 8 | Families Helping Families ™ |





