March 25, 20268 min read

How to Type Hindi in Excel — Cells, Formulas, and Formatting

A practical guide to entering Hindi text in Excel spreadsheets — from cell data entry to column headers, mixed language formulas, and proper font setup.

hindi excel spreadsheet typing data entry

Excel with Hindi content is more common than you'd think — employee databases with names in Devanagari, product catalogs in regional languages, attendance sheets for schools, billing data for local businesses. The challenge is that Excel adds a few quirks of its own beyond just "can I type Hindi here?"

This guide covers everything from basic cell entry to the less obvious issues like formula text, sorting, and cell width adjustments.

First: Get Hindi Input Working on Your System

Before anything Excel-specific, your Windows system needs to support Hindi input. If you've already done this, skip ahead. If not, here's the quick setup:

Windows 10/11: Settings → Time & Language → Language & Region → Add a Language → Hindi (India).

After installation, press Win + Spacebar to toggle between English and Hindi. You'll see the language indicator near the clock in the taskbar — "ENG" for English, "HIN" for Hindi.

For keyboard layout, pick Microsoft Hindi Phonetic if you're not familiar with the INSCRIPT standard layout. Phonetic lets you type "namaste" and get नमस्ते.

Alternatively, skip the system setup entirely and use transliterate.in to convert your text online, then paste directly into Excel cells. Both approaches work fine.

Typing Hindi in Excel Cells

Basic Text Entry

Click a cell, switch to Hindi input (Win + Spacebar), and start typing. Hindi text appears in the cell just like English text would. Press Enter to confirm and move to the next row, or Tab to move right.

One thing to note: as you type with phonetic input, a small suggestion box floats near the cell. Press Enter or Spacebar to accept the top suggestion, or use number keys (1–9) to pick from alternatives. This popup is the input method editor (IME) doing its job.

Screenshot description: An Excel spreadsheet with column headers in Hindi (नाम, पता, फ़ोन नंबर) and sample data entries in Devanagari text. The IME suggestion popup is visible near one cell.

Adjusting Column Width

Devanagari characters are generally wider than their Latin equivalents when rendered at the same font size. A cell that fits "Name" might cut off "नाम" visually.

Double-click the right edge of the column header to auto-fit width, or right-click the column header → Column Width → set a specific value. For Hindi text, column widths 20–30% wider than your English equivalent tend to work well.

Row Height for Devanagari

At certain font sizes, the matras (vowel marks above/below characters) get clipped. If text like ी or ू looks cut off at the top or bottom, increase row height: right-click the row number → Row Height → increase by 20–30%.

Font Selection in Excel

Not all fonts render Devanagari properly. In Excel, these fonts work reliably:

Mangal — the gold standard for Hindi in Office applications. If you're creating documents that others will open, this is the safest choice. Nirmala UI — cleaner look, good for dashboards and reports that also have English content. Handles mixed-language cells well. Kokila — a bit more elegant if you want something that doesn't look like a government form.

To set the font: select your cells → Home tab → Font dropdown → type the font name.

You can set a default font for the entire sheet by going to File → Options → General → "When creating new workbooks" → change the default font.

Mixed English-Hindi Cells

Excel handles Unicode, so you can freely mix scripts in the same cell. Type part in English, toggle to Hindi, type more. The cell stores it all as Unicode text.

Example use case: a product name like "Premium चाय - Pack of 10" works fine in a single cell.

For data entry purposes, it's often cleaner to separate languages into different columns — one for the English name, one for the Hindi name — but that's a workflow decision, not a technical requirement.

Hindi in Column Headers and Formulas

Headers

Column headers in Hindi work exactly like any other cell. Type your Hindi header, format the row (bold, background color, center alignment), and freeze it using View → Freeze Panes → Freeze Top Row.

Using Hindi Text in Formulas

Here's where things get interesting. You can use Hindi text as values in IF statements, VLOOKUP references, and CONCATENATE formulas — as long as the text matches exactly (same Unicode codepoints, same spelling).

Example:

=IF(A2="हाँ","Approved","Pending")

This checks if the cell A2 contains "हाँ" (Yes in Hindi) and returns "Approved" if true. The Hindi string inside the formula needs to be typed or pasted correctly.

