Word Overtype Mode
In Word 2003 you could press your insert key on your keyboard to either type over text or insert text. The default was to insert text, but you could quickly…
Finding Duplicates in Excel
A common problem in processing data in Excel is handling duplicates or double entries. Excel has a few convenient tools for quickly making these changes. Simply eliminating duplicate entries in…
Scientific notation in Excel
Excel automatically converts numbers with 15 or more digits into scientific notation. In fact, when it simplifies the number it loses the rounded digits. They aren't recoverable. As long as…
Excel Countdown formula
How many days until the end of the year? How many days until the big meeting? Use this simple Excel countdown formula to find out. The DATEVALUE formula converts a…
Excel Page Numbers
There a couple of ways to add page numbers to a Microsoft Excel worksheet. In the Page Layout tab, click on the Page Setup Additional Options button. Bring up the…
Excel Video: Sorting by Multiple Columns
If you have a large spreadsheet of information, you may often want to sort the information by more than one column. For example, what if you want to sort by…
Print Gridlines in Excel
Gridlines are the very lightly colored lines that surround each cell in a Microsoft Excel spreadsheet. Be default, they won't print. Printing them is fairly easy though. To make Excel…
Disappearing Excel Gridlines
My Microsoft Excel Gridlines are no longer visible in the program. How do I get them back?There are 4 possible reasons that gridlines are no longer visible in Microsoft Excel.…
Excel: Setting Page Breaks for Printing
Do you have a long spreadsheet that you need to print? Do you want to control which rows and columns are printed on which pages? You can use the page…
Common Formula Mistakes in Excel
3 Ways Excel can Betray You — We regularly hear harrowing stories of an accounting sheet gone wrong with an errant formula. These small mistakes are hard to catch and…