Windows Supplemental Worksheet by Scott Wiseman
File Management – Using
the Windows Explorer
A.
Windows is the OS which manages all the computers files

B.
Everything on a computer is a file – EVERYTHING

C. Applications
(Excel, Word etc.) manipulate the files that use their "language"

What are all these
drive letters?
Everyone has unique
network drive mappings which represent another folder on another computer.
The letter (P or T or whatever) is arbitrary. IT dept. can assign any letter to
any resource (folder)

What is a
File Extension?
|
File extensions
--the letters (usually three) following the final period
in the file's name. This extension is an essential
aspect of nearly every file on your computer; without
it, Windows doesn't know whether to open the file in
your word processor, spreadsheet or some other
application, or to let other programs use it as a system
resource. Knowing a file's extension can also help you
customize your system and clean out the garbage.

Unfortunately,
Microsoft started hiding file extensions in Windows 95.
To make sure your file extensions are visible, open
Windows Explorer or any folder window and choose View,
Folder Options or Tools, Folder Options (depending on
your version). Click the View tab, make sure the option
to 'Hide extensions for known file types' is unchecked
(the exact wording will vary depending on your version
of Windows; ), and click OK. Now extensions will be
visible for nearly every file on your desktop and in
your Explorer and folder windows. |
|
|

Computer Terms
|
How
to save a file
I will use WordPad as an example.
To save a file:
- Click on File, which is located on the menu bar. A
drop-down menu will appear.
- Click on Save. A dialog box similar to the one shown
here will appear.
A dialog box?
Whenever you see an ellipse (…) after a menu option,
selecting that option causes a dialog box to appear. You use
dialog boxes to send commands to the software. Most dialog
boxes provide an OK button and a Cancel button. Press the OK
button if you are satisfied with your entries and you want
to send the commands to the program. Press the Cancel button
if you have changed your mind and do not want to send the
commands to the computer.

Tabs?
Fields?
You type entries into fields (also referred to as text
boxes). For example, in the Save As dialog box, you type the
name you want the file to have in the File Name field.
List boxes?
List boxes enable you to make a choice from a list of
options. To make your selection, simply click on the option
you want. In some list boxes, you can choose more than one
item. To choose more than one item, hold down the Ctrl key
while you make your selections. If there are more options
than can be displayed in the box, a scroll bar appears on
the list box. Use the scroll bar to view the additional
choices.
A drop-down or pull-down
menu?
Fields with a drop-down menu have a small downward
pointing arrow next to them. You click on the arrow and a
list of options appears. You select the option you want from
the list. You can also open the drop-down menu by holding
down the Alt key and pressing the down arrow.
You can use the arrow keys to move up and down in a
drop-down menu. You can also move to an item by typing the
first few letters of the option.
Radio buttons?
Windows programs use radio buttons to present a list of
mutually exclusive options. You can select only one of the
options presented. Radio buttons are usually round.
Check boxes?
Check boxes are another method used to select options.
You click on the check box to select the item. An X or a
checkmark appears in a selected box. You toggle check boxes
on and off by clicking in the box.
A slider?
You use a slider to increase or decrease a value. You
increase a value by moving the slider from left to right;
you decrease a value by moving the slider from right to
left.
A spinner?
A spinner is a set of arrows located on the side of a
text box. You use the up arrow to increment a value and the
down arrow to decrement a value. You can also type the value
you want directly into the text box. |
|
Customizing Windows
A. Desktop Shortcuts, wallpaper,
screensaver etc.
Controlling your icons.
Right clicking anywhere on your open desktop
gives you:


Making a desktop shortcut
from your "Start" Menu.
1. Find the program on the Start Menu
2. Right Click and choose "Send to" then "Desktop (create shortcut)

B. Taskbar
- Customizing the taskbar.
http://channels.lockergnome.com/windows/videotips/2/
C. Toolbars - System Tray, Quick Launch, Links,
Desktop


