PCTips.us

1.  A quick way to enter the time
To enter the current date or time click on a cell and type =today() or =now().
Excel updates the result every time you open the sheet, so it’s always current.
2. Enter a fixed time into Excel
If you want Excel to enter the current date or time and fix it [...]

1. Convert rows to columns
You can convert rows to columns (and　columns to rows) by highlighting the　cells you want to switch around,　clicking on Edit, Copy, selecting a new　cell and then going to Edit, Paste　Special… Finally, place a tick in the　Transpose box on the dialog box and　click on OK.
2. Calculate time between dates
Enter in a cell the [...]

Did you know that you can create a hyperlink from a Web page on your intranet or the Internet to a particular sheet, range, and cell in an Excel workbook? For example:
Link Test
will open your file called Hyperlinktesting.xls and then select cell A1 on Sheet1.
Using this kind of linking, you can specify exactly where [...]

Working in a complex worksheet, you may have encountered that annoying “#DIV/0!” error when the divisor of your formula is a zero. Using the built-in IF function, you can create your own message for display when you divide by zero:
=IF (DIVISOR = 0,”Your Text”, DIVIDED/DIVISOR)
The IF function evaluates the first parameter (DIVISOR = 0). If [...]

Track Changes works hand-in-hand with workbook sharing. It keeps a log of all changes to a workbook. It tracks cell changes, worksheet additions and deletions, column changes, and other types of changes, as well as the date, time, and name of the user who made the change. When data is changed, it keeps a record [...]

Excel supports two data systems: 1900 and 1904. Early Macintoshes did not support dates before Jan. 1, 1904. For this reason, Excel for Macs renders entered dates as the number of days since 1/1/1904. Excel for Windows, on the other hand, supports dates starting Jan. 1, 1900, and so renders dates as the number of [...]

Custom Views is a tool in Excel that lets you assign a name to a particular sheet layout so you can recall it for later viewing. You can access the feature by selecting View | Custom Views. In the Custom Views dialog box, you’ll see a listing of saved views, and you can add or [...]

Here’s a little piece of post-Y2K calendar trivia for you. Since the 1950s, astronomers and geophysicists have used Julian dates to track time in continuous, absolute terms, without bothersome seasons, leap years, or man-made conventions. Julian dates associate a date with the number of days elapsed since January 1 of the same year. (For example, [...]

One of the most common mistakes users make in preparing a report or sorting data is including redundant entries. For example, if a worksheet keeps a running tally of purchases made by Customer 1, there’s no need to report cells other than the ones keeping the composite figures. A built-in filter in Excel will take [...]

If some of your users spend much of their day working in a specific workbook, you can teach them how to designate that workbook to open each time Excel launches. All they need to do is place the workbook (or a shortcut to the workbook) in the XLStart folder. This technique also works with network [...]