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.
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.
Learning objectives
Open the practice workbook
HANDS-ON PRACTICE
Practice in your own copy
Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.
Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.
The _result workbook shows the complete Item, Qty, Unit price, Line total table and all three rows, with no stray values outside the table.
Hands-on practice
Step 1: Keep only the table that must be printed and confirm no unnecessary blank columns sit inside the print range.
Range A1:D4 is selected in full before printing, including the header row and all three data rows.
Step 2: Choose File > Print, select Current sheet or Selected cells as appropriate, then inspect scaling and margins.
The File menu is open with the pointer directly on the Print command.
Step 3: In preview, confirm all columns are visible on the page before printing or saving as PDF.
Print settings shows Selected cells (A1:D4), with all four columns fitting on one page using Fit to width.
Checkpoint
Item
Qty
Unit price
Line total
Pen
3
5
15
Notebook
2
20
40
Folder
1
12
12
For formula lessons, result cells must be calculated rather than typed manually.
Common mistakes and fixes
Correction: return to the exact range and command named in the steps, then compare the live sheet with the Item, Qty, Unit price, Line total source fields.
Independent practice
Add one row with the same schema, repeat the action, verify the new row behaves correctly, then remove it to restore the sample.
Key takeaways
✓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.
✓Keep only the table that must be printed and confirm no unnecessary blank columns sit inside the print range.
✓Choose File > Print, select Current sheet or Selected cells as appropriate, then inspect scaling and margins.
✓If the result differs, repeat “Keep only the table that must be printed and confirm no unnecessary blank columns sit inside the print range.” and then “Choose File > Print, select Current sheet or Selected cells as appropriate, then inspect scaling and margins.”. Verify the working table still uses Item, Qty, Unit price, Line total before changing source values.
✓Add one row with the same schema, repeat the action, verify the new row behaves correctly, then remove it to restore the sample.
QUICK CHECK
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Understand cell references.