In your case make sure you have a formula, and then select in the Formula Bar the cell reference you want to anchor and hit F4 the number of times until you have set the correct anchor preference. Select Last Cell in Contiguous Range The keyboard shortcut to select the last cell in a contiguous range is: Ctrl+ Arrow Key Using Ctrl along with your arrow keys allows you to move to the beginning or end of contiguous data in a row or column. How to Lock All the Cells in an Excel Worksheet By default, when you protect a sheet or workbook, all of the cells will be locked. Recommended Articles This has been a guide to Shortcut Key to. Repeatedly making changes in a model, and waiting each time for Excel formulas to recalculate, can become tiresome. However, there could be shapes charts, slicers, etc.
If you are using Freeze Panes, the Ctrl+ Home shortcut will take you to the first cell in your sheet that is beyond the Freeze Panes. Select cells and ranges that you want to lock, right click and select the Format Cell item from the context menu. I have a notebook with no Scroll Lock key or any shortcut using the 'Fn' key. It was only after poking around did I find out that the Mac keyboard shortcut equivalent is not F4, but Apple key + T. Continue with the financial modelling course extract on Excel keyboard shortcuts Next we look at keyboard shortcuts that help you in Excel. Well, many of the shortcuts in Excel that you use with the Ctrl key on a Windows keyboard is compatible with the Ctrl key for Mac in Excel 2016. Ctrl+1 Changes the format of the selected cells.
I suppose you want to lock certain cells instead of the whole sheets. If this response answers your question then please mark as answer. Select Multiple Cells in Contiguous Range The keyboard shortcut to select multiple cells in a contiguous range is: Ctrl+ Shift+ Arrow Key Using the same process as in Shortcut 3, but adding the Shift key, allows you to select multiple cells simultaneously. Follow the steps below to learn how to lock and protect cells in Microsoft Excel versions 2010, 2007, and 2003. Shift+F6 Move to previous pane. Editor's Note: This tutorial was written for Excel 2016, but still applies to modern versions of Excel.
Ctrl+P Print the current sheet. When the on-screen keyboard appears, click the ScrLk button. Tip: To quickly open the On-screen Keyboard in Windows 10, click the Windows button. Alt+Shift+F2 Saves the current worksheet. Shift+Page Down In a single column, highlights all cells above that which are selected.
You can also double click on that cell reference in the Formula Bar to make it easier to select. This will stop Excel formulas calculating automatically in a large spreadsheet, speeding up your work if you have a large model that has slowed down. This article has also been viewed 130,755 times. Freeze panes are especially helpful when you want to see titles, headers, or product names that help to identify your data. Shift+Up Arrow Extends the highlighted area up one cell. Maybe your keyboard has an F Lock key on it you need to press. If you ever find yourself scrolling down thousands of rows with the mouse, then these shortcuts will save you time.
In the Protect Sheet window, enter a password that's required to unprotect the sheet optional and any of the actions you want to allow users. Right-click on your selection, select Format Cells, and click on the Protection tab. Ctrl+Shift+P Opens the for point size. Ctrl+X Cuts all cells within the highlighted section. You can lock all the cells in a worksheet or specific cells, allowing some parts of the spreadsheet to be changed.
Do you know how to use Excel Shortcuts? Note: To close the on-screen keyboard, click the X in the upper-right corner of the on-screen keyboard. Shift+Page Up In a single column, highlights all cells above that which are selected. F5 Goes to a specific cell. Ctrl+F10 Maximize currently selected window. If you suspect that Scroll Lock is turned on, but Scroll Lock does not appear in the Excel status bar, it may be because the status bar is customized to hide the Scroll Lock status.
Select all the cells you don't want to be locked. Any help would be greatly appreciated. Not the answer you're looking for? Ctrl+3 Puts italics all cells in the highlighted section. While using a Macbook for a period of time in 2013, I realised that there are some differences when using Mac Office and Windows Office. Lock and protect selected cells from viewing by encrypting 1. In a large Excel model calculations can slow down. And of course, holding Ctrl while using the left or right arrow key accomplishes the same action horizontally instead of vertically.