- How to create a name range in mac excel 2013 how to#
- How to create a name range in mac excel 2013 download#
Consider the previous example where we had searched for the word ‘Scooter’ in our Excel sheet, and all the fields having the word ‘Scooter’ were highlighted.
![how to create a name range in mac excel 2013 how to create a name range in mac excel 2013](https://www.lifewire.com/thmb/Ih_QKEk7O-1D5vCgoJ1gX58VYpw=/3084x1608/filters:no_upscale():max_bytes(150000):strip_icc()/ExcelDropDownList2-4a4bbc1bfe954aeeb77523293cf07514.jpg)
Now let us see some examples where we can use a search box and get refined results.
How to create a name range in mac excel 2013 how to#
=SEARCH($G$9,$A2& $B2&$C2&$D2) Example of Search Box in Excel Usageīy now, we have been able to develop a clear understanding of how to implement a Search Box in Excel. We can then specify all the search locations in the same manner as we specified for ‘A2’. Adding $ sign before ‘A’ ensures that the search location remains fixed even if we change the location of the search box.Īffixing the ‘&’ sign after ‘A2’ means that we wish to add more locations from where data is to be searched. So, ‘A2’ means that we wish to search for the data in column ‘A’ starting from the 2 nd row. This parameter, ‘A’, specifies the column from which data is to be searched, and ‘2’ specifies the initial position. We can either type in the cell number or simply click on the cell where we want the search box after we have written =SEARCH in the conditional formatting rule window. This parameter defines the location where we wish to apply the search rule. Let’s have a look at each parameter individually. Let us now try to understand what each parameter within the formula of Search means in Excel. Now let us try to understand the meaning of the parameters that we used in the Search formula and how it worked for us in Excel. For example, now, after the fields for Scooter have been highlighted, we can simply apply a filter on the color and refine our search results even further.
![how to create a name range in mac excel 2013 how to create a name range in mac excel 2013](https://2.bp.blogspot.com/-RESAv7C44HI/Wh87mFmeAqI/AAAAAAAAAA4/UXPiqLUmISc5HucojbHChZ3J-25Dd0j-QCLcBGAs/s1600/Laptop_replair_imac_macbook_vancouver.jpg)
This simplifies the process of looking for any value. You’ll see that all the rows with the word scooter have been highlighted.
![how to create a name range in mac excel 2013 how to create a name range in mac excel 2013](https://pryormediacdn.azureedge.net/blog/2015/07/Excel-Macro-PivotTable2.png)
In this case, we have selected G1 as the search box cell.
![how to create a name range in mac excel 2013 how to create a name range in mac excel 2013](https://www.exceltip.com/wp-content/uploads/2014/11/unnamed-8.png)
How to create a name range in mac excel 2013 download#
You can download this Search Box Excel Template here – Search Box Excel Template Usage of Search Box in ExcelĬonsider that you have the data of a company that deals in the sale and purchase of used vehicles.