|
|
|
View formulas and functions quickly in any version
To view all formulas and functions quickly when using any version of Excel, hold down the Ctrl key followed by the accent key. This is normally the first key on the left of the top row of the keyboard. This will immediately display all formulas.
A new toolbar will also appear called Formula Auditing. The first button on
the left checks for errors and the next two along draw arrows to show where
formulas take their information from. Use the same shortcut to return to normal
view.
Sue Hocking
Article tags
Related articles
It’s easy to hit the wrong key when using a PC and throw yourself into a panic. There's no need to worry - we have easy fixes for 30 common everyday errors
A limit to the number or columns and rows in a spreadsheet causes problems
Discover how keyboard shortcuts could speed things up – and print out our free guide to help you master some of the most common PC keyboard shortcuts
Q.Why can't my browser find the website address I typed...
Q.All updates have been downloaded, so why won't Windows...
Q.How do I stop Windows 7 search?
Be a money saving expert
Return of the Mac computer
The benefits of owning a smartphone
Choose Gold, Silver or Bronze membership
Save up to 40% on the cover price of each issue
Get access to the subscriber club exclusive website
Our price won't be beaten by any shop or website
|
|
|
|
|
Nikon Coolpix S570 BlackPrice: £66.99 |
Computeractive Ultimate Guide - Storage, Sharing & BackupPrice: £5.99 |
Back Issue CD-Rom 13 (2010)Price: £9.99 |
Hallmark Card Studio DeluxePrice: £15.31 |
Marine AquariumPrice: £15.41 |
