Wednesday, October 23, 2019

Fill Series


11_series_filled_using_fill_command

SOURCE:
https://www.howtogeek.com/279148/how-to-automatically-fill-sequential-data-into-excel-with-the-fill-handle/

Click+drag plus (bottom right corner) for selected cells.
Then, type in fill series
#1-5

Essential Hotkeys

Enter > next column
Tab > next grid
click > drag > format

Ctrl+S - save workbook
Ctrl+O: Open Existing Workbook

Left/Right Arrow: Move one cell to the left or right
Ctrl+Left/Right Arrow: Move to the farthest cell left or right in the row
Up/Down Arrow: Move one cell up or down
Ctrl+Up/Down Arrow: Move to the top or bottom cell in the column
Tab: Go to the next cell
Shift+Tab: Go to the previous cell
Ctrl+End: Go to the most bottom right used cell
Ctrl+W: Close a workbook
Ctrl+O: Open a new workbook
Ctrl+Shift+Space: Select the entire worksheet

Excel Projects

 fhgfghfghfh