Let’s Discuss Query Design Options In Microsoft Access

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

Introduction

Access offers a few choices that let you outline and run questions that arrival precisely the data you’re searching for. For example, consider the possibility that you have to discover what number of something exists inside your database. For sure on the off chance that you might want your question results to consequently be arranged a specific way? On the off chance that you know how to utilize Access’ inquiry choices, you can outline any question you need.

All through this instructional exercise, we will utilize an example database. On the off chance that you might want to take after along, you’ll have to download our Access 2013 example database. You should approach 2013 introduced on your PC keeping in mind the end goal to open the illustration.

Changing inquiries

Access offers a few choices for improving your inquiries work for you. Notwithstanding changing your inquiry criteria and joins after you fabricate your questions, you can sort and conceal fields in your inquiry comes about.

To alter your inquiry:

When you open a current inquiry in Access, it is shown in Datasheet see, which means you will see your question brings about a table. To alter your inquiry, you should enter Design see, the view you utilized while making it. There are two approaches to change to Design see:

  • On the Home tab of the Ribbon, tap the View order. Select Design View starting from the drop menu that shows up.

Screenshot of Access 2013

  • In the base right corner of your Access window, find the little view symbols. Tap the Design View symbol, which is the symbol most distant to one side.

Screenshot of Access 2013

Once in Design see, roll out the coveted improvements, at that point select the Run order to see your refreshed outcomes.

You may see that Access likewise offers SQL see. You can disregard this. SQL see enables you to make propelled capacities that you won’t have to use for this instructional exercise or for most Access capacities.

Arranging inquiries

Access enables you to apply various sorts without a moment’s delay while you’re planning your question. This enables you to see your information precisely the way you need.

A sort that incorporates in excess of one arranged field is known as a multilevel sort. A multilevel sort enables you to apply an underlying sort, at that point additionally arrange information with extra sorts. For example, on the off chance that you had a table loaded with clients and their locations, you may decide to first sort the records by city, at that point one after another in order by last name.

At the point when in excess of one sort is incorporated into an inquiry, Access peruses the sorts from left to right. This implies the furthest left sort will be connected first. In the case underneath, clients will be arranged first by the City where they live and after that by the Zip Code inside that city.

Screenshot of Access 2013

To apply a multilevel sort:

  • Open the inquiry and change to Design see.
  • Find the field you need to sort first. In the Sort: push, tap the drop-down bolt to choose either an Ascending or Descending sort.

Screenshot of Access 2013

  • Rehash the procedure in alternate fields to include extra sorts. Keep in mind, the sorts are connected from left to right, so any extra sorts must be connected to fields situated to one side of your essential sort. On the off chance that important, you can improve the fields by tapping the highest point of a field and dragging it to another area.

Screenshot of Access 2013

  • To apply the sort, tap the Run charge.

Screenshot of Access 2013

  • Your inquiry results will show up with the coveted sort.

Screenshot of Access 2013

You can likewise apply multilevel sorts to tables that don’t have inquiries connected to them. On the Home tab on the Ribbon, select the Advanced drop-down order in the Sort and Filter gathering. From the menu that shows up, select Advanced Filter/Sort and make the multilevel sort as you regularly would. When you’re done, tap the Toggle Filter summon to apply your sort.

Screenshot of Access 2013

Concealing fields inside inquiries

Once in a while you may have fields that contain imperative criteria, yet you should not have to really observe the data from that field in the last outcomes. For instance, take one of the questions we worked in our last lesson: an inquiry to discover the names and contact data of clients who had put orders. We included Order ID numbers in our inquiry since we needed to ensure we just pulled clients who had put orders.

Notwithstanding, we truly didn’t have to see this data in our last inquiry comes about. Truth be told, in the event that we were simply searching for client names and addresses, seeing the request number blended in there might have been diverting. Luckily, Access makes it simple to shroud fields while as yet including any criteria they contain.

To conceal a field inside a question:

  1. Open the question and change to Design see.
  2. Find the field you need to cover up.
  3. Tap the checkbox in the Show: column to uncheck it.Screenshot of Access 2013
  4. To see the refreshed question, select the Run charge. The field will be covered up.

To unhide a concealed field, essentially come back to Design view and tap the checkbox in the field’s Show: push once more.

Blogs :  office.com/setup

How To Use Backspace/Delete and Undo/Repeat Option In Word Document

undo backspace in ms word 2003
 Tags:-office.com/ setup,office.com /setupoffice.com/setup  

Introduction

Before the finish of this exercise, you ought to have the capacity to:

  • Utilize delete and erase
  • Utilize fix and rehash

