Happy Computers Essentials Guide to

Opening, Creating and Closing Workbooks

Opening Saved Documents

Click On The Open Document Icon Shown Below (It's at the top left of the screen)

The following will appear

Change the folder if required

Click on the name of the file to open It will be highlighted

Click Open
You Can Open More Than One Workbook At A Time

You can select and open as many files as you want in one go. To select more than one file, use either the shift key and click on the first then the last file, or the CTRL key and click on files individually. Alternatively, you can drag around the files to select a block.

Opening One Of The Last Files You Used

• 
  The File menu in Excel will display the last four files you have used. Simply click on the one you want to open
  
• 
  The menu Documents Option in Windows, will display the last 15 files you have used in any application. Again simply, click the name of the file you want to open it
  

Creating New Workbooks

Click On the New File Icon Shown Below (It's at the top left of the screen)


A new blank document will be created

Closing Workbooks That Are Open

Click on File The File Menu will drop down

Click on Close The workbook will close
If the Workbook needs to be saved you will be prompted to do so.

Managing Files in the Open Dialog Box

Changing the View of your Files in the Open Dialog Box

Click on Open

Use the buttons shown below to change the view of your files



The Default view is List. This shows the name of your files in alphabetical order. Other views are:

Details	Shows Name of file, Size, type and date last modified
Properties	Shows properties for the selected file
Preview	Gives preview of selected file

Sorting Files

In the Open dialog box click the Command and Settings button

Choose Sorting from the pull down menu






In the Sort files by drop down list specify a sorting options - Name, Size, Types of File or Last Modified

Choose whether you wish the files to be displayed in Ascending or Descending order.

Click OK

Managing Files (In the File Open Dialog)

Click the Open File button or File Menu: Open


Find the files or folders you want to work with (see previous pages)

Click on the file to change with the right mouse button

From the pull down menu click on the option required

Selecting Files

One File	Click on that file
Files that are next to each other in a list	Click on the first file and release your mouse pointer. Now hold down your SHIFT key and click on the last file in the list. All files in-between will be selected.
Files that are not next to each other in a list	Click on the first file and release your mouse pointer. Now hold down your CTRL key and click on the other file you wish to select and so on.

Copying Files Using the Open Dialog Box

In the Open Dialog box select the file(s) you wish to copy

Right-click over the file(s)

From the pull down menu choose copy

Using the Look in drop-down list choose the drive or folder you wish to copy to

Right click again and choose paste

Moving Files

In the Open Dialog box select the file(s) you wish to move

Right-click over the file

From the pull down menu choose cut

Using the Look in drop-down list choose the drive or folder you wish to move to

Right click again and choose paste

Deleting Files

In the open dialog box select the file(s) you wish to delete

Right click over the file

Choose delete from the pull down menu The file will go to the Recycle Bin

True Delete (Avoiding the Recycle Bin)

In the open Dialog box select the file(s) you wish to delete

Right click over the file

Keeping your SHIFT key held down choose delete from the pull down menu

(The file will be deleted)

Renaming a File

In the Open Dialog Box select the file you wish to rename

Right-click over that file

From the pull down menu choose rename

Type the new name and press Enter The file will have a new name

Copying File(s) to the Floppy Disk

In the Open Dialog box select the file(s) you wish to copy to the floppy disk

Right-click over the file(s)

From the pull down menu choose Send to and then 3 1/2 floppy

Favourites

You use the Favourites folder to store shortcuts to files and folders of interest. You can use a shortcut for quick access to the file without having to remember where the file is located.
To add a file or folder to the Favourites folder…

Select the file or folder you want a shortcut for

Click and then click Add Selected Item To Favourites.

To add a shortcut to the folder selected in the Look In box, click Add 'Look In' Folder To Favourites.
To open a favourite file or folder…
Click and then double-click the shortcut or the filename or folder name.

Access the Web in the Open Dialog Box

Click on the Web Toolbar icon You will be connected to your internet browser