![]() Unfortunately, Google Sheets doesn’t offer a way to insert a symbol directly from its menu, but you can copy the symbol from Excel or Google Docs and then paste it to your spreadsheet. Then (2) select the plus or minus symbol and (3) click Insert, then (4) Cancel.Īs a result, the plus–minus symbol is added to the selected cell. In the Symbol window (1) choose Latin-1 Supplement from the Subset drop-down list.Then, in the Ribbon, go to Insert > Symbol. Select the first cell where you want to insert a plus or minus sign (e.g., C2).If you do this often, you might want to automate the insertion with a VBA loop. ![]() After that, you can copy the symbol to the rest of the cells in the range. Note: You can only insert a symbol in one cell at a time. How do you put the plus-minus sign together 1. You can represent a range using the plus–minus symbol (±). Alternatively type CHAR(177) as the formula to get the Plus-Minus Sign. Say you have the following data with Product name in Column B and you want a Price range in Column C. This tutorial demonstrates how to insert plus or minus sign in Excel and Google Sheets.
0 Comments
Leave a Reply. |