Disable formula errors in Excel
Disable formula errors in Excel Go to menu > tools > options > error checking tab and disable errors you don’t want to see
How to freeze rows at top excel of spreadsheet (Excel Freeze Pane)
How to freeze rows at top excel of spreadsheet Select the a row use menu > window > freeze pane
How to Remove gridlines from excel worksheet
To remove gridlines from excel worksheet go to: menu > tools > options > and un-check grid
How to Move a formula in Excel 2007
Select the cell that contains the formula that you want to move. On the Home tab, in the Clipboard group, click Cut. Do one of the following: To paste the formula and any formatting, on the Home tab, in the Clipboard group, click Paste. To paste the formula only, on the Home tab, in the
Excel – Get proper fraction from a number
Get proper fraction from a number (for eg 1/2 from 2/4), use =text(fraction, “?/?”)
Copy a formula in Excel
Select the cell that contains the formula you want to copy. On the Home tab, in the Clipboard group, click Copy. Do one of the following: To paste the formula and any formatting, on the Home tab, in the Clipboard group, click Paste. To paste the formula only, on the Home tab, in the Clipboard
Calculating Percentages in Excel
There are several ways to calculate percentages. Percentages are calculated by using the following equation: amount/total = percentage Where percentage is in decimal format. To quickly display the result as a percentage, Click Percent Style on the Formatting toolbar.
Creating a Drop Down List in Excel 2007
Creating a Drop Down List in Excel 2007 Drop down list allows you to enter data into an Excel spreadsheet from a preset list of entries. This can be done to make data entry easier or to limit the number of choices. Enter the data on sheet from which you wish to create your drop