Solution 2: On USB / Bluetooth keyboards, you can activate the Function Lock shortcut: press Fn + Esc. Solution 1: If you are using a laptop, hold the Fn button for one second. You use the number keys above the letters on the keyboard to press the shortcuts.
This will paste the formula exactly, without changing the cell references, because the formula was copied as text. Select the destination cell, and press Ctl+V. Select the formula in the cell using the mouse, and press Ctrl + C to copy it. : Takes you to the last cell of the row are are currently on. Press F2 (or double-click the cell) to enter the editing mode.: Takes you to the first cell of the row you are currently on.I have not figured out an equivalent for the row navigation and keyboard shortcuts. The closest I have found to this in the smartsheet documentation are the following keyboard shortcuts. Is there a keyboard shortcut that allows this sort of thing in smartsheet - on a Mac? Mac keys: Page down or Function-Down arrow Move to next sheet in workbook. I am a frequest user of these keyboard shortcuts in both Execl and Google Sheets. Read more Move one screen down in worksheet. In both Excel and Google Sheets it is possilbe to do to jump to the last filled non-blank row or column in series of rows/columns which allows quick navigation around a spreadsheet.