jnrmonitor.blogg.se - Paintbrush for mac tips and tricks

Highlight a whole row by holding down the Shift key and hitting Spacebar.

Quickly jump into a cell to edit the contents, by pressing the F2 key.

Toggle between absolute and relative cell references using F4.

Move quickly between your worksheets by holding down the Ctrl key and Page Up or Page Down.

Hold down Ctrl (or Cmd) key and the Shift key with your left hand and the Left or Right or Up or Down Arrow keys. Quickly move around your data ranges by holding the Ctrl key (or Cmd key on a Mac) and the Left or Right or Up or Down Arrow keys.It’s all about reducing your reliance on the mouse and instead harnessing the awesome efficiency of navigating spreadsheets from the keyboard. It’s one of the single best investments of time you can make to further your spreadsheet skills.