Resources

Learn

Bite-sized guides for real spreadsheet problems.

Pending sharing screen with Viewer selected and the cursor on the role dropdown; the invitation is unsent and the complete A1:C3 table remains visible.

troubleshooting

Fix spreadsheet sharing access errors

Diagnose Google Sheets sharing failures by checking who has access, General access, and the recipient role without broadening permissions unnecessarily.

11 min readRead guide ↗

Google Sheets showing the full Task, Hours, Rate, Cost sample table used to diagnose a protected-cell edit problem.

troubleshooting

Fix protected cell edit errors

Diagnose why a protected Google Sheets cell cannot be edited, confirm the protected range, and choose the right permission fix without removing protection from unrelated cells.

8 min readRead guide ↗

Verified group/ungroup rows evidence for step 1

beginner-guides

Group and ungroup rows

Complete “Group and ungroup rows” using the visible Category, Item, Amount sample so each action and the final state can be checked against the source data.

7 min readRead guide ↗

Verified hide/unhide-column evidence for step 1

beginner-guides

Hide and unhide rows and columns

Complete “Hide and unhide rows and columns” using the visible Item, Internal ID, Status sample so each action and the final state can be checked against the source data.

6 min readRead guide ↗

Filter-view evidence for step 1 — 00-range-selected.png

beginner-guides

Use filter views with collaborators

Complete “Use filter views with collaborators” using the visible Task, Owner, Status sample so each action and the final state can be checked against the source data.

7 min readRead guide ↗

Verified assign/resolve comment evidence for step 1

beginner-guides

Resolve comments and assign tasks

Complete “Resolve comments and assign tasks” using the visible Task, Owner, Status sample so each action and the final state can be checked against the source data.

7 min readRead guide ↗

Verified Note/Comment evidence for step 1

beginner-guides

Add notes and comments to cells

Complete “Add notes and comments to cells” using the visible Task, Owner, Status sample so each action and the final state can be checked against the source data.

6 min readRead guide ↗

Initial Task and Status source data in the _result workbook.

beginner-guides

Use data validation for clean entry

Complete “Use data validation for clean entry” using the visible Task, Status sample so each action and the final state can be checked against the source data.

7 min readRead guide ↗

Date/time evidence for step 1 — 00-initial.png

beginner-guides

Enter dates and times correctly

Complete “Enter dates and times correctly” using the visible Event, Date, Time sample so each action and the final state can be checked against the source data.

7 min readRead guide ↗

Range C2:C4 selected for applying the custom percentage format.

beginner-guides

Create custom number formats

Complete “Create custom number formats” using the visible Item, Amount, Rate sample so each action and the final state can be checked against the source data.

6 min readRead guide ↗

Initial A1:B4 table with Date and Daily sales before using the fill handle.

beginner-guides

Use fill handle and autofill

Complete “Use fill handle and autofill” using the visible Date, Daily sales sample so each action and the final state can be checked against the source data.

6 min readRead guide ↗

Cell I4 selected; the formula bar shows =$B4*I$1 to prove the copied mixed-reference behavior.

beginner-guides

Use relative absolute and mixed references

Complete “Use relative absolute and mixed references” using the visible Item, Qty, Unit price, Line total sample so each action and the final state can be checked against the source data.

8 min readRead guide ↗

Cells B2:B4 selected in the Example sheet before creating the Amounts named range.

beginner-guides

Create named ranges

Complete “Create named ranges” using the visible Item, Amount sample so each action and the final state can be checked against the source data.

8 min readRead guide ↗

beginner-guides

Undo restore and version history

Complete “Undo restore and version history” using the visible Task, Status sample so each action and the final state can be checked against the source data.

6 min readRead guide ↗

beginner-guides

Use keyboard shortcuts efficiently

Complete “Use keyboard shortcuts efficiently” using the visible Task, Owner, Status sample so each action and the final state can be checked against the source data.

6 min readRead guide ↗

beginner-guides

Find and replace spreadsheet values

Find a specific value in the sample table and replace only the intended matches while keeping unrelated cells unchanged.

6 min readRead guide ↗

beginner-guides

Use smart chips in a spreadsheet

Complete “Use smart chips in a spreadsheet” using the visible Task, Owner, Due sample so each action and the final state can be checked against the source data.

6 min readRead guide ↗

beginner-guides

Create checkboxes for task lists

Complete “Create checkboxes for task lists” using the visible Task, Done sample so each action and the final state can be checked against the source data.

6 min readRead guide ↗

Before auto-fit: columns A:C with column B intentionally narrow and its longer descriptions clipped

beginner-guides

Resize and auto-fit columns

Complete “Resize and auto-fit columns” using the visible Task, Long description, Status sample so each action and the final state can be checked against the source data.

7 min readRead guide ↗

beginner-guides

Apply alternating colors to tables

Complete “Apply alternating colors to tables” using the visible Item, Category, Amount sample so each action and the final state can be checked against the source data.

6 min readRead guide ↗

beginner-guides

Merge cells without losing data

Complete “Merge cells without losing data” using the visible Quarterly review, , sample so each action and the final state can be checked against the source data.

5 min readRead guide ↗

Verified wrapping/alignment evidence for step 1

beginner-guides

Wrap text and align cells

Complete “Wrap text and align cells” using the visible Task, Long description, Status sample so each action and the final state can be checked against the source data.

6 min readRead guide ↗

Verified insert/delete-cell evidence for step 1

beginner-guides

Insert and delete cells safely

Complete “Insert and delete cells safely” using the visible Item, Owner, Status sample so each action and the final state can be checked against the source data.

7 min readRead guide ↗

The duplicated tab has been renamed Archive.

beginner-guides

Rename duplicate and color sheet tabs

Complete “Rename duplicate and color sheet tabs” using the visible Task, Owner, Status, Due sample so each action and the final state can be checked against the source data.

7 min readRead guide ↗

beginner-guides

Move and copy rows and columns

Complete “Move and copy rows and columns” using the visible Item, Owner, Status sample so each action and the final state can be checked against the source data.

8 min readRead guide ↗

Cell D2 is selected; the name box shows D2, the formula bar shows =B2*C2, and the result is 15.

beginner-guides

Use the formula bar and name box

Complete “Use the formula bar and name box” using the visible Item, Qty, Price, Total sample so each action and the final state can be checked against the source data.

7 min readRead guide ↗

The pointer is directly on the Bold toolbar button while A2 is selected.

beginner-guides

Navigate the Sheets toolbar

Complete “Navigate the Sheets toolbar” using the visible Task, Owner, Status, Due sample so each action and the final state can be checked against the source data.

6 min readRead guide ↗

The File menu is open with the pointer directly on the Print command.

beginner-guides

Print and export a sheet

Complete “Print and export a sheet” using the visible Item, Qty, Unit price, Line total sample so each action and the final state can be checked against the source data.

8 min readRead guide ↗

The Import file dialog shows the CSV, Import location = Insert new sheet(s), Separator type = Detect automatically, and the Import data button.

beginner-guides

Import CSV files

Import the CSV into separate Order, Region, Amount columns without overwriting the existing sheet or collapsing the file into one column.

7 min readRead guide ↗

beginner-guides

Understand cell references

Complete “Understand cell references” using the visible Item, Qty, Unit price, Line total sample so each action and the final state can be checked against the source data.

8 min readRead guide ↗