Rick Selby's Microsoft Windows Excel Help Page

Outlook 2002 & 2003 Outlook & Outlook Express Import & Export Outlook Express Files Export Outlook Express to Windows Live Mail Hotmail More E-mail Problems

Tricks and Tips for Office Office 2002-03 Installing Office Errors MS "Word" MS Works MS Excel Access Tables Access Forms Access Queries Access Reports FrontPage Errors

Microsoft Shortcut Key and Office Shortcut Keys Microsoft XP Shortcut Keys

Window Media Player Hyper Links & Shortcuts Printing Favorite Links

"In God" † Prayer Requests † Jesus Help Page † Tribute to Sept. 11, 2001
"Christian" Merchandise † "If You Were The Father"

Think Adoption, NOT Abortion

United States spends more money killing people than taking care of its own?

Bush and his cronies

NOT to help poorer America.

Social Security, the money is running out?

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

Need Help, click here for support.

you will not be able to find drivers for your hardware at this time.

Vista 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

MS Word 97

2000

Office 2007 Fromat not compatiable with earliers versions.

MS Office 07 and saved in 07

earlier version cannot open, edit and save the formatting.

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.

Click here to download.

Excel XP & 03

Excel 97, 2000, XP & 03

Auto Shapes:

Inserting Auto Shapes
Adding Text to Auto Shape Objects

Adding Shadow to an Auto Shape

Adding a Connector Line to two or more Auto Shapes or Objects or Images

Buttons:

The close, minimize, and maximize buttons are not there

Cells:

Adding Borders by using the Borders Icon
Adding Borders by using the Formatting Window

Apply Text and Graphics Formatting Multiple Times using the "Sticky" Feature

Auto Fill

Separating values in a cell. (Example: Changing from last name, first name in a cell to each in separate cell.)

Changing Indents in Cells

Clearing contents of a Cell

Deleting a Cell or Cells

Editing a Cell

Formatting Cells

Hiding Zeros Values and Negative Numbers

Inserting a Cell or Cells

Make a Copy that excludes Hidden Cells in Excel

Merging Cells in a Workbook

Un-merging Cells in a Workbook

Shading

Clip art:

Adding clip art
Adding a connector line to two or more Auto Shapes or Objects or Images

E-mail :

"Excel could not start the E-mail program" error message when you use the Send To command in Excel 2002

If Outlook or Outlook Express is your E-mail Client
If you use another MAPI E-mail Client

Add a Custom Address List to your Outlook Toolbar

There are two parts to creating a Custom List of Recipients

Create a Custom Toolbar Button

Add E-mail Addresses and Subject Lines

E-mail attachments:

Can't open .xls extension as e-mail attachments

Equation Editor

Errors:

Cannot Empty Clipboard Error Message

Tracing errors
Identifying Invalid Data

Expressions:

Expressions that use Text Values as Criteria

Formulas:

Protecting Formulas

Using Paste Functions and the Formula Palette
Entering Formulas in Cells Directly

Entering Formulas by Dragging

Entering Formulas in the Formula Bar

Entering Formulas by Selecting Cells

Freezing:

Freezing Rows and Columns
Unfreezing Rows and Columns

Headers and footers:

Adding a Header
Adding a Footer

Keyboard functions:

Keys for Entering Data on a Worksheet
Keys for working in cells or the formula bar

Keys for moving and scrolling in a worksheet or workbook

Mail Merge:

Merging with word

Moving Data:

Moving data using Drag and Drop on the same Worksheet
Moving Data using Drag and Drop to another Worksheet

Copying Data to Another Area or Worksheet

Name ranges:

Creating and Naming a Range
Deleting a Name Range

Page Numbers:

Inserting a Page Numbers

Page Breaks:

Inserting a Page Break
Deleting a Page Break

Printing:

Printing Option

Rows and columns:

Inserting a Column
Deleting a Column

Inserting a Row

Deleting a Row

Modifying the Size of a Column using Auto Fit

Modifying the Size of a Column Manually

Modifying the Size of a Row using Auto Fit

Modifying the Size of a Row Manually

Transpose a Column of Data to a Row

Saving:

Saving a Workbook
Saving a Workbook after the first time

Selecting:

Selecting Cells by Dragging the Mouse
Selecting Cells by using the Name

Sorting:

Sorting Information by a Single Column
Sorting Information by using the Sort Dialog Box

Styles:

Styles, applying

Tabs

Setting Up A Tab Order For Certain Cells

Text:

Move Text and Graphics with the "Spike"
Rotating Text

Trouble Shooting (Most are covered on the Troubleshooting Page):

Excel opens without displaying a workbook
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

Auto Shapes:

Inserting Auto Shapes:

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.

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.
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

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
Change to a row of data.
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:

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 )
- Add the following lines in "win.ini" file.

Excel opens without displaying a workbook

Error Message

When you open a Microsoft Excel workbook (.xls file), Excel does not open the file, and you may receive the following error message:
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