Select both of the cells you want to use as the beginning of your series.
EXCEL KEYBOARD SHORTCUT TO FILL SERIES SERIES
To fill the series with just data and not the formatting select Fill Without Formatting.ĪutoFill can be used to more then one row at a time. By default copying brings the formatting as well. To fill only the formatting and no data, select Fill Formatting Only.īy using AutoFill, it is easy to copy C2 to D2. In this case Fill Days is the same as Fill Series. When you use AutoFill, it will default to Fill Series or Copy Cells depending on your data type. If you want to display every day of the week, this option is called Fill Days. This shortcut works over hundreds and thousands of cells, making it one of the most powerful shortcuts in Excel.
Now every subsequent weekday is displayed for 7 days without typing. Fortunately, this is an option that will be displayed by selecting the down arrow in the tan box to the right of our data.īy selecting Fill Weekdays in the drop-down menu, cells A7 and A8 change from Saturday and Sunday to Monday and Tuesday. Because Monday was selected, Excel knows we are looking at days of the week and it is filling the series through Sunday.Įxcel filled the cells with each subsequent day of the week. A preview of what Excel will put in the last cell is displayed just to the right of the cursor. Then click and drag that corner down or across to fill those blank cells with your data.
EXCEL KEYBOARD SHORTCUT TO FILL SERIES PLUS
The cursor will change shape to look like a bold plus symbol. Then put your cursor over the lower right-hand corner of those cells. To start using AutoFill, select the cell or cells you want to copy or use for the start of a pattern.
0 kommentar(er)
