LXLogicExcel
🔥
0
0
Mit Tabellen arbeiten

Lektion 1 von 5

Moving around a worksheet and entering data

Was du danach kannst

Navigate the grid with the keyboard, read the Name Box and status bar, and add a row of data without breaking the sheet.

Ridgeline Hardware emails you twelve order lines every fortnight. Before you calculate anything you need to be able to move around them without reaching for the mouse, and add a line when one comes in late.

0 XP

Schritt 1 von 6 · 1 Punkt

You are somewhere down in the Orders sheet and you want to get back to A1. Press the shortcut that jumps to the top-left cell.

ABCDEFGHIJ
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 10 to 13 of 13

Halte die Zusatztasten und drücke dann die letzte Taste. Wir lesen sie direkt von deiner Tastatur.

Strg+Pos1