How can I lock columns on Excel and keep them locked when I put them into a Palm handheld?
I'm not entirely sure what you mean by 'locked'. If you mean protecting them these are the procedures.
In protecting cells, we actually do the procedure 'backwards'. We don't specify which cells to lock, we unlock cells then protect the sheet or workbook.
First determine which columns/cells you want to allow changes to. Then select them, select Format>>Cells. A dialogue box should appear. Select Protection and clear the locked box.
Now select Tools>>Protect Sheet or Protect Workbook. A password is optional. If you don't password protect the sheet others will still be able to change the settings.
Changes will only be allowed in the unlocked cells. If changes are attempted in the other cells a dialogue box will apeear saying the sheet is protected.
If you mean freezing panes, then put the pointer in the first column where you want to scroll from and select Windows>>Freeze Panes. This will keep data to the left fixed.
If you meant something else then you'll have to let us know.
To lock columns in Excel and keep them locked when transferring to a Palm handheld, you can follow these steps:
1. Open your Excel file and select the column(s) you want to lock. You can do this by clicking on the letter at the top of the column.
2. Right-click on the selected column(s) and choose "Format Cells" from the context menu.
3. In the Format Cells dialog box, go to the "Protection" tab.
4. Uncheck the "Locked" option, which will unlock the selected column(s). This is because in Excel, cells are initially locked by default.
5. Click "OK" to apply the changes.
6. Now, you need to protect the sheet or workbook to ensure that the selected column(s) remain locked. To do this, go to the "Review" tab in the Excel Ribbon.
7. Click on "Protect Sheet" or "Protect Workbook" (depending on your needs) to open the protection settings.
8. In the protection settings, you can add a password if you want to restrict access to making changes. If you don't set a password, others will still be able to change the settings.
9. Enable the "Protect worksheet and contents of locked cells" option. This will ensure that only the unlocked cells can be modified, while the locked columns remain unaffected.
10. Click "OK" to apply the protection settings.
Now, when you transfer the Excel file to your Palm handheld, the locked columns should remain locked, and changes will only be allowed in the unlocked cells. If someone tries to modify the locked columns on the Palm handheld, they will receive a message indicating that the sheet is protected.
Please note that the exact steps may vary depending on the version of Excel you are using on your computer and the capabilities of your Palm handheld device.