D. Manipulating the Start Menu. (dragging onto
start button, shortcuts to network drives, P drive)
Windows Explorer: Managing Your Files
This tutorial will present "how to" information on the following operations in Windows Explorer:
Finding Files
Saving Files
Copying Files
Moving Files
Deleting Files
Creating Folder Directories
Before learning how to
Find, Save, Copy, Move, Delete files, etc. let's take a
look at one of the most useful tools to help you manage your files. The
program is called Windows Explorer. As you learn about file
management in
the steps to follow, refer to the image below of Windows Explorer.
Notice the identification of the parts of Explorer below.
You may want to print this tutorial to have at your side as you go
through it. Or you can go through the examples with 2 windows
open -- your Explorer window and your browser window. To do
this, open both windows.
Accessing Windows Explorer
To access your Windows Explorer:
- Click on Start, Programs, Windows Explorer
- Or use the "windows" and "E" keys.
Parts of Windows Explorer
Try to think of the structure of this file management tool as a filing
cabinet with folders inside of filing drawers, etc. This concept is
represented in Explorer with a "tree" type of appearance -- directories come
off main drives; files come off directories,
etc.
On the left side of your Explorer window are the folders in your chosen
drive. The Explorer view begins with Desktop, followed by My Computer,
and lists all your drives, followed by other folders or programs contained
within the Desktop and My Computer.
Your directory structure is indicated by the indentation levels in
Explorer's
left pane. On the right side are the files and folders that are contained
within the folder you select at left. Your selected folder appears to be
open, with its contents spilling out into the right panel.
A minus sign on a folder means that it is fully expanded. A plus sign on
a folder means that more files are contained inside it than are visible.
When you want to see details of your files (i.e. size, date
created/modified), click on 'View', 'Details'. When you just want to see
a list of files, click on 'View', 'List'.
If you save a file and then can't remember what you named it or where it
was saved, you can search for the file using the Windows Search feature.
Windows allows you to locate files based on file name, a portion of
a name, date, and/or the text included in a file. To conduct a search,
you
can
The Search Results box comes up which looks like the image below.
Using a basic search, you indicate the file name or a portion of the file
name (if you don't know it all) and search either your entire computer,
or any drives or directories that you choose.
Here are some examples of ways of searching:
Your search results screen will list the file or files which match your
criteria. The screen functions like a window in Explorer or My Computer.
Here you may open, delete, move, and copy files.
Although Windows Explorer is not used for saving files, this operation
will be covered here, as it involves the need to be familiar with the
directory structure of Windows in order to know where to save or retrieve
files when using applications.
When saving
any document, using any application, you will follow these steps:
- When you are ready to save a file, click on 'File', 'Save As'
- When the 'Save As' dialogue box comes up, click on the little
triangle button at the end of the 'Save in:' box to display your drives.
- Scroll to the drive letter (C: or A:), then double click on the
folder (directory) to which you wish to save the file. You will then see
that folder pop into the 'Save in:' box.
- In the 'File name:' box below, enter your choice of a filename.
- In the 'Save as type:' box, you notice that the application being
used is already in the box. If you wish to save the file as another file
type (i.e. text only, etc.), click the little triangle button at
the end of the box to select.
- Lastly, click on the 'Save' button.
You can use several methods
for copying (and moving) files:
Basically when copying files from one directory or drive to another, you
are going to select the file, then use one of these methods to copy
it to another location.
RIGHT CLICKING
MENU BAR
KEYBOARD
DRAGGING
NOTE: You need both directories visible to use this option. Or
you can open up Explorer again and move the windows around for good
viewing.
Drop it precisely on the folder to which it will go. A small box will be
visible
around the selected folder, so that you can drop it within that folder.
If you
miss, check the folders above and below your selected folder to see if
the file landed there. Otherwise, you may have to search to locate it.
TIP: You can copy several files at a time by
The process of moving files from one place to another is essentially the
same. When right clicking, or choosing Edit from the menu,
Note: Dragging files only copies files -- they remain in 2
places. Also, remember you can move multiple files in the same manner as
described under 'Copying Files'.
Deleting files and folders is easy - almost too easy. Here again,
you have several options:
Unless you have indicated in the recycle bin that you wish all files
that you delete to be permanently deleted, and unless you are on a floppy
drive, deleting will merely send your files to the recycle bin,
from where you can permanently delete them later.
WARNING: When you delete a folder, you delete all files in that folder.
Before deleting a folder, be sure that it does not contain files you wish
to keep!
Remember, only files deleted from your hard drive can be retrieved
from the Recycle Bin.
How to Create Folder
Directories
Create folders by performing these steps:
- Open Windows Explorer -- Start, Programs, Windows Explorer
- If your window is small you may need to enlarge it (maximize it or
drag the right lower corner).
- To create a folder (directory) on C: click one time on C: (on left)
to highlight/select it.
- Go up to the menu bar at the top and click on 'File', 'New', 'Folder'.
- A folder box appears on the right. Type your desired folder name. and
click Enter.
- On the menu bar at the top, click 'View', 'Refresh' and now you will
see your new folder on the left.
NOTE: Sub folders
can be created under already established folders in the same manner. On
the menu bar, click one time on the folder and click 'File', 'New',
'Folder'.
Shortcuts.
|
BASIC
SHORTCUT KEYS
The
below basic shortcut keys are a listing of shortcut keys that
will work with almost all IBM compatible computers and software
programs. It is highly recommended that all users keep a good
reference of the below short cut keys and/or try to memorize the
below keys. Doing so will dramatically increase your
productivity.
|
Shortcut Keys |
Description |
| Alt + F |
File menu options
in current program. |
| Alt + E |
Edit options in
current program |
| F1 |
Universal Help in 90% of Windows programs. |
| Ctrl + A |
Select all text. |
| Ctrl + X |
Cut
selected item. |
| Shift + Del |
Cut selected item. |
|
Ctrl + C |
Copy
selected item. |
|
Ctrl + Ins |
Copy
selected item |
|
Ctrl + V |
Paste |
| Shift + Ins |
Paste |
| Home |
Goes to beginning
of current line. |
| Ctrl + Home |
Goes to beginning
of document. |
| End |
Goes to end of
current line. |
| Ctrl + End |
Goes to end of
document. |
| Shift +
Home |
Highlights from
current position to beginning of line. |
| Shift + End |
Highlights from
current position to end of line. |
| Ctrl + Left
arrow |
Moves one word to
the left at a time. |
| Ctrl +
Right arrow |
Moves one word to
the right at a time. |
MICROSOFT WINDOWS SHORTCUT KEYS
|
Shortcut Keys |
Operating System |
Description |
|
Alt + Tab |
3.X
/ 95
/ 98
/ NT
/
2000 /
XP |
Switch between
open applications. |
|
Alt + Shift + Tab |
3.X
/ 95
/ 98
/ NT
/
2000 /
XP |
Switch backwards
between open applications. |
|
Alt +
Print Screen |
3.X
/ 95
/ 98
/ NT
/
2000 /
XP |
Create a
screen shot only for the program you are
currently in. |
|
Ctrl + Esc |
95
/ 98
/ NT
/
2000 /
XP |
Bring Up start button. |
|
Alt + Esc |
95
/ 98
/ NT
/
2000 /
XP |
Switch Between open
applications on taskbar. |
|
F2 |
3.X
/ 95
/ 98
/ NT
/
2000 /
XP |
Renames selected Icon |
|
F3 |
95
/ 98
/ NT
/
2000 /
XP |
Starts find from
desktop |
|
F4 |
95
/ 98
/ NT
/
2000 /
XP |
Opens the drive
selection when browsing. |
|
F5 |
95
/ 98
/ NT
/
2000 /
XP |
Refresh Contents |
|
Alt + F4 |
3.X
/ 95
/ 98
/ NT
/
2000 /
XP |
Closes Current open
program. |
|
Ctrl + F4 |
3.X
/ 95
/ 98
/ NT
/
2000 /
XP |
Closes Window in
Program |
|
Ctrl + (the '+' key
on the
keypad) |
98
/ NT
/
2000 /
XP |
Automatically adjust
the width's of all the columns in Windows explorer |
|
Alt + Enter |
95
/ 98
/ NT
/
2000 /
XP |
Opens properties window
of Selected icon or program. |
|
Shift + F10 |
95
/ 98
/ NT
/
2000 /
XP |
Simulates right click
on selected item. |
|
Shift + Del
|
95
/ 98
/ NT
/
2000 /
XP |
Delete programs/files
without throwing into the recycle bin. |
|
Holding Shift |
3.X
/ 95
/ 98
/ NT
/
2000 /
XP |
Boot safe mode or by
pass system files. |
|
Holding Shift |
95
/ 98
/ NT
/
2000 /
XP |
When putting in an
audio CD will prevent CD Player from playing. |
WINDOWS
KEYBOARD SHORTCUTS
Below is a listing of Windows keys that can be
used on computers running a Microsoft Windows
operating system
and using a keyboard with a
Windows key. In the below list of shortcuts the windows key
is represented by "WINKEY". If you are looking for Windows
shortcut keys see the above Microsoft Windows
shortcut key section.
| Shortcut
Keys |
Description |
| WINKEY + D |
Minimizes all
windows and returns the user to the
desktop. |
| WINKEY +
M |
Minimizes all windows. |
| WINKEY +
SHIFT + M |
Undo the minimize. |
| WINKEY + E |
Open Microsoft Explorer. |
| WINKEY + Tab |
Cycle through open programs through the
taskbar. |
| WINKEY + F |
Display the Windows Search / Find feature. |
| WINKEY +
CTRL + F |
Display the search for computers window. |
| WINKEY + F1 |
Display the Microsoft Windows help. |
| WINKEY + R |
Open the run window. |
| WINKEY + Pause / Break key |
Open the system properties window. |
| WINKEY + U |
Open Utility Manager. |
| WINKEY + L |
Lock the computer (Windows XP and above only). |
EXCEL
SHORTCUT KEYS
|
Shortcut Keys |
Description |
| F7 |
Spell check
selected text and or document. |
| F11 |
Create chart. |
| Ctrl + Shift + ; |
Enter the current
time |
| Ctrl + ; |
Enter the current
date |
| Alt + Shift + F1 |
Insert New
Worksheet |
| Shift + F3 |
Open the Excel
formula window. |
| Shift + F5 |
Bring up search
box. |
| Ctrl + A |
Select all contents
of the worksheet. |
| Ctrl + B |
Bold highlighted
selection. |
| Ctrl + I |
Italic highlighted
selection. |
| Ctrl + K |
Insert link. |
| Ctrl + U |
Underline
highlighted selection. |
| Ctrl + 5 |
Strikethrough
highlighted selection. |
| Ctrl + P |
Bring up the print
dialog box to begin printing. |
| Ctrl + Z |
Undo last action. |
| Ctrl + F9 |
Minimize current
window. |
| Ctrl + F10 |
Maximize currently
selected window. |
| Ctrl + F6 |
Switch between open
workbooks / windows. |
| Ctrl + Page up |
Move between Excel work sheets in the same Excel
document. |
| Ctrl + Page down |
Move between Excel work sheets in the same Excel
document. |
| Ctrl + Tab |
Move between Two or more open Excel files. |
| Ctrl + Shift + ! |
Format number in
comma format. |
| Ctrl + Shift + $ |
Format number in
currency format. |
| Ctrl + Shift + # |
Format number in
date format. |
| Ctrl + Shift + % |
Format number in
percentage format. |
| Ctrl + Shift + ^ |
Format number in
scientific format. |
| Ctrl + Shift + @ |
Format number in
time format. |
| Ctrl + Arrow
key |
Move to next
section of text. |
| Ctrl + Space |
Select entire
column. |
| Shift + Space |
Select entire
row. |
WORD
SHORTCUT KEYS
|
Shortcut Keys |
Description |
| Ctrl
+ A |
Select all contents
of the page. |
| Ctrl
+ B |
Bold highlighted
selection. |
| Ctrl
+ C |
Copy selected text. |
| Ctrl
+ X |
Cut selected text. |
| Ctrl
+ P |
Open the print
window. |
| Ctrl
+ F |
Open find box. |
| Ctrl
+ I |
Italic highlighted
selection. |
| Ctrl
+ K |
Insert link. |
| Ctrl
+ U |
Underline
highlighted selection. |
| Ctrl
+ V |
Paste. |
| Ctrl
+ Y |
Repeat the last
action performed. |
| Ctrl
+ Z |
Undo last action. |
| Ctrl
+ L |
Aligns
the line or selected text to the left of the screen. |
| Ctrl
+ E |
Aligns the line or
selected text to the center of the screen. |
| Ctrl
+ R |
Aligns the line or
selected text to the right of the screen. |
| Ctrl
+ M |
Indent the
paragraph. |
| Ctrl
+ Shift + F |
Change the font. |
| Ctrl
+ Shift + > |
Increase selected
font +1. |
| Ctrl
+ ] |
Increase selected
font +1. |
| Ctrl
+ Shift + < |
Decrease selected
font -1. |
| Ctrl
+ [ |
Decrease selected
font -1. |
| Ctrl
+ Shift + * |
View or hide non
printing characters. |
| Ctrl
+ <left arrow> |
Moves one word to
the left. |
| Ctrl
+ <right arrow> |
Moves one word to
the right. |
| Ctrl
+ <up arrow> |
Moves to the
beginning of the line or paragraph. |
| Ctrl
+ <down arrow> |
Moves to the end of
the paragraph. |
| Ctrl
+ Del |
Deletes word to
right of cursor. |
| Ctrl
+ Backspace |
Deletes word to
left of cursor. |
|
Ctrl + End |
Moves the cursor to the end of the document. |
|
Ctrl + Home |
Moves the cursor to the beginning of the document. |
| Ctrl
+ Spacebar |
Reset highlighted text to the default font. |
| Ctrl
+ 1 |
Single-space lines. |
| Ctrl
+ 2 |
Double-space lines. |
| Ctrl
+ 5 |
1.5-line spacing. |
| Ctrl
+ Alt + 1 |
Changes text to
heading 1. |
| Ctrl
+ Alt + 2 |
Changes text to
heading 2. |
| Ctrl
+ Alt + 3 |
Changes text to
heading 3. |
| F1 |
Open Help. |
|
Shift + F3 |
Change the case of
the selected text. |
|
Shift + Insert |
Paste. |
| F4 |
Repeat the last
action performed (2000+) |
| F5 |
Open goto window. |
| F7 |
Spell check
selected text and or document. |
|
Shift + F7 |
Activate the
thesaurus. |
| F12 |
Save as. |
|
Shift + F12 |
Save |
|
Mouse Shortcuts |
Description |
| Click, hold, and drag |
Selects text from where you click and hold to
the point you drag and let go. |
| Double-click |
If double-click a word selects the complete
word. |
| Double- click |
Double-clicking on the left, center, or right of
a blank line will make the alignment of the text
left, center, or right aligned. |
| Double-click |
Double-clicking anywhere after text on a line
will set a
tab stop. |
| Triple-click |
Selects the line or paragraph of the text the
mouse triple-clicked. |
| Ctrl + Mouse wheel |
Zooms in and out of document. |
INTERNET EXPLORER SHORTCUT KEYS
|
Shortcut Keys |
Description |
|
Alt + Left Arrow |
Back a page. |
|
Alt + Right Arrow |
Forward a page. |
|
F5 |
Refresh current page /
frame. |
|
F11 |
Display the current
website in full screen mode. Pressing F11 again will
exit this mode. |
|
Esc |
Stop page or download
from loading. |
|
Ctrl + Enter |
Quickly complete an
address. For example type computerhope in the
address bar and press CTRL + ENTER to get http://www.computerhope.com. |
|
Ctrl + N |
Open New browser
window. |
|
Ctrl + P |
Print current page /
frame. |
|
Spacebar |
Moves down a page at a
time. |
|
Shift + Spacebar |
Moves up a page at a
time. |
FRONTPAGE SHORTCUT KEYS
|
Shortcut Keys |
Description |
| Ctrl + C |
Copy selected text. |
| Ctrl + X |
Cut selected text. |
| Ctrl + P |
Paste selected
text. |
| Ctrl + K |
Create a hyperlink. |
| Ctrl + B |
Bold highlighted
selection. |
| Ctrl + I
|
Italic highlighted
selection. |
| Ctrl + U |
Underline
highlighted selection. |
| Ctrl + L |
Left align the
text. |
| Ctrl + R |
Right align the
text. |
| Ctrl + E |
Center the text. |
| Ctrl + / |
Display HTML tags. |
| Ctrl + S |
Save document. |
| Ctrl + Tab |
Switch between open
web pages. |
| Ctrl + Ins |
Enter Line break. |
| Ctrl + Enter |
Move cursor above
or below a table. |
| Ctrl + Shift + B |
Preview in web
browser window. |
| Ctrl + Shift + < |
Decrease font size. |
| Ctrl + Shift + > |
Increase font size. |
| Ctrl + Del |
Deletes word to right of cursor. |
| Ctrl + Backspace |
Deletes word to left of cursor. |
|
|
FAQ's (Frequently Asked
Questions)
What this message means in windows
applications.
If you see this message you have opened a
document that you already have Open and made changes to.
* If you choose “Yes” would erase any
changes since the last time you “saved” it.
* No is like cancel.