Driver FixRecommendedSound, Wi-Fi or graphics acting up? Check drivers firstFind missing or outdated drivers fast.Check DriversOctober DealsAmazon USOctober deal check: compare before you payAmazon US: current deals, useful picks and tech finds.Check DealsClean PCRecommendedOne scan can reveal what keeps slowing WindowsLook for cleanup and repair opportunities.Run Scan×
Skip to content
Mountain View desk2 min

How to Freeze Columns or Rows in Google Sheets

Freeze rows or columns to keep labels visible while scrolling in Google Sheets. Follow the steps for computer, Android, iPhone, or iPad.

What’s actually slowing this PC down?

Pick the symptom - the matching free tool is one click away.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

To keep headings or identifying columns visible while you scroll in Google Sheets, freeze them from View > Freeze on a computer. In the mobile app, select a row or column and choose Freeze. You can freeze a custom number, including four columns, and undo the setting later.

What freezing does

Freezing pins selected rows or columns in place so they remain visible as you scroll through the rest of a sheet. It is useful when a table’s labels are no longer on screen—for example, when you need to see column headings while moving down a long list. Freezing is different from hiding or grouping rows and columns. Google’s Sheets help page describes the feature and its desktop controls.

As an Amazon Associate I earn from qualifying purchases.

Freeze rows or columns on a computer

  1. Open the spreadsheet in Google Sheets.
  2. Select the row or column that marks where the frozen area should end.
  3. Choose View > Freeze.
  4. Choose how many rows or columns to freeze.

For a custom boundary—such as keeping four columns visible—select the appropriate boundary and choose the matching freeze option in the menu. Some interfaces may show an option such as “Up to current column”; menu wording can vary, so use the option that corresponds to the number of rows or columns you want to keep in view. The official help confirms that you select how many to freeze but does not enumerate every menu label.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

To remove a frozen area on a computer, choose View > Freeze > No rows or No columns, as appropriate. Google’s Sheets cheat sheet also points to View > Freeze for keeping rows or columns in place while scrolling.

#1 Best Overall
Pixiecube Excel Cheat Sheet Desk Pad | Excel Shortcut Keys Mouse Pad | Extended Large XL Gaming Mousepad | PC Office Spreadsheet Keyboard Mat | Non-Slip Stitched Edge
  • EXCEL SHORTCUTS. ZERO SEARCHING. – Our bestselling reference mat puts an extensive collection of commonly used commands, formulas and helpful tricks directly beneath your fingertips so you can find answers fast, work smarter and stay in the flow.
  • YOUR DESK. SMARTER. – Clearly organized sections for navigation, selection, formatting, data and functions make it easy to find the right Excel command exactly when you need it.
  • LEARN, WORK & RESET – Built-in desk-exercise diagrams give you 10 quick ways to stretch, recharge and return to work feeling sharper.
  • ROOM TO WORK & CREATE – The extended 31.5 x 11.8-inch Pixiecube desk mat fits a laptop or keyboard and mouse, while the soft 2 mm surface adds comfort and protects your desktop.
  • BUILT FOR REAL-WORLD WORKDAYS – A rugged stitched edge helps prevent fraying, and the water-resistant, stain-resistant surface protects against scratches, spills and everyday wear—because smarter desks should work harder.

Freeze or unfreeze in the mobile app

Device Freeze Unfreeze
Android Touch and hold the row or column, then tap Freeze. Touch and hold it again, then tap Unfreeze.
iPhone or iPad Tap the row number or column letter, tap the right arrow in the menu, then tap Freeze. Use the same menu and tap Unfreeze.

These mobile steps are documented separately for Android and iPhone and iPad.

Repeat frozen headings when printing

If you want frozen headings to appear on each printed page, first freeze the relevant rows or columns in the sheet. Then on a computer choose File > Print > Headers & footers and select Repeat frozen rows or Repeat frozen columns. See Google’s print settings instructions.

Best Value
Illustrator Mousepad, Adode AI Shortcuts Mouse pad, Keyboard Shortcut Mat for Adode llustartor, Large Size Desk Mat Mousepad, Spreadsheet Keyboard Mat, Non-Slip, Stitched Edge,31.5"x15.7"
  • UNIQUE DESIGN for illustrator. The Large mouse pad with shortcuts specifically designed for illustrator, making it easy for you to use AI and improve work efficiency.
  • LARGE AND PERFECT SIZE. The size of 800x400x3mm (31.5x15.7x1.18inches) will cover the area for a laptop and mouse, providing plenty of room for work or gaming.
  • WELL CATEGORIZED - orderly organized in an easy-to-find arrangement, grouped into frequently used operations such as navigation, selection, formatting, data/functions etc.
  • SEAMLESS & COMFORT – Densely bonded soft fabric with anti-fray stitched edges. This allows more accurate and faster mouse movement, providing a seamless gaming experience
  • PREMIUM QUALITY PRINT with highly durable inks, this desk mat displays sharp and distinct details, ensuring it remains unfaded even after numerous cleanings.
Rank #4
excovip Commands Shortcuts Mouse Pad for ChatGPT-80x30x0.2 cm Extended Large Cheat Sheet Mousepad PC Office Spreadsheet Keyboard Mouse Mat Non-Slip Stitched Edge 0447
  • 【Large Mouse Pad】Our extra-large mouse pad 31.4×11.8×0.07 inch(800×300×2 mm) is perfect for use as a desk mat, keyboard and mouse pad, or keyboard mat, offering you unparalleled comfort and support during long gaming sessions or work days.
  • 【Ultra Smooth Surface】 Mouse Pad Designed With Superfine Fiber Braided Material, Smooth Surface Will Provide Smooth Mouse Control And Pinpoint Accuracy. Optimized For Fast Movement While Maintaining Excellent Speed And Control During Your Work Or Game.
  • 【Highly durable design】-The small office&gaming mouse pad is designed with high stretch silk precision locking edges to avoid loose threads on the cloth. Ensure Prolonged Use Without Deformation And Degumming.
  • 【 Non-slip Rubber Base】-Dense shading and anti-slip natural rubber base can firmly grip the desktop. Premium soft material for your comfort and mouse-control.
  • 【Enhanced Productivity】 Boost your work efficiency with this handy ChatGPT keyboard and mouse mat. No more getting stuck on endless online searches or flipping through textbooks, just glance down for the reference you need.
Rank #3
Excel Cheat Sheet LED Desk Pad | Excel Shortcut Keys Mouse Pad - Colorful RGB Luminous Extended Large Gaming Mousepad| PC Office Spreadsheet Keyboard Mat| Non-Slip Stitched Edge Desk Mat
  • EXCEL SHORTCUTS. INSTANTLY ILLUMINATED. – Keep frequently used commands, formulas and helpful tricks directly beneath your fingertips so you can work faster without breaking focus. Grouped into frequently used operations such as navigation, selection, formatting, data/functions and featuring 10 desk exercise diagrams to reset and recharge.
  • YOUR DESK. SMARTER. BRIGHTER. – Seven vibrant RGB lighting modes glow around all four edges, adding energy and style to work, study or gaming at the touch of a button.
  • EXTRA-LARGE SPACE TO WORK & PLAY – The 31.5 x 13.8-inch surface fits a laptop or keyboard and mouse, while the cushioned 3 mm design creates a comfortable, organized workspace.
  • PRECISION IN EVERY MOVE – The densely woven Pixiecube fabric surface supports fast, accurate mouse tracking, while the heavy-duty natural rubber base grips the desk to prevent slipping and shifting.
  • BUILT FOR REAL-WORLD WORKDAYS – A rugged stitched edge helps prevent fraying, and the water-resistant, stain-resistant surface protects against scratches, spills and everyday wear—because smarter desks should work harder.
Rank #2
Pixiecube Excel Shortcut Keys Mouse Pad - Extended Large XXL Cheat Sheet Gaming Mousepad | PC Office Spreadsheet Keyboard Mat | Non-Slip Stitched Edge
  • EXCEL SHORTCUTS. ZERO SEARCHING. – Our bestselling reference mat puts an extensive collection of commonly used commands, formulas and helpful tricks directly beneath your fingertips, so you can find answers fast, work smarter and stay in the flow.
  • YOUR DESK. SMARTER. – Clearly organized sections for navigation, selection, formatting, data and functions make it easy to find the right Excel command exactly when you need it.
  • AN XXL WORKSPACE THAT WORKS HARDER – With cushioned, 3mm construction, the expansive 35.4 x 15.7-inch Pixiecube desk mat gives you room for a laptop or full-size keyboard, mouse, notes and accessories without feeling crowded.
  • PRECISION IN EVERY MOVE – Densely woven micro-weave fabric supports fast, accurate mouse tracking, while the heavy-duty natural rubber base grips the desk to prevent slipping and shifting.
  • BUILT FOR REAL-WORLD WORKDAYS – A rugged stitched edge helps prevent fraying, and the water-resistant, stain-resistant surface protects against scratches, spills and everyday wear—because smarter desks should work harder.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Leave a Reply

Your email address will not be published. Required fields are marked *

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

More from the Wire

  1. World desk4 min
    How to Spot an AI Voice Scam Before Sending MoneyDon’t rely on how a caller sounds. Pause, call back through a known number, and verify the emergency with another trusted person before sending money.
  2. Mountain View desk4 min
    Google’s SynthID Detector: How to Check AI-Generated Images, Video and AudioGoogle’s SynthID Detector looks for an embedded watermark in supported images, video and audio. Here is what its results do—and do not—show.
  3. Redmond desk20 min
    How to create a link to File or Folder in Windows 11Windows 11 gives you several ways to point to a file or folder without moving or duplicating it. You can create a desktop shortcut,…
Recommended PC Tool
Recommended PC Tool
Windows Errors? Fix Them Before They SpreadFree repair scan
Crashes, No Sound, or Screen Glitches?Free driver scan

Two free Windows tools

One Free Minute Could Fix That PC

Before you go - each of these free tools takes about a minute and tackles what quietly slows a Windows PC down.

Special offer. View Outbyte info, uninstall instructions, EULA, and Privacy Policy.