AuditBible
January 19, 2018, 03:16:27 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
Sirius Satellite Radio Inc.
 
   Home   News Alerts Help Search Calendar Members Contributions Staff List Login Register  

Microsoft Store
Del.icio.us Digg FURL FaceBook Stumble Upon Reddit SlashDot Google Bookmarks

Pages: 1   Go Down
  Add bookmark  |  Print  
Author Topic: How to view all formulas in a sheet  (Read 2067 times)
 
0 Members and 1 Guest are viewing this topic.
beancounter
Administrator
*****
Offline Offline

Gender: Male
Experience: 1985
Posts: 168



Activity
100%


View Profile WWW
« on: September 05, 2008, 07:34:13 PM »

Here's a quick tip that allows you to check all of the formulas in your worksheets.

In your active sheet, hold down the Control Key and hit the Tilde Key (~).  On U.S. keyboards, it is found between the Escape Key and the Tab Key, in the upper left corner of your keyboard.

Hit this keyboard shortcut, and presto - all of your formulas will be displayed on the screen at once.  You can even print your worksheet with the formulas displayed.  When you are done examining your formulas, hit Ctrl+~ again to toggle back to the normal view.

This is especially handy when an insured provides you with a large summary and you want to see if it contains any formulas.
Logged

bc
Pages: 1   Go Up
  Add bookmark  |  Print  
 
Jump to:  

Related Topics
Subject Started by Replies Views Last post
Why can't I view the links? Why Can't I View Links? beancounter 0 3780 Last post March 19, 2008, 03:26:40 PM
by beancounter
Sheet Metal Products Manufacturing-Stamping. Manufacturing The valetudinarian 1 4511 Last post January 19, 2010, 10:16:26 AM
by beancounter
DLSE-2005-I Information Sheet Employment Status AuditorBob 0 2444 Last post July 20, 2009, 09:39:15 AM
by AuditorBob
Microsoft Store
Unique Hits: 1849234
Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines
AuditBible © 2008 | Sitemap
Valid XHTML 1.0! Valid CSS!