Saturday
August 23, 2014

Homework Help: Programming

Posted by bill on Saturday, September 9, 2006 at 6:12pm.

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.

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

English - You're locked in with us. What is meaning of locked in in this ...
physics - A 1,200-kg car runs into the rear of an 1,800-kg minivan that was ...
Physict - This question is similar to some on driver's-license exams: A car ...
physics - This question is typical on some driverís license exams: A car moving ...
physics - This question is typical on some driver's license exams: A car moving ...
physics - disregard the previous I did not include the first part This question ...
Physics - A car moving at 43 km/h skids 16 m with locked brakes. How far will ...
Physical science - A car moving at 50km/hr skids 15m with locked brakes. How far...
Physics - A car travels at 64 mi/h when the brakes are suddenly applied. ...
PHSC - Hello, i need help. This is Work-Energy Theorum A car moving at 50km/hr ...

Search
Members