{"id":453,"date":"2018-06-28T09:21:19","date_gmt":"2018-06-28T09:21:19","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=453"},"modified":"2024-03-30T11:00:58","modified_gmt":"2024-03-30T11:00:58","slug":"worksheets","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/worksheets\/","title":{"rendered":"Worksheets in Excel"},"content":{"rendered":"\n
Difference between a worksheet and a workbook<\/h2>\n\n\n\n
With Excel, you can achieve high efficiency with little effort. However, before you start working with the application, it’s good to know such basic things as the difference between a worksheet<\/strong> and a workbook.<\/strong><\/p>\n\n\n\n
Worksheet<\/h3>\n\n\n\n
A worksheet is a place where you can insert data, tables, charts, etc. In Excel 2013 a worksheet can contain up to 1 048 576 rows<\/strong> and 16 384 columns<\/strong>, which gives 17 billion cells<\/strong>.<\/p>\n\n\n\n
<\/figure>\n\n\n\n
Workbook<\/h3>\n\n\n\n
You can compare a workbook in Excel to the one you can find in the real world. It is a place where you can store your worksheets. An Excel workbook is a file that contains at least one visible worksheet.<\/p>\n\n\n\n
In earlier versions of Excel, when you created a new file, the default workbook consisted of three worksheets. In Excel 2013 there is, by default, only one worksheet. Each additional, you have to add by clicking the plus icon, which is located to the right of the worksheet tab.<\/p>\n\n\n\n
<\/figure>\n\n\n\n
Worksheet operations<\/h2>\n\n\n\n
When you start creating additional tabs inside your workbook, you will notice that their default names and arrangement are not very intuitive. For that reason, you may want to make some modifications. Excel gives you that option. You can freely manipulate their names and location.<\/p>\n\n\n\n
Below, you will find the list of operations that you can perform with Excel worksheets.<\/p>\n\n\n\n
Adding worksheets<\/h3>\n\n\n\n
When you create a blank workbook, you will, by default, receive one sheet. If you want to add more sheets you can do it by clicking the plus button, which is located on the right side of the tabs.<\/p>\n\n\n\n