Mhelp4Ucom‎ > ‎Office 2007 ▼‎ > ‎Excel 2007 ▼‎ > ‎

How to define a name by using a selection of cells

                                               Contact us for Site Advertising Rates & Metrics    

                                                                           

                                                                                                                                               Report Errors & Bugs

 


                                                 How to define a name by using a selection of cells

                                                                           This Mhelp clip will show you how to define a name by using a selection of cells in Excel.

                                                                                   This Mhelp clip has five steps.
                                                                                  1 - Highlight the cell range you want to name.
                                                                                  2 - Click the Formulas tab.
                                                                                  3 - In the Defined Names group, click Create from Selection. A dialog box will open.
                                                                                  4 - Check the location option for the cells you want to create a name from.
                                                                                  5 - Click OK.

                                                                              This concludes the Mhelp clip.