How To Enter, Edit, and Delete Data In Microsoft Excel 2003

excel 2003 -edit-links-menus

Tags:- office.com/ setup,office.com /setupoffice.com/setup     

Introduction

By the end of this lesson, you should be able to:

  • Enter text in a cell
  • Edit information in a cell
  • Delete information in a cell
  • Select multiple cells

Entering text in a cell

You can enter three types of data in a cell: text, numbers, and formulas. Text is any entry that is not a number or formula. Numbers are values that are used when making calculations. Formulas are mathematical calculations.

To enter data into a cell:

  • Click the cell where you want to type information.
  • Type the data. An insertion point appears in the cell as the data is typed.

    The Insertion Point

  • The data can be typed in either the cell or in the Formula bar.

    Text is Entered in Cell or Formula Bar

  • Data being typed appears in both the active cell and Formula bar.

    Text Appears in Cell and Formula Bar When Typed

  • Notice the Cancel and Enter buttons in the formula bar.

    The Excel 2003 Formula Bar

  • Click the Enter button Enter button to end the entry and turn off the Formula bar buttons.

Excel’s AutoComplete feature keeps track of previously entered text. If the first few characters you type in a cell match an existing entry in that column, Excel fills in the remaining characters for you.

Editing information in a cell

Information in a spreadsheet is likely to change over time. Information can be changed in the following ways.

Quick and easy method:

  • Click the cell that contains the information to be changed.
  • Type the new entry. The old entry is replaced by the new entry.

If the original entry is long and requires only a minor adjustment (in spelling, for example), then you can directly edit the information in the cell.

To edit information in a cell:

Method 1: Direct cell editing

  • Double-click the cell that contains the information to be changed.
  • The cell is opened for direct editing.

    Direct Cell Editing

  • Make the necessary corrections.
  • Press Enter, or click the Enter button on the Formula bar Enter button to complete the entry.

Method 2: Formula bar editing

  • Click the cell that contains the information to be changed.
  • Edit the entry in the Formula bar.

    Edit Information in the Formula Bar

Deleting information in a cell

To delete data that already appears in a cell:

  • Click the cell that contains the information to be deleted.
  • Press the Delete key, OR
  • Right-click and choose Clear Contents from the shortcut menu.

    Clear Contents selection on the Shortcut Menu

To delete data being typed but not yet added to the cell:

  • Cancel an entry by pressing the Escape key.

Performing Undo and Redo actions

Sometimes you might do something to a spreadsheet that you didn’t mean to do, like type the wrong number in a cell. Excel 2003 allows you to undo an operation. Use the Undo button Undo button on the Standard toolbar to recover an error. The last single action is recoverable.

To undo recent actions (typing, formatting, etc.) one at a time:

  • Click the Undo button Undo button.

To undo several recent actions at once:

  • Click the arrow next to the Undo button.
  • Select the desired Undo operation(s) from the list.

    The Undo List Box

  • Microsoft Excel reverses the selected action and all actions that appear in the list above it.

An Undo operation can be cancelled by applying a Redo. This is useful when an Undo operation was mistakenly applied. Remember, a Redo is possible only if you have not changed an Excel spreadsheet since the last Undo operation was completed:

To Redo an Undo operation:

  • Press the  Redo button.

To Redo several recent Undo actions at once:

  • Click the arrow next to Redo button.
  • Select the desired Redo operation from the list.
  • Microsoft Excel reverses the Undo operation.

To select the entire worksheet:

  • Click the gray rectangle in the upper-left corner to select entire worksheet.

    Select Entire Workbook

If the cells and columns you want to select are not directly next to one another, select one of the ranges you want to select and hold down the Control key while selecting other ranges.

Use Cntrl Key to Select Specific Columns, Rows, Cells

Blogs :  www.office.com /setup

How to Add Hyperlinks In Microsoft PowerPoint Presentation 2010

hyperlinks 2010

  Tags:- office.com/ setup,office.com /setupoffice.com/setup     

In PowerPoint, you can connection to a page, email address, document, slide in a similar introduction, and slide in an alternate introduction. You can do the greater part of this utilizing two apparatuses called hyperlinks and activity catches.

In this lesson, you will figure out how to embed hyperlinks utilizing content and protests, and additionally how to embed an activity catch.

Survey the hyperlink

In PowerPoint, hyperlinks end up dynamic in Slide Show see. When you see the slide in Slide Show see, you’ll see that the pointer transforms into a hand as it draws nearer to the hyperlink. The hand pointer demonstrates that the content or protest can be clicked. Since this content is naturally organized uniquely in contrast to other content on the slide, the hand pointer is most valuable for hyperlinks that utilization a question, for example, a photo or shape.

