Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Excel cell alignment

Currently (Excel 2003) the cell alignment vertical and horizontal is handled
by drop-down lists.

So setting the alignment for a cell needs:

1. Selecting vertical alignnment. Minimum 2 clicks or more in case you need
to scroll
2. Selecting horizontal alignment. Minimum 2 clicks or more in case you need
to scroll

Basically it may involve 6 clicks just to select formatting and minimum 3
more clicks to call the toolbar and OK etc.

Solution:
SHould have a more graphics based solution for example a 3 by 3 grid that
lets you select vertical/horizontal formatting in a single click, e.g.,
top-right, centre-centre or bottom -right etc. The lesser used formatting
options justify etc. could be stored in a drop-down.

In case you still want to use drop-down, the length of the drop-down must be
increased to all the options that are there. This is true of a lot of places
in the current office GUI.

Regartds,
Sarbjit

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions
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
missing cell borders in Excel Nak Excel Discussion (Misc queries) 8 April 22nd 23 06:11 AM
resetting last cell jagdish.eashwar Excel Discussion (Misc queries) 11 March 31st 06 02:06 AM
Automatically Changing Cell Reference's when Pasting in Excel No I'm Spartacus Excel Discussion (Misc queries) 0 February 13th 06 01:01 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM


All times are GMT +1. The time now is 11:45 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"