To capitalize all letters in Google Sheets, select the cells and choose Format > Text > Capitalization > UPPERCASE. If you want a formula-based method, put an UPPER formula in an empty column, fill it down, and paste the results back as values if needed. These steps are for Google Sheets in a web browser; Google Sheets is sometimes casually called Google Excel, but it is a separate spreadsheet program.
What You’ll Need
- A Google account with access to the spreadsheet in Google Sheets.
- The cells containing the text you want to change. If the data matters, make a copy of the sheet or duplicate the column first.
- An empty column if you plan to use a formula and want to preserve the original text until you have checked the results.
Step-by-Step
- Open the right spreadsheet and find the text. Open the file in a web browser and identify the column or range to change. For example, if a list of names is in column A, note the first and last row containing names. Avoid selecting the entire sheet unless you intend to process all its text; a focused range reduces the chance of changing headings, notes, or unrelated entries.
- Choose whether to change the cells directly or use a formula. The capitalization menu is the quickest option when you are happy to replace the selected text immediately. Use the formula method when you want to keep the original data visible for comparison, preserve a source column, or produce uppercase results in a separate column. Either approach changes letter case, not the underlying meaning of the text.
- Capitalize the selected cells with the menu. Drag across the cells you want to change, or click the first cell and Shift-click the last cell in the range. In the top menu, select Format > Text > Capitalization > UPPERCASE. The selected text should change to uppercase in place. Click a few cells to confirm the result, and check the top and bottom of the range to ensure you selected every intended row.
- Use UPPER in a spare column if you want a preview. Suppose the original text is in A2:A20 and the empty destination column is B. Click B2 and enter
=UPPER(A2). The result for a sample value such as green valley would be GREEN VALLEY. The formula changes lowercase letters to uppercase while retaining spaces, punctuation, numbers, and other characters. Keep the original column until you have checked the converted entries. - Fill the formula down the column. Select B2, then drag the small blue square at the lower-right corner of the cell down to B20. If the neighboring source column has a continuous block of data, you can also double-click that square and let Sheets fill the formula alongside it. Check the last populated row: a short fill may leave some names unchanged, while an overly long fill can create formulas beside blank rows.
- Check the converted results before replacing anything. Compare several entries from the top, middle, and bottom of the list. Look for missed rows, unexpected blank results, or values that were not meant to be included. UPPER preserves punctuation and spacing, so a value such as 14 oak-street remains 14 OAK-STREET; it does not correct spelling, remove extra spaces, or standardize names beyond letter case.
- Keep the formulas or turn the results into fixed text. If the uppercase column should update when the original text changes, leave the formulas in place. If you want to replace the source column with permanent uppercase text, copy the checked results, select the original destination cells, and choose Edit > Paste special > Values only. In Google Sheets, Ctrl+Shift+V on Windows or ChromeOS and Command+Shift+V on Mac paste values only. After confirming the replacement, you can remove the temporary formula column if it is no longer needed.
Common Mistakes
Typing over the original data too early. A formula needs to read the original cell while it creates the converted result. If you put the formula into the same cell it refers to, you can create a circular reference or overwrite the source. Use an empty helper column, check the output, and only then replace the original values if that is your goal.
Copying formulas when you meant to copy text. A cell containing UPPER is a live formula, not fixed text. If you move or delete the source cells, the results can change or show an error. Use Paste special > Values only to keep the displayed uppercase text without its connection to the source.
Selecting the wrong range. Applying the menu to a heading or a neighboring column may change text you did not intend to edit. Before using the capitalization command, check the highlighted range in the grid and the name box. When using formulas, check that the references point to the source column and that the fill ends at the last actual record.
Expecting UPPER to clean or rewrite text. Capitalization only affects case. It will not remove leading or trailing spaces, fix misspellings, convert a date stored as text into a date, or make a person’s name follow a preferred spelling convention. Those tasks require separate editing or cleanup.
Tips
- Duplicate a tab for a large or sensitive change. Right-click the sheet tab and choose Duplicate before making broad edits. A backup makes it easier to compare results or restore the original wording if you discover that the selected range was too large.
- Use the menu for a one-time change. When you simply want the selected text to become uppercase and do not need a record of its original case, the capitalization menu avoids adding helper formulas or extra columns.
- Use a helper column when accuracy matters. Keeping source text and uppercase output side by side makes unusual entries easy to spot. This is especially useful for imported customer lists, inventory codes, or survey responses where a mistake could be hard to notice after overwriting.
- Keep the header clear. If you use a formula column, put a descriptive label such as Uppercase name in its first row. Do not include the header in the formula fill unless you also want to transform it.
- Remember that formulas recalculate. A formula result reflects the current source cell. This is useful for a working report, but it means changes to the source also change the uppercase output. Paste values only when the uppercase version should remain fixed.
- Know the Excel difference. Excel also has the UPPER function, so the formula approach is familiar there. Menu options for changing capitalization differ by program and version; the Google Sheets path above is not an Excel ribbon path.
Troubleshooting
The menu option is missing or unavailable. Confirm that the file is open in Google Sheets rather than being previewed in Drive or opened in another spreadsheet editor. Click a cell or select a text range, then reopen Format > Text and look for Capitalization. If the menus look different, reload the page and check that you have edit access; a view-only file may not allow changes.
The formula displays an error or does not change the text. Make sure the formula is in a different cell from its source and that the reference points to the intended cell. For example, with source text in A2, enter the UPPER formula in B2, not A2. If the result looks unchanged, the source may already be uppercase, or it may contain numbers and symbols rather than lowercase letters. Those characters are not converted.
Some rows did not update. Check whether the formula was filled through the full data range. Select the last expected result cell and confirm that it contains an output. If not, extend the fill handle or copy the formula from the row above and paste it into the missing rows. Also check for blank rows that may have stopped a double-click fill before the end of the list.
The values changed back or now show an error. You may still be looking at formulas linked to source cells. Restore the source values if possible, or use Undo immediately if you have just made the change. For a lasting conversion, copy the formula results and paste values only over the intended cells. If you already closed the file or made later edits, use version history to review or restore an earlier version rather than repeatedly undoing unrelated changes.
Only part of a cell looks uppercase. Check whether the cell contains multiple lines or whether the visible text is clipped by the column width. UPPER converts lowercase letters throughout the cell, including text after line breaks, but it does not change font styling or make the whole value visible. Widen the column or open the cell to inspect the complete contents.
Frequently Asked Questions
Can I capitalize an entire column in Google Sheets?
Select the used cells in that column and choose Format > Text > Capitalization > UPPERCASE. If you want to keep the originals, use a neighboring helper column and fill the UPPER formula down instead. Selecting only the populated rows helps avoid changing unrelated cells.
Does UPPER change numbers, punctuation, or spaces?
No. It changes lowercase letters to uppercase and leaves numbers, punctuation, and spaces as they are. For example, a code such as ab-204 becomes AB-204, while the hyphen and digits remain unchanged. It does not trim extra spaces or alter the structure of the cell.
Can I make uppercase text stay uppercase when the source changes?
A formula output updates when its referenced source changes. To freeze the current result, copy the converted cells and use Edit > Paste special > Values only. The pasted text is then independent of the original formula, so later edits to the source will not update it.
Will this work in Microsoft Excel too?
The UPPER function works in Excel as well as Google Sheets, but the instructions for the capitalization menu are specific to Google Sheets in a browser. In Excel, use a helper cell with UPPER and fill it down, then copy and paste values if you need to replace the original text.
Can I undo the change?
Immediately after a menu action or paste, use the Undo button or Ctrl+Z on Windows or ChromeOS; use Command+Z on Mac. If you have made many later edits or closed the sheet, check File > Version history > See version history to review earlier saved states. Make a copy first if you are unsure which version to restore.
Related
- Add a Border to an Image in Excel: Step-by-Step
- Add Color to Excel Data Validation Lists
- How to Add Color to Every Other Row in Excel Easily
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create a Badge Template in Word for PrintingTo create a badge template in Word, set up a page for your badge inserts, place a precisely…
- Remove Duplicates in Excel: Keyboard Shortcut and StepsIn Excel for Microsoft 365 on Windows, select a cell in your data and press Alt+A, then M…
- Excel Text to Columns: Choosing a Number DelimiterExcel’s Text to Columns has no special “number delimiter”: choose the character—such as a comma, tab, space, semicolon,…
- Hanging Indent in Word: A Simple Step-by-Step GuideTo add a hanging indent in Word, select the paragraph or paragraphs, open the Paragraph settings, and choose…
- Add a Cover Page in Microsoft Word 365To add a cover page in Word 365 for Windows, open the document and choose Insert > Pages…
- Freeze One Row and One Column in Excel at the Same TimeTo freeze the top row and first column together in Excel for Microsoft 365 on Windows, select cell…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.