Power users rely on these lesser-known Excel shortcuts to work faster across large datasets, formulas, and worksheets.

A legend box in an Excel chart lists the chart's data series. It specifies each series' name and the color of its marker on the chart. When you try to edit a legend using the Format Legend dialog box, ...

Microsoft Excel's form controls can turn the Boolean options of a true-false choice into a clickable data-entry option. If you create spreadsheets to record business information about sales, personnel ...