In the event that you float over the hyperlink, a ScreenTip will show up on the off chance that you made one when you embedded the hyperlink. Tap the hyperlink to open the site page if the PC is associated with the Internet.

ScreenTip Example

To embed a hyperlink to a slide in a similar introduction:
  • Select the content or protest you need to use as a hyperlink. In this case, we will utilize content.

Text Hyperlink

  • Select the Insert tab.
  • Tap the Hyperlink summon in the Links gathering. The Insert Hyperlink exchange box will show up.

Hyperlink Command

  • On the off chance that you utilize content for the hyperlink, the Text to show handle will seem dynamic in the exchange box. The content you select on the slide will show up in this field.

Insert Hyperlink Dialog Box

  • Snap Place in this Document to connection to a slide in the present introduction. The substance of the Insert Hyperlink exchange box will change, and a rundown of slides in the introduction will show up.

Place in this Document

  • Look through the rundown.
  • Select the slide you need to connection to from the hyperlink. A thumbnail picture of the slide will show up in the Slide see region.

Choose Slide

  • Choose whether you need to include a ScreenTip.
  • To embed a ScreenTip:

1.Snap ScreenTip. The Set Hyperlink ScreenTip exchange box will show up.

2.Enter the tip content.

3. Snap OK in the Set Hyperlink ScreenTip exchange box.

  • Snap OK to close the Insert Hyperlink exchange box.

View the slide in Slide Show view, and tap the hyperlink to see the chose slide.

Read More Blogs :  Office setup help

How To Align Text In Microsoft Excel 2007

How to align text vertically in Excel

Tags:- office.com/ setup,office.com /setup office.com/setup     

                                                                  Introduction

Worksheets that have not been arranged are regularly hard to peruse. Luckily, Excel gives you numerous devices that enable you to arrange content and tables in different ways. One of the ways you can design your worksheet so it’s less demanding to work with is to apply distinctive sorts of arrangement to content.

In this lesson, you will figure out how to left, focus, and right adjust content; consolidation and focus cells; vertically adjust message; and apply diverse sorts of content control.

                Aligning text

Excel 2007 remaining adjusts content (marks) and right-adjusts numbers (values). This makes information less demanding to peruse, however you don’t need to utilize these defaults. Content and numbers can be characterized as left-adjusted, right-adjusted, or focused in Excel.

To adjust content or numbers in a cell:

  • Select a cell or scope of cells.
  • Tap on either the Align Left, Center, or Align Right summons on the Home tab.

Alignment Commands

  • The content or numbers in the cell(s) go up against the chose arrangement treatment.

Left-click a segment name to choose a whole section or a column mark to choose a whole line.

Changing vertical cell alignment

You can likewise characterize vertical arrangement in a cell. In vertical arrangement, data in a cell can be situated at the highest point of the cell, center of the cell, or base of the cell. The default is base.Vertical Examples

To change vertical alignment from the alignment group:

  • Select a cell or scope of cells.
  • Tap the Top Align, Center, or Bottom Align order.

Vertical Alignment

Changing text control

Content control enables you to control the way Excel 2007 presents data in a cell. There are two basic kinds of content control: Wrapped content and combined cells.

Wrapped Text wraps the substance of a cell over a few lines if it’s too vast than the section width. It builds the tallness of the cell too.

Text Wrap Example

Merge Cells can also be applied by using the Merge and Center button on the Home tab.

Merge Example

To change text control:

  • Select a cell or scope of cells.
  • Select the Home tab.
  • Tap the Wrap Text summon or the Merge and Center order.

Text Control

On the off chance that you alter your opinion, tap the drop-down bolt alongside the charge, at that point pick Unmerge cells.

Blogs :  Office com setup

How To Use Mail Merge In Microsoft Word 2010

Mail-Merge-in-Word-2010

       Tags:- office.com/ setup,office.com /setupoffice.com/setup     

Mail Merge is a valuable apparatus that will enable you to effectively deliver various letters, names, envelopes, and all the more utilizing data put away in a rundown, database, or spreadsheet. In this lesson, you will figure out how to utilize the Mail Merge Wizard to make an information source and a frame letter, and investigate other wizard highlights. Furthermore, you will figure out how to utilize the Ribbon summons to get to Mail Merge devices outside of the wizard.

                 To utilize Mail Merge:

  • Select the Mailings on the Ribbon.
  • Select the Start Mail Merge summon.

Mail Merge

  • Select Step by Step Mail Merge Wizard.

The Mail Merge undertaking sheet shows up and will manage you through the six principle ventures to finish a consolidation. You will have a few choices to make amid the procedure. The accompanying is a case of how to make a shape letter and consolidation the letter with an information list.

