The second Page Setup dialog box appears.įrom the Paper Size pull-down menu, select the desired size. The default paper size is 8 1/2" x 11" sheets, but you can select other available paper sizes, such as legal (11" x 14"). In the Orientation section, select the desired option ( Portrait or Landscape). If the Page Setup section is not expanded, click it.
Under Orientation, select the desired option ( Portrait or Landscape).Ĭhanging the Orientation: Formatting Palette Option Changing the Orientation: Dialog Box Option After changing the orientation, you may need to proceed with Changing the Paper Size below.
In addition, changing the orientation can also help to fit a large worksheet to one sheet of paper. Most documents are portrait (tall) oriented, but many worksheets may be easier to read in the landscape (wide) mode. Several different aspects of your page layout may be altered to customize the way your printed worksheet appears. In order to fit information on a page or change the appearance of a page, you may want to customize your page layout. This article is based on legacy software.
Hover over the tab you want to rename, and double Left-click the tab.(Archives) Microsoft Excel 2007: Customizing Page Layout Mac. Right-click the tab you want to rename if you are using a PC, or control-click the tab you want to rename if you are using a Mac. To rename a worksheet tab, follow either of these steps: To add a new worksheet, click the Insert Worksheet tab, to the right of the existing worksheet tabs. You can access the different worksheets by clicking the worksheet tabs just above the status bar. When done, simply click Ok.īy default, three worksheets are included in each Excel workbook. Go to the Advanced option, and under Display, you can click the check box for Show formula bar. In order to hide or show the formula bar if it has mistakenly been hidden, go to Excel Options at the bottom right of the menu that opens when you click the Office button. It is possible to hide the formula bar, though is not recommended. The formula bar is located below the ribbon and spans most of the window. This is most prominent when using functions, as you do not see the whole equation in the cell in the worksheet, only the result. Whenever you input any information into a cell, the output, or end result is what is shown once you move away from the cell. The formula bar allows you to see all the details and methods used to return what is seen in a cell. This will be one of the most useful tools as you use Excel. Each cell on the spreadsheet has a cell address that is the column letter followed by the row number. Cells can contain text, numbers, or formulas for automatic calculations. The intersection of a column and a row is called a cell. The numbers of the rows are indicated in the blue buttons down the left of the worksheet. The letters of the columns are indicated in the blue buttons across the top of the worksheet. The worksheet is a grid of columns (designated by letters) and rows (designated by numbers). Spreadsheet BasicsĮach Excel file is a workbook that can hold many worksheets. The options displayed will vary depending on the element you have selected. To access this feature, simply right-click the element you wish to edit if you are using a PC, or control-click the element you wish to edit if you are using a Mac. The most common Excel commands and functions can be accessed quickly by using the shortcut menu. UW Chief Information Security Officer (CISO).
0 kommentar(er)
