Could someone explain to me why the United States
spends more money killing people than taking care of its own?
The tax rebate is Bush and his cronies way of bailing out big corporations
using tax payers' money, it is NOT to help poorer America.
Why is there money to help big corporations, killing people, but when it comes
to Social Security, the money is running out? Why don't they bail out
Social Security? My measly $300 rebate has already gone to Big Oil. Yours most
likely will end up in some big corporation's pockets too and our children will
have to pick up the tab.
John 14:6 "I am the way,
the truth, and the life: no man cometh unto the Father, but by me."
Another great site for Office Support and Help is
Rick Selby's
Excel Help Page Site Visitors
To find a topic on this page, Click Edit on the Toolbar, Find (on this page), type in keyword
If you are planning on upgrading to Vista, there are hardly any drivers available.
They are not the same as XP and most likely you will not be able to find
drivers for your hardware at this time. Check with your manufacture for Vista drivers before you upgrade or you may be out of luck for a while
until someone comes up with drivers. This is another repeat of XP SP 2.
Three things to remember when you are working with computers.
First thing is "YOU CAN DO IT".
Second take your time, a little mistake can cause a big problem.
Third all answers are only a question away.
TABLE OF CONTENTS
Basically MS Word 97, 2000, XP, 03 and 07 are the same. Where they differ most is in the menus and the newer versions
have more features. The basic operations of all are almost the same. The instructions
listed on these pages are just basic instructions. The toolbars differ a little
but the functions most people use daily are the same.
Office 2007 Fromat not compatiable with earliers
versions.
When a file is created in MS Office 07 and saved in 07 format the earlier
version cannot open, edit and save the formatting. 07 has features and
formatting that the earlier versions do not recognize. Microsoft has a conversion
tool out you can download to make 07 fromat work with the earlier versions
of MS Word so they can open, edit and save in the 07 format.
Download the convertion tool here but make sure you have all the Office Updates installed first.
.
A program that is supposed to open those hard to open Excel files.
You can use the Auto Shapes Toolbar to insert Auto Shapes.
Pick the Auto Shape you desire.
Click the worksheet you want to insert the Auto Shape and holding the
left mouse button down draw a line or shape depending if you are inserting
a line or a drawing.
Holding down the CTRL Key when you draw a line will keep the line
straight.
When you leave off the mouse button the Auto Shape will appear.
Adding Text to Auto Shape Objects:
Right click inside the Auto Shape.
On the Shortcut Menu click Add Text.
Type in the text you want added.
To Format the text right click inside the Auto Shape.
Right click inside the Auto Shape after the text is typed in.
On the Shortcut Menu click Format Auto Shape.
A window will open where you can format the text.
Adding Shadow to an Auto Shape:
Select the Auto Shape you want to add Shading to.
On the Drawing Toolbar click the Shadow Icon. (Will be on the right
end of the toolbar.)
Next click on the type of shading you want added.
Adding a Connector Line to two or more Auto Shapes or
Objects or Images:
Start Excel or PowerPoint.
If it is not already visible, display the Drawing toolbar.
On the View Menu, point to Toolbars, then click Drawing.
The Drawing toolbar appears at the bottom of the window.
Click AutoShapes on the Drawing toolbar.
Point to an AutoShape type, such as Basic Shapes.
Then click the shape that you want.
On the Drawing Toolbar click AutoShapes.
Point to Connectors.
Click the connector that you want.
Drag the mouse pointer between the objects that you want to connect.
Release the mouse and the objects will be connected.
Move one of the Objects or Images and the connecting line will move
with it.
To use in word copy and paste.
Not actually worth doing but to use in word:
Select all (CTRL +A)
On the Edit menu, click Copy.
Switch to Microsoft Word.
On the Edit menu, click Paste.
Now in Word MS left this out so when you move in Word 2000 the line WILL NOT move with the Objects or Images.
The close, minimize and maximize buttons are not there:
Click on Tools
Click on Options
Click on the View tab.
Remove the "windows in taskbar" checkmark.
Word has NO fix like this, though.
Cells:
Adding Borders:
Even though you see the lines outlining the cells they will not print
by default.
Adding Borders by using the Borders Icon:
Click the Cells you want to add a border to.
Click Borders Icon on the Formatting Toolbar. (Will look like a box
divided into 4 sections).
Click the Icon from the window that drops down that looks like the borders
you want to add to the cells.
Adding Borders by using the Formatting Window:
Select the cells you want to add a border to.
Right click on the cells.
The Shortcut Menu will open.
Click Format Cells.
The Formatting Window will open.
Click Borders Tab.
Select the Style first.
Select the Color you want to use next.
Select the Outline or the Borders you want to use next.
The Outline will be around the complete cell.
The Borders you select as to where you want the lines to be.
Click "OK" at the bottom of the window.
Apply Text and Graphics Formatting Multiple Times using
the "Sticky" Feature:
Select the item whose format you would like to copy.
To copy the selected format to several items, double-click the Format
Painter Button. The button stays selected, or "Sticky."
Select the text or graphic where you want to apply the new format.
When you're finished applying the format, click the Format Painter Button
again or press ESC.
Fill in a Series of Number, Dates, or Other Items:
Select the First cell in the range you want to fill.
Enter the Starting Value for the series.
To increment the series by a specified amount.
Select the next cell in the range and enter the next item in the
series.
The difference between the two starting items determines the amount
by which the series is incremented.
Select the cell or cells that contain the Starting Values.
Drag the Fill Handle over the range you want to fill.
To fill in increasing order, drag down or to the right.
To fill in decreasing order, drag up or to the left.
Notes
To specify the type of Series. Use the right mouse button to drag
the Fill Handle over the range. Click the appropriate command on the
Shortcut Menu.
Example
If the starting value is the date JAN-2002, click Fill Months for
the series FEB-2002, MAR-2002, and so on; or click Fill Years for
the series JAN-2003, JAN-2004, and so on.
To Manually Control how the series is created, or use the keyboard to
fill in a series, use the Series command.
Formulas that return arrays MUST be entered as Array Formulas.
Separating values in a cell.
Example: Changing from last, first name in a cell to each in separate cell.
Select the column you have the details in
Click on data on the formatting toolbar
Click text to columns
Select delimited
Click next
Uncheck tab
Check comma or type of separator
From here you can click Finish or Next if you want some other options.
This will split the values of the one cell into multiple cells, based
on how many separators there are.
Changing Indents in Cells:
Select the cells or Range you want to indent the text in.
Right click on them and the Shortcut Menu will open.
Click Format Cells.
The Format Cells window will open.
Click the Alignment Tab.
Here you can set the text alignment horizontally and vertically, also
set the indent of the text.
Clearing contents of a Cell:
Select the cells you want to clear the contents of.
Two ways to clear a cell or cells.
By using the Shortcut Menu, right click the cell and click Clear
Contents (Pressing the Delete Key will delete the cell or cells
completely and move the remaining cells up or across, depending, which
you select).. This will clear only the information in the cell.
By using the Edit Command on the Standard Toolbar.
Click Edit, Clear Contents, and then pick your choice, Clear Contents,
Clear Formats, or Clear All.
Clear All will clear contents and formatting.
Note
Pressing the Delete Key will delete the cell or cells completely
and move the remaining cells up or across, depending, which you select.
Deleting a Cell or Cells:
Select the cell or cells you want to delete.
Right click the cell or cells.
The Shortcut Menu will open.
Click Delete.
A window will open asking how you want to move the remaining cells.
Choose Shift Up, or Left.
Click "OK".
Editing a Cell:
A cell can be edited two ways.
A cell can be edited in the cell itself by just replacing the text
or formula.
A cell can be edited in the Formula Bar by replacing the text or
a formula.
Formatting Cells:
All cell formatting can be done using the same steps.
Select the cell or range of cells.
Right click on the cell or cells.
The Shortcut Menu will open.
Click Format Cells.
The Format Cells Window will open.
In this window you can apply any formatting you want using the different
tabs in the window.
Set the formatting for category, alignment, font, borders and shading,
patterns, and protection here.
Categories are:
Numbers
Currency
Accounting
Date
Time
Percentage
Fraction
Scientific
Text
Special
Custom
Hiding Zeros Values and Negative Numbers in Cells and
Columns
To hide zeros and negative numbers in cells and columns
Highlight the cells or columns you want to use
this format
Click on Format on the Toolbar
Click Click Cells or Columns
Click Custom in the left pane
In the right pane type in the following in the type box
0.;; hide numbers zero value or less
without decimal point
0.0;; hide numbers zero value
or less with decimal point and one zero
0.0;; hide numbers zero value
or less with decimal point and two zeros
$0.00;; hide numbers zero value
or less with $ sign, decimal point and two zero
Click OK
Inserting a Cell or Cells:
To insert an extra cell, click a cell next to where you want to insert
the extra cell.
Right click that cell and the Shortcut Menu will open.
To insert more than one cell, select the number of cells you want
to insert. If you want to insert 2 cells select 2 cells next to where
you want to insert them.
Click Insert.
A window will open asking how you want to shift the cells to insert
the extra cell.
Make your selection.
Click "OK".
Make a Copy that excludes Hidden Cells in Excel:
Note
When you use outlining or subtotals to create a small summary of
a large set of data, you can make a copy of just the displayed cells
in the summary, excluding the detail.
First display only the Summary Rows or Columns, and then select all
of the summary data.
On the Menu Toolbar click Edit, click Go To, click Special, and then
click Visible Cells Only.
Click the Copy Button.
Click a cell on a blank worksheet.
Click the Paste Button.
The copy includes only the summary data.
Merging Cells in a Workbook:
Select the cells you want to merge.
On the Formatting Toolbar click on Merge and Center Icon. Looks like
a box with an "a" in it with 4 arrows pointing in all 4 directions.
OR
Select the cells you want to merge
Right click on them
Click Format Cells
Click on the Alignment tab
At the bottom left put a tic in the Merge Cells
UN-merging Cells in a Workbook:
select the cell you want to un-merge
Right click in it
Click on Format Cells
Click on the alignment tab
Take the tic out of the Merge Cells at the bottom right
Adding Shading to Cells:
Select the cells you want to add shading to.
Right click on them.
A Shortcut Menu will drop down.
Click Format Cells.
Click Patterns Tab.
Click the color you want to use.
Click "OK".
Adding Clip Art:
Select the cell you want to place the Clip Art close to.
Click Insert on the Standard Toolbar.
Click Picture.
Click Clip Art.
The Clip Art Window will open.
Select the Clip Art you want to insert.
Click Insert Clip Art Icon on the drop down that appears when you select
the Clip Art Picture.
After the Clip Art is inserted you can move or re-size it to the way
you want it.
E-mail :
Note
You can use the Send To: To include the Specified Access Datasheet,
Form, Report, Module, or Data Access Page in an electronic mail message,
where it can be viewed and forwarded.
You can include objects in Microsoft Excel 2000 (*.xls), MS-DOS text
(*.txt), rich-text (*.rtf), or HTML (*.html) format in messages for
Microsoft Exchange, Microsoft Mail, Microsoft Windows for Workgroups
mail, or another electronic mail application that USES the Microsoft
Mail Applications Programming Interface (MAPI).
If Outlook or Outlook Express is your E-mail Client:
Click File On the Menu Toolbar.
Click Send To.
Click Mail Recipient or Mail Recipient (as attachment).
Depending on which mail program your using one of two things will open.
Your default E-mail program will open.
The window your working in will change to an E-mail program if
Outlook or Outlook Express is your default E-mail program.
To:
The recipients of the message whose names you want to put on the To
line in the mail message. If you leave this argument blank, Access prompts
you for the recipients' names.
Separate the recipients' names you specify in this argument and
in the Cc and Bcc arguments with a semicolon (;) or with the list
separator set on the Number tab of the Regional Settings Properties
dialog box in Windows Control Panel. If the mail application can't
identify the recipients' names, the message isn't sent and an error
occurs.
Cc:
The recipients of the message whose names you want to put on the Cc
("carbon copy") line in the mail message. If you leave this argument
blank, the Cc line in the mail message is blank.
BCC:
The recipients of the message whose names you want to put on the BCC
("blind carbon copy") line in the mail message. If you leave this argument
blank, the BCC line in the mail message is blank.
Subject:
The subject of the message. This text appears on the Subject line
in the mail message. If you leave this argument blank, the Subject line
in the mail message is blank.
Click Send a Copy.
If you use another MAPI E-mail Client:
Note
You can't include objects in Microsoft Active Server (*.asp) or Microsoft
IIS (*.htx, *.idc) format, although these selections are displayed in
the list.
To:
The recipients of the message whose names you want to put on the To
line in the mail message. If you leave this argument blank, Microsoft
Access prompts you for the recipients' names.
Separate the recipients' names you specify in this argument and in
the Cc and BCC arguments with a semicolon (;) or with the list separator
set on the Number tab of the Regional Settings Properties dialog box
in Windows Control Panel. If the mail application can't identify the
recipients' names, the message isn't sent and an error occurs.
Cc:
The recipients of the message whose names you want to put on the Cc
("carbon copy") line in the mail message. If you leave this argument
blank, the Cc line in the mail message is blank.
BCC:
The recipients of the message whose names you want to put on the BCC
("blind carbon copy") line in the mail message. If you leave this argument
blank, the BCC line in the mail message is blank.
Subject:
The subject of the message. This text appears on the Subject line
in the mail message. If you leave this argument blank, the Subject line
in the mail message is blank.
Message Text:
Any text you want to include in the message in addition to the database
object. This text appears in the main body of the mail message, after
the object. If you leave this argument blank, no additional text is
included in the mail message. If you leave the Object Type and Object
Name arguments blank, you can use this argument to send a mail message
without a database object.
Edit Message:
Specifies whether the message can be edited before it is sent. If
you select Yes, the electronic mail application starts automatically,
and the message can be edited. If you select No, the message is sent
without providing a chance to edit the message. The default is No.
Template File:
The path and file name of a file you want to use as a template for
an .html file. The template file is a file containing HTML tags.
Note
The Send To action is available only if you have a MAPI-compliant
electronic mail application installed on your computer, or if you have
a VIM-compliant electronic mail application and have installed and set
up Mapivi32.dll.
For information on how to install and set up Microsoft Access support
for VIM mail applications.
Add a Custom Address List to your Outlook Toolbar:
Notes
If you send E-mail to the same people frequently, you can automate
the process of creating and addressing the message.
With Outlook, you can add a custom toolbar button that lists the people
to whom you send E-mail most often.
Then, with one click, you can create a new message that's addressed
to the person you want to send it to. And, if you regularly send E-mail with
the same subject line, such as a weekly report, you can also create
a message that has the subject line filled in.
There are two parts to creating a Custom List of Recipients:
First, create the Toolbar Button.
Then, add the E-mail , Addresses and Subject Lines to it.
Create a Custom Toolbar Button:
On the Tools Menu, click Customize, and then click the Commands Tab.
In the Categories List, click New Menu.
In the Commands List, click New Menu and drag it to the toolbar. When
the pointer looks like an I-beam, release the mouse button.
On the toolbar, right-click the New Menu Button, and in the Name Box on
the Shortcut Menu, type a name for the New Toolbar Button.
Add E-mail Addresses and Subject Lines:
In the Customize Dialog Box, in the Categories List, click File.
In the Commands List, click Mail Message and drag it to the Custom Menu
Button that you added to the toolbar.
When you rest the pointer over the Custom Button, a gray box appears.
Drop the Mail Message command onto the gray box.
If you are adding a subsequent command, NO gray box will appear. Drop
the command onto the most recent command you added.
Note
If you want to use a different icon, choose the command from the Commands
List that has the icon you want.
Example
If you add a Distribution List, you can use the Distribution List
Command to get the Distribution List Icon.
On the toolbar, right-click the Mail Message Command, and in the Name
Box on the Shortcut Menu, type a name for the person, distribution list,
or alias you're assigning to the command.
Then, on the Shortcut Menu, point to Assign Hyperlink, and then click
Open.
Under Link to, click E-mail Address.
In the E-mail Address Box, enter the E-mail address of the person,
distribution list, or alias you want to assign to the command.
If you want this automatically addressed message to also have a standard
subject line, such as Status Report, type it in the Subject Box.
Repeat these steps for each person, group, or standard subject line
you want to add to the button.
E-mail attachments:
Can't open .xls extension as E-mail attachments:
Excel works with any documents that are saved on the Desktop or on the
network but not with attachments.
Open excel
Click on tools
Click on options
Take the tick out of the "Ignore other applications"
Errors:
Tracing Errors:
A Red Trace Line means an Error.
A Blue Trace Line means No Error.
Click Tools on the Standard Toolbar.
Click Auditing.
Click Trace Error.
To find an error in a formula follow the Red Arrows back to the source.
Check your formula for a mistake.
Make the correction and all lines should turn Blue.
Identifying Invalid Data:
Click Circle Invalid Data Button on the Auditing Toolbar.
All cells with Invalid Data will now have a Red Circle around the data.
Expressions:
Expressions that use Text Values as Criteria:
These work with letters and names also. I just happen to use dates here:
Expression Description:
8/5/99
Returns the exact number or in this case date
<8/5/99
Returns all number or in this case dates before
>8/5/99
Returns all numbers or in this case dates after
>>=8/5/99
Returns all numbers or in this case dates on or after
<=8/5/99
Returns all numbers or in this case dates on or before
Not<8/5/99
Returns all numbers or in this case dates not before
Not>8/5/99
Returns all numbers or in this case dates not after
"London"
Displays all entries, which have London.
"London" Or "Hedge End"
Uses the Or operator to display all entries that have London or
Hedge End
Between #1/5/95# And #1/10/95#
The Between.. And operator to show all entries no earlier than 5-Jan-95
and no later than 10-Jan-95.
#2/2/95#
Displays all entries that have the date 2-Feb-95.
In("Canada", "UK")
Uses the In operator to display all entries that include Canada
or the UK.
Not "USA"
Uses the Not operator to all entries that do not have USA.
Like "S*"
Entries that start with the letter S.
Like "*Imports"
Entries whose names end with the word "Imports".
Like "[A-D]*"
Entries that start with A through D.
>="N"
Displays all entries that start with the letters N through Z.
Is Null
Displays all entries where that field is Null (blank).
Is Not Null
Displays all entries where the field contains a value.
Like "*ar*"
Entries that include the letter sequence "AR".
Like "Rick Selb?"
Entries with "Rick" as the first part of its name and a 5-letter
second name in which the first 4 letters are "Selb" and the last letter
is unknown.
Formulas:
Note
Always type in the equal sign first. Excel has over 300 Formulas included.
Protecting Formulas
Protecting formulas requires separating cells with formulas from ordinary cells in the sheet, Locking them, and then protecting the sheet
The cell must be locked and the sheet must be protected
Step One
By default all cells are locked when
protected in the Worksheet and Workbook
Before you can protect certain cells you have to remove the default
setting
To do this open the Worksheet, make sure it isn't protected
Click Tools
Click Protection
Make sure the sheet is unprotected
Press CTRL+A to select all cells
Click Format
Click Cells
Click Protection tab
Remove checks from Locked and Hidden if they
have a check in them
Click OK
Step Two
Selecting Cells With Formulas
Press F5
Click Special button at bottom right in the Go To
Special window
Select the Formulas option
Then choose the options for the formula you would like to
protect
Click OK
Step Three
Lock The Cell
Select a cell in the sheet and press Ctrl+1
The Format Cells dialog window will open
Click on the Protection tab
Check the Locked option
Step Four
Protect A Worksheet
Click Tools on the Standard toolbar
Click Protection
Click Protect Sheet
Click OK
Note: You do not need to use a password if you do not
want
Using Paste Functions and the Formula Palette:
Paste Function window
You can use a command called the Paste Function. It works like a Function
Wizard.
Select the cell you want to paste the formula in.
Click Paste Function Icon on the Standard Toolbar. (Looks something
like f*)
The Paste Function window will open.
On the right side of the window choose the Category.
On the left side of the window choose the Function Name.
Below the Category side of the window it will show an explanation of
the Function.
Click "OK" after you have chosen the Function you want.
Entering Formulas in Cells Directly:
A formula can be entered in the cell directly.
Type in the Equal Sign first (=) without the brackets.
Type in the formula.
A formula will be typed in similar to this =A1+A2+A3-B2 (Not case sensitive)
OR =Sum(A1:A3)-B2, both are the same.
Click Enter Key.
Entering Formulas by Dragging:
To enter a formula from the cell above (=sum(A1:J1) in cell K1.
Select cell K1 and move the mouse to the lower right corner till it
turns into a Cross.
Hold down the left mouse button and drag down to K2, K3.
The formula will change in each cell as you go down. Row 2 will be (=sum(A2:J2)
Row 3 will change to (=sum(A3:J3) and so on down the table.
Entering Formulas in the Formula Bar:
You also can type the formula in the Formula Bar.
Type in the Equal Sign first (=) without the brackets.
Type in the formula.
A formula will be typed in similar to this =A1+A2+A3-B2 (Not case sensitive)
OR =Sum(A1:A3)-B2, both formulas have the same result.
Click Enter Key.
Entering Formulas by Selecting Cells:
To enter a formula that calculates the sum of A1 to A3 times B1.
Select the cells A1 to A3.
Click the Sum Icon on the Formatting Toolbar.
Type in the minus sign (-) without the brackets.
Select cell B1.
Click Enter Key.
For my French/Canadian friends:
Under Accounting and Currency check the drop down list for symbols and
you will find French/Canadian Currency listed along with other conversions.
Freezing:
Freezing Rows and Columns:
Select the cell to the right and under where you want to Freeze the
rows and columns.
Click Window on the Standard Toolbar.
Click Freeze.
Unfreezing Rows and Columns:
Click Window on the Standard Toolbar.
Click Unfreeze.
Headers and footers:
Adding a Header:
Click File on the Standard Toolbar.
Click Print Preview.
Click Setup... Tab.
Click Headers/Footers Tab.
Click Custom Header Tab.
You can type in each section what you want in the header.
In the Center section you will see "&Tab" this you can delete.
You can select Date, Fonts, Page Numbers and whatever from the icons
to auto insert if you want.
Click "OK".
Adding a Footer:
Click File on the Standard Toolbar.
Click Print Preview.
Click Setup... Tab.
Click Headers/Footers Tab.
Click Custom Footer Tab.
You can type in each section what you want in the header.
In the Center section you will see "& Tab" this you can delete.
You can select Date, Fonts, Page Numbers and whatever from the icons
to auto insert if you want.
Click "OK".
Keyboard functions:
Keys for Entering Data on a Worksheet:
ENTER:
Complete a cell entry and move down to the beginning of the next
row
ALT+ENTER:
Start a new line in the same cell
SHIFT+ENTER:
Complete a cell entry and move up to the cell directly above the
one you're in
TAB:
Complete a cell entry and move to the next cell to the right
SHIFT+TAB:
Complete a cell entry and move to the next cell left
ESC:
Cancel a cell entry
DELETE:
Delete the character to the right of the insertion point, or delete
the selection
CTRL+DELETE:
Delete text to the end of the line
ARROW KEYS:
Move one character up, down, left, or right
HOME:
Move to the beginning of the row you're working in
Keys for working in cells or the formula bar:
BACKSPACE:
Edit the active cell and then clear it, or delete the preceding
character in the active cell as you edit cell contents
ENTER:
Complete a cell entry
ESC:
Cancel an entry in the cell or formula bar
= (EQUAL SIGN):
Start a formula
CTRL+;(SEMICOLON):
Enter the date
CTRL+SHIFT+:(COLON):
Enter the time
Keys for moving and scrolling in a worksheet or workbook:
ARROW KEYS:
Move one cell up, down, left, or right
CTRL+ARROW KEY:
Move to the edge of the current data region
HOME:
Move to the beginning of the row
CTRL+HOME:
Move to the beginning of the worksheet
CTRL+END:
Move to the last cell on the worksheet, which is the cell at the
intersection of the rightmost used column and the bottom-most used
row (in the lower-right corner), or the cell opposite the home cell,
which is typically A1
TAB:
Move to the next cell to the right
Mail merge:
Using Excel with Word Mail Merge:
Open Word.
Click Tools on the Standard Toolbar.
Click Mail Merge.
A new window will open.
Click Create under Main Document.
Click Mailing Labels or whatever you want to use.
Another window will open and choose you document you want to use.
The document you are using now.
A new document.
Next click Get Data under Data Source.
Click Open Data Source.
The Find Data Source window will open.
At the bottom of the window make sure you select the correct file type
under file type.
Find the Excel file that has the names and addresses you want to use.
A new window will open asking what Range or Worksheet you want to use.
Make your selection.
Another window will open telling you to click "Set Up Document".
Click Set Up Document.
It will then set up your document.
The Label Option window will open.
Here you have to choose your printer, the make of labels you will be
using, and the number of the labels you will be using.
Click "OK".
Next the Create Label window will open.
Click Insert Merge Field.
Click the fields you want to insert, remember to add space where they
will be needed and to press the Enter Key to go to the next line of the
address.
Click "OK" after all fields are inserted.
Click "Merge" Button.
The Merge Window will open.
Choose where you want to merge.
Next choose the records you want to merge.
All or From
Click Merge.
Word will set up you mailing labels for printing.
Moving data:
Moving data using Drag and Drop on the same Worksheet:
Select the cells you want to move.
Move the mouse to one of the borders.
The cursor will change from a cross to a pointer.
Drag the box to the area you want to move it to.
Release the mouse button.
Moving Data using Drag and Drop to another Worksheet:
Select the cells you want to move to another worksheet.
Right click on the cells.
The Shortcut Menu will open.
Click Cut.
Click on the worksheet at the bottom you want to move it to.
Click in a cell you want to enter the information in. Excel will place
the data in the same number of cells it used on the other worksheet.
Right click and the Shortcut Menu will open.
Click Paste.
Copying Data to Another Area or Worksheet:
Select the data you want to copy.
Right click the cells.
The Shortcut Menu will open.
Click Copy.
Go to the area or worksheet you want to copy the data to.
Right click on the cell you want to copy it to.
The Shortcut Menu will open.
Click Paste.
Name Ranges:
Creating and Naming a Range:
Select the cells you want to use for the Range.
In the Name Box type in the name you want to give to the selected cells.
Press the Enter Key.
Deleting a Name Range:
Open the Define Name Dialog Box, (press the CTRL+F3 keys).
Select the Range Name you want to delete.
Click the Delete key.
Page Numbers:
Inserting Page Numbers:
Click on File
Page Setup
Then click on the Header/Footer tab
Click on the Header or Footer button.
Page numbers can be put either in the header or the footer.
Place the cursor in the section where you want the page number
Left if you want the page number at the left
Center if you want the page number in the center
Right if you want the page number at the right
Click on the # icon
Click OK.
Page Breaks:
Inserting a Page Break:
Click View on the Standard Toolbar.
Click Page Break Preview.
In the new view you will see Dotted Blue Lines and Gray Page Numbers.
The dotted blue lines represent the page outlines.
The gray page numbers represent the order that the pages will print.
You can add page breaks by right clicking in the Page Break Preview
Window.
You can add additional page breaks above and to the left of the
active cell.
Deleting a Page Break:
Click View on the Standard Toolbar.
Click Page Break Preview.
In the new view you will see Dotted Blue Lines and Gray Page Numbers.
The dotted blue lines represent the page outlines.
The gray page numbers represent the order that the pages will print.
You can delete page breaks by right clicking in the Page Break Preview
Window.
Printing
Printing Options:
Select the area you want to print.
Click File on the Standard Toolbar.
Click Print Area.
Click Set Print Area.
Click Print Preview.
The Print Area will be outlined in yellow.
If a blue dotted line appears in the print area that shows what can
fit on the page with the page settings.
If a blue dotted line does appear you will have to change the page setup,
(Landscape, Portrait and Scaling) to fit the worksheet on the page.
Or you can set it up to print multiple pages.
You can move these blue dotted lines by moving the mouse over them
till the pointer changes to a double headed pointer and holding down
the left button on the mouse and dragging it to where you want it.
You might have to play with the setting to achieve the final goals you
want. It will depend on the worksheets your printing as how you will have
to set them up.
Rows and columns:
Inserting a Column:
To insert a New Column, it will be inserted to the left of the one you
select.
Select a column; the new column will be inserted to the left of the
one you select.
Right click on that column.
The Shortcut Menu will open.
Click Insert.
You can also place the cursor in a cell and right click to insert
a new column.
The Shortcut Menu will open.
Select "entire column".
Click "OK".
The column will be inserted to the left of the cell you selected.
Deleting a Column:
Right click the Column Heading you want to delete.
The Shortcut Menu will open.
Click Delete.
Inserting a Row:
To insert a row, it will be inserted above the row you select.
Select the row you want the new row inserted above.
Right click and the Shortcut Menu will open.
Click Insert.
The new row will be inserted above the row you selected.
You also can place the cursor in a cell to insert a new row.
Right click the cell you want the new row placed above.
The Shortcut Menu will open.
Click Insert.
A window will open select "Entire Row".
The new row will be placed above the cell you selected.
Deleting a Row:
Right click the Row Heading.
The Shortcut Menu will open.
Click Delete.
Modifying the Size of a Column using Auto Fit:
Move the mouse to the line left of the Column Heading(the line that
separates the columns) you want to re-size
The mouse will change to a line with 2 arrows pointing left and right.
Double click on the mouse while the pointer is shaped like a line with
2 arrows.
This way the column is automatic re-sized according to the information
in the column.
Modifying the Size of a Column Manually:
Move the mouse to the line left of the Column Heading (the line that
separates the columns) you want to re-size
The mouse will change to a line with 2 arrows pointing left and right.
Holding the mouse down, drag the line to the width that you want the
column to be.
Modifying the Size of a Row using Auto Fit:
Move the mouse to the line below the Row Heading that you want to re-size
(The line that separates the rows.)
The mouse will change to a line with 2 arrows pointing up and down.
Double click on the line while the pointer is shaped with the line and
2 arrows.
Modifying the Size of a Row Manually:
Move the mouse below the Row Heading that you want to re-size (The line
that separates the rows.)
The pointer will change to a line with 2 arrows pointing up and down.
Holding the mouse down, drag the line to the width you want it to be.
Transpose a Column of Data to a Row:
Example
Dairy
Meat
Beverages
Produce
Change to a row of data.
Dairy Meat Beverages Produce
Follow these steps to Transpose a Row of Data into a Column or
vice versa:
Select the cells that you want to switch.
Click Copy on the Edit Menu.
Select the upper-left cell of the paste area.
The paste area must be outside the copy area.
On the Edit menu, click Paste Special.
Select the Transpose Check Box.
Notes
Data from the top row of the copy area appears in the left column
of the paste area, and data from the left column appears in the top
row.
For more information on options in the Paste Special Dialog Box,
click the? in the upper-right corner of the dialog box, and then click
the option you want to learn more about.
Saving:
Saving a Workbook:
The first time you save a workbook:
When you first open a workbook save it.
The first time you save a workbook save it using the "Save As" command.
Press the "F12" button.
OR you can "Save As" by clicking File on the Standard Toolbar, then
click Save As.
A window will open.
At the top you will see "Save in:"
Chose the folder you want to save it in.
At the bottom you will see "File Name:"
There type in the name you want the workbook to have.
Below that it ask you to select the format you want to save it as.
Unless for unknown reasons save it as "Microsoft Excel Workbook".
Then click the Save button.
Saving a Workbook after the first time:
The Save Icon is on the Standard Toolbar and looks like a TV.
It will be the third icon in from the left.
Click the Save Icon.
OR you can save by clicking File, Save.
Remember to save your workbook often as you use it. This way if for
some reason you lose the workbook it will be saved.
You could lose your workbook if the program would malfunction.
The computer would stall.
You lose your current.
Selecting:
Selecting Cells by Dragging the Mouse:
Click on the first cell you want to select.
Holding the mouse button down, drag the mouse to the right and then
down to select the range of cells you want to select.
After you have selected the cells, let off the mouse button.
Selecting Cells by using the Name Box:
In the Name Box type in the location of the first cell you want to use.
Example
A1
Place a colon (:) after the location of the first cell.
Type in the location of the last cell you want to select.
Example
G55
Press the Enter Key. Cells A1 through G55 will be selected.
Sorting:
Sorting Information by a Single Column:
Place the cursor in any cell in the column.
On the Standard Toolbar click the icon with the AZ or ZA with an arrow
on it.
The AZ Icon with the arrow pointing down will sort from A to Z.
The ZA Icon with the arrow pointing down will sort from Z to A.
The worksheet will be arranged according to the sort you selected.
Notes
If you have a heading make sure you insert a blank row between the
row with the Heading names and the rows with the information you want
to sort.
If you do not do this, the Heading row will be sorted with the information.
If you do not want to insert a blank row, you have to sort using the
Sort Dialog Box.
Sorting Information by using the Sort Dialog Box:
You can sort by as many as 3 criteria using the Sort Dialog Box.
Place the cursor in the column you want to sort by.
Click Data on the Standard Toolbar.
Click Sort.
The Sort Dialog Box will open.
At the bottom of the window you will see "My list has"
Select one of the other, either you have a heading row or you don't
have a heading row.
Then at the top in the Sort by, click the drop-down arrow and select
what you want to sort by first.
Then select the AZ or ZA sort by.
Then click on the drop down arrow in the "Then by" and select the next
criteria you want to sort by.
Then Select the AZ or ZA sort.
If you want to set another criteria to sort by, go to the second "Then
by" window and make your selections.
Click "OK".
Styles:
Applying Styles:
Click Format on the Standard Toolbar.
Click Style.
The Style Dialog Box will open.
Click Style Name list arrow.
Choose the rest of the formatting for the style that you would like
to include.
The Fonts, Alignment, Borders, Patterns, and Protection formatting are
listed with the "Modify" button.
Click "OK".
Setting Up A Tab Order For Certain Cells
This is a way to Tab to certain cells and skip over others
Select the starting cell
Press and hold the Ctrl key
Click each cell that you will want to go to next, in the order that
you will want the tab to work
Click View
Click Custom Views
Click Add
Give this a name of some sort "SpecialTabOrder"
Click OK
Save the workbook
To utilize that tab order
Click on View
Custom View
Select the name you assigned "SpecialTabOrder"
Click Show
Text:
Move Text and Graphics with the "Spike":
Select an Item you want to Move, and then press CTRL+F3.
Repeat this step until all the items are on the Spike.
Click a place in the current document, or in a new document, where you
want to paste the items.
Do one of the following:
If you want to Paste the items Once and Empty the Spike, press CTRL+SHIFT+F3.
If you want to Paste the items Multiple times, Type Spike, and then
press F3.
Rotating Text:
Select the cells or Range you want to format or rotate the texts.
Right click on them and the Shortcut Menu will open.
Click Format Cells.
The Format Cells window will open.
Click the Alignment Tab.
You can click on the line in the window with "Text" written on the right
under Orientation and drag the line to the degrees you want the text angled
at.
Or you can type in the degrees you want it angled at.
When opening excel files, for each file that is opened,
another instance of Excel is loaded, so if I need to open six workbooks, I load
six instances of Excel:
To stop this from happening
Go to Tools
Options
Click on the View tab.
Uncheck Windows in taskbar.
Note: In Word 2000 you can't do this.
"Excel could not start the E-mail program" error
message when you use the Send To command in Excel 2002
Error Message
When you use the Send To command in Microsoft Excel 2002,
you may receive the following error message or an error message that is
similar to the following:
Excel could not start the E-mail program.
Check your network connection. Make sure Office is installed correctly,
you E-mail program is set up correctly, and you can connect to
your E-mail server.
Cause
This behavior occurs if all the following conditions are true:
Microsoft Office Outlook 2003 is your mail
client.
You try to send the workbook as the body of
the message to the recipient.
Solution
Another one of Microsoft's Goofs, you have to E-mail the workbook
as attachments or try the suggestions below.
Send the workbook as an attachment from Excel 2002
Save the workbook in Excel 2002, and then add the workbook
file as an attachment to a message from Outlook 2003
Open the workbook in Microsoft Office Excel 2003, and then
send it to the recipient as the body of the message.
Try the following, I am told this works. (Provided by Vijaye
Bawri )
When you open a Microsoft Excel workbook (.xls file), Excel does
not open the file, and you may receive the following error message:
Cannot find the file 'path' (or one of its
components). Make sure the path and filename are correct and that all
required libraries are available.
Excel may actually open, but the file will not open. If Excel is already
running, a second instance of Excel may start
Solution
Open Excel
On the Tools menu, click Options
Click the General tab
Click to clear the Ignore other applications check box
Click OK
After you do this, you should be able to open workbooks by double-clicking
them in Windows Explorer
DISCLAIMER: The information provided
on ALL of these pages is provided as-is. No warranty is provided or implied. Use
at your own risk.
All content on these pages has been gathered and compiled by Rick Selby. Privacy
Policy
Drug History if you are looking for buy viagra test Research Drug Overdose did you know that like to take Viagra? if you have never heard of buy viagra 100mgOld man who takes Viagra You`ve probably heard of the term Buy viagra Online Now