![]() Insert / delete columns and rows - To insert: with an entire row or column selected, use Control+ Shift ++ (Mac: Control + I, but in 2016, same as Win).While not a keyboard shortcut, it's still one of the most powerful features in Excel, because it will copy a formula (or a pattern) down a column to the bottom of a table in one click. Fill handle - double click that little square at the bottom right of any selection.They let you move to the edges of the data instantly, without tedious scrolling. These shortcuts are "must know" if you work with large sets of data. Data navigation - Control + arrow key(s) (Mac: you can also use Command). ![]() (Note: on Macs up to 2011, this shortcut is not as robust). Did you know that many commands can be repeated? You can use this for things like applying the same borders, format, or even to insert a worksheet again. Repeat last action - F4 or Control Y (Mac: Command + Y).Bonus: add the shift key to select everything on the way. Very satisfying when you want to go instantly to the first cell or last cell of a worksheet, no matter where you are. (Mac: fn + Control + left arrow, fn + Control + right arrow.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |