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 ...

How to display multiple subtotal rows in a Microsoft Excel PivotTable Your email has been sent Microsoft Excel PivotTables are a great way to summarize data. They’re easy to create and display ...

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 two keyboard shortcuts will let you insert the current date and time in any cell of your spreadsheet. It doesn’t matter if you are using Google Sheets or Microsoft Excel; you can use these ...

In this article we will show you how to display multiple columns in a validation list in Excel. We will show you a method that can then be applied to your data. To create a validation list with ...

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 ...

In Microsoft Excel, tooltips are simply small windows that pop up when you select or highlight certain cells. These windows generally include a message specific to the connected cell, and offer you ...

Microsoft Office Excel can be configured to display a number with the default currency symbol. In addition to the options for currency symbols, the format has options for the number of decimal places ...

Microsoft Windows may get all the press coverage, but when you want to get real work done, you turn your attention to the applications that run on it. And if you use spreadsheets, that generally means ...

Q: I found an anomaly with a rather simple Excel computation; specifically, Excel calculates 111,111,111 times 111,111,111 to equal 12,345,678,987,654,300, which is ...