TIPS: This shortcut is useful when a column contains a formula that you want to use in every cell in that column. A PC keyboard has a scroll lock key, but a Mac one doesn't appear to. Click on the Freeze Panes button and click on the Freeze Panes option in.
The problem is scroll lock is on, and you need to switch it off again. Then select the Layout tab from the toolbar at the top of the screen. This can be annoying when you were in the middle of navigating around the spreadsheet with arrow keys and then suddenly the sheet starts moving instead. You are commenting using your Facebook account. You are commenting using your Twitter account. New Perspectives Excel 2016 Module 12: SAM Mac Project 1b. You are commenting using your Google account. If the wrong numbers are selected, you can click and drag the mouse to choose the correct cells. If you are using a PC or Windows based laptop, you can make an Excel cell reference absolute or fixed by pressing the F4 function key on the keyboard after the cell reference.
