Back at the desktop level, we don’t want to be interrupted by SH, so let’s create a temporary view: With the sheet you want to view active, click the View tab. In the Sheet View group, click New.

To create the attendance sheet for the next month, copy the entire data to a new page in Excel and change the dates. The respective days’ names will change automatically. Now, you have to enter ...

Step 6: You’ll be taken back to your spreadsheet’s main view. From here, simply select the range of cells by dragging the cursor from the first cell down to wherever your last cell is located.

Excel's dominance as a spreadsheet has yet to be truly tested, certainly not by Corel's Quattro Pro (still sold today in WordPerfect Office), the open-source LibreOffice, or Apple's Numbers.