Excel 2024: Fast Worksheet Copy

February 26, 2024 - by Bill Jelen

Excel 2024: Fast Worksheet Copy

Yes, you can right-click any sheet tab and choose Move or Copy to make a copy of a worksheet. But that is the very slow way to copy a worksheet. The fast way: Hold down the Ctrl key and drag the worksheet tab to the right.

The downside of this trick is that the new sheet is called January (2) instead of February but that is the case with the Move or Copy method as well. In either case, double-click the sheet name and type a new name.

Ctrl+drag February to the right to create a sheet for March. Rename February (2) to March.

Select January. Shift+select March to select all worksheets. Hold down Ctrl and drag January to the right to create three more worksheets. Rename the three new sheets.

continue reading »

More Reading

Excel 2024: The Fill Handle Does Know 1, 2, 3…

Excel 2024: The Fill Handle Does Know 1, 2, 3… »

February 22, 2024 - by Bill Jelen

Why does the Excel Fill Handle pretend it does not know how to count 1, 2, 3? The Fill Handle is great for filling months, weekdays, quarters, and dates. Why doesn't it know that 2 comes after 1?

Excel 2024: Total the Visible Rows

Excel 2024: Total the Visible Rows »

February 20, 2024 - by Bill Jelen

After you've applied a filter, say that you want to see the total of the visible cells.

Excel 2024: Filter by Selection

Excel 2024: Filter by Selection »

February 17, 2024 - by Bill Jelen

The filter dropdowns have been in Excel for decades, but there are two faster ways to filter. Most people select a cell in the data, choose Data, Filter, open the dropdown menu on a column heading, uncheck Select All, and scroll through a long list of values, trying to find the desired item.

read more articles »

Featured Products

Cool Excel Sh*t

March 2021

Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.

Supercharge Power BI - 3rd Edition

February 2021

Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.

Microsoft 365 Excel: The Only App That Matters

June 2022

Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!

MrExcel 2021 - Unmasking Excel

February 2021

This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.

see more products »