Blog

Tip of the Week: How to Copy Excel Worksheets

Tip of the Week: How to Copy Excel Worksheets

If you have ever invested time and effort into an Excel spreadsheet, then you know how irritating it is to move all of that data to a different sheet. Thankfully, you can easily and accurately copy this data using a simple technique. Here’s how you can do it.

First, you have to choose whether you want to copy an existing worksheet into the same workbook or to a new Excel file. You can do both with relative ease!

Copy Your Worksheet Within the Workbook

To copy a worksheet, all you have to do is right-click the sheet tab of the target worksheet and use the menu which appears. Select Move or Copy…, and after you have done so, you should select Create a copy from the options available. Select OK, and that’s it! You now have your copy, which you can edit and rename as you see fit.

Copy Your Worksheet to a Different Workbook

Copying a worksheet to a different book is a bit more involved, but still manageable. First, you might notice that Excel has this function built right into its user interface, but you will need to have both the current workbook and the target workbook open. On your original worksheet’s window, right-click the sheet tab. Then, you select the Move or Copy… option using the To Book option to locate the new target. You’ll see a list of open workbooks to select from, so find the one you want and make sure Create a copy is selected. Once you’re ready, click OK.

You can also drag one worksheet to another, if you have both workbooks open. To do so, under the View tab, select View Side by Side from the Window group. Doing this tells Excel to split the view in two, allowing for an easier time doing this. You can then click and drag the sheet tab you want to copy from one workbook to the other while holding down the Ctrl key. Without the Ctrl key, you’ll just move the sheet over.

We hope this tip helps you cut down on some of the time you might waste moving data around unnecessarily. To learn more tips and tricks to make the most of your technology, be sure to call us at 603-889-0800.

Related Posts

Social media can be remarkably overstimulating, and for some users this is a problem which is difficult to navigate without giving it up entirely. If you want a nice middle-ground to terminating your account entirely, you can instead curate your news...
One of the big advantages that Mac computers have had over the traditional PC is that they “don’t get viruses,” but how true is this claim, really? Research conducted by Elastic Security Labs proves that this is certainly not the case, discrediting t...
Microsoft Excel is a great tool for keeping data and figures organized…until, that is, you need to scroll down at all, leaving some important headers out of sight. Fortunately, there is a way to keep your headings in view: freezing the panes they are...
All jobs have aspects of them that are simply dull or unengaging. After all, nothing can be exciting all the time. This week we wanted to focus on these rote tasks and what you can do to make them less of an impact on your time and job fulfillment. T...
How often have you been browsing the web on your phone, only to find something that would be legitimately useful for your work—maybe it was a tip you wanted to try out, or a bit of information that would be helpful to know—so you wanted to be able to...
Have you ever found yourself in a position where you wanted to download an email from your inbox? Whether it’s documentation or a different reason, there is a way to download your messages into a PDF. PDFs make for great file-sharing formats, as the ...
For the average business, the database plays a big role. How big of a role? Your business won’t function the way you want it to function without it. In order to manage your databases correctly, you need a solid database management system (DBMS). This...
If you want to optimize productivity, then you’ll want to take a look at the startup page for your Google Chrome web browser. If you change this setting, you can shave off countless minutes every week while you fumble around trying to find your favor...
How often do you receive emails from someone written in another language? We bet the answer is “not often,” but you never know when being able to translate an email might come in handy—especially if you ever do business overseas. Let’s go over the bu...

In what seems to be the final stage of a plan that Microsoft has been inching towards for years, Microsoft Office will apparently be phased fully into the Microsoft 365 brand. Let’s consider what we know so far about this change.

When working in your browser, we know how efficiency is extremely important. Like many other pieces of software the developers at Google have baked some keyboard shortcuts to make getting around their browser easier for the average user. Let’s take a...
Businesses that sell goods have always used inventory management, whether using pen and paper or a spreadsheet. In the information age, inventory management is more complex and with a lot of businesses operating on the Internet, it is more important ...

Onsite Service Coverage Area

Although we provide remote services and support to businesses in over 20 states, onsite services are limited to within reasonable driving distance from our offices in NH.  We will manage a local vendor for locations outside of our service area to provide onsite assistance when needed.

 

Onsite Computer Support Services are available to businesses within 60 miles of Nashua New Hampshire. We have excellent onsite coverage from Concord NH, south through Manchester NH, and then down into Boston. From Northern and Central Mass, we cover from Worcester, east to the North Shore, including the Salem NH and Portsmouth NH area.

White Mountain IT Services

 


33 Main St, Suite 302
Nashua, NH 03064

 


121 Riverfront Drive
Manchester, NH 03102

 

Client Help Desk      603-889-2210

New Client Inquiries   603-889-0800

Open Positions