LXLogicExcel
🔥
0
0
Mit Tabellen arbeiten

Lektion 5 von 5

Printing what you meant to print

Was du danach kannst

Set a print area, fit the sheet to the page sensibly, and repeat headings so page two is still readable.

the branch manager prints this. Right now it would come out over four pages, with the headings only on the first, and column H on a sheet of its own. Ten minutes of page setup is the difference between a report and a pile of paper.

0 XP

Schritt 1 von 6 · 1 Punkt

Set the print area to just the order data and its totals: A1:H13.

Formatierung

ABCDEFGHIJ
1OrderDateBranchProductQtyUnitPriceSales tax rate0.08
240012026-01-05FairviewRomex 12-2 250ft4148.00592640.84
340022026-01-05FairviewRomex 12-2 250ft5148.00
440032026-01-06NorthgateWood primer, 1gal246.75
540042026-01-07NorthgateBall valve 1/2in19.25
640052026-01-07BrooksideCopper pipe 1/2in 10ft131.40
740062026-01-08BrooksideCopper pipe 1/2in 10ft131.40
840072026-01-08BrooksideInterior latex paint, 5gal3138.00
940082026-01-08BrooksideCordless drill 18V5209.00
1040092026-01-09FairviewBall valve 1/2in39.25
1140102026-01-09NorthgateRoller and tray set614.20
1240112026-01-09BrooksideWater heater element 4500W624.10
1340122026-01-10NorthgateCordless drill 18V1209.00
Rows 1 to 13 of 13