ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can you view cell formats without opening the formatting window (https://www.excelbanter.com/excel-discussion-misc-queries/166423-can-you-view-cell-formats-without-opening-formatting-window.html)

Mike

Can you view cell formats without opening the formatting window
 
Is there a 'Cell Format Bar' that allows you to view the cell formats.
Something similar to the formula bar but for cell formats

Texas Aggie

Can you view cell formats without opening the formatting window
 
Yes Mike,

View Toolbars Formating

if you do not like those choses, you can create your own toolbar.

http://www.cpearson.com/excel/menus.htm

--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009


"Mike" wrote:

Is there a 'Cell Format Bar' that allows you to view the cell formats.
Something similar to the formula bar but for cell formats


Gord Dibben

Can you view cell formats without opening the formatting window
 
No.

You may come up with something using VBA but beyond my skills.


Gord Dibben MS Excel MVP

On Fri, 16 Nov 2007 14:12:01 -0800, Mike wrote:

Is there a 'Cell Format Bar' that allows you to view the cell formats.
Something similar to the formula bar but for cell formats




All times are GMT +1. The time now is 06:05 AM.

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