Learn how you can make use of Name Box in Excel. The purpose of Excel Name Box is to help reduce the time taken while working with columns, cells, rows & ranges.

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

Enter the new name of the column in the Name text box. Click the "Scope" drop-down menu and select "Workbook" to apply the change to all of the sheets in the workbook.

3] Change the user name in a Comment Box in Excel If you want to change the user name that appears at the beginning of the comment text in bold, you can do that using Excel Options.

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