You could create another worksheet and map each cell to the
corresponding one at your data worksheet and use this function:
=cell("format", cell_address)
On 6/16/07, Malcolm Greene <[EMAIL PROTECTED]> wrote:
> Excel gurus: Is there a way to have Excel display all the formatting
> codes used in each cell in the same way that Excel displays cell
> formulas (vs. cell data)?
>
> In other words, Ctrl+~ toggles between Excel data and Excel formulas.
>
> I'm looking for a similar way to toggle between Excel formatting codes
> and data so I can get a big picture view of how a spreadsheet is
> formatted (vs. having to manually visit each cell and use Ctrl+1 to view
> its format)
>
> Any suggestions (other than saving to XML format and parsing out
> styleids/codes and mapping back to cell coordinates?)
>
> Thanks!
> Malcolm
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
