Loading…
Loading…
Data often comes in separate blocks. Ctrl+A inside a block selects just that block. Ctrl+Shift+Arrow stops at the end of a block, and pressing it again hops over the gap to the next block. Combine these to select exactly what you need, for example the data without its header.
Example: From A2, Ctrl+Shift+→ then Ctrl+Shift+↓ selects the table body and leaves the header row out.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.