See all How-To Articles

How to Insert Plus or Minus Sign in Excel & Google Sheets

This tutorial demonstrates how to insert plus or minus sign in Excel and Google Sheets.


plus minus sign 3


Insert the Plus or Minus Sign

Say you have the following data with Product name in Column B and you want a Price range in Column C. You can represent a range using the plus–minus symbol (±).


plus minus sign 4


Note: You can only insert a symbol in one cell at a time. After that, you can copy the symbol to the rest of the cells in the range. If you do this often, you might want to automate the insertion with a VBA loop.

  1. Select the first cell where you want to insert a plus or minus sign (e.g., C2). Then, in the Ribbon, go to Insert > Symbol.


plus minus sign 1


  1. In the Symbol window (1) choose Latin-1 Supplement from the Subset drop-down list. Then (2) select the plus or minus symbol and (3) click Insert, then (4) Cancel.


plus minus sign 2


As a result, the plus–minus symbol is added to the selected cell.


plus minus sign 3


Insert Plus–Minus in Google Sheets

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.

See all How-To Articles