So if, for example, we start in Cell C5 and Press Ctrl+ Shift+ Home, the following range will be selected. Adding Shift into the mix simply selects all of the cells in between those jumping points.
KEYBOARD SHORTCUTS FOR EXCEL 2016 FILL CELL HOW TO
Shortcuts 1 and 2 taught us how to jump from whatever cell we are in to the beginning corner (Home) or ending corner (End) of our data range. A small menu will open so you can select one of these: R: Freeze top row. For this shortcut to work, you need to be in text editing mode (indicated by a blinking cursor). To select large amounts of data containing many blanks, I recommend checking out this post for some alternatives:Ģ Keyboard Shortcuts to Select a Column with Blank Cells 6. Here are the most useful shortcuts I’ve found for Excel: Alt + Enter: Add line break in cell. If so, this method may not be your best option.
![keyboard shortcuts for excel 2016 fill cell keyboard shortcuts for excel 2016 fill cell](https://www.lifewire.com/thmb/klPRTLtb-2OOSWVLvlSxoDr1FQg=/1766x1178/filters:no_upscale():max_bytes(150000):strip_icc()/AutoFillSolution-5bdf35d9c9e77c005178859d.jpg)
However, sometimes a column can have many blank cells. This process only selects cells that come before a blank cell. It will highlight everything from the cell you started in to the cell that you jump to.Īs before, the same concept applies using arrows that go in other directions. Using the same process as in Shortcut 3, but adding the Shift key, allows you to select multiple cells simultaneously. The keyboard shortcut to select multiple cells in a contiguous range is: That will jump you down to the last cell in the contiguous set of data for that column. Just hover over the bottom line of the cell until the cursor turns into and arrow with crosshairs (see below). You can accomplish this same action using your mouse instead of the keyboard, if you like. And of course, holding Ctrl while using the left or right arrow key accomplishes the same action horizontally instead of vertically.
![keyboard shortcuts for excel 2016 fill cell keyboard shortcuts for excel 2016 fill cell](http://www.thecompanyrocks.com/wp-content/uploads/2011/09/Excel-Keyboard-Shortcuts-to-Enter-Data.png)
Repeating this process will move you further down the column to just before the next blank cell.Ĭtrl+ ? will reverse that process in the upward direction. 7 Keyboard Shortcuts For Quick Cell Selection Shift + Arrow Keys Expands the selected range in the direction of the arrow key. Whenever we want to make the text all caps (uppercase), we must select the corresponding cells and press the shortcut Ctrl + Shift + A using the keyboard. Microsoft Excel: Intermediate / Advanced. How to Use Flash Fill in Excel to Clean or Extract Data (Beginner's Guide) Automatically Sum Rows and Columns Using the Quick Analysis Tool. For example, if you start at the top of a column and then press Ctrl+ ? you will jump to the last cell in that column before an empty cell. How to Fill Blank Cells in Excel with a Value from a Cell Above.
![keyboard shortcuts for excel 2016 fill cell keyboard shortcuts for excel 2016 fill cell](https://i.ytimg.com/vi/9FWWKAb80KU/maxresdefault.jpg)
Using Ctrl along with your arrow keys allows you to move to the beginning or end of contiguous data in a row or column. To insert a comment using a keyboard shortcut. The keyboard shortcut to select the last cell in a contiguous range is: Worksheet cells with embedded comments are easy to recognize by their red triangle in the upper right of a cell.