Simple clear advice in plain English

Why are my spreadsheets full of formulae instead of useful data?

A shortcut can fix this problem and revert to a less frightening spreadsheet

Hide formulae in a spreadsheet
A screenful of formulae is not much use unless you are Einstein

Q  At some point in the past couple of weeks, something has happened to my Excel setup and it is affecting all my spreadsheets. Now, rather than displaying the values of cells, my matrices are a sea of formulae. I have no idea what’s happened but it has made my spreadsheets useless. Any ideas?
Nelson Porter

A  Yes, we have an idea because it’s a problem that plagues the Computeractive planning spreadsheet, which is shared by all staff: all it takes is one wayward keypress and our spreadsheet is saved with all the formulae showing, inevitably leading to confusion for some other colleague.

Fortunately, the answer is simple – to toggle the display of formulae or values in cells, just use the keyboard shortcut Control (Ctrl) and `.

We’re aware that in print the second part of that shortcut is going to be hard to decipher so, just to be clear, it indicates the key bearing the grave accent. On most standard keyboard layouts, this is the key that sits just to the left of the 1 and in between the Tab and Escape (Esc) keys.

On most British keyboards, this same key additionally carries a vertical pipe symbol and the notation for the logic operator NOT, which looks like a geometric hook.

Reader Comments

   

Add your comment

Please keep comments constructive and free from abuse of any kind and swearing. If you wish to link to a product or service online, please do so in such a way that makes it clear that it is not spam. If you are connected to any such product you should make that clear.

We may use your comments in the magazine. We may edit your comments for clarity or to remove unacceptable material. We will attribute your comments but not share your email address.

We request your email address and record your Internet Address (IP address) in order to block spam from our site. We will never share this information without your permission.

All comments are reviewed by the Computeractive Team before being published. Please bear with the slight delay this causes, you don't need to post more than once.

Click here to read our Privacy Policy

Click here to read our site Terms & Conditions

Related articles

Hands on Spreadsheets: Functions and formulas

A selection of hidden Excel gems to boost your productivity

enhance-your-spreadsheets-in-excel-illustration

Enhance your spreadsheets in Excel

Spreadsheets don't have to look boring. We show how you can make yours stand out from the crowd with these great techniques

Hands on: Import and export data from Excel spreadsheets

Four options for dealing with the ins and outs of the software

Content Recommendation

Question & Answer

Q.Why is Windows Backup skipping files?

> Read the answer

Q.Why do my scanned documents display gibberish?

> Read the answer

Q.How can I convert MTS files to edit in Windows Movie...

> Read the answer

Best deals on the web

img

Samsung NP350E7C-A04UK

£349.99- Buy it now

img

Toshiba Satellite C850D-11Q (PSCC2E-00R00JEN)

£299.97- Buy it now

img

Lenovo G580 (MAANJUK)

£379.99- Buy it now

Updating your subscription status Loading

Most popular articles

No matching document

Poll

Do you have Windows 8?

Jargon Buster

Computing terms explained in plain English

Restore Point

A Windows backup of system files and settings.

Great shopping deals from Computeractive

Information currently unavailable