Wiki Sumber Informasi iSIKHNAS

Checking named ranges

1. From the 'Nama Terdefinisi' section of the 'Rumus' tab of the Ribbon, click 'Pengatur Nama':
   
   • From the 'Pengatur Nama' dialog box, you are able to:
     • create new named ranges
     • edit existing named ranges
     • delete existing named ranges
     • apply a variety of filters to existing named ranges.
       
2. From the worksheet's name box, click the down arrow to reveal a list of existing named ranges. Clicking on any one of these will take you to (and select) the range, even if it is on another worksheet.