How to hide formula in excel sheet
Last answer on Sep 8, 2009 11:22:52 am BST danny, on Sep 8, 2009 7:20:49 am BSTBest answers for « how to hide formula in excel sheet » in :
Basic Excel Formulas ShowBasic Excel Formulas
Below are some basic formulas for Microsoft excel:
Basic formula :
ADDITION cell A1 to A10 = sum (A1: A10)
AVERAGE cell A1 to A10 = average (A1: A10)
MAXIMUM cell A1 to A10 = max (A1: A10)
MINIMUM...
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet
To freeze a line in an excel sheet, for example line 1:
Select line 2.
Go to menu Window and select Freeze panes.
Avoid duplicates in Excel ShowAvoid duplicates in Excel
In order to avoid duplication when encoding in a column from an excel sheet:
take the conditional format on the first cell under the headings (eg A2)
choose the following formula:...

