See all How-To Articles

How to Insert Sum Symbol in Excel & Google Sheets

This tutorial will demonstrate how to insert the sum symbol in Excel and Google Sheets.

symbols insert sum intro

Inserting the Sum Symbol into Excel

Excel has a few options for inserting bullet points. The first is to use the Symbols feature.

1. In the Ribbon, select Insert > Symbols > Symbol.

symbols ribbon

2. The Symbol box will appear. You can resize the box if you want to see more symbols by dragging the bottom right-hand corner of the box.

symbols insert symbol

3. With the Font on (normal text), you can use the drop-down list on the right to change the subset from Basic Latin to Greek and Coptic.

symbols change subset

4. Click on the sum (Greek Capital Letter Sigma) symbol and click on Insert.

symbols insert sum

5. Click Close to close the Symbol box and return to Excel.

Inserting Sum into Excel Using the Alt Code

To use a shortcut instead, hold down the Alt key, then type ALT+2+2+8 (Alt 228) to insert the sum (Σ) symbol.

Inserting Sum Using the Symbol Font

You can also insert sum by changing the font to Symbol and typing the letter S into a cell.

1. In the Ribbon, select Home > Font and then select Symbol from the Font drop-down box.

symbol insert ribbon symbol font

2. Type the letter S into your required cell.

sum insert sum font

You can insert many other types of symbols using these methods.

Inserting the Sum Symbol into Google Sheets

Inserting Sum Using the Alt Code

The Alt code works the same in Google sheets as it does in Excel; the secret is to be in Edit mode in the cell before pressing the Alt key.

1. Select the cell where the Sum symbol needs to be placed.

2. Press F2 to enter Edit mode.

3. Press ALT+228 to enter sigma into the Cell.

symbols insert sum google sheets

Inserting Sum Using Special Characters

Google Sheets does not have a symbol function. Google Documents however, does. If you wish to insert symbols such as sigma into Google Sheets you need to open a Google document and copy and paste from that document into the Google sheet.

1. In the File menu, select New > Document.

symbols insert google doc

A new tab will open in the browser showing a new Google Document.

2. In the Insert Menu, select Special characters.

symbols insert google doc special characters

You can select a variety of categories in the left drop-down box such as Symbol, Emoji, Punctuation etc.

symbols insert google doc list

3. Select Symbol in the left-hand drop-down box, and then select Maths in the right-hand box.

symbols special characters google sheets

4. Click on the sum symbol to insert the symbol into the Google document.

5. Click the close button to close the Insert special characters box.

6. Highlight the symbol with your mouse and then press CTRL+C to copy the symbol.

7. Switch back to the Google sheet and press CTRL+V to paste the symbol.

sum insert symbol google sheets