30 Aug
Excel has a feature called AutoRecover that allows you to save a workbook automatically at a preset time interval. Every time a file is saved, a backup copy will first be saved using the previously saved copy of the workbook, and the current information will be saved to the original workbook. Follow these steps [...]
Posted in General by: admin
No Comments
26 Aug
To count blank or empty cells within a given range you use the COUNTBLANK function.
Cells with formulas that return “” (empty text) are counted.
Cells with zero values are not counted.
Cells with spaces are not counted.
Syntax
COUNT(range)
Examples:
COUNTBLANK(A1:A20)
In the example below, cell B12 contains the function: =COUNTBLANK(B1:B11). The result is 5. This is a result [...]
Posted in Data, Formulas, Functions by: admin
No Comments
24 Aug
To count cells, within a given range or list of arguments, that contains only numbers you use the COUNT function.
Dates and text that represent numbers are considered numbers and will therefore be counted.
Logical values, text, or error values are not counted
Syntax
COUNT(value1,value2,…)
Examples:
COUNT(A1:A20) :counts numbers in a range of cells.
COUNT(A1:A20, 7) :counts numbers in a range [...]
Posted in Data, Dates, Functions by: admin
2 Comments
20 Aug
Do you really need to change the tab color of a worksheet?
Well, you may have a workbook with a considerable number of worksheets, and you may just want one or two of the worksheets to stand out from the crowd. Anyhow for any reason you may have here is how to do it:
1. Switch to [...]
Posted in Customization, Formatting by: admin
No Comments
17 Aug
To add a background to a worksheet follow these steps:
1. Switch to the worksheet where you want to add a background.
2. Click Format, point to sheet then click Background.
3. The Sheet Background window will open. Select your picture then click Insert.
4. The selected picture will be repeated as a background.
To remove the background:
1. Switch to [...]
Posted in Customization, Formatting by: admin
No Comments
10 Aug
If you want to find cells in your worksheet that have data validation, then follow these steps:
1. On the Edit menu, click Go To. The Go To window will open.
2. Click Special. The Go To Special window will open.
3. Click Data validation.
4. At the bottom of the window click on the radio button that says [...]
Posted in Data, Validation by: admin
No Comments
03 Aug
If you want to find cells that have conditional formatting, then you have two choices:
1. Find cells with any conditional formatting.
2. Find cells that have conditional formatting settings identical to the settings of a specific cell.
For option 1 do the following:
1. On the Edit menu, click Go To. The Go To window will open
2. Click [...]
Posted in Data, Formatting by: admin
No Comments