If you format the cell the way you like (font and font size), then leave the
cells unlocked and protect the sheet, doesn't that do what you want.

Be aware that copy|paste may break your formatting. But typing shouldn't.

Robotbird wrote:

I'm using Excel 2007.

I have a worksheet with most cells locked down, but a few left open for
people to write in. In those cells I want users to be restricted to a default
font and font size.

Is it possible to leave cells unlocked, but still somehow protect the
formatting within them?

--

Dave Peterson