You might be familiar with bookmarks in Microsoft Word, which are invisible way-points in specified locations of a document that you can jump to whenever you need to. Microsoft Excel's alternative to ...

Excel users who regularly reference the same cell in ranges from within their Workbook, will be happy to know that the popular platform has an easier way to create a named range. It is considered the ...

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

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

This article will be handy if you want to rename or edit the data series name in a Microsoft Excel graph or chart without changing the row or column name. The data series is the data that appears at ...

Microsoft Excel lets you create simple forms that your users can enter data. To save them time and make sure you get the information you need, you can create a drop-down box that limits the users to ...