Important: Comparisons in Excel formulas are case-insensitive for ASCII, but for Unicode (Hindi text), they're an exact Unicode match. If one cell has "हाँ" typed with phonetic input and another has the same-looking text pasted from a different source, they might not match if the Unicode normalization differs. VLOOKUP errors in Hindi data are often caused by this.

To troubleshoot: use =LEN(A2) and =LEN("हाँ") — if the character counts differ for visually identical text, you have different Unicode representations.

CONCATENATE with Hindi

=CONCATENATE(A2," - ",B2)

This works fine even if A2 has a Hindi name and B2 has an English category. Excel just strings them together.

Sorting Hindi Data

Excel can sort Hindi text alphabetically, but the results depend on whether Excel knows it's dealing with Hindi Unicode. By default, Excel sorts by Unicode codepoint value, which produces a result that roughly follows alphabetical order for Devanagari but isn't perfect by Hindi dictionary standards.

For data that needs proper Hindi alphabetical sorting (ka, kha, ga, gha...), consider:

Add a helper column with the sort order (1 for क, 2 for ख, etc.)
Sort by the helper column
Hide the helper column after sorting

This is admittedly manual, but Excel doesn't have built-in Hindi collation like a proper database would.

Pasting Hindi from External Sources

If you're getting Hindi text from websites, other documents, or a tool like transliterate.in, paste using Ctrl+Shift+V or Home → Paste → Paste Special → Text to paste as plain text. This strips formatting from the source and lets Excel apply its own cell formatting.

Regular Ctrl+V works too, but occasionally brings over unwanted formatting if the source was a Word document.

Pasting from TranslitHub

A common workflow for data entry teams:

Prepare the Roman-script text in a document
Paste it into TranslitHub in batches
Copy the Devanagari output
Paste into Excel

This avoids needing every team member to have Hindi input configured on their machines. One person handles the transliteration, the rest do standard copy-paste.

Printing Hindi Excel Sheets

Before printing, check Print Preview (Ctrl+P → Preview). Hindi text in cells sometimes gets clipped near page margins. Adjust by:

Going to Page Layout → Margins → Narrow (gives more space)
Reducing font size by 1–2 points
Changing page orientation to Landscape for wide tables

For headers and footers in Hindi: Insert → Header & Footer → click in the header/footer area, switch to Hindi input, type your text. This appears on every printed page.

Excel's .xlsx format stores everything as Unicode, so Hindi text is preserved perfectly. Recipients on any modern system can open the file and read the content.

If the recipient has an older version of Excel (Excel 2003 or earlier) or is using a non-Microsoft spreadsheet app that doesn't support Unicode well, you might see issues. In practice, Excel 2007 and later handle it fine.

When sharing as PDF (File → Save As → PDF or Export → Create PDF), the Hindi text embeds correctly. Mangal and Nirmala UI are system fonts on Windows, so they render properly on any Windows machine. If the recipient is on macOS, they might need to have the font installed — or just use PDF to be safe.

Common Issues

Cells show question marks or boxes instead of Hindi: The cell's font doesn't support Devanagari. Select the cells, go to Home → Font, and change to Mangal or Nirmala UI. Typing Hindi switches cell to formula mode: This can happen if you press = accidentally. Press Escape and try again. Auto-correct changes Hindi text: Excel's autocorrect is designed for English. Go to File → Options → Proofing → AutoCorrect Options and turn off corrections that are interfering. Alternatively, type your Hindi text in a cell that starts with a letter (not a number), so Excel doesn't try to interpret it as a formula. VLOOKUP not finding Hindi values that are visually identical: See the Unicode normalization issue discussed earlier. Use =EXACT(A2, B2) to check for a true match — if it returns FALSE for visually identical text, the Unicode codepoints differ. Hindi text in a cell appears right-to-left: Right-click the cell → Format Cells → Alignment tab → Text direction → Left-to-Right. Devanagari is naturally left-to-right, but occasionally Excel gets confused by Unicode bidirectional markers.

Working with Hindi in Excel has a small learning curve, but once you've set up fonts and input methods, it's pretty stable day to day. The most common workflow hiccups are around sorting and formula matching — both of which have simple workarounds once you know what to look for.