Backspace and Delete

  • Utilize the Backspace and Delete keys (on your console) to eradicate message in your record.
  • The Backspace key eradicates the content to one side of the addition point one character at any given moment.
  • The Delete key (situated under the Insert key) eradicates content to one side of the inclusion point.

Utilizing Undo

Have you at any point committed an error in your report and expected to return and roll out improvements, yet you thought it was past the point of no return? Uplifting news! Word offers an element that keeps this from happening.

The Undo charge gives you a chance to fix, or erase, the last change made to your record. As you can envision, this is an extremely helpful component. In the event that you commit a change or error you don’t need or did not intend to do, you can essentially “fix” your activity.

To utilize Undo:

  • Snap Edit on the menu bar.
  • Select Undo. This charge will change names contingent upon the move you simply made. On the off chance that you coincidentally erased a sentence, it will state Undo Clear.
  • Press Ctrl+Z on your console for an easy route to Undo.

Or on the other hand

  • Fix the greater part of your ongoing activities by over and again tapping the Undo catch situated on the Standard toolbar.

Undo Button

  • Notice the little rundown bolt alongside the Undo catch. When you tap on it, you’ll see a rundown of all the different activities you have performed on the report you are taking a shot at. You can choose the same number of activities as you need to fix.

Essential: If you fix an activity amidst the rundown, you will likewise fix every one of the activities over the one you select. For instance, on the off chance that you fix the fifteenth activity in your rundown, you will likewise be fixing the 14 activities that preceded the one you select.

Undo List

Utilizing Repeat

  • The Repeat highlight enables you to rehash the last activity and can spare a great deal of time as you make your record.

To utilize Repeat:

  • Snap Edit on the menu bar.
  • Select Repeat. This order will change names contingent upon the move you simply made. On the off chance that you have to arrange a title on one page and wish to organize another title a similar way utilizing Repeat, it will state Repeat Style.
  • Press Ctrl+Y on your console for an alternate way to Repeat.

Repeat Typing Command

Blogs :   www.office.com/ setup

How To Find Different Record In Microsoft Access 2003

find records

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

Presentation

Before the finish of this exercise, you ought to have the capacity to:

  • Play out a basic find
  • Utilize a trump card to discover a record

Performing a simple find

When you have a to a great degree substantial database comprising of thousands of records, you may need to rapidly find one of them. Access gives a simple method to discover singular records: the Find work.

To utilize the Find work:

  • Snap anyplace in the field that contains the information you need to look (e.g., Last Name).
  • Pick EditFind on the menu bar, or tap the Find catch on the toolbar to open the Find and Replace discourse box.
  • In the Find What field, type the data you need to look for. It might be a last name (e.g., Manning) or a bit of the last name (e.g., Man).

Find and Replace Dialog Box

  • The Look In drop-down box defaults to the field or section where the cursor was situated when the Find was started. You can leave the definition as is whether you know the data is contained in this field, or you can choose Search the whole table starting from the drop menu list.

Look In Field

  • In the Match field Access defaults to Whole Field, however you can alternatively choose either Any Part of Field or Start of Field.

Match Field

  • Tap the Find Next catch to look for the principal event of a record that matches the inquiry.

Playing out a straightforward find

  • Tap the Cancel catch if the record was found. The Find and Replace exchange box will close.
  • Or on the other hand
  • Tap the Find Next catch to look for the following record that meets the Find criteria.
  • In the occasion that Access did not discover a counterpart for the hunt, the Office Assistant will fly up to illuminate you that there were no coordinated records found.Item Not Found Dialog Box

To look for a record utilizing a special case:

  • Pick EditFind on the menu bar, or tap the Find catch on the toolbar to open the Find and Replace exchange box.
  • In the Find What field, type the trump card blend (e.g., B*) to locate the main record where the Last Name starts with the letter B.

Found Record

  • Tap the Find Next catch to start the inquiry. The main record found that matches the pursuit is featured.

Found Record

  • (The Office Assistant will give warning if no coordinating records were found.)
  • Tap the Cancel catch if the record was found. The Find and Replace discourse box will close.
  • Or on the other hand
  • Tap the Find Next catch to scan for the following record that meets the Find criteria.

Blogs :  www.office.com/setup

How To Use Excel Vlookup Function In Microsoft Excel

excel-vlookup function

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

A considerable lot of our students have revealed to us they need to figure out how to utilize Excel’s VLOOKUP work. VLOOKUP is a greatly valuable apparatus, and figuring out how to utilize it is less demanding than you might suspect!

