To insert the current date in worksheet footer, follow these steps:
1. In the File menu click Page Setup. The Page Setup window will open.
2. Select the Header/Footer tab.
3. Click the Custom Footer button. The Footer window will open.
As you can notice the footer is divided into three sections; left, center and right. Above those sections there is a [...]
The way you calculate the difference between two times depends on the way you want to present your results:
1. Present the result in standard time format (hh:mm:ss).
Simply subtract the two times from each other and format the result cell as time.
Examples:
A1 = 9:15:00
B1 = 14:07:20
Difference = B1-A1 = 4:52:20 (4 hours, 52 minutes and 20 [...]
The IF function is used to conduct conditional tests on values and formulas, and it is syntax is;
IF(logical_test,value_if_true,value_if_false)
As you can see it has only one logical test, and then the cell which has the formula will have a certain value if the test is “TRUE” and another value if the test is “FALSE”.
If you have [...]
To view hidden sheets in a workbook, you need to unhide them first.
To unhide a worksheet:
1. In the Format menu point to Sheet then click Unhide.
2. The Unhide window will open, with the hidden sheets listed.
3. Select the sheet you want to unhide then click OK.
Applies to: Excel 2003
To copy and paste data as a picture (image) follow these steps:
1. Select the range you want to copy.
2. While holding down the SHIFT key, Click on the Edit menu.
3. Click Copy Picture.
4. Select a cell in the range where you want to paste the picture.
5. Click Paste Picture in the Edit menu ( while [...]
To insert page number in worksheet footer, follow these steps:
1. In the File menu click Page Setup. The Page Setup window will open.
2. Select the Header/Footer tab.
3. Click the Custom Footer button. The Footer window will open.
As you can notice the footer is divided into three sections; left, center and right. Above those sections there is a number [...]
To calculate the difference or the number of days between two dates, you simply subtract one date from the other.
Example (using format:dd/mm/yyyy):
Suppose you have the date 25/11/2007 in cell A1 and the date 15/01/2008 in cell B1 (both cells formatted as date). To calculate the difference between these two dates you use the following formula:
=B1 [...]
To extract day, month or year from a date, you use the corresponding Excel built in function for each one of these date parts.
Day: Day(mydate).
Month: Month(mydate).
Year: Year(mydate).
Examples:
Suppose you have in cell A1 (formatted as date), the date:15/11/2009 (ddmmyyyy), Then:
Day(A1) will result in 15
Month(A1) will result in 11
Year(A1) will result in 2009
Applies [...]
If you are getting blank pages when you are printing a worksheet, then there are a number of possibilities:
1. You have some ‘unnoticed’ text in one of the cells, e.g. ‘.’ or ‘,’.
2. You have cells that contain text, but the text color is the same as the cell background color.
3. You have a cell with a formula [...]
Select the cell(s) for which you want to clear conditional formatting.
On the Format menu, click Conditional Formatting.
The Conditional Formatting dialogue will open, and the applied conditions will be listed.
Click Delete.
The Delete Conditional Format window will open.
Select the condition(s) to delete then press OK.
Applies to: Excel 2003
