Monday 27 April 2020

How to create Name with column Header of a Table


How to create Name with column Header of a Table

 1. Open Microsoft Excel.
2      2.  Open excel sheet which contain a table.
      3. Select header (example Roll Number)

3.  Click "Formulas" the click "Define Name" 

4.  "New Name" dialog box appears with Name (Roll Number as Roll_number)
5. Click "Ok"


















No comments: