One Day is the Same as Another

By now, you probably know you can use the fill handle to create a series of days. Simply enter the first day or abbreviation (Mon, Tues, and so on). Then, select that cell’s fill handle and select the target cells. Excel will respond by entering the appropriate days or abbreviations to create a days-of-the-week series.

But what if you don’t want to create a series? Suppose you want to copy that particular day of the week instead of creating a series. Don’t worry–the solution is simple. Hold down the Ctrl key while you drag the fill handle across the target cells.


About The Author