Your spreadsheet formulas are always shown in the Formula Bar of Excel. This makes it easy to view and edit the formulas of a spreadsheet. How do you hide formulas in Excel?
If you do not want others to be able to view the formulas. Hide formulas in the Formula Bar by setting them to hidden and applying worksheet protection.
Before you apply worksheet protection, you need to change the property of the cells that contain the formulas to hidden.
In the latest version of Excel it has become your responsibility (if you choose to) to create your own toolbar, and in our basic Excel series we show you how.
The Quick Access Toolbar at the top of your screen begins with just the Save, Undo and Redo buttons. If you require fast access to any other Excel commands you are able to add them yourself. You can add almost any functionality to the toolbar including those not found on the Ribbon.
As part of our basic Excel series, this post explores 7 incredible additions to the toolbar that are sure to improve the way you work.
Excel was created for the use of calculating and analysing huge amounts of data. Because of this it has never been great for storing large amounts of text or pictures. Inserting images into a cell would make the spreadsheet even larger and more awkward in its daily use.
Comments are fantastic for leaving notes for other users, but they can also be used to store pictures. These pictures can then be made visible when required rather than permanently displayed on screen within a cell.
I was asked today if it was possible to write an IF function that could insert a happy face if certain criteria was met. This would be used to show good performance. An unhappy face would be inserted for poor performance.
To insert a happy face in Excel we need to enter a capital J and format the cell in a Wingdings font. For an unhappy face, it’s a capital L formatted in the Wingdings font.
The following basic Excel skills demonstrates using this technique to display a happy or unhappy face dependent upon someone’s exam grade. The exam grade is in cell B3 and the smiley face will be inserted into cell C3.
[Read more…] about Insert a Happy Face using the IF FunctionFollowing my Excel lottery number generator video I have had frequent requests for a Lotto 6/55 version. So here it is.
This spreadsheet demonstrates some fantastic Excel techniques, and as always the file is unprotected so that it can all be investigated.
The following Excel features are used:
