ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format: cells problem (https://www.excelbanter.com/excel-discussion-misc-queries/171416-format-cells-problem.html)

JLB

Format: cells problem
 
I have XP with office 2003, but had the same problem with Windows
2000/office 2000.
When I click Format: cells, I rarely get the entire menu (Number,
Alignment, etc). Most often I only get one menu option, which is always Font.
If I re-try enough times I can usually eventually get all the menu options.
When I go to the next cell, the same thing will happen & I waste much time
trying to do a simple task.
How do I fix this so I get all the Format: cells menu options each time?
--
JLB

Dave Peterson

Format: cells problem
 
It sounds like you're still editing the cell.

Hit enter (to finish the change), then click Format|Cells.

(Excel allows you to change the font of different strings within a cell. You
can bold or change colors or change size or... to make it stand out in the
cell.)



JLB wrote:

I have XP with office 2003, but had the same problem with Windows
2000/office 2000.
When I click Format: cells, I rarely get the entire menu (Number,
Alignment, etc). Most often I only get one menu option, which is always Font.
If I re-try enough times I can usually eventually get all the menu options.
When I go to the next cell, the same thing will happen & I waste much time
trying to do a simple task.
How do I fix this so I get all the Format: cells menu options each time?
--
JLB


--

Dave Peterson

Mike Rogers[_2_]

Format: cells problem
 
JLB

I agree with Dave that you are in the edit mode. You should be only
selecting the cell with a single click. If you double click it allows for
only the font menu to be available under formatcells. You get the full menu
with a single click.

Mike Rogers

"JLB" wrote:

I have XP with office 2003, but had the same problem with Windows
2000/office 2000.
When I click Format: cells, I rarely get the entire menu (Number,
Alignment, etc). Most often I only get one menu option, which is always Font.
If I re-try enough times I can usually eventually get all the menu options.
When I go to the next cell, the same thing will happen & I waste much time
trying to do a simple task.
How do I fix this so I get all the Format: cells menu options each time?
--
JLB



All times are GMT +1. The time now is 08:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com