Stages 1-3

  • Pick the sort of archive you need to make. In this illustration, select Letters.
  • Snap Next:Starting archive to move to Step 2.
  • Select Use the present archive.
  • Snap Next:Select beneficiaries to move to Step 3.
  • Select the Type another rundown catch.
  • Snap Create to make an information source. The New Address List exchange box shows up.
    • Snap Customize in the exchange box. The Customize Address List discourse box shows up.
    • Select any field you don’t need, and snap Delete.
    • Snap Yes to affirm that you need to erase the field.
    • Keep on deleting any pointless fields.
    • Snap Add. The Add Field exchange box shows up.
    • Enter the new field name.
    • Snap OK.
    • Keep on adding any fields vital.
    • Snap OK to close the Customize Address List discourse box.

                      To redo the new address list:

Mail Merge

  • Enter the vital information in the New Address List exchange box.
  • Snap New Entry to enter another record.
  • Snap Close when you have entered the greater part of your information records.
  • Enter the document name you need to spare the information list as.
  • Pick the area where you need to spare the record.
  • Snap Save. The Mail Merge Recipients discourse box shows up and shows the greater part of the information records in the rundown.
  • Affirm that the information list is right, and snap OK.
  • Snap Next:Write your letter to move to Step 4.

Stages 4-6

  • Compose a letter in the present Word report, or utilize an open existing record.

To embed beneficiary information from the rundown:

  • Place the inclusion point in the report where you need the data to show up.
  • Select Address piece, Greeting line, or Electronic postage from the errand sheet. A discourse box with alternatives will seem in light of your choice.

Merge Fields

OR

  • Select More Items. The Insert Merge Field discourse box will show up.
  • Select the field you need to embed in the archive.
  • Snap Insert. Notice that a placeholder shows up where data from the information record will in the end show up.
  • Rehash these means each time you have to enter data from your information record.
  • Snap Next: Preview your letters in the assignment sheet once you have finished your letter.
  • See the letters to ensure the data from the information record shows up accurately in the letter.
  • Snap Next: Complete the union.
  • Snap Print to print the letters.
  • Snap All.
  • Snap OK in the Merge to Printer discourse box.
  • Snap OK to send the letters to the printer.

The Mail Merge Wizard enables you to finish the union procedure in an assortment of ways. The most ideal approach to figure out how to utilize the distinctive capacities in Mail Merge is to attempt to build up a few of the diverse reports—letters, names, and envelopes—utilizing the distinctive kinds of information sources.

Blogs : Office Setup

How To Create forms In Microsoft Word 2013

creating forms in ms word

       Tags:- office.com/ setup,office.com /setupoffice.com/setup     

If you’ve ever used Microsoft Word, you’ve probably spent a lot of time customizing different options to get your document to look exactly the way you want. But have you ever created a document for other people to use?

For example, let’s say you’re organizing a field trip and want everyone to send in their permission forms electronically. To simplify the process, you could create a form in Microsoft Word. A form allows you to create placeholders for different types of information, such as text, dates, yes-no questions, and so on. This makes it easier for everyone to know what type of information to include, and it also helps ensure all of the information is formatted the same way.

We’ll use Word 2013 to show you how to create a form, but this should work the same way for Word 2010 or Word 2007. You can also download our example file if you’d like to follow along.

 Step 1: Turn on the Developer tab
Before you create form elements in a document, you’ll need to activate the Developer tab on the Ribbon. To do this, click File > Options to access the Word Options dialog box. Select Customize Ribbon, then click the check box for the Developer tab.

Screenshot of Microsoft Word

The Developer tab will appear on the Ribbon.

Screenshot of Microsoft Word

 

 Step 2: Add content controls
Now you’re ready to add the different parts of the form, which Word calls content control fields. To add a content control field, place your cursor in the desired location, then choose a field from the Controls group on the Developer tab. You can hover your mouse over the fields to see the different options. In this example, we’re adding a text field so users can type their first names.

Screenshot of Microsoft Word

The content control field will appear in the document.

Screenshot of Microsoft Word

You can add several types of fields. For example, you can add check boxes for a yes-no question:

Screenshot of Microsoft Word

Or even a date selection field:

Screenshot of Microsoft Word

Once you’ve added all of your fields to the document, you’re ready to send out the form for others to use!

Step 3: Customize as needed
If you want even more control over the way your form looks, you can turn on Design Mode from the Controls group on the Developer tab.

Screenshot of Microsoft Word

Then you can modify the properties for each content control field, including the text that will appear in each field. If you’re willing to spend a little more time customizing each field, you can build a pretty robust form. For example, you could create your own custom drop-down list, as in the example below:

Screenshot of Microsoft Word
Those are the basics of creating your own custom form in Microsoft Word. If you want to learn more, check out this article from Microsoft on how to Create a Fillable Form.

Blogs : Office Setup Help