Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to get all format options in Excel when only 1 comes up?

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 194
Default How to get all format options in Excel when only 1 comes up?

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

"rwcita" wrote:

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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to get all format options in Excel when only 1 comes up?

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

"Mike Rogers" wrote:

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

"rwcita" wrote:

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I retain the format of varying numbers in Excel? xardoz Excel Discussion (Misc queries) 6 June 20th 06 05:16 PM
Excel charts should have format templates Boy from Oz Charts and Charting in Excel 1 March 24th 06 03:40 AM
Imported Date & Time format with calcs. managed in excel from imrp Todd F. Excel Worksheet Functions 0 July 8th 05 09:03 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . P.S.Sodha Excel Discussion (Misc queries) 0 April 2nd 05 01:53 PM


All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"