View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mr. Low Mr. Low is offline
external usenet poster
 
Posts: 505
Default Excel 2007: Suggestion on for a full screen page reference menu

Dear Sir,

I encountered some problems in working with a single file that has large
number of pages on it.

Your current worksheet design only allows up to 15 to 16 page names to be
displayed on the page name bar.

If the user need to work with say 30 to 40 pages whereby he need to link up
the formulas at different pages, it would be a tedious task to him.
He need to search for the pages by moving the page bar right or left.. This
is cumbersome and difficult to locate the correct pages at the shortest
possible time

In order to overcome this problem, I have a suggestion in mind to share with
you.

If a special button could be added to the page bar whereby at a single
click, all the active pages would be displayed on the other menu at full
screen. This screen may allows the user to sort the pages in alpha numeric
order or by dragging the pages to their desired positions. It may also allows
the user to set the font color of the page name. The current color scheme
only allows black and white fonts on toggle basis . With a wide selection of
font colors, it would make the pages look better and clearer in tandem with
its background color.

However, the most important function of this menu is to allow the user to
search and locate the pages quickly by looking at all the active files on
the full screen..Base on my estimation, a full screen maybe able to display
up to 200 page names depending on the length of the name.

The user can easily go to the file by clicking at it on this menu. This
would make maneuvering from pages to pages more swiftly. This is particularly
helpful for files that have large number of formula linking between different
pages. Take for instance the annual budget for a large corporation with
complicated costing methods.

I hope my suggestion is relevant for your product improvement in the near
future.

Please ignore my suggestion if the current software already have this
feature or there are some other methods to overcome this problem. except
working on a large number of linked files.



Kind Regards

Low Seng Kuang
Malaysia




--
A36B58K641