What does Ctrl + Shift + 1 do in Google Sheets?

Natively it applies one fixed format (two decimals). With XLKeys Pro installed, it becomes a format cycle: each press steps the selection through a configurable list of number formats, like Macabacus in Excel.

Can I customize which formats the cycle uses?

Yes. The XLKeys options page lets you reorder, add, or remove formats in the cycle — including custom format strings for things like parenthesized negatives or abbreviated millions.

Are there color cycles too?

Yes — XLKeys also has a Font Color Cycle (Ctrl + ’) and a Fill Color Cycle (Ctrl + Shift + K), both Pro features that cycle through standard model colors.

Is the Number Format Cycle free?

It’s an XLKeys Pro feature with a 30-day free trial — no credit card required. The fixed native formats (currency, percentage, date) remain free.

All shortcuts

Number Format Cycle in Google Sheets

Pro

Windows

Ctrl+Shift+1

Mac

⌘+Shift+1

Number formatting is the highest-frequency task in any model — commas here, decimals there, parentheses on negatives. Excel plugin users cycle formats with one repeated keystroke instead of digging through menus. Sheets makes you visit Format > Number over and over.

XLKeys turns Ctrl + Shift + 1 into a number format cycle in Google Sheets: press it once for comma format, again for decimals, again for parenthesized negatives. The cycle order is configurable in the XLKeys options, so it steps through the formats you actually use.

Excel vs. Google Sheets vs. XLKeys

Where	Shortcut
Excel	`Ctrl`+`Shift`+`1 (applies comma format) / Macabacus cycles`
Google Sheets (native)	`Ctrl`+`Shift`+`1 (fixed two-decimal format only)`
Google Sheets + XLKeys	`Ctrl`+`Shift`+`1`

Sheets natively maps Ctrl + Shift + 1 to a single fixed decimal format. XLKeys upgrades it to a Macabacus-style cycle: press repeatedly to step through your preferred formats.

How to use it

Select the cells to format.
Press Ctrl + Shift + 1 (⌘ + Shift + 1 on Mac).
The first format in your cycle is applied — press again to step to the next format.
Customize the cycle order and formats in the XLKeys options page.

Frequently asked questions

Related shortcuts

Accounting Number Format

Alt→H→A→N

Auto-Color

Ctrl+Shift+S

Font Color

Alt→H→F→C

Make Google Sheets feel like Excel

Install XLKeys to use number format cycle and 150+ other Excel-style shortcuts, Alt-key sequences, formula auditing, Goal Seek, Sensitivity Tables, and Workbook Health audits in Google Sheets.

Add XLKeys to Chrome Free printable cheat sheet →