Can you protect the font in a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to make sure that whatever is insterted into a certain cell on a
reservation form I have created, stays in bold and stays on the left side of
the cell. Is there a way to "protect" that font and the cell, but still
allow others to enter data with out some password? Thanks.
 
You can protect the worksheet, and allow users to edit those cells, but
not format them:

Select the cells in which users can enter data
Choose Format>Cells
On the Protection tab, remove the check mark from Locked, then click OK
Choose Toolst>Protection>Protect Sheet
Select the options you want, and remove the check mark from Format cells.
Click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top