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

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

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows. You probably know that Excel’s Subtotal ...