|
|
|
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
Are you frustrated when your PC beeps, gives an error message and doesn't do what you want it to? We explain what these problems are and how to fix them
Have you discovered lots of new and interesting websites but can never find them again? We show you ways to organise and save them on your PC and online
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
Q.Why are some of the keys on my keyboard doing strange...
Q.Is my phone’s Bluetooth any use?
Q.Can I switch boot drives so that I can work on older...
Make a profit from your unused gadgets
Run Windows and Ubuntu on the same computer
Hide private folders
Save up to 40% on the price
Exclusive subscriber website
Our price won't be beaten
St Helena, a 'small British village' in the mid-Atlantic, is seeking support and funding for a broadband connection
|
|
|
|
|
Computeractive Excel (2010) Online tutorialPrice: £19.99 |
Computeractive Word (2010) Online TutorialPrice: £19.99 |
Computeractive Powerpoint (2010) Online TutorialPrice: £19.99 |
Angry BirdsPrice: £9.99 |
Back Issue CD-Rom 14 (2011)Price: £15.99 |
