o Select Save if the file has already been named. Choose Save As if you'd like to save the file for the first time or if you'd like to save the file as a different name. o Save As allows you to name the file and choose a location to save the spreadsheet. To Save the Workbook: Click the Microsoft Office Button. Use the Page Up and Page Down keys to navigate the worksheet. Press the Shift key and then the Tab key to move to the left of the selected cell. To Move Through a Worksheet Using the Keyboard: Press the Tab key to move to the right of the selected cell. Just select the cell and place your insertion point in the formula bar. You can also make changes to and delete text from the formula bar. Press the Delete key to delete the entire contents of a cell. Press the Backspace key on your keyboard to delete text and make a correction. Type the new name of the cell and press return key To restore old address ->formula tab -> name manger of 34Ħ To Edit or Delete Text: Select the cell. Click in the Name Box, the cell address will be selected and aligned to the left side of the box. Hint: You can name a cell, and use this name as cell address. For example, this cell is C3 since it is where column C and row 3 intersect. Each cell has a name, or a cell address based on the column and row it is in. The text appears in the cell and in the formula bar. Enter text into the cell using your keyboard. As you select a cell, the cell address appears in the Name Box. Each rectangle in the worksheet is called a cell. Select from the left windowpane the template needed, the down loaded and modify its fields to match your needs of 34ĥ Worksheet To Insert Text: Click a cell to select it. Hint : If you added the command new to quick access toolbar, then you only need to click the Icon new Hint : if you need to use templates for timesheet, invoices, schedules, etc. A new, blank workbook appears in the window. The New Workbook dialog box opens and Blank Workbook is highlighted by default. Create a New, Blank Workbook: Click the Microsoft Office Button. Add two commands to the Quick Access toolbar. Click the Microsoft Office Button and review the menu options. Click on category Prepared then select properties Modify any of the default settings. Change document properties, add your name as document Author, title,subject.etc. Select a category on the left to access different Excel options. Also known as the main menu To Change the Default Excel Options: Click the Excel Options button. You can also add security features, send, publish, and close files. From this menu you can create a new spreadsheet, open existing files, save files in a variety of ways, and print. Double click again to show the ribbon You can also minimize and maximize the Ribbon by right-clicking anywhere in the main menu and selecting Minimize the Ribbon in the menu that appears of 34ģ The Microsoft Office Button When you click the button, a menu appears. Hint: double click any command tab to hide the ribbon. To maximize the ribbon, click the arrow again and select Minimize the Ribbon to toggle the feature off. To Minimize and Maximize the Ribbon: Click the drop-down arrow next to the Quick Access toolbar.

You may wish to add other commands to make using specific Excel features more convenient for you.

The Save, Undo, and Redo commands appear by default in the Quick Access toolbar. OR Select More Commands from the menu and a dialog box appears. It will appear in the Quick Access toolbar. Select the command you wish to add from the drop-down list. of 34Ģ The Quick Access Toolbar: to add command Click the arrow to the right of the Quick Access toolbar. To Change Page Views Click the Page View options are Normal, Page Layout, and Page Break. To Zoom In and Out: drag the slider left to zoom in and to the right to zoom out. On the bottom, right area of the spreadsheet is page view commands, the zoom tool, and the horizontal scrolling bar. By default, three worksheet tabs appear each time you create a new workbook. At the bottom, left area of the spreadsheet are the worksheet tabs. The Quick Access Toolbar is pinned next to the Microsoft Office Button, and includes commands such as Undo and Redo. For options such as New, Save, Save As, and Print. This Ribbon system replaces the traditional menus used with Excel Above the Ribbon in the upper-left corner is the Microsoft Office Button. 1 Ribbon menu The Ribbon menu system with tabs for various Excel commands.

Excel 2007 tutorial free download pdf