LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Viewing Formulas

I am trying to troubleshoot a multi-page spreadsheet that someone else messed up, and I'd like to view the formulas -- in their entirety -- to do that. Using cntr + ` (grave accent) shows formulas in cells, but if the formulas in the cells happen to be smaller than the cell width, they can't be completely seen.

Lotus and Quattro had an option of printing out the formulas separately, as in:

A1: This is a test
A2: +b4/e6
A3: @if($c$12<"HELLO",4,"HI")
etc.

Is there anyway to get that with Excel? I'm using 2003.

Thanks in advance for your replies.
 
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
Viewing formulas Lynne Mawson New Users to Excel 4 October 31st 06 11:51 AM
Shortcut for viewing formulas gloria81101 Excel Discussion (Misc queries) 1 June 20th 06 06:24 PM
Viewing in web Corrine Charts and Charting in Excel 0 January 26th 06 06:30 PM
viewing formulas Tom Andrew Excel Discussion (Misc queries) 1 May 26th 05 06:40 PM
Viewing Pictures Nicola Excel Discussion (Misc queries) 1 December 8th 04 03:24 PM


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