To center a word in an Excel cell, select the cell, then choose Home > Center in the Alignment group. This centers the cell’s contents horizontally. If you also want it centered from top to bottom, choose Middle Align in the same group. The steps below are for Microsoft Excel for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook with the word entered in a cell, or a blank cell where you can enter it.
- Access to the Home tab and the Alignment group. No formula, add-in, or special setting is required.
Step-by-Step
- Open the worksheet and find the word. Open the workbook and go to the sheet containing the text. If the word is not entered yet, select a cell, type it, and press Enter. Excel treats ordinary typed words as text automatically. You can center an existing entry or set the alignment first and type into the cell afterward.
- Select the cell containing the word. Click the cell once so that it has the selection border. The Name Box to the left of the formula bar shows the selected cell address, such as B3. If you have a group of cells to format, drag across them or click the first cell and Shift-click the last. Selecting a range applies the alignment setting to every selected cell; it does not create one large centered area.
- Open the Home tab. If the ribbon is collapsed, click Home to display its commands. Find the Alignment group, usually near the middle of the ribbon. It contains horizontal alignment buttons, vertical alignment buttons, text wrapping, and other cell layout controls.
- Center the word horizontally. Click the Center button in the Alignment group. The word moves to the horizontal center of its cell. Make sure you choose Center, not Merge & Center: the latter combines selected cells and can affect the layout or contents of a range.
- Center it vertically if needed. To position the word halfway between the top and bottom edges of a taller cell, click Middle Align in the same Alignment group. Horizontal Center and vertical Middle Align are separate settings. You can use either one alone or apply both to place the word at the visual center of the cell.
- Check the result in the worksheet. Click another cell to see the final formatting without the selection border. If the cell is narrow, widen its column by dragging the boundary between its column letters. If the row is unusually tall, adjust the row height using the boundary between its row numbers. These changes make the centered position easier to see; the alignment setting itself does not resize cells.
- Save the workbook. Press Ctrl+S on Windows or choose File > Save. This preserves the alignment along with the rest of the workbook. If the word should be centered in several cells, repeat the selection and alignment process for those cells or select the full target range before clicking Center.
On Excel for Mac, select the cell and use the Home tab’s Alignment group in much the same way; the ribbon labels may be arranged differently depending on the window size. In Excel for the web, select the cell, open Home, and choose Center in the alignment controls. If the ribbon is condensed, expand the alignment menu to find the command.
Common Mistakes
Centering a range and expecting one word in the middle of it. Selecting B2:D2 and clicking Center centers the contents separately in B2, C2, and D2. It does not center a word across the combined width of all three columns. To make a heading appear centered over several columns without joining the cells, use Center Across Selection as described in Tips.
Choosing Merge & Center by accident. This command merges the selected cells as well as centering the content. When multiple cells contain information, Excel generally keeps only the upper-left cell’s content and warns that the other values will be removed. Use the ordinary Center button for a single cell, and avoid merging data cells that need to remain separate for sorting, filtering, or formulas.
Expecting alignment to affect only part of a cell’s text. Excel’s cell alignment applies to the cell’s contents as a whole. If a cell contains a sentence and you want just one word centered independently of the rest, ordinary Center alignment cannot do that. Put the word in its own cell, or use a text box if the layout is for a presentation or printed page and the text does not need to behave as cell data.
Confusing horizontal and vertical alignment. Center moves text left or right within the cell. It does not place text in the vertical middle. For a tall cell, choose Middle Align as well. Conversely, Middle Align alone does not center the word horizontally.
Tips
Use Center Across Selection for a heading spanning columns. If a label should appear centered over a range while the cells remain separate, select the range, open the Format Cells dialog from the small dialog launcher in the Alignment group, and go to the Alignment tab. In the Horizontal list, choose Center Across Selection, then click OK. This is often safer than merging cells in a worksheet that may later be sorted or edited. The text must be in the leftmost cell of the selected range to display across it.
Use keyboard access if you prefer not to click. In Excel for Windows, press Alt, then H, A, C in sequence to open the Home ribbon key tips and apply Center. Press the keys one after another rather than holding them all down. Ribbon key tips can vary in other Office versions or languages, so use the button if the sequence shown on screen differs. On a Mac, use the Home tab’s alignment control because Windows Alt key-tip sequences do not apply.
Format a whole set of entries consistently. Select the target cells before choosing Center to apply the same horizontal alignment in one action. This works well for short labels or codes in a column. Keep in mind that it centers each entry within its own cell. To select non-adjacent cells, hold Ctrl on Windows while clicking them; on Mac, use Command while selecting. Check that the selected cells are the intended ones before applying formatting.
Consider wrapping and column width. Centering does not make a long entry fit. If a cell contains several words and the text is clipped, widen the column or use Wrap Text in the Alignment group. Wrapped text can occupy multiple lines; Middle Align will then position the whole wrapped block vertically, not center each line separately. For a single short word, a suitably sized column usually gives the clearest result.
Troubleshooting
The word still looks left-aligned. Confirm that you selected the cell containing the word, not a nearby blank cell, and click the standard Center button again. If you selected several cells, inspect each one: cells with no content will remain visually blank, while populated cells should center their own entries. Also check whether the word is overflowing from a cell into an empty cell beside it. Widen the original column or enter content in the adjacent cell to make the cell boundary easier to judge.
The word appears centered in the wrong space. A cell’s alignment is measured against that cell’s boundaries, not the visible width of the worksheet or a group of columns. If the goal is to center a title over several columns, select the intended range and use Center Across Selection. Confirm that the title is in the leftmost cell; text in another cell in the range will not be centered across the entire selection.
The word is centered left to right but not top to bottom. The row may be taller than the text, and horizontal Center does not change vertical alignment. Select the cell and choose Middle Align. If the cell is part of a merged area, the alignment controls can behave differently because the merged area has one combined boundary; consider unmerging it and using Center Across Selection when separate cells are important.
The Center button is unavailable or the result will not change. First check that the sheet is not protected in a way that prevents formatting. If the workbook is in a read-only view, save an editable copy or ask for permission to change it. You can also open Format Cells and inspect the Alignment tab for an indent or other setting that affects the appearance. If alignment changes but the entry still looks off, check for leading spaces in the cell’s text; alignment centers those spaces along with the visible letters. Edit the entry to remove unwanted spaces.
The formatting disappears after editing or pasting. Pasting can bring formatting from the source along with the text. After pasting, select the destination cell and click Center again, or use Paste Special options that keep the desired destination formatting. If you enter new text into an already centered cell, its alignment normally remains in place; if it does not, check whether the new content was pasted over the cell or whether a different cell was selected.
Frequently Asked Questions
How do I center one word in an Excel cell without merging cells?
Select that cell and click Home > Center. This centers its contents within the existing cell and does not merge it with neighboring cells.
How do I center a word both horizontally and vertically?
Select the cell, click Center for horizontal alignment, and then click Middle Align for vertical alignment. The commands control different directions, so apply both if you want the word in the middle of a taller cell.
Can I center a word across multiple columns?
Yes. Put the word in the leftmost cell of the span, select the span, and choose Center Across Selection from the Format Cells dialog’s Alignment tab. This centers the display across the selected cells while keeping them separate. Clicking Center alone centers the word only in its own cell.
Can I center just one word in a sentence inside a cell?
Not with the cell alignment buttons. They position the entire cell entry together. Move the word to a separate cell if it needs independent alignment, or use a text box when you need precise visual placement rather than ordinary worksheet data.
Will centering change the value or formulas in the cell?
No. Center is a formatting change; it does not alter the cell’s text, number, or formula result. It also does not change how Excel calculates with the value. You can change the alignment later without re-entering the content.
Why does the word not look exactly centered?
Check for leading or trailing spaces, an indent setting, a narrow column, or adjacent content that makes the cell boundary hard to see. The text is centered relative to the cell’s actual edges, not relative to the visible letters or neighboring columns.
Related
- Dynamic Forecast in Excel: Build One That Updates
- Forecast in Excel: How to Build a Reliable Prediction
- Ungroup in Excel: How to Bring Back the Ungroup Command
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Switch Excel Sheet View: Normal, Page Layout, and MoreTo switch an Excel worksheet’s display mode in Microsoft 365 for Windows, select View, then choose Normal, Page…
- Excel MAX Between Two Dates: Find the Highest ValueTo find the largest value in B2:B100 for records dated between the start date in D2 and the…
- Insert a Citation in Word from EndNote: Step-by-StepTo insert an EndNote citation in Word, open your EndNote library and Word document, place the cursor where…
- Adding a Header in Word: Steps and OptionsTo add a header in Microsoft Word for Microsoft 365 on Windows, choose Insert > Header, select a…
- How to Center a Table on a Page in Excel for PrintingTo center a table on a printed page in Excel, open Page Layout, launch the Page Setup dialog,…
- Delete a Page in Word: Can You Remove One?Yes. In Word for Microsoft 365, you can select the contents of a page and delete them, but…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.