FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -First, we must go to the “Formulas” tab > “Defined Names” group, then click the “Name Manager.” Alternatively, we can press “Ctrl + F3” (the shortcut for Name Manager). For a new named range, click on the “New” button. You may see the window below by clicking the “New” button.

Detailed explanation-2: -On the Formulas tab, in the Defined Names group, click Name Manager. In the Name Manager dialog box, double-click the name you want to edit, or, click the name that you want to change, and then click Edit.

Detailed explanation-3: -Manage names in your workbook with Name Manager On the Ribbon, go to Formulas > Defined Names > Name Manager. You can then create, edit, delete, and find all the names used in the workbook.

Detailed explanation-4: -Click the Home tab; Go to Font group; Then you will view the border button, as the figure 2 shows above.

Detailed explanation-5: -Apply a custom view Go to View > Workbook Views > Custom Views.