了解Excel是一项宝贵的技能。但是该工具并不总是易于使用，如果您不完全了解其功能，可能会令人沮丧。Excel工作表与工作簿经常出现这种情况，因为它们是您很容易混淆的术语。事实上，这种混淆导致一些人将工作表称为电子表格。工作簿(Workbooks)和工作表的创建和管理方式不同，因此了解它们之间的区别非常重要。
在本Excel教程中，您将了解工作表和工作簿之间的区别。您还将学习如何操作工作表并将它们从一个工作簿移动到另一个工作簿。此外，如果您想成为高级用户，请务必查看我们的40 个最佳 Excel 键盘快捷键(40 best Excel keyboard shortcuts)和宏，以加快您的工作流程。
工作表和工作簿(Workbooks)有什么区别(Difference Between Worksheets)？
将工作簿想象成一本普通的纸质书；它是页面的集合。Excel工作表只是一页，或者是书中许多页面中的一张。这意味着Excel工作簿是工作表的集合，但它也可以包含单个工作表。您可以在一个工作簿中放入多少个工作表？Microsoft表示这取决于您计算机的硬件。只要您的设备允许，您可以在一个工作簿中包含任意数量的工作表。
当您第一次打开Excel时，该软件会向您显示一个包含三个空白Excel工作表的工作簿。您可以在屏幕的左下角看到它们作为单独的选项卡，分别命名为Sheet1、Sheet2和Sheet3。您可能只需要使用这三个中的一个，但不需要删除您不使用的那些。
Excel工作表由行、列和单元格组成，您可以在其中输入日期、文本、数字以及Excel 公式和函数(Excel formulas and functions)等数据。您在工作表单元格、行和列中输入的数据也可以显示在图形和图表(graphs and charts)中。
您可以使用文件扩展名xlsx将(xlsx)Excel工作簿保存在您的设备上。但是，旧版本的软件使用 xls 扩展名，所以如果您看到这个而不是xlsx(xlsx)，请不要感到惊讶。别担心，任何新版本的Excel都可以打开这两种类型的文件扩展名。
将工作簿中的工作表分组(Grouping worksheets)很方便。您可能希望将包含密切相关数据的工作表保存在一个地方。如果您将数据从一个工作表链接到另一个工作表，工作簿会很方便。(Workbooks)工作簿(Workbooks)就像将不同但相关的文件放在一起的文件夹。但是，从一张工作表跳到另一张工作表可能会非常混乱，这就是为什么您应该学习如何正确管理它们的原因。
如何查看(View)、重命名(Rename)、插入(Insert)和删除(Delete)工作表(Worksheet)
Excel为工作表提供的默认名称不是很具描述性。Sheet1、Sheet2和Sheet3中没有太多信息。因此，您应该首先学习有关工作表的基础知识。
查看工作表
查看单个电子表格所需要做的就是单击其选项卡。但是，如果您使用许多名称较长的工作表，Excel将无法显示所有工作表标签。在这种情况下，您可以使用选项卡左侧的箭头。这些箭头将帮助您向左或向右导航。您也可以右键单击所述箭头，然后将显示所有选项卡的列表。然后您只需单击所需的工作表即可。
重命名工作表
重命名工作表很容易。只需右键单击该选项卡，就会打开一个上下文菜单。选择重命名(Choose Rename)并输入新名称。您也可以双击要重命名的选项卡并键入新名称。
插入新工作表
您(Did)是否注意到工作表选项卡旁边有一个带有文件图标的小选项卡？单击(Click)它，一个新的工作表将出现在最后一个工作表的右侧。这是打开新工作表的最快、最简单的方法。
插入新工作表的另一种方法是选择要插入新工作表的位置右侧的选项卡，然后右键单击并选择插入(Insert)。
将打开一个新的弹出窗口。选择工作表并单击“确定”。
删除工作表
删除工作表很简单。右键单击工作表的选项卡。将出现一个上下文菜单，只需单击删除(Delete)。
如何移动工作表
使用Excel可能会很复杂，您需要在工作簿之间移动不同的工作表或以不同的顺序放置工作表。这是你如何做到的。
在同一工作簿(Same Workbook)中移动工作表(Worksheet)
要将工作表从一个位置移动到另一个位置，请右键单击其选项卡以打开上下文菜单，然后选择移动(Move)或复制(Copy)。将出现一个新窗口，您需要单击将位于所选工作表之后的电子表格的名称，然后单击“确定”。
将工作表移动到同一工作簿中不同位置的最简单方法是在其选项卡上按住鼠标左键，然后将其拖动到您想要的位置。将有一个黑色小箭头指示您可以放下工作表的位置。当您处于所需位置时，松开鼠标按钮。
将工作表(Worksheet)移动到新工作簿(New Workbook)
要将工作表移动到全新的工作簿，请右键单击其选项卡并选择移动(Move)或复制(Copy)。出现新窗口时，打开 To Book(Book)标题下的下拉菜单，然后选择 ( New Book )。
当您将电子表格移动到新工作簿时，Excel会将其从现有工作簿中删除并自动打开一个包含该工作表的新工作簿。
将工作表(Worksheet)移动到不同的工作簿(Different Workbook)
打开包含要移动的工作表的源工作簿。您还必须打开要将所需工作表移动到的工作簿。让它们同时打开。右键单击工作表的选项卡并选择移动(Move)或复制(Copy)。在“To Book”下拉菜单下找到目标工作簿的名称并选择它。按 OK(Press OK)确认。
如何复制工作表
有时您需要复制一份已经存在的工作表。以这种方式进行小的修改更容易，特别是如果您将使用相同的格式或公式。该过程与移动工作表非常相似。
在同一工作簿(Same Workbook)中复制工作表
要复制同一工作簿中的工作表，请右键单击其选项卡并转到“移动(Move)”或“复制”(Copy)。打开新窗口后，选中创建(Create)副本框。您必须选择要在其前面放置副本的工作表的名称。然后单击“确定”进行确认。
在新工作簿(New Workbook)中复制工作表(Worksheet)
如果要在新工作簿中复制工作表，则必须再次转到上下文菜单中的“移动(Move)”或“复制(Copy)”，然后选中“创建(Create)副本”框。在“预订”下单击下拉菜单并选择（新书）。Excel将创建一个包含复制的工作表的新工作簿。
在不同的工作簿(Different Workbook)中复制工作表(Worksheet)
如果需要将工作表复制到不同的工作簿，请打开源工作簿和目标工作簿。右键单击要移动的工作表选项卡，然后转到“移动(Move)”或“复制”(Copy)。当一个新对话框打开时，选中创建(Create)副本框。打开 To Book(Book)下的下拉菜单，然后选择目标工作簿的名称。按确定按钮确认。
如何在Google表格
中打开Excel 文件(Excel File)
不是每个人都喜欢使用Microsoft Excel。Google 表格(Google Sheets)是其最受欢迎的替代品。如果您的同事向您发送了一个Excel文件，您可以在Google 表格(Google Sheets)中毫无问题地打开它。只需(Simply)打开一张空白的Google 表格(Google Sheet)，然后转到“文件(File)”选项卡并选择“打开(Open)” 。在“打开文件(Open File)”菜单中找到并单击“上传(Upload)”选项卡。按住鼠标左键单击 excel 文件并将其拖入空白处。
您还可以点击屏幕中间的浏览(Browse)，然后从那里导航到您想要导入Google 表格的(Google Sheets)Excel表格。选择所需的文件，然后单击“打开(Open)” 。
如何在 MS Excel 中打开 CSV 文件
CSV文件是包含以逗号分隔的信息和数据的简单文本文件。它用于在通常无法直接通信的不同应用程序之间传输数据，例如电子表格内容。例如，此类应用程序是MS Excel和Google Sheets或Microsoft Word。如果您收到CSV文件，您可以按照以下方法使用Excel打开它。
1. 打开要将CSV文件中包含的数据保存到的Excel电子表格。(Excel)单击(Click)“数据(Data)”选项卡并找到“获取外部数据(Get External Data)”组。选择来自文本(Text)。
2. 选择您要在Excel中打开的(Excel)CSV文件，然后点击导入(Import)。在弹出的新窗口中单击Delimited，然后单击Next。
3. 在新窗口中，在分隔符下，选中逗号(Comma)框，然后选中下一步(Next)。
4. 另一个窗口将打开，在Column data format下选择General，然后单击Finish。
工作簿(Difference Between Workbooks)和工作表
之间的区别
了解工作簿和工作表之间的区别将帮助您快速浏览两者并轻松管理它们。工作表是MS Excel的核心，一个工作簿中可以有多个工作表。编辑(Editing)和操作数据只能在工作表中进行，而不能在工作簿中进行。了解工作表中的数据量受列数、行数和单元格数的限制也很有趣。工作簿中的数据量没有任何限制。
Microsoft Excel Workbooks and Worksheets: What’s the Difference?
Knowing Excel iѕ a valuable skill. But the tоol іs not always easy to use and can be frυstrating if you don’t fully understand the features. That’s often the cаse with Excel worksheets vs. workbookѕ because they’rе terms that yоu can easily confuse. In fact, this confusion leads to some people referring to worksheets as spreadsheets. Workbooks and worksheets are created and managed differently, so it’s esѕential to know the difference between them.
In this Excel tutorial, you’ll learn what is the difference between a worksheet and a workbook. You will also learn how to manipulate worksheets and move them from one workbook to another. Also, if you want to become a power user, make sure to check out our 40 best Excel keyboard shortcuts and macros to speed up your workflow.
What’s the Difference Between Worksheets and Workbooks?
Imagine a workbook as a regular paper book; it’s a collection of pages. An Excel worksheet is just a single page, or one sheet of the many pages that are in the book. That means that an Excel workbook is a collection of worksheets but it can also contain a single worksheet. How many worksheets can you put in one workbook? Microsoft says that it depends on your computer’s hardware. You can have any number of worksheets in a workbook, as long as your device allows it.
When you first open Excel, the software will present you with a workbook with three empty Excel sheets. You can see them in the bottom left corner of the screen as separate tabs named Sheet1, Sheet2, and Sheet3. You may need to use just one of these three, but you don’t need to delete the ones you are not using.
Excel worksheets are made of rows, columns, and cells in which you can input data such as dates, text, numbers, and Excel formulas and functions. The data you enter in the worksheet cells, rows, and columns can also be displayed in graphs and charts.
You can save Excel workbooks on your device with the file extension xlsx. However, the older version of the software used the xls extension so don’t be surprised if you see this instead of xlsx. Don’t worry, any new version of Excel can open both types of file extensions.
Grouping worksheets in a workbook is handy. You would want to keep worksheets that contain closely related data in one place. Workbooks are convenient if you are linking data from one worksheet to another. Workbooks are just like folders that keep different but related files together. However, hopping from one worksheet to another can be very confusing, and this is why you should learn how to manage them properly.
How to View, Rename, Insert, and Delete a Worksheet
The default names Excel gives to worksheets are not very descriptive. There is not much information in Sheet1, Sheet2, and Sheet3. So you should first learn the basics about worksheets.
Viewing Worksheets
All you have to do to view a single spreadsheet is to click on its tab. But if you are working with many sheets with longer names, Excel won’t be able to display all the sheet tabs. In that case, you can use the arrows to the left of the tabs. These arrows will help you navigate left or right. You can also right-click on said arrows and a list of all the tabs will be displayed. Then you can just click on the desired worksheet.
Renaming a Worksheet
Renaming a worksheet is easy. Just right-click on the tab and a context menu will open. Choose Rename and type in the new name. You can also double-click the tab you want to rename and type the new name.
Inserting a New Worksheet
Did you notice a small tab with a file icon next to the worksheet tabs? Click on it and a new worksheet will appear to the right of the last one. This is the fastest and easiest way to open a new worksheet.
Another way to insert a new worksheet is to select the tab to the right of where you want to insert a new one, then right-click and select Insert.
A new pop-up window will open. Select the worksheet and click OK.
Deleting a Worksheet
Deleting worksheets is simple. Right-click on the tab of the worksheet. A context menu will appear and simply click Delete.
How to Move Worksheets
Working with Excel can be complex and you will need to move different worksheets between the workbooks or place your worksheets in a different order. Here is how you can do it.
Moving a Worksheet in the Same Workbook
To move the worksheet from one position to another, right-click on its tab to open the context menu, and select Move or Copy. A new window will appear and you need to click on the name of the spreadsheet that will go after the selected worksheet, and click OK.
The easiest way to move the worksheet to a different place within the same workbook is to hold left-click on its tab, and then simply drag it to the spot where you want it to be. There will be a little black arrow indicating the spot where you can drop off the worksheet. Release the mouse button when you are in the desired position.
Moving a Worksheet to a New Workbook
To move a worksheet to a completely new workbook, right-click on its tab and select Move or Copy. When a new window appears, open the drop-down menu under the To Book title, and select (New Book).
When you move a spreadsheet to a new workbook, Excel will remove it from the existing one and automatically open a new workbook that will contain the worksheet.
Moving a Worksheet to a Different Workbook
Open the source workbook that contains the worksheet you wish to move. You will also have to open the workbook to which you will move the desired worksheet. Keep them open at the same time. Right-click on the worksheet’s tab and select Move or Copy. Under the “To Book” drop-down menu find the name of the targeted workbook and select it. Press OK to confirm.
How to Copy a Worksheet
Sometimes you will need to make copies of an already existing worksheet. It is easier to make small modifications that way, especially if you will be using the same formatting or formulas. The process is very similar to moving a worksheet.
Copying a Worksheet in the Same Workbook
To copy a worksheet in the same workbook right-click its tab and go to Move or Copy. Once a new window opens, check the Create a copy box. You will have to select the name of the worksheet in front of which you want to put the copy. Then click OK to confirm.
Copying a Worksheet in a New Workbook
If you want to copy a worksheet in a new workbook you will again have to go to Move or Copy in the context menu and check the Create a copy box. Under “To Book” click the drop-down menu and select (new book). Excel will create a new workbook containing the copied worksheet.
Copying a Worksheet in a Different Workbook
Open both the source and target workbooks if you need to copy a worksheet into a different workbook. Right-click on the tab of the worksheet you want to move and go to Move or Copy. When a new dialogue box opens, check the Create a copy box. Open the drop-down menu under To Book, and select the name of the target workbook. Press the OK button to confirm.
How to Open an Excel File in Google Sheets
Not everyone likes to use Microsoft Excel. Google Sheets is its most popular alternative. If your colleague sends you an Excel file, you can open it in Google Sheets without a problem. Simply open a blank Google Sheet and go to the File tab and select Open. In the Open File menu find and click the Upload tab. Hold the left-click on the excel file and drag it into the space.
You can also click on Browse in the middle of the screen, and from there navigate to the Excel sheet you want to import into Google Sheets. Select the file you want and click Open.
How to Open a CSV File in MS Excel
CSV files are simple text files that contain information and data separated by commas. It is used to transfer data, such as spreadsheet content, between different applications that typically cannot directly communicate. Such apps are, for example, MS Excel and Google Sheets, or Microsoft Word. If you receive a CSV file, here is how you can use Excel to open it.
1. Open the Excel spreadsheet to which you want to save the data contained in the CSV file. Click on the Data tab and find the Get External Data group. Select From Text.
2. Select the CSV file you want to open in Excel and click Import. In a new window that pops open click Delimited and then Next.
3. In a new window, under Delimiters, check the Comma box and then Next.
4. Another window will open, select General under the Column data format, and click on Finish.
The Difference Between Workbooks and Worksheets
Knowing the difference between workbooks and worksheets will help you quickly navigate the two, and manage them easily. Worksheets are the core of MS Excel, and you can have multiple worksheets in one workbook. Editing and manipulating data is possible only in worksheets and not in workbooks. It is also interesting to know that the amount of data in a worksheet is limited by the number of columns, rows, and cells. The amount of data in a workbook is not limited at all.
