Add a header and the date for each of the columns (assignments) in the range.

Add a header and the date for each of the columns (assignments) in the range.

Cell B2.

Text "Date".

Cell Range C2: S2

Text: "22-Aug, 29-Aug,…12-Dec"

View Answer

Answer: Step 1: Click Cell B2. Type the text: Date

Step 2: Click cell C2. Type the text: 22-Aug

Step 3: Click cell D2. Type the text: 29-Aug

Step 3: Click cell C2, then shift-click cell D2.

Step 4: Copy until cell S2 (by dragging from cell D2 to cell S2).