Google Sheets Tools: Right-Click Menu, Alternating Colors, Clean Data, and Basic Track

We are excited to share our latest update: Everyday Spreadsheet Tools and the Spreadsheet Basics Learning Track! Learning formulas is important, but practical skills like setting up neat tables, cleaning messy text, and formatting rows are just as helpful at work.

In this release, we added helpful everyday tools, clean settings dialogs, and a step-by-step 5-part guide for beginners and regular spreadsheet users alike.

1. Right-Click Menu

Right-clicking any cell opens a clean, quick menu with common spreadsheet actions:

• Copy and Paste: Quick Cut (Ctrl+X), Copy (Ctrl+C), and Paste (Ctrl+V) with clear cell outlines.
• Paste Values or Formatting: Paste only numbers without changing cell design, or copy colors without overwriting numbers.
• Add Rows and Columns: Quickly add a row above or below, or add a column to the left or right.
• Move Cells Smoothly: Add or delete cells while shifting neighboring rows or columns into place neatly.
• Quick Formatting: Clear styling with one click, insert checkboxes, or set up simple dropdown lists.

2. Alternating Row Colors

Reading wide tables is now much easier on the eyes. Open the Alternating Colors window from the Format menu to pick from 7 clean color themes (Slate Gray, Ocean Blue, Mint Green, Soft Purple, Forest Teal, Warm Amber, Coral). You can preview the look before applying it with one click.

3. Data Cleanup Tools

Messy data often causes formula mistakes. We added 3 simple cleanup tools under the Data menu:

• Trim Spaces: Removes accidental extra spaces at the beginning, middle, or end of words.
• Remove Duplicate Rows: Finds and removes repeated rows while keeping the original entry safe.
• Split Text into Columns: Breaks full names or combined lines into separate neighboring columns using commas, spaces, or custom symbols.

4. New Learning Track: Spreadsheet Basics

We added 5 hands-on introductory exercises at /exercises for essential foundation skills:

1. Cell Math: Learn everyday math symbols (+, -, *, /) and simple order of operations.
2. Locking Cells: Understand how dollar signs ($A$1) help keep tax rates or fixed numbers locked when copying formulas down.
3. Dragging to Fill: Learn how to drag the corner of a cell to quickly fill numbers, dates, and formulas down a list.
4. Combining Text: Join names, codes, and text together using the & sign.
5. Connecting Sheets: Link numbers and totals across multiple tabs in the same workbook.

5. Smooth Support for Desktop and Mobile

All new menus, dialogs, and shortcuts work smoothly with both your computer keyboard and touch screens on mobile devices.