Google Sheets Formatting & Structure Shortcuts

Inserting a row above or a column to the left both use a similarly chorded shortcut (Ctrl+Alt+Shift+= on Windows, Cmd+Option+Shift+= on Mac), though the exact binding can vary somewhat by Sheets version and keyboard layout, which is why most people fall back on the right-click context menu for row/column insertion at least as often as the keyboard shortcut — the menu route is more discoverable and consistent across different setups than trying to recall an exact four-key chord. Text wrapping, controlled through the toolbar's wrap-text icon rather than a bound keyboard shortcut, toggles whether long content in a cell spills onto multiple visible lines within that cell (growing the row height as needed) or instead overflows visually into an empty neighboring cell or gets truncated at the cell boundary — the same underlying concept as Excel's wrap text feature, just reached through a toolbar click rather than a ribbon button. Freezing rows or columns (View menu > Freeze, again with no default keyboard shortcut) locks selected rows and/or columns in place so they remain visible while scrolling through the rest of the sheet — most commonly used to keep a header row pinned at the top of a long dataset, functionally identical in purpose to Excel's Freeze Panes even though the two apps expose the feature through different menu locations. Bold (Ctrl+B) works exactly as it does in every other text-editing app covered on this site, applying to the text content of whatever cells are currently selected. Number formatting in Sheets is where the biggest structural difference from Excel shows up. Rather than one comprehensive Format Cells dialog, Sheets spreads number formatting across a set of individual quick-apply keyboard shortcuts (Ctrl+Shift+1 for a standard number format, with several more covering percentage, currency, and other common formats depending on your exact Sheets version and locale) plus a fuller Format menu for anything more customized, like a specific decimal precision or an entirely custom number format string. This means the single-dialog habit that serves Excel users so well with Ctrl+1 doesn't translate directly — in Sheets, quickly applying a specific common format is often genuinely faster via the dedicated shortcut, but anything beyond the handful of presets requires navigating into the Format menu rather than one all-purpose keyboard shortcut covering every formatting need at once. A practical habit worth building for anyone regularly formatting shared operational spreadsheets in Sheets: because there's no single formatting dialog to memorize the way there is in Excel, it's worth learning the specific quick-apply shortcuts for whichever formats you use most often (currency and percentage are the two most common in financial or reporting spreadsheets) rather than defaulting to the Format menu every single time, since the keyboard shortcuts genuinely save meaningful time once memorized, even without a unified dialog behind them. Conditional formatting, while not covered by a dedicated keyboard shortcut of its own, is worth mentioning alongside these structural tools since it's reached through the same Format menu and is used disproportionately often in shared operational sheets — highlighting overdue dates in red, or flagging a status column's values with distinct background colors, gives collaborators an at-a-glance visual read of a shared sheet's state without anyone needing to read every cell's raw text individually, which matters considerably more in a file several people are scanning quickly throughout a workday than in a personal single-author workbook. Merging cells (via the toolbar's merge icon, again with no default keyboard shortcut) works similarly to Excel's Merge & Center in concept, but Sheets offers a few distinct merge variants — merge all, merge horizontally, and merge vertically — accessible from a small dropdown beside the main merge button, giving slightly more granular control over exactly how a selected range combines than Excel's single default merge behavior provides directly from its own toolbar button.