Diagonal Headers in Excel
Reading a chart of numbers can be made more difficult if you have long column headers that expand the width of the cells. Long column headers can even cause the […]
Diagonal Headers in Excel Read Post »
Reading a chart of numbers can be made more difficult if you have long column headers that expand the width of the cells. Long column headers can even cause the […]
Diagonal Headers in Excel Read Post »
Deciphering a spreadsheet is easier with Excel conditional icons, which visually communicate changes and differences in numbers with directional arrows, stop light colors, flags, and bars. In the example above,
Excel Conditional Icons Read Post »
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
Finding Duplicates in Excel Read Post »
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 you
Scientific notation in Excel Read Post »
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 date
Excel Countdown formula Read Post »
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 Header
Excel Page Numbers Read Post »
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
Excel Video: Sorting by Multiple Columns Read Post »
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
Print Gridlines in Excel Read Post »
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.
Disappearing Excel Gridlines Read Post »
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
Excel: Setting Page Breaks for Printing Read Post »