Before you begin, you ought to comprehend the fundamentals of capacities. Look at our Functions lesson from our Excel Formulas instructional exercise (or select a particular rendition of Excel). VLOOKUP works the same in all adaptations of Excel, and it even works in other spreadsheet applications like Google Sheets. You can download the case in the event that you’d get a kick out of the chance to work alongside this article.

What precisely is VLOOKUP?

Essentially, VLOOKUP gives you a chance to scan for particular data in your spreadsheet. For instance, in the event that you have a rundown of items with costs, you could scan at the cost of a particular thing.

We will utilize VLOOKUP to discover the cost of the Photo outline. You can presumably as of now observe that the cost is $9.99, yet that is on the grounds that this is a straightforward illustration. When you figure out how to utilize VLOOKUP, you’ll have the capacity to utilize it with bigger, more unpredictable spreadsheets, and that is the point at which it will turn out to be really helpful.

Using VLOOKUP

We’ll add our recipe to cell E2, yet you can add it to any clear cell. Similarly as with any equation, you’ll begin with an equivalents sign (=). At that point write the equation name. Our contentions should be in enclosures, so write an open bracket. Up until now, it should resemble this:

=VLOOKUP(

Including the arguments

Presently, we’ll include our contentions. The contentions will disclose to VLOOKUP what to look for and where to seek.

The principal contention is the name of the thing you’re hunting down, which for this situation is Photo outline. Since the contention is content, we’ll have to place it in twofold statements:

=VLOOKUP(“Photo outline”

The second contention is the cell extend that contains the information. In this illustration, our information is in A2:B16. Similarly as with any capacity, you’ll have to utilize a comma to isolate every contention:

=VLOOKUP(“Photo outline”, A2:B16

Note: It’s imperative to realize that VLOOKUP will dependably look through the main section in this range. In this illustration, it will look section A for “Photograph outline”. Sometimes, you may need to move the segments around so the principal segment contains the right information.

The third contention is the section file number. It’s less complex than it sounds: The principal section in the range is 1, the second segment is 2, and so on. For this situation, we are attempting to discover the cost of the thing, and the costs are contained in the second segment. This implies our third contention will be 2:

=VLOOKUP(“Photo outline”, A2:B16, 2

The fourth contention discloses to VLOOKUP whether to search for inexact matches, and it can be either TRUE or FALSE. On the off chance that it is TRUE, it will search for rough matches. By and large, this is just helpful if the primary segment has numerical esteems that have been arranged. Since we’re searching for correct matches, the fourth contention ought to be FALSE. This is our last contention, so simply ahead and close the enclosures:

=VLOOKUP(“Photo outline”, A2:B16, 2, FALSE)

That is it! When you press Enter, it should give you the appropriate response, which is 9.99.

screenshot of Microsoft Excel

How it functions

How about we investigate how this equation functions. It initially seeks vertically down the principal section (VLOOKUP is short for vertical query). When it discovers “Photograph outline”, it moves to the second section to discover the cost.

In the event that we need to discover the cost of an alternate thing, we can simply change the main contention.

Blogs :  office.com /setup

 

How To Insert Hyperlinks In Microsoft Excel 2003

excel-insert-hyperlinks-in 2003

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

Inserting hyperlinks

You can insert hyperlinks into a spreadsheet to get to particular sites from that spreadsheet. Numerous organizations utilize hyperlinks inside spreadsheets to effectively connection to online records that are significant to that particular spreadsheet.

In this case, we are working with an individual planning spreadsheet. We will embed a hyperlink that connects to GCFLearnFree.org. The site offers an instructional exercise on Money Basics, which incorporates general planning data.

To embed a hyperlink to a site:

  • Select the cell where you might want to embed the hyperlink.
  • Select Insert  Hyperlink from the primary menu. The Insert Hyperlink dialog box will show up.
  • Enter the content you might want to show up as your connection in the Enter content to display: field.
  • Enter the site address in the Address: field at the base of the exchange box.
  • Click OK. The hyperlink will show up in your spreadsheet.

Hyperlinks

Blogs :   Office.com/setup

How To Empower your sales team with the Microsoft 365

sales team

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

Microsoft 365 collaborated with the American Association of Inside Sales to bring deals end-clients content concentrated on key needs for deals experts.

Getting Organized with Outlook

Invest less energy suffocating in managerial assignments and spotlight on what’s imperative: building associations with your clients, accumulating experiences, and conveying predominant customer administrations. Figure out how you can invest more energy in offering utilizing Outlook adequately.

Empower Seamless Collaboration with SharePoint

The organization amongst advertising and deals is basic. Figure out how you can guarantee you generally have the most exceptional substance from promoting utilizing SharePoint.

Draw Insights Across Your Organization with Yammer

Figure out how to use the energy of your colleagues: they have worked in comparative businesses, have comparative clients and practically identical difficulties. Reach over your association, to discover best practices and specialists utilizing Yammer.

Reinforce Customer Relationships with Microsoft Teams

Don’t simply turn into an email address for your client. Make an association utilizing video brings in Microsoft Teams.

Advance Sales Performance with PowerBI

Figure out how to use information representation to reveal industry and client bits of knowledge. You will settle on more quick witted business choices utilizing effective scientific abilities inside PowerBI.

Blogs :  Office Setup

Introducing New Connectors In Microsoft Access 2013

new connectors in access

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

New Connectors:

Last November, we shared our arrangement to include an arrangement of present day information connectors that will empower Office ProPlus clients to extend what is conceivable in their associations.

  • Today, we are satisfied to declare the expansion of two new connectors in our portfolio: Microsoft Dynamics and Salesforce. These two connectors are taking off to clients with Office 365 ProPlus, E3, or E5 designs.

Blog1.png

  • Access incorporates a rich arrangement of outside information connectors, among which you can discover SQL Server, Azure SQL, Excel, SharePoint, Oracle, and that’s only the tip of the iceberg.
  • The new MS Dynamics and Salesforce information connectors in Access can be utilized as a part of an assortment of situations, supporting bringing in from, or connecting to outside information sources.

blog2.png

Expanding the arrangement of outer information connectors empowers new situations for Access clients who wish to coordinate line of business information from various information sources into one intelligible arrangement in Access, and we will keep on releasing connectors to associate current information sources to Access.

Blogs :  Install office key

How To Format a Chart In Microsoft Excel 2003

pie-chart-in-excel-2003

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

Introduction

Before the finish of this exercise, you ought to have the capacity to:

  • Configuration the graph title
  • Configuration the graph legend
  • Arrangement the hub

Arranging the outline title

The outline title can be arranged to change shading, design, typeface, size, and arrangement utilizing the Format Chart Title discourse box.

To organize the outline title:

  • Select the graph title.

Select the Chart Title

  • Select the Chart Title
  • Tap the Format catch on the Chart toolbar (or double tap the outline title).Chart Toolbar
  • The Format Chart Title discourse box contains three distinct tabs—Patterns, Font, and Alignment—that can be utilized to arrange the graph title.
  • The Patterns tab gives you a chance to characterize fringes and fill hues.
  • The Font tab gives you a chance to characterize textual style, textual style, size, and shading.
  • The Alignment tab gives you a chance to characterize flat and vertical cell situation, and content introduction.

Format Chart Title Dialog Box

  • Tap the OK catch to acknowledge the graph title arrange changes.

Designing the diagram legend :

The diagram legend shows valuable data about the outline. Like a guide, the legend distinguishes what distinctive hues or questions speak to in the graph. The outline legend, similar to the diagram title and class pivot marks, can be arranged to your enjoying.

To organize the diagram legend:

  • Press the show/conceal legend catch on the Chart toolbar to turn on the legend show. (This catch demonstrations like a flip by killing the show on or.)

The Legend Button on the Chart Toolbar

  • Snap to choose the diagram legend.
  • Tap the Format catch on the Chart toolbar (or double tap the diagram legend).

Chart Toolbar

  • The Format Legend discourse box contains three unique tabs—Patterns, Font, and Alignment—that can be utilized to organize the outline title.
  • The Patterns tab gives you a chance to characterize outskirts and fill hues.
  • The Font tab gives you a chance to characterize text style, textual style, size, and shading.
  • The Placement tab gives you a chance to characterize the area where the legend will show up on the outline.

Format Legend Dialog Box

  • Tap the OK catch to acknowledge the outline legend arrange changes.
  • The best way to change the real content that shows up in the diagram legend is to change the source information in the worksheet.

Changing the information arrangement shading

At the point when an outline is made in Excel 2003, you’ll see that shading is consequently connected to the information arrangement. You can keep this arrangement or change it for every datum arrangement in the outline. A wide range of parts of every datum arrangement can be changed, yet you’ll likely change the shade of bars, segments, pie cuts, and zones frequently.

To change the shade of an information arrangement:

  • Select the information arrangement you wish to alter.

Data Series Color Selection

  • Tap the Format catch on the Chart toolbar (or double tap the information arrangement).

Chart Toolbar

  • Utilize the Format Data Series discourse box to pick another shading.

Format Data Series Dialog Box

  • Tap the OK catch to acknowledge the Data Series shading changes.

Blogs : Office.com/setup

How To Utilize WordArt And Shapes In Microsoft PowerPoint 2007

word art in ms powerpoint 2007

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

Introduction

PowerPoint 2007 Word Art and ShapesPowerPoint 2007 Word Art and Shapes There are numerous highlights and orders you can use in PowerPoint to make outwardly engaging slides. Two of these highlights are WordArt and shapes. WordArt enables you to make adapted content with surfaces, shadows, and blueprints. It can be connected to content on any slide. Furthermore, in PowerPoint you can embed an assortment of shapes, for example, lines, bolts, callouts, stars, and fundamental shapes, including rectangles and circles.

In this lesson, you will figure out how to apply and change WordArt styles, and also how to embed and adjust different shapes on a slide.

 

To apply a WordArt style:

  • Select the content you need to change. The Format tab will show up.
  • Select the Format tab.
  • Move your cursor over a WordArt style in the WordArt Styles gathering to see a live review of the style on the slide.

WordArt Styles

  • Tap the More drop-down bolt to see all conceivable WordArt styles.

More WordArt Styles

  • Snap an alternative to choose it.

To change the fill shade of a WordArt style:

  • Select the content you need to change.
  • Tap the Text Fill charge in the WordArt Styles gathering.

WordArt Fill Command

  • Move your cursor over a shading choice to see a live review on the slide.
  • Snap a shading to choose it.

Or on the other hand select from the accompanying:

  • No Fill: This alternative will leave the WordArt content without a fill shading.
  • More Fill Colors: This opens a discourse box of shading decisions you can use as a fill shading.
  • Picture: This opens the Insert Picture discourse box. From here, you can choose a photo from your PC to use as the fill foundation.
  • Slope: This shows a submenu of different inclination choices that change how the fill shading shows up.
  • Surfaces: This shows a submenu of different surfaces you can apply to WordArt content.

Working with WordArt

To change the content blueprint of a WordArt style:

  • Select the content you need to alter. The Format tab will show up.
  • Select the Format tab.
  • Tap the Text Outline order in the WordArt Styles gathering.

Text Outline

  • Move your cursor over a shading alternative to see a live review on the slide.
  • Snap a shading to choose it.

From the Text Outline menu, you can likewise apply no blueprint shading, get to more hues, change the heaviness of the line, and change the line style.

To apply a content impact to a WordArt style:

  • Select the content you need to adjust. The Format tab will show up.
  • Select the Format tab.
  • Tap the Text Effects summon. A menu of choices will show up.
  • Select a menu choice. The choices are Shadow, Reflection, Glow, Bevel, 3-D Rotation, and Transform. Each will show a submenu.

Text Effects

  • Snap a choice from the submenu to choose it.

You can utilize WordArt to make adapted content that is attractive and proficient; in any case, with such a significant number of styles and choices, you can likewise make message that isn’t suitable for an introduction, that is hard to peruse, or that essentially does not look engaging. Keep in mind, since you can accomplish something doesn’t mean you should!

To embed a shape:

Select the Home tab.

  • Tap the Shapes charge.
  • Snap a shape from the menu.
  • Embed Shape

Insert Shape

  • Move your cursor toward the slide. It will appear as a cross shape.
  • Snap and hold down the mouse catch, and drag the cursor until the point when the shape is the coveted size.

Shape Cursor

  • Discharge the mouse catch to embed the shape.

To change a shape style:

  • Select the shape. The Format tab will show up.
  • Select the Format tab.
  • Tap the More drop-down bolt in the Shapes Style gathering to show more style alternatives.

Shape Style

  • Move your cursor over a style to see a live review of the style on the slide.
  • Snap a style to choose it.

Working with shapes

To change the shape fill:

  • Select the shape. The Format tab will show up.
  • Select the Format tab.
  • Tap the Shape Fill charge to show a drop-down rundown.
  • Select a shading from the rundown, or pick one of the other menu choices.

Shape Fill

To change the shape layout:

  • Select the shape. The Format tab will show up.
  • Select the Format tab.
  • Tap the Shape Outline charge to show a drop-down rundown.
  • Select a shading from the rundown, or pick one of the other menu alternatives.

Shape Outline

To apply a shape impact:

  • Select the shape you need to alter. The Format tab will show up.
  • Select the Format tab.
  • Tap the Shape Effects order.
  • Move your cursor over a menu alternative. A submenu will show up.
  • Move your cursor over a choice in the submenu to see a live review of the impact on the slide.

Shape Effect

  • Snap an alternative to choose the shape impact.

You can resize and move the shape simply like you would with content boxes and pictures.

Blogs : Office setup help

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