How to get all format options in Excel when only 1 comes up?

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

Guest

Why does only one option come up sometimes in Excel 2003 when I select
multiple cells and choose Format, Cells, and how do I go about getting all
the options (e.g. Number, Allignment, Font, Border, Patterns, Protection) to
come up when this happens?
 
rwcita

When you get only one option is it to format "Font"? You have double
clicked in the cell and are in the "Edit" mode. Just single click to select
the cell and when you goto format you will have all the options.

Does this help?

Mike Rogers
 
Thank you do much for your quick response. Yes, Font was the only option, and
your solution was most helpful.
 

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

Similar Threads

Locking only borders and patterns 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Formating cells in PivotTable. 1
Question about conditional formatting of zeros in Excel 0
want format cells alignment not format cells font style 2
Original cell formatting clears when I move contents 2
David Biddulph is correct 8
How to prevent users from changing cell format 1

Back
Top