Quamut: the go to how to.
 
 
 
Published_by_bn Sign In Help_but My_quamut_but
 
 
 
   Excel 2007 found in Computers & Technology  :  Software  :  Microsoft A   A   A
text size
 
 
 
Add to my favorites Send this Quamut to a friend del.icio.us
 

How to Create New Spreadsheets and Open Existing Spreadsheets

To get started working in Excel, you first have to know how to create a new spreadsheet or open an existing one.

How to Create a New Excel Spreadsheet

You can create an Excel spreadsheet from:
  • A blank spreadsheet
  • A template
  • An existing spreadsheet

How to Create a Blank Spreadsheet

Creating a new spreadsheet in Excel is as simple as launching the program. When Excel starts, it automatically displays a blank spreadsheet. If Excel is already running and you’d like to open a new blank spreadsheet:
  1. Click the Office button and select New (Ctrl+N).
  2. The New Workbook dialog box opens. Select Blank and Recent from the left pane of the dialog box.
  3. Select Blank Workbook and click Create.

How to Create a Document from a Template

If you don’t want to build a spreadsheet yourself, you can use one of a wide variety of predesigned templates that have the appropriate formulas built into them. For instance, rather than use Excel to make an invoice from scratch, you may be able to use or modify an existing invoice template, resulting in less work and a more professional look. Just load a template that fits your needs and type right into it.
  1. Click the Office button and select New (Ctrl+N).
  2. The New Workbook dialog box opens. On the left side of the dialog box is a list of template categories. The category Installed Templates at the top of the list contains templates that are automatically installed on your computer when you install Excel. The other categories contain templates that you can download from www.microsoft.com for free. When you select a template category, thumbnails of the available templates appear in the center pane of the window. When you select a thumbnail in the center pane, a larger preview appears on the right side of the window.
  3. Select the template and click Create for an installed template or Download for a not-yet-installed template.

How to Create a Document from an Existing Document

This option allows you to treat a document you’ve already created as a template: Excel creates a copy of the spreadsheet you select, and you just type over the text and data that’s currently there.
  1. Click the Office button and select New (or Alt+F, N).
  2. The New Document dialog box opens. Select New from Existing.
  3. The New Document dialog box now allows you to browse for the existing document.
  4. Once you’ve found the document, click Create New.

How to Open an Existing File

To work on a file you’ve already created and saved:
  1. Click the Office button and select Open (Ctrl+O).
  2. The Open dialog box opens. Browse for the file.
  3. Once you’ve found the file, double-click to open it, or select it and click Open at the bottom of the dialog box.

Compatibility with Older Excel Files

Excel 2007 can open any Excel spreadsheet created in older versions of Excel.
 
 
  Acknowledgments & Disclaimer
 
 

 
 
 
Download the PDF
for just $2.95
 
Excel 2007
 
► Complete guide
► Handy, portable format
 
Excel 2007 Chart
 
Buynow_button