Programming

posted by .

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.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. English

    You're locked in with us. What is meaning of locked in in this sentence. IS this mean "you are with us"?
  2. physics

    A 1,200-kg car runs into the rear of an 1,800-kg minivan that was moving at 6 m/s. The two vehicles are locked together after the collision and move with a speed of 12 m/s. How high above the ground would the locked- together vehicles …
  3. Physical science

    A car moving at 50km/hr skids 15m with locked brakes. How far will the car skid (with locked brakes if the car moves at 100km/hr assume that the mass of the car is 500kg
  4. physics

    This question is typical on some driver's license exams: A car moving at 50km/hr skids 15m with locked brakes.How far will the car skid with locked brakes at 120 km/h?
  5. physics

    disregard the previous I did not include the first part This question is typical on some driver's license exams: A car moving at 50 km skids 15 m with locked brakes.How far will the car skid with locked brakes at 120 km/h?
  6. physics

    This question is typical on some driver’s license exams: A car moving at 40 km/h skids 12 m with locked brakes. How far will the car skid with locked brakes at 80 km/h?
  7. Physics

    A car moving at 43 km/h skids 16 m with locked brakes. How far will the car skid with locked brakes at 129 km/h?
  8. Physict

    This question is similar to some on driver's-license exams: A car moving at 50 km/h skids 15 m with locked brakes. Show that with locked brakes at 150 km/h the car will skid 135 m.
  9. English

    1. I was angry that the door was locked. 2. I was angry the door was locked. 3. I was angry because the door was locked. =================== Can we omit 'that' as in #2?
  10. Physics

    A car moving at 60 km/h skids 13 m with locked brakes. How far will the car skid with locked brakes at 180 km/h?

More Similar Questions