· Step 1 Create a query to get the named range Firstly create a named range to reference I have called my named range FilePath and copied in a new folder location Add a named range by typing in the name FilePath into the name box Then copy in the folder path into this cell Go to the Power Query tabSelect the range you want to name, including the row or column labels Click Formulas > Create from Selection In the Create Names from Selection dialog box, select the checkbox (es) depending on the location of your row/column header If you have only a header row at the top of the table, then just select Top rowName Range is a name assigned to a range of cells in excel, it helps us in using a given range conveniently by mentioning their name rather than range notations like A1G3 etc As you could see below, the range A1A6 has been assigned name "ToBeSum" we will see in this post how to use name range in an excel formula In the pic above you could see that the name of the range is
Structure Of An Excel Template Report Vertex 18 Documentation