Recommended Free Tools
The most useful Google Sheets improvements are simple controls used in the right order: freeze the labels you need, standardize what people enter, narrow data with filters, summarize it with a pivot table, and reserve formulas for calculations that must remain repeatable. If your account includes Gemini, natural-language prompts can handle many of those setup and editing tasks, but every suggested change still needs a human check.
This guide gives you seven workflows, with exact examples and the limits that matter when you are working in a shared spreadsheet.
As an Amazon Associate I earn from qualifying purchases.
Choose the right Sheets technique for the job
Start by identifying the problem rather than reaching for the newest feature. The table below maps common needs to the control that addresses them most directly.
| Need | Best fit | Why it fits | What to watch |
|---|---|---|---|
| Keep labels visible in a long or wide sheet | Freeze rows or columns | Headers and identifiers remain on screen while you scroll | Freeze only the rows and columns that provide useful context |
| Prevent inconsistent categories | Dropdowns | People choose from a controlled list instead of typing variations | Change the list deliberately when categories evolve |
| Represent a yes/no state | Checkboxes | A checked or unchecked cell is easy to scan and filter | Use them for two-state values, not multi-stage statuses |
| Focus on a subset of records | Filters and sorting | You can isolate qualifying rows and order them by a meaningful field | Confirm which range the filter applies to before editing |
| Group and total records | Pivot tables | They turn row-level data into summaries such as sales by region | Keep source columns consistent so groups do not split unexpectedly |
| Repeat an arithmetic or lookup rule | Formulas | The result recalculates when source cells change | Check references and preserve a clear source range |
| Draft or transform text with plain language | Gemini or the AI function | Natural-language instructions can speed up setup and text work | Generated output requires review and may be limited by your plan or feature rollout |
1. Use Gemini for natural-language spreadsheet actions
When Gemini in Sheets is available on your account, you can describe an outcome instead of assembling every menu command yourself. Google says it can create tables and formulas, generate analysis and insights, build charts and graphs, and perform edits such as conditional formatting, pivot tables, dropdowns, checkboxes, sorting, filtering, find-and-replace, number formatting, and inserting, deleting, or freezing rows and columns.
#1 Best Overall
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
Check access before planning around Gemini
Gemini actions require an eligible Google Workspace or Google AI plan. Availability, labels, and behavior can vary as Google rolls features out, so a missing Gemini control is usually an account or rollout issue rather than a problem with your sheet.
Write prompts that name the range and the result
A useful prompt specifies the table, the field to change, and the desired result. For example:
Freeze the top rowLock the first two columnsFilter for sales greater than $1,000Sort by date in descending orderCreate a dropdown for the Status column with Not started, In progress, and DoneInsert checkboxes in the Completed columnCreate a pivot table showing total sales by region in a new sheet
If several tables are visible, identify the table range or its header names. Gemini operates on one table range at a time, so an instruction that spans unrelated blocks can produce an incomplete result.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Use the preview as a checkpoint
Gemini presents an action preview before applying an edit. Read the proposed range, values, and formatting; select Apply only when the change matches your intent. If the result is wrong, use Undo immediately, then narrow the prompt and try again. The preview is especially important for structural edits that insert, delete, or reformat cells.
2. Freeze headers and identifier columns
Scrolling removes the context that tells you what a number means. Freezing the header row keeps field names visible in a long list; freezing identifier columns keeps a customer name, order number, or project code beside the values you are reviewing.
Rank #2
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
Freeze from the Sheets menus
- Open the sheet and select the row or column boundary you want to keep visible.
- Choose View > Freeze.
- Select 1 row or 2 rows for headers, or choose the required column count for identifiers.
- Scroll down and across to verify that the intended labels remain in place.
For a table with a single header, freeze the top row. For a wide operational sheet, freezing the first one or two identifier columns is usually enough; freezing too much of the canvas reduces the space available for the data itself. If Gemini is enabled, the equivalent prompts are “Freeze the top row” and “Lock the first two columns.”
3. Standardize entry with dropdowns and checkboxes
Free typing creates near-duplicates such as In progress, In-Progress, and in progress. Those differences break filters, pivot groups, and summaries. A dropdown turns a category into a controlled choice. A checkbox is better when the value has exactly two states, such as completed versus not completed.
Create a dropdown for a category
- Select the cells, column, or table range that should share the choices.
- Open Data > Data validation (the label may appear as a dropdown-related command in the current Sheets interface).
- Choose a dropdown rule and enter one option for each permitted category.
- Save the rule, then test it in a blank cell and an existing record.
Keep the option text short and mutually exclusive. If an item can move through several stages, use a dropdown such as Not started, In progress, and Done rather than trying to encode the stages in a checkbox.
Add a checkbox for a two-state field
- Select the target cells.
- Choose Insert > Checkbox.
- Use the checked state for the positive condition and leave it unchecked for the negative condition.
- Filter or calculate from that column consistently; do not mix words such as
yesanddoneinto the same field.
Gemini can create either control from a prompt and show the proposed edit before it is applied. Current Gemini editing does not support multi-select dropdowns, so use separate columns or another documented structure when a record genuinely needs several labels.
4. Filter and sort before you analyze
Analysis becomes clearer when the working set is explicit. A filter hides rows that do not meet a condition without deleting them. Sorting then puts the remaining records in an order that supports the question you are asking, such as newest date first or highest revenue first.
Rank #3
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
Set up a filter safely
- Click inside the table, including its header row.
- Choose Data > Create a filter.
- Open the filter control in the relevant header.
- Select values or conditions that define the active set, then apply them.
Before filtering, confirm that the range includes every row and column in the table. A blank header, an isolated total, or a second table immediately beside the first can cause Sheets to infer the wrong range.
Sort on a field that answers the question
Sort by a meaningful field and choose ascending or descending order deliberately. “Sort by date in descending order” surfaces the latest records; “Filter for sales greater than $1,000” removes lower-value rows from the current view. Avoid sorting a single column inside a related table, because that separates values from the records they belong to. Select the complete table or use the table’s sort command.
Filtering and sorting change the view or order of the source records; they do not replace a grouped summary. When the question is “How much in total for each region?” move to a pivot table instead.
5. Summarize grouped data with a pivot table
A pivot table converts repeated row-level records into a summary. Typical uses include total sales by region, task counts by status, or expense totals by month. It is useful when you need to compare groups without writing a separate formula for every category.
Build a pivot from a clean source range
- Click any cell in the source table.
- Choose Insert > Pivot table.
- Confirm the source range and choose a new sheet or a specified destination range.
- Add a field to Rows for the group, such as Region or Status.
- Add a numeric field to Values, then choose the required aggregation such as sum or count.
- Add a field to Columns or Filters only when it helps answer a specific comparison.
Every source column should have a clear header, and values that represent the same category should use identical spelling. Otherwise one logical group can appear as several pivot rows. If the source grows over time, include a range that covers the expected records or update the pivot source deliberately.
Rank #4
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
Ask Gemini for the structure when it is available
A prompt such as Create a pivot table showing total sales by region in a new sheet tells Gemini both the measure and the grouping. Review the proposed source range and destination before applying it. Gemini can create a pivot in a new sheet or a specified range, but the one-table-range limitation still applies.
6. Keep calculations in formulas and use the AI function for text drafts
Use ordinary formulas when the result must be deterministic, auditable, and recalculated whenever source values change. Totals, percentages, date differences, lookups, and conditional calculations belong in formula cells with visible references. Keep those formulas separate from manually typed notes so another person can trace the logic.
Make repeatable calculations inspectable
- Place a clear header above every calculated column.
- Keep the source fields in stable columns and fill the formula through the complete data range.
- Check that relative and absolute references behave as intended when the formula is copied.
- Test a known row and an edge case, such as a blank or zero value, before relying on the entire column.
Gemini can create a formula from a plain-language description, but inspect the references and the resulting expression just as you would inspect a formula written by hand.
Use the AI function for language-heavy work
Google’s September 5, 2025 product announcement describes the AI function as a way to categorize, summarize, or generate text across a specified range. That makes it useful for drafting labels, short summaries, or classifications from text-heavy cells. It is not a substitute for a controlled calculation: generated wording can require interpretation, and a category that affects reporting should be checked against your allowed values.
Free tools Windows power users keep installed
One-click scans. No signup required.
Review generated text for factual accuracy, tone, missing context, and consistency before sharing it or using it to drive a business decision. Keep the original text in a separate column so the generated version can be compared or regenerated without losing the source.
Best Value
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
7. Review, protect, and recover your workflow
Speed is valuable only when an edit is reversible and the underlying records remain trustworthy. Treat every automated or collaborative change as a proposed change to a data model, not as an unquestionable answer.
Use a review sequence before sharing
- Keep raw imports or manually collected records on a separate source sheet.
- Give headers and ranges unambiguous names so prompts and formulas target the intended table.
- Preview Gemini actions and verify the affected range, values, and formatting before selecting Apply.
- Spot-check totals, category counts, and a few original records after a structural edit.
- Use Undo as soon as you detect an unwanted change, then rerun a narrower instruction.
- Share the cleaned or summarized output rather than exposing an editable raw-data area when collaborators do not need it.
Know the current Gemini boundaries
The May 13, 2025 Google Workspace update lists editing options including dropdowns, conditional formatting, pivot tables, filters, and sorting, while noting limited conditional-formatting options and no multi-select dropdowns. The October 16, 2025 update reports that Gemini can execute multiple actions from one prompt, including chained formatting, cleaning, and structural edits. Because these capabilities are being rolled out and can change, verify the preview and the final sheet rather than assuming that a prompt will behave identically in every account.
A repeatable workflow for a new spreadsheet
For a new dataset, the following order minimizes rework:
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →- Preserve the import on a raw-data sheet and identify the complete table range.
- Freeze the header and any key identifier columns.
- Apply dropdowns and checkboxes to fields that need controlled entry.
- Check for inconsistent labels, blanks, and mixed data types.
- Use filters and sorting to inspect the records relevant to the immediate question.
- Add formulas for recurring calculations and test them on known examples.
- Create a pivot table when the question is about totals or counts by group.
- Use Gemini or the AI function for natural-language setup and text drafts only where the account supports them, then review the result.
- Protect the source area, label the output, and share the version that has passed your checks.
Troubleshooting common failures
The filter includes only part of the data
Remove the filter, inspect the header row for blanks, and recreate the filter while a cell inside the complete table is selected. Keep unrelated tables separated from the working range.
A pivot table splits one category into several rows
Inspect the source values for capitalization, extra spaces, punctuation, or alternate spellings. Standardize the source with a dropdown or a cleaned helper column, then refresh or rebuild the pivot.
A Gemini edit changed the wrong area
Use Undo, identify the exact table range and field names, and submit a narrower prompt. If the action affects more than one table, run separate prompts because Gemini works on one table range at a time.
Gemini is missing or lacks an expected option
Confirm that the signed-in account has an eligible Google Workspace or Google AI plan. Feature availability and editing behavior can differ during rollout; use standard Sheets menus and formulas when the required Gemini action is unavailable.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Quick Recap
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.
