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 […]
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 […]
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 […]
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 […]
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 […]
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. […]
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 […]
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 […]
When your data has been entered into Excel, you can use the built-in Filter tool on the Data Tab to narrow down what you are viewing based on criteria you […]