![learn how to use microsoft excel 2007 learn how to use microsoft excel 2007](https://i.pinimg.com/550x/05/bd/db/05bddbc1b3377209a7f2e1928cef5e34.jpg)
When changes are made to this text field, the content or function of the selected cell is also altered. There, you can perform operations on the data and know the formula behind the content of a cell. Just below the commands of each menu, the formula bar is located.
#Learn how to use microsoft excel 2007 software
The application’s main menuĮach menu changes the lower options bar, where the buttons that grant access to the different functions of this software are grouped. There, you will find all Excel functions sorted by categories. Recent filesĪs soon as you create your new book, you will access the work area. This is an interesting section to open ongoing projects quickly. Available templates in Excelīack to the main screen, let us talk about the recent and pinned files section.
![learn how to use microsoft excel 2007 learn how to use microsoft excel 2007](https://i.ytimg.com/vi/nYU8fRlrYYw/maxresdefault.jpg)
To load a template, just double-click on its thumbnail. There, you will find designs to create calendars, charts, balance sheets, and much more. If you want to start with a book that already has an attractive design, we recommend that you visit the template gallery by clicking on More templates. Using the Blank workbook button, you will create a new blank workbook.
#Learn how to use microsoft excel 2007 license
Type the name of the Spreadsheet ( Address Book) in the File Name box, and click on the Save button.Application options, Microsoft 365 account settings, and active license details are also accessible. Step 14: To save the Excel spreadsheet, click on the Office Button and select the Save As option. Step 13 : Select the correct printer and click on the OK button. Step 12: To print the Excel spreadsheet, click on the Office Button and select the Print option. Step 11: To preview the spreadsheet before printing, click on the Print Preview icon in the Quick Access Toolbar. Select All Borders from the dropdown menu to draw the all the borders around the selected cells in the spreadsheet. Click on the Borders icon in the Font group under the Home tab in the Ribbon to select a way to define the border around the selected text. Note that all cells between A2 and I11 will be selected. To add a border to the cells, select cell A2 and hold down the key while moving the mouse to cell I11 and clicking. Step 9: To center-align the text in the City, State, Postal code, and Phone columns, highlight cells D3 to G11, click on the C enter Justify icon in the Alignment group under the Home tab in the Ribbon to center-align the selected text. The text in each selected cell will be aligned to the center. Step 8: To center-align the text in the header row, select this row and click on the Center Justify icon in the Alignment group under the Home tab in the Ribbon. You should now have a blue background with white text for the header row (cells A1 to I2). Select a white color from the dropdown font color box. Step 7: To change the font color of the header row, highlight this row (cells A1 through I2) and click on the Font Color icon in the Font group under the Home tab in the Ribbon. Select a blue color from the dropdown color box and see the cell color change in the highlighted cells. While this row is selected, click on the Fill Color icon in the Font group under the Home tab in the Ribbon to display all the colors available for filling these cells. Step 6: To color the cells in the header row, first highlight the header row (cells A1 through I2). Now, click on the Bold icon in the Font group under the Home tab in the Ribbon (circled below) to make the highlighted text bold. Step 5 : To make the text in the header row of the Address Book bold, click on cell A1, hold the key down, and click on cell I2, so that all the cells from A1 to I2 are highlighted. Step 4 : To store contact information in the Address Book, use the same procedure to type in the contact information given below, from Cell A3 to Cell I11. Step 3: To add the contact information headers, click on Cell A2 and type First Name in cell B2 type Last Name, in cell C2 type Address, in cell D2 type City, in cell E2 type State, in cell F2 type Postal Code, in Cell G2 type Phone, in cell H2 type Email, and in cell I2 type Comments.
![learn how to use microsoft excel 2007 learn how to use microsoft excel 2007](https://image.slidesharecdn.com/microsoftofficeexcel2007english-120919123421-phpapp01/85/microsoft-office-excel-2007-english-25-320.jpg)
Step 2: Click on Cell D1 in Row 1 and type Address Book. Select All Programs, then Microsoft Office, then click on Microsoft Excel to start the Excel application. Step 1: Start the Microsoft Excel Application by clicking on the Start button at the bottom left corner of the Window.