Microsoft Excel by default shows a horizontal and vertical scroll bar in an Excel workbook. It lets you move through the worksheet so that you can scroll the data on the page easily. But if you don’t ...

When you have too many data points to display in a dashboard chart, add a scroll bar so users can still view all the data. Sometimes a chart’s underlying data doesn’t fit in the chart window. When ...

If you’re a full-time spreadsheet jockey, or just a casual number-cruncher, you’ve come to know and either love or hate Excel’s interface. Well, your world just changed. Throw away almost everything ...

Freezing panes enables you to lock rows or columns, so they remain static, even when scrolling. For example, you might have descriptive headers used to identify business data during data entry, so ...