Firstly, click on Add-ons in the toolbar at the top and select Get add-ons. 2. Now, search for Remove Duplicates in the search bar and press enter. Once the result shows up click on +Free button to install the add-on for free. Choose the desired Google account when prompted and allow the add-on to access your account.Apr 24, 2023 · Reset Color and Random Unique Color. To highlight duplicate rows we’ll have to do two things. The first is to reset previous highlights (if they exist) with the colorReset () function. Then color them with colors that are unique to each set of duplicate rows, with the getRandomUniqueColor () function. In your spreadsheet, highlight all the rows you want to search for duplicates. After that, click Add-ons > Remove Duplicates > Find duplicate or unique rows. After the add-on opens, check to make sure the range listed is correct and then click "Next." Next, choose the type of data you want to find.Nov 25, 2022 · We can then type the following formula into cell C2 to count the number of duplicate values for the Mavs team: We can then click and drag this formula down to each remaining cell in column C to count the number of duplicate values for each team: Mavs have 3 duplicate values. Warriors have 2 duplicate values. Hawks have 1 duplicate value. In your spreadsheet, highlight all the rows you want to search for duplicates. After that, click Add-ons > Remove Duplicates > Find duplicate or unique rows. After the add-on opens, check to make sure the range listed is correct and then click "Next." Next, choose the type of data you want to find.Aug 25, 2023 · Find duplicate or unique rows This feature is designed to identify duplicate or unique rows in Google Sheets and manage them further (highlight, remove, move to another tab, and even more). 2. Quick Dedupe A one-step alternative to the first feature. In a large set of data, it’s tough to find the number of times each value repeats in a Column manually. But you can easily find the multiple occurrences of a single value or keyword in a column. Google Sheets Count functions are a great help in this case. To find how many times a single item repeats in a column, you can use a COUNTIF function ...To use this tool, follow these steps: Open your Google Sheet and select the range of cells that you want to check for duplicates. Click Data > Find duplicates. A dialogue box will appear. Select the column that you want to check for duplicates and click OK. The duplicates will be highlighted in your sheet.How to Find Multiple Occurrences of Rows in Google Sheets. Google Sheets: Find All Duplicates in a Column and Delete the Row. Remove Duplicate Rows and Keep the Rows with Max Value in Google Sheets. How to Conditional Format Duplicates Across Sheet Tabs in Google Sheets. How to Filter Duplicates in Google Sheets and Delete.Now that I have over 10 worksheets and it is growing week by week I am finding that there are duplicates happening between the sheets, as conditional formatting only works per sheet. So is there a way for me to do have Google Sheet conditionally format the entire workbook by looking at column C and column D and if there is a match that it ...Apr 7, 2020 · 1. The Concatenate Values to Merge Duplicate Rows in Google Sheets. 2. Keeping Data with UNIQUE + JOIN to Merge Duplicate Rows in Google Sheets. 3. The QUERY Function to Remove Duplicate Rows. 4. The Use of Power Tools. Let’s dive into a real example to understand better how to merge duplicate rows in Google Sheets. Jul 15, 2020 · Click on an empty cell, preferably to the right near your data. Type the formula (=UNIQUE) in the cell, then add the cell coordinates where you noticed duplicates. In this case it is =UNIQUE (B11:B13). Click ‘Enter’ on your keyboard. All duplicate data should now appear in that cell/ column. In your spreadsheet, highlight all the rows you want to search for duplicates. After that, click Add-ons > Remove Duplicates > Find duplicate or unique rows. After the add-on opens, check to make sure the range listed is correct and then click "Next." Next, choose the type of data you want to find.See full list on lifewire.com Here’s how you can identify and highlight duplicates in Google Sheets. If you’re only looking for duplicates in a single column, follow these steps: Select the column where you want to find duplicates. From the menu bar, click Format > Conditional Formatting. The Conditional Formatting menu will open on the right side of your sheet. From the Format cells drop-down menu, select Custom ...Jul 15, 2020 · Click on an empty cell, preferably to the right near your data. Type the formula (=UNIQUE) in the cell, then add the cell coordinates where you noticed duplicates. In this case it is =UNIQUE (B11:B13). Click ‘Enter’ on your keyboard. All duplicate data should now appear in that cell/ column. Oct 3, 2020 · Find duplicate values in comma separated rows with random data. Your assistance will be greatly appreciated as I have been struggling with this for a while and couldn't find a solution. I have a Google Sheets file with comma-separated data in two columns as per the screenshot attached. soon,son,so,on,no N/A kind,kid,din,ink,kin,in dink sing ... Using Conditional Formatting to Highlight Duplicates. Step 1. Select the range in which you want to find duplicates. Usually this will be a single column of data such as a list of users, products, ... Step 2. Step 3. Step 4. Step 5.In the Conditional format rules panel that appears, click the dropdown menu under Format cells if and choose Custom formula is, then type the following formula: Once you click Done, the duplicate values that occur in both columns will be highlighted in green: We can see that the following names are duplicates across the two columns: Each of ...Sep 16, 2017 · Welcome to TechPot YouTube Channel.In this video we'll learn how to check for duplicate values in a Column in Google sheet.Use the simple formula shown in th... Edit, Add, or Delete a Conditional Formatting Rule. To edit a rule, select it, make your changes, and click "Done." To set up an additional rule, select "Add Another Rule." To remove a rule, hover your cursor over it and click the trash can icon.Article Link: https://spreadsheetpoint.com/highlight-duplicates-google-sheets/In this video, I will show you how to highlight duplicates in Google Sheets.Whi... Open the spreadsheet you want to check for duplicates in Google Sheets. First, select the first column (A) to check with column B. You can highlight the entire column by clicking on the column letter above it. Then, click the ‘Format’ menu from the menu bar and select ‘Conditional formatting’.In your spreadsheet, highlight all the rows you want to search for duplicates. After that, click Add-ons > Remove Duplicates > Find duplicate or unique rows. After the add-on opens, check to make sure the range listed is correct and then click "Next." Next, choose the type of data you want to find.Article Link: https://spreadsheetpoint.com/highlight-duplicates-google-sheets/In this video, I will show you how to highlight duplicates in Google Sheets.Whi... How To Find Duplicates with Conditional Formatting in Google Sheets. Here’s how to find duplicates with conditional formatting in Google Sheets. Step 1. First, select the range that you want to check for duplicates. In this example, we want to highlight all cells in Column A that have the same last name. Step 2 Aug 18, 2022 · To get the total number of duplicates, we can add each duplicate count. Follow these steps to start counting duplicates in Google Sheets: First, select the cell where we will place our unique values. In this example, we’ll place our unique values starting at cell C2. Next, we will use the SORT and UNIQUE functions to get a sorted list of the ... Aug 28, 2023 · Highlight the column you want to find duplicates in. Using our practice sheet, let’s see if there are any duplicates in the Director (1) column. 2. Click 'Format' in the top menu. 3. Click 'Conditional formatting.'. This will populate a box on the right-hand side of the screen. You’ll see a prompt called “Format cells if…”. This help content & information General Help Center experience. Search. Clear searchRelated: How to Create and Use Filter in Google Sheets. Highlight Duplicates in Selected Cells on Google Sheets. Let’s say you need to find duplicates only for a selected range of cells instead of the entire column. To do that, enter the data range (eg. C4: C20) in the box below the “Apply to range.” Then, you need to enter the below formula:fancy a symbol
Using Conditional Formatting to Highlight Duplicates. Step 1. Select the range in which you want to find duplicates. Usually this will be a single column of data such as a list of users, products, ... Step 2. Step 3. Step 4. Step 5.Apr 24, 2023 · Reset Color and Random Unique Color. To highlight duplicate rows we’ll have to do two things. The first is to reset previous highlights (if they exist) with the colorReset () function. Then color them with colors that are unique to each set of duplicate rows, with the getRandomUniqueColor () function. Follow the given below steps. Open your "Google Sheets document." and highlight the "column or columns" you need to modify. 2. At the top of the menu bar, select "Format". 3. After that in the drop-down menu, select "Conditional Formatting". 4. Now select the "Range" as per your choice from the new menu that appears.Go to Format > Conditional Formatting. The “Conditional Formatting” will open to the right. How to Highlight Duplicates in Google Sheets - Conditional formatting. 3. Check that the cell range shown corresponds to the two columns. Then in the “Format cells if” drop-down list, select “Custom formula is”.2. In the menu at the top, select “ Data – > Data cleanup ,” and afterward pick “Remove duplicates.”. 3. A dialogue will pop up. Mark the boxes close to every column in the list you need to check, or you can verify “ Select All ” and afterward click “ Remove duplicates .”. 4.The Three Formula Approaches to Find Duplicates in Google Sheets. Using the UNIQUE function – Extracting unique values. With the help of the FILTER function – For testing duplicates. Using CONCATENATE and IF logical (dynamic formula) in combined form – This is for finding/marking a single value in multiple rows.Step 1: Highlight the columns or rows that you want to find duplicates in. You do this by clicking and dragging over the column letters or row numbers (i.e. I highlighted columns A and B). Step 2: Right-click anywhere in the blue highlighted area and a box will pop up. Scroll down to the bottom of that box and click “Conditional formatting“.This help content & information General Help Center experience. Search. Clear searchThe VLOOKUP formula can help you find duplicated values between two sheets. This video will walk you through that process.Here is the formula used: =VLOOKUP...zack addy on bones
How to highlight duplicates in a single column in Google Sheets Highlight the data range you want to check for duplicate information. Then select Format > Conditional Formatting. From the Conditional format rules window that appears, click the dropdown menu under Format rules, and select Custom... ...2. In the menu at the top, select “ Data – > Data cleanup ,” and afterward pick “Remove duplicates.”. 3. A dialogue will pop up. Mark the boxes close to every column in the list you need to check, or you can verify “ Select All ” and afterward click “ Remove duplicates .”. 4.This video is about how to find and highlight duplicate entries in Google Sheets. If you like this video, please hit the "Like" button and if you want to see...Google Sheets offers flexible ways to find, review or fix duplicate data. For example, you can highlight a single cell carrying the duplicate value, or the entire row of data if there’s a ...Mar 1, 2020 · The VLOOKUP formula can help you find duplicated values between two sheets. This video will walk you through that process.Here is the formula used: =VLOOKUP... Aug 18, 2022 · To get the total number of duplicates, we can add each duplicate count. Follow these steps to start counting duplicates in Google Sheets: First, select the cell where we will place our unique values. In this example, we’ll place our unique values starting at cell C2. Next, we will use the SORT and UNIQUE functions to get a sorted list of the ... Open the spreadsheet. 2. Select the cells where you want to find duplicates. 3. Click on Format > Conditional Formatting. 4. Select the Single color tab on this sidebar, and confirm the range in ...Oct 3, 2020 · Find duplicate values in comma separated rows with random data. Your assistance will be greatly appreciated as I have been struggling with this for a while and couldn't find a solution. I have a Google Sheets file with comma-separated data in two columns as per the screenshot attached. soon,son,so,on,no N/A kind,kid,din,ink,kin,in dink sing ... Aug 14, 2021 · Open the spreadsheet you want to check for duplicates in Google Sheets. First, select the first column (A) to check with column B. You can highlight the entire column by clicking on the column letter above it. Then, click the ‘Format’ menu from the menu bar and select ‘Conditional formatting’. Jul 15, 2020 · Click on an empty cell, preferably to the right near your data. Type the formula (=UNIQUE) in the cell, then add the cell coordinates where you noticed duplicates. In this case it is =UNIQUE (B11:B13). Click ‘Enter’ on your keyboard. All duplicate data should now appear in that cell/ column. Here’s how you can identify and highlight duplicates in Google Sheets. If you’re only looking for duplicates in a single column, follow these steps: Select the column where you want to find duplicates. From the menu bar, click Format > Conditional Formatting. The Conditional Formatting menu will open on the right side of your sheet. From the Format cells drop-down menu, select Custom ... Method 1: Conditional Formatting. Highlighting duplicates with a single column: Select the column containing the data you want to check for duplicates. Go to the ""Format"" menu, choose ""Conditional formatting,"" and set up a rule to highlight duplicates. This will instantly highlight any duplicate entries within the selected column.crossville chronicle
Using Excel's Remove Duplicates Feature. 1. Open your original file. The first thing you'll need to do is select all data you wish to examine for duplicates. 2. Click the cell in the upper left-hand corner of your data group. This begins the selecting process. 3. Hold down the ⇧ Shift key and click the final cell.Here’s how: Select the range of cells where you want to check for duplicates. Click on the “Format” menu at the top of the screen and select “Conditional formatting.” In the conditional formatting dialog box, choose “Custom formula is” from the drop-down menu. Enter the following formula: =COUNTIF ...3 quickest ways to find & highlight duplicates in Google Sheets. With & without formulas 🖌️👉 Add-on used in the video in the Google store: https://workspac...Feb 14, 2020 · Learn how to identify repeated values in your spreadsheet table. We discuss a method using conditional formatting and one using an IF function.Go here for th... Start the add-on. Select the range you want to process and go to Extensions > Remove Duplicates > Quick dedupe: Tip. If you don't select your table before running the add-on, it will automatically pick up the used range — cells with data till the first blank row & column. Tip. You can also spot Quick Dedupe in the Dedupe & Compare group in ... Sep 14, 2023 · Here’s how you can use Apps Script to remove duplicates: Step 1: Open your Google Sheets spreadsheet and go to the “Extensions” menu. Select “Apps Script” to open the Apps Script editor. Step 2: In the Apps Script editor, delete the default function (myFunction) and replace it with the following code: javascript. function ... Method 1: Conditional Formatting. Highlighting duplicates with a single column: Select the column containing the data you want to check for duplicates. Go to the ""Format"" menu, choose ""Conditional formatting,"" and set up a rule to highlight duplicates. This will instantly highlight any duplicate entries within the selected column.Follow the given below steps. Open your "Google Sheets document." and highlight the "column or columns" you need to modify. 2. At the top of the menu bar, select "Format". 3. After that in the drop-down menu, select "Conditional Formatting". 4. Now select the "Range" as per your choice from the new menu that appears.Aug 11, 2022 · Now that the add-on is installed, go back to your Google Sheets document and click on the Extensions tab, followed by the Remove Duplicates option. Make sure to click on the Find duplicate or unique rows. On the next page, make sure that the right range is selected and click on the blue Next button. In step two, choose what you want the add-on ... Here’s how you can identify and highlight duplicates in Google Sheets. If you’re only looking for duplicates in a single column, follow these steps: Select the column where you want to find duplicates. From the menu bar, click Format > Conditional Formatting. The Conditional Formatting menu will open on the right side of your sheet. From the Format cells drop-down menu, select Custom ...Learn how to use conditional formatting in Google Sheets to highlight cells with duplicate data.To do a row instead of a column, use 1:1 to reference all of ...Finding Unique Values Using the ‘Remove Duplicates’ Tool. Google Sheets offers a menu option that is dedicated to just this task – removing duplicates to find unique values. Using this method, you can remove duplicates with just three clicks. Here are the steps you need to follow: Select the range of data that you want to work on.Install find duplicate in Google Sheets extension. Step 4: You click the Continue button > select your Gmail > Allow > Done. Grant permission to find duplicate in Google Sheets extension. Step 5: You go back to the Google Sheet page with duplicate data > Add-ons > Remove Duplicates > Start to start finding duplicates in Google Sheets.Step 1: Highlight the columns or rows that you want to find duplicates in. You do this by clicking and dragging over the column letters or row numbers (i.e. I highlighted columns A and B). Step 2: Right-click anywhere in the blue highlighted area and a box will pop up. Scroll down to the bottom of that box and click “Conditional formatting“.wonderful whites of wv
How to use the Remove Duplicates add-on. Start Remove Duplicates. Step 1: Select your data. Step 2: Choose what to find. Step 3: Pick the columns to check. Step 4: Decide what to do with the found values. See the result. How to work with scenarios. Video: Remove Duplicates for Google Sheets — Automation.To get the total number of duplicates, we can add each duplicate count. Follow these steps to start counting duplicates in Google Sheets: First, select the cell where we will place our unique values. In this example, we’ll place our unique values starting at cell C2. Next, we will use the SORT and UNIQUE functions to get a sorted list of the ...Step 1: Highlight the columns or rows that you want to find duplicates in. You do this by clicking and dragging over the column letters or row numbers (i.e. I highlighted columns A and B). Step 2: Right-click anywhere in the blue highlighted area and a box will pop up. Scroll down to the bottom of that box and click “Conditional formatting“.Firstly, click on Add-ons in the toolbar at the top and select Get add-ons. 2. Now, search for Remove Duplicates in the search bar and press enter. Once the result shows up click on +Free button to install the add-on for free. Choose the desired Google account when prompted and allow the add-on to access your account.Now that the add-on is installed, go back to your Google Sheets document and click on the Extensions tab, followed by the Remove Duplicates option. Make sure to click on the Find duplicate or unique rows. On the next page, make sure that the right range is selected and click on the blue Next button. In step two, choose what you want the add-on ...This help content & information General Help Center experience. Search. Clear search Start the add-on. Select the range you want to process and go to Extensions > Remove Duplicates > Quick dedupe: Tip. If you don't select your table before running the add-on, it will automatically pick up the used range — cells with data till the first blank row & column. Tip. You can also spot Quick Dedupe in the Dedupe & Compare group in ...May 9, 2020 · The first step to achieve this is to highlight the entire column that needs to be searched for duplicates by clicking on the column label above it. Once highlighted, right-click and select Conditional formatting. This will bring up a panel on the right side of the window that shows conditional formatting rules. Apr 7, 2020 · 1. The Concatenate Values to Merge Duplicate Rows in Google Sheets. 2. Keeping Data with UNIQUE + JOIN to Merge Duplicate Rows in Google Sheets. 3. The QUERY Function to Remove Duplicate Rows. 4. The Use of Power Tools. Let’s dive into a real example to understand better how to merge duplicate rows in Google Sheets. For "LOOKUP TABLE", select "Sheet1" and then click "OK". A list of the duplicates in the range of cells that you selected will appear. The third way to find duplicates is to use the "Filter" function. To do this, select the range of cells that you want to check for duplicates and then go to "Data" > "Filter". In the "Filter" dialog box, select ... Nov 25, 2022 · In the Conditional format rules panel that appears, click the dropdown menu under Format cells if and choose Custom formula is, then type the following formula: Once you click Done, the duplicate values that occur in both columns will be highlighted in green: We can see that the following names are duplicates across the two columns: Each of ... Use of arrays to store duplicates. Solution: Create a output array and use setBackgrounds() instead. Use Objects {} to store duplicates; If the above solutions are still slow, use sheets api to batch set backgrounds; Snippet:Mar 2, 2016 · To display all duplicate records, i.e. occurrences greater than 1, click the filter arrow in the header of the Occurrences column (the column with the formula), and then click Number Filters > Greater Than. Select " is greater than " in the first box, type 1 in the box next to it, and click the OK button: hot rod lincoln lyrics1. Click Kutools > Select > Select Same & Different Cells, see screenshot: 2. In the Select Same & Different Cells dialog box, do the following operations: (1.) Click button under the Find values in text box to select the first column data, and then click button under the According to text box to select the second column data; (2.) Oct 3, 2020 · Find duplicate values in comma separated rows with random data. Your assistance will be greatly appreciated as I have been struggling with this for a while and couldn't find a solution. I have a Google Sheets file with comma-separated data in two columns as per the screenshot attached. soon,son,so,on,no N/A kind,kid,din,ink,kin,in dink sing ... In the Conditional format rules panel that appears, click the dropdown menu under Format cells if and choose Custom formula is, then type the following formula: Once you click Done, the duplicate values that occur in both columns will be highlighted in green: We can see that the following names are duplicates across the two columns: Each of ...How To Find Duplicates with Conditional Formatting in Google Sheets. Here’s how to find duplicates with conditional formatting in Google Sheets. Step 1. First, select the range that you want to check for duplicates. In this example, we want to highlight all cells in Column A that have the same last name. Step 2Feb 10, 2023 · In the menu at the top, select Data -> Data cleanup, and then choose Remove duplicates. A dialogue popup will appear. Mark the boxes next to each column in the list you want to check, or you can ... To get the total number of duplicates, we can add each duplicate count. Follow these steps to start counting duplicates in Google Sheets: First, select the cell where we will place our unique values. In this example, we’ll place our unique values starting at cell C2. Next, we will use the SORT and UNIQUE functions to get a sorted list of the ...Follow these 6 simple steps to highlight duplicates in Google Sheets: Select the range where you want to search for duplicates. Click the Format tab. Choose the Conditional Formatting option. Spreadsheet named "Animal Newsletter" with Format tab open and Conditional Formatting highlighted.Aug 17, 2022 · 3 quickest ways to find & highlight duplicates in Google Sheets. With & without formulas 🖌️👉 Add-on used in the video in the Google store: https://workspac... Here’s how you can use Apps Script to remove duplicates: Step 1: Open your Google Sheets spreadsheet and go to the “Extensions” menu. Select “Apps Script” to open the Apps Script editor. Step 2: In the Apps Script editor, delete the default function (myFunction) and replace it with the following code: javascript. function ...Formula: Suppose you may want to include an unlimited number of rows in the Query to cover future values. In that case, modify the above Query as below. =query (B3:C,"Select B, Sum (C) where B is not null group by B") Note:- The above two Query formulas that combine duplicate rows are based on the sample data above (screenshot).How to highlight duplicates in a single column in Google Sheets Highlight the data range you want to check for duplicate information. Then select Format > Conditional Formatting. From the Conditional format rules window that appears, click the dropdown menu under Format rules, and select Custom... ...How to highlight duplicates in a single column in Google Sheets Highlight the data range you want to check for duplicate information. Then select Format > Conditional Formatting. From the Conditional format rules window that appears, click the dropdown menu under Format rules, and select Custom... ...jessa kae
Jun 20, 2022 · Related: How to Create and Use Filter in Google Sheets. Highlight Duplicates in Selected Cells on Google Sheets. Let’s say you need to find duplicates only for a selected range of cells instead of the entire column. To do that, enter the data range (eg. C4: C20) in the box below the “Apply to range.” Then, you need to enter the below formula: Google Sheets is loaded with useful features, including the ability to find and remove duplicate entries. Though it takes a bit of know-how to set up, it’s a...Use of arrays to store duplicates. Solution: Create a output array and use setBackgrounds() instead. Use Objects {} to store duplicates; If the above solutions are still slow, use sheets api to batch set backgrounds; Snippet:This help content & information General Help Center experience. Search. Clear searchJan 23, 2021 · How to find Duplicates in Google Sheets? Using simple custom formula and conditional formatting you can easily find duplicate values and highlight the duplic... Jan 16, 2023 · Use the shortcut, Ctrl + F, to open the Find tool. In the message box, enter the repeated keyword. Furthermore, you could configure the Find tool to perform an even more advanced search. To explore more about what the Find tool can do to locate the repeated values, follow these steps: From the Find tool pop-up, select the three-dot menu. Article Link: https://spreadsheetpoint.com/highlight-duplicates-google-sheets/In this video, I will show you how to highlight duplicates in Google Sheets.Whi... This help content & information General Help Center experience. Search. Clear search To display all duplicate records, i.e. occurrences greater than 1, click the filter arrow in the header of the Occurrences column (the column with the formula), and then click Number Filters > Greater Than. Select " is greater than " in the first box, type 1 in the box next to it, and click the OK button:Jul 18, 2023 · If not, you get a FALSE result. Here are the steps to follow: In the second row of column C (in cell C2), insert the formula: =A2=B2. Press the return key. Double click the fill handle to copy the same formula to the rest of the cells in column C. You should now see the results of each comparison in column C. vidanta riviera maya
Related: How to Create and Use Filter in Google Sheets. Highlight Duplicates in Selected Cells on Google Sheets. Let’s say you need to find duplicates only for a selected range of cells instead of the entire column. To do that, enter the data range (eg. C4: C20) in the box below the “Apply to range.” Then, you need to enter the below formula:Start the add-on. Select the range you want to process and go to Extensions > Remove Duplicates > Quick dedupe: Tip. If you don't select your table before running the add-on, it will automatically pick up the used range — cells with data till the first blank row & column. Tip. You can also spot Quick Dedupe in the Dedupe & Compare group in ...On your computer, open a spreadsheet in Google Sheets. To create a filter, select an option: Select a range of cells, then click Data Create a filter . Right click on a cell or a range of cells, then click Create a filter. To see filter options, go to the top of the range and click Filter . Filter by condition: Choose conditions or write your ...We can then type the following formula into cell C2 to count the number of duplicate values for the Mavs team: We can then click and drag this formula down to each remaining cell in column C to count the number of duplicate values for each team: Mavs have 3 duplicate values. Warriors have 2 duplicate values. Hawks have 1 duplicate value.Aug 11, 2022 · Now that the add-on is installed, go back to your Google Sheets document and click on the Extensions tab, followed by the Remove Duplicates option. Make sure to click on the Find duplicate or unique rows. On the next page, make sure that the right range is selected and click on the blue Next button. In step two, choose what you want the add-on ...