Here is a link to the page More Excel Shortcuts I created this with the latest version of Camtasia Studio, which has a new feature that captures keyboard shortcuts, and can show the key combinations in the video.
#2017 EXCEL FOR MAC FLASH FILL HOW TO#
Then it shows how to use a keyboard shortcut, to enter the same date in all the selected cells. The video shows how to create a date series with the Fill handle. To see the steps for filling the dates, watch this very short video. When you use that shortcut, Excel copies the date from the active cell (cell A2), into all the selected cells below. That is the keyboard shortcut for Fill Down.
Keep the range of date cells selected (cells A2:A9 in this example). If you want all the date cells to have the same date, do one more step: When you double-click the Fill handle, Excel automatically fills the dates down to the first blank cell in the next column.īy default, the dates are entered in a series of 1 day intervals. When the pointer changes to a small black plus sign, double-click. Then point to the Fill handle, which is the small black square at the bottom right corner of the selection. See how to AutoFill Excel dates in series or same date, with just a couple of clicks.Įnter the first date in the date column - cell A2 in this example. Then, if there is data in the next column, you can use the Fill handle to quickly enter the rest of the dates. Just enter the first date, in the top cell. If you’re entering dates on an Excel worksheet, you don’t have to enter each date individually.
0 kommentar(er)
