Impress your coworkers with these nifty tricks.

Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior. By default, Excel displays only visible data in a chart. Consequently, if you hide ...

2 ways to display negative numbers in red in Microsoft Excel Your email has been sent To enter a negative value into a Microsoft Excel sheet, precede the value with a hyphen character, (-), which ...

Excel is the spreadsheet program of the Microsoft Office suite. Using Excel, you can store and track all the information that's important to your business, like sales figures, payroll information and ...

These four overlooked Excel features completely changed how I design spreadsheets.

Q. Some of my Excel spreadsheets contain many worksheets—up to 36 in some cases. But not all the worksheet tabs show at the bottom of the screen. Is there some way to make more tabs visible, such as ...

Please note: This item is from our archives and was published in 2006. It is provided for historical reference. The content may be out of date and links may no longer function. Is there a way to ...

What language is your intranet coded in? If it's in ASP or ASP.net you can use an Excel workbook as an ADO datasource.

In one of the Excel sheets from work I noticed it had a name that was in kanji and it was being displayed as gibberish so I just tried other CJK character sets and it seems that Excel 2011 can't ...