Until the end of September, Chandoo and I will be offering a free, one-hour bonus video with all purchases of Dashboards for Excel.
Here’s a quick tip before I go. Chances are you already knew it. But I’m never surprised anymore by how much I learn from others even this late in the game. And in case you didn’t already know it, it will make your life easier.
So sometimes I want to copy an entire worksheet tab into a new workbook where it can exists on its own. Previously, I would start up a new workbook, press CTRL+A and copy everything over. This method has its faults: sometimes formats don’t copy over correctly, sometimes what’s being copied is just too large for the clipboard. Turns out, there’s an easier way.
You can right click the worksheet tab you’re interested in and selected Move or Copy….
This brings up the Move or Copy dialog box.
First, you’ll check “Create a copy” at the bottom of the dialog box. In the first dropdown, you’ll select “(new book)”. When you press OK, the entire worksheet will have been copied exactly as it appears into a new workbook. You can also copy the worksheet into an already open workbook by selecting the desired tab from the dropdown.
What a time saver! I wonder how I missed this all those years.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.