Microsoft Excel 2007 tutorial: what is worksheet?

What is worksheet?

I. What is worksheet?

Worksheet is a primary document that you use in Excel to store and work with data; you can also call it spreadsheet. Worksheet or spreadsheet consists of cells that are organized into columns and rows. A spreadsheet is always stored in a workbook and a workbook can contains a lot of worksheets. By default, Excel opens a workbook with three worksheets. See the figure:

Excel 2007 a workbook with default worksheet

In this section, you also learn how to organize worksheet before you do other things on the worksheet; and in the next section, you will learn how to select worksheet tab, set and reset color worksheet, rename, insert, delete worksheet and so on.

II. Organize worksheet

In general, when you start to open a workbook, the first thing you should do is to set the formats to the worksheet such as setting margin, page orientation, page size, and other formats. To set each format to the worksheet, do the following:

- Click the worksheet that you want to set the formats.

- Click Page Layout tab. In this tab, there is a group of Page Setup. See the figure below:

Excel 2007 page layout tab

- Click drop-down arrow under Margins icon to select any template margin to your worksheet. If you are not satisfied with any template margin, click Margin icon and then click Custom Margin.

Excel 2007 Custom Margin

Excel displays the Page Setup dialog box as the figure:

Excel 2007 Page Setup dialog box

This dialog box contains four tabs including Page, Margins, Header/Footer, and Sheet. For each tab will briefly describe below:

- Page: Switch the page orientation between Portrait and Landscape layouts, and select the paper size such as Letter, Tabloid, Legal, A3, A3, A5, etc and choose the print quality also.

- Margin: Set the margin sizes for entire document (top, bottom, left, right), the margins size for header/footer, and specify text center alignment.

- Header/Footer: Select template headers/footers for page header/footer. If you are not satisfied with the templates, click Custom Header to set the header style you like for the header page and click Custom Footer to set the footer style you like for the footer page.

- Sheet: Define area that you want to print, row to repeat at the top and column to repeat at the left on every printed paper.

In the Margin tab, you can set the margin sizes such as top, bottom, left, and right as you want; you can set the size for header and footer also. In addition, you can set data that you enter in the worksheet to be both horizontal and vertical center alignment if you tick these two options under Center on page or you can set the data either horizontal or vertical if you tick either Horizontally or Vertically under Center on page. After you complete the margin settings for the worksheet, click PrintPreview to see what you have set, and then click Ok.

- Click drop-down arrow under Orientation icon to switch the paper to portrait or landscape or click Page Setup Launcher to display the Page Setup dialog box and then click Page tab and click Portrait or Landscape.

- For the paper size, you can select the template sizes by clicking Size icon and then click drop-down arrow under Size icon, and choose any template size you like. If you are not satisfied with the template sizes, you can set paper size by yourself by clicking drop-down arrow under Size icon and then click More Paper Sizes.

Excel 2007 More Paper Sizes

Excel displays Page Setup dialog box. Click Options, Sent To OneNote 2007 Properties dialog box appears as the figure:

Excel 2007 set page size

- Enter the width and height you want in front of Width and Height box or click spin up/down arrow in front of Width or Height box to increase or decrease the width or height and then click Ok. When you click Ok, you will back to Page Setup dialog box. Then click Ok again.



This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.