Excel : Creating New Workbook | Saving Workbook | Closing Workbook

Excel Saving

• Be sure to save your work as you go. There is a Save button in the
  Quick Access Toolbar – click it often.
• The first time you save a workbook (Book1, etc.) you will be in the
  Save As dialog box where you will enter the name of the file. Use
  any combination of letters, numbers, spaces and special characters.
  Note - there are a few special characters that cannot be used: (" * : < > ? \ / |.).
• While in Save As, be sure to note the location of the workbook so
  you can find it later – usually defaults to My Documents.
• Automatic Saving – Excel 2010 is very efficient and will save your work as
  you go even if you do forget. Go to File/Options/Save to view or update
  save options.

 Remember to save your work as you go. You can click the
Save button as often as you’d like

Backstage View

The File menu in Excel 2010 opens what is known  as Backstage view. This is where you can manage  your files (open, save, print, find info, etc.) and set  program options (formerly accessed through  Tool/Options).

Creating a new Workbook

When you start Excel, you’ll see a new blank workbook (Book1). You can begin typing in that workbook or choose to create a new workbook.

To create a new workbook, go to File/New then click  Create (under Blank workbook on right side of screen)

Opening a workbook

Go to File/Open – locate the folder that contains the file  you would like to open, click the file and click Open (or double-click the filename).

Closing a workbook

Go to File/Close. If changes were made since you last  saved, you will be prompted to save the workbook.

Moving around in a workbook

When typing in a workbook, you’ll need to know what cell you’re working in: The cell reference just above column A shows you what cell you’re in and there should be a dark border around the cell. If you have multiple cells selected, the first cell shows in the cell reference area and that cell is white, while the others are shaded to show that they are selected.

• Arrow keys move one cell at a time in the direction on the key.
• Page Down moves down one screen at a time
• Page Up moves up one screen at a time
• Home, then left arrow moves to the beginning of a row of data
• End, then right arrow moves to the end of a row of data
• Ctrl+Home moves to the beginning of the workbook (cell A1)
• Ctrl+End moves to the end of the data in the workbook 
• Use the scroll bar to move up or down in the workbook – single arrow up or down moves one line at a time. Click above or below the scroll box to move one screen at a time. Drag the scroll box up or down. Note – this does not move the insertion point – you’ll need to click somewhere on the page to begin typing in a cell.