When editing a formula in a dialog box in Microsoft Excel, you might go to use the Arrow keys to move the blinking cursor to a different position. However, frustratingly and confusingly, doing this ...

The Bullet feature is not available in Microsoft Excel by default; you must go to settings to have it enabled. The bullet feature cannot add bullets to cells in your Excel spreadsheet, but it can add ...

Using Excel to create business forms means including elements available on your Web-based and paper forms, including check boxes. Like other Excel form elements, check boxes appear on the drawing ...

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

Despite Microsoft Office’s evolution toward menu-driven shortcuts, it’s worth remembering those funky Fn keys still serve a purpose. As part of key combos in Word, Excel, and Outlook, they make it ...

How to use VBA’s InputBox function to select a range on the fly in Excel Your email has been sent Often, you’ll want Excel users to specify a range that the app then uses in an automated way.

How to take advantage of the Name box in Microsoft Excel Your email has been sent Scrolling around a large sheet can be tedious, awkward, and occasionally, even fruitless because you simply can’t find ...

Whenever you create a new document, by default, Office sets the username based on the username settings that appear in the Word Options dialog box, as well as the PowerPoint and Excel dialog boxes. In ...

The January 2017 JofA article “Data Mining Your General Ledger With Excel” presents a step-by-step, formula-based approach to extracting general ledger data and then scrubbing them so that they can be ...