![sheet excel sheet excel](http://d13ot9o61jdzpp.cloudfront.net/images/excel_sheet_function.png)
Excel places the copied worksheets just before the worksheet you select. Specify where you want to insert the worksheet.Ĭhoose a destination worksheet from the “Before sheet” list. The resulting workbook has only the worksheets you transferred to it. To do so, choose “(new book)” in the “To book” list. The “To book” menu shows all the currently open workbooks (including the source workbook).Įxcel also lets you move worksheets to a new workbook, which it automatically creates for you. When you move or copy a worksheet, Excel launches the Move or Copy window (shown in Figure 4-8).Ĭhoose the destination file from the “To book” drop-down list. Right-click the selection, and then choose Move or Copy. Excel highlights all the worksheets you select (and groups them together). To transfer multiple worksheets at once, hold down the Ctrl key, and then select all the worksheets you want to move or copy. Right-click the worksheet you want to transfer, and then, from the shortcut menu that appears, choose Move or Copy.
#Sheet excel windows
Remember, you can move from one window to another using the Windows task bar, or by choosing the file’s name from the ribbon’s View→Windows→Switch Windows list.
![sheet excel sheet excel](https://www.lifewire.com/thmb/jql6BdU-pES5IV5MqDUm5d93Jf4=/1920x1280/filters:no_upscale():max_bytes(150000):strip_icc()/ExcelWorksheets-5bcf80bec9e77c00511a56f3.jpg)
The file that contains the worksheet you want to move or copy is called the source file the other file (the one where you want to place the worksheet copy) is the destination file. You’ll also take a look at Find and Replace, an Excel tool for digging through worksheets in search of specific data.
#Sheet excel how to
In this chapter, you’ll learn how to manage the worksheets in a workbook. Each page is called a worksheet, and a collection of one or more worksheets is called a workbook (which is also sometimes called a spreadsheet file). Excel lets you create spreadsheets with multiple pages of data, each of which can conveniently exchange information with other pages. Not only are you likely to lose your spot in the avalanche of data, you’ll face a host of formatting and cell-management problems.įortunately, a better solution exists. But cramming a bunch of tables onto the same worksheet page isn’t the solution. What’s worse is that, with your data scattered in multiple places, you’re missing the chance to use some of Excel’s niftiest charting and analytical tools. If you create these tables in different spreadsheets, you must copy the information you want the sheets to share from one location to another, all without misplacing a number or making a mistake. You create one table summarizing your firm’s yearly sales, another listing expenses, and a third analyzing profitability and making predictions for the coming year.
#Sheet excel professional
That’s great for getting started, but as power users, professional accountants, and other Excel jockeys quickly learn, some of the most compelling reasons to use Excel involve multiple tables that share information and interact with each other.įor example, say you want to track the performance of your company. So far, you’ve learned how to create a basic worksheet with a table of data in it.