LXLogicExcel
🔥
0
0
Working With Sheets

Lesson 1 of 5

Moving around a worksheet and entering data

What you will be able to do

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

Step 1 of 6 · 1 point

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

Hold the modifiers, then press the last key. We read it straight from your keyboard.

Ctrl+Home