Google Sheets Basics: How to Freeze Rows, Add Columns & Master Essential Sheet Controls (Beginner Guide)

Learn Google Sheets basics like freezing rows, adding columns, and essential sheet controls with simple step-by-step instructions for beginners.

Google Sheets is a free online spreadsheet tool by Google that lets you organize data, create reports, track expenses, manage tasks, and a lot more. Students, businesses, and professionals alike use it daily to stay organized.

However, for many beginners, simple tasks such as freezing rows, adding columns, or adjusting layouts can prove to be difficult. Mastering these basic skills is crucial for making your sheet easier to read, organize, and manage.

In this Google Sheets tutorial, you will learn the most important Google Sheets basics in a step-by-step, easy-to-follow guide.

How to Freeze Rows in Google Sheets

Freezing rows keeps selected rows visible even when you scroll down. It is extremely useful for headers so you don't lose track of your column labels.

• Open your Google Sheet.
• Click on View from the top menu.
• Go to Freeze.
• Select 1 row (or more if needed), or choose Up to current row.

Example: If your sheet has a header like Name, Email, and Age, freezing the first row keeps it visible while scrolling through hundreds of entries.

How to Freeze Columns in Google Sheets

Freezing columns keeps selected columns fixed while you scroll horizontally. This is ideal for keeping primary identifiers like names or IDs visible at all times.

• Click View in the top menu.
• Go to Freeze.
• Choose 1 column or Up to current column.

Example: If the first column has student or customer names, freezing it helps you track their corresponding monthly data easily as you scroll right.

How to Add a Column in Google Sheets

Adding a new column allows you to expand your dataset and organize more variables side-by-side.

• Right-click on a column letter (like A, B, C) at the top of your sheet.
• Click Insert 1 column left or Insert 1 column right.

Example: Easily insert a 'Phone Number' column next to an existing 'Email' column without rewriting any data.

How to Add a Row in Google Sheets

Adding a new row creates space for extra entries in your dataset, keeping everything in chronological or alphabetical order.

• Right-click on a row number on the left side of your sheet.
• Click Insert 1 row above or Insert 1 row below.

Example: Insert a new row to add a new student or employee record exactly where it belongs.

How to Adjust Column Width in Google Sheets

Adjusting column width changes the size of the column to fit your content properly and prevent text from getting cut off.

• Hover between two column letters until the cursor turns into a double-headed arrow.
• Drag left or right to adjust size manually.
• OR double-click the border to automatically fit the longest cell content in that column.

Example: Double-clicking the boundary of an email column will expand it so that long email addresses fit cleanly and remain fully readable.

How to Adjust Row Height in Google Sheets

Adjusting row height changes the vertical size of rows, which is useful when a cell contains multi-line text or custom formatting.

• Hover between two row numbers on the left until the cursor changes.
• Drag up or down to set the desired height.
• OR double-click the border to auto-adjust based on content height.

Example: Increase row height for headers or rows containing wrapped text notes to improve readability.

How to Delete Blank Rows in Google Sheets

Removing empty rows cleans up your dataset, makes scrolling faster, and keeps your spreadsheet looking professional.

• Select the blank rows by clicking and dragging over their row numbers.
• Right-click on any selected row number.
• Click Delete rows.

Example: Clean up unused empty space at the bottom or middle of a report to improve load performance.

How to Merge Cells in Google Sheets

Merging cells combines multiple adjacent cells into one larger cell, which is perfect for creating banners or main headers.

• Select the range of adjacent cells you want to merge.
• Click Format in the top menu, then go to Merge cells.
• Choose Merge all, Merge horizontally, or Merge vertically.

Example: Create a large centered title like 'Q1 Financial Summary' spanning across columns A to G.

Conclusion

In this Google Sheets basics guide, you learned how to freeze rows and columns, add rows and columns, change column width and row height, delete blank rows, and merge cells. These are some of the most critical foundational skills to learn.

Although these actions may seem simple, they play a huge role in making your spreadsheets clean, organized, and easy to understand. As you practice more, you will become comfortable with advanced features like formulas, charts, filters, and pivot tables.