Copy the Sheet

Excel offers several ways to copy a worksheet. The quickest and easiest way is to drag the sheet tab.

Click the tab for the sheet you want to duplicate—in this case, the one we named January— to activate it.

Position the mouse pointer on the sheet tab.

Hold down the Ctrl (Windows) or Option (Mac OS) key and drag the sheet tab to the ...

Get Creating Spreadsheets and Charts in Excel: Visual QuickProject Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.