ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software»
  • Office Software Suites»
  • Microsoft Office

Working With the Edit Menu of Microsoft Office Excel 2003

Updated on April 25, 2016
Patkay profile image

Patrick is a dedicated writer who wishes to make the world better by informing individuals who seek more knowledge.

Working With the Edit Menu of Microsoft Office Excel 2003

Making Changes Using Edit Command

The edit menu of Microsoft Office Excel 2003 provides a number of important editing commands useful for making changes to an Excel document. For instance there is the undo tool that will help you to undo or cancel out unwanted changes you may have applied to your work. In Excel 2007, this menu has been changed, most of its features are available on the Home Tab Ribbon.

Tools on Edit Menu of Microsoft Office Excel 2003

  • Undo typing – this is the first command we encounter on opening the edit menu. You use it to revert back the recent changes you have made on your file. For instance, if you delete part or all of your work unintentionally, you can simply go to Edit and click on undo. It is also much easier to use the short cut ctrl + Z on your Keyboard. You will find most short cuts indicated on the menus.
  • Cut – this command is useful when you want to move your data from one point to another. Simply highlight the data you want to move, click cut and then right click on the destination and paste it. Alternatively, click on the destination where you want to paste and press the enter key.
  • Copy – it is for duplicating data. For instance you can highlight your data in sheet 1 copy it and then paste it in sheet 2.

The Office Clipboard on Microsoft Office Excel 2003

  • Office clipboard – the office clipboard holds text, images, and other objects that you copy or cut. They stay here until they are deleted or replaced. You can reuse these items by pasting them anywhere else in your document.
  • Paste – this command is used together with the copy and cut commands. It is for pasting (transferring) data to the desired position after copying or cutting.
  • Paste special – it is for pasting the contents that you have copied, but you select an option for pasting for instance you can paste whatever you have copied as a Microsoft Office Word document object, as a picture, HTML, Unicode text or as a simple text.

Using the Paste Special Option

The paste special option tool
The paste special option tool | Source

Tools on Edit Menu of Microsoft Office Excel 2003

  • Fill – the fill command is used to set data to be used to automatically fill a repeating pattern. For instance, if you want to write numbers 1 to 100, you can do it simply by using the fill command. Type 1 on the begging cell, click on the 1 you have typed, go to Edit > Fill, select fill. If you want your numbers to go down, select column, set the start value as 1 and the stop value as 100. Click okay and the numbers will be automatically filled.
  • Clear – use this command to clear or erase any of the following; all, formats, contents, and comments.
  • Delete – this command is used to delete contents where you can shift cells left, shift cells up, delete entire row, and delete entire column.

The Find and Replace Tool

Find and replace tool
Find and replace tool | Source

Tools on Edit Menu of Microsoft Office Excel 2003

  • Delete Sheet – you do not need your worksheet any longer? Use this command to delete it. Make sure there is no data that you need because if there is, it will be lost permanently.
  • Move or copy sheet – using this command, you can be able to copy or move your worksheet to another workbook or to the same workbook but now in a different position for instance before a specific sheet or you can move it to the end.
  • Find – this tool is very similar to that of Microsoft word, you use it to find contents within your worksheet. You can use it to find a word, a phase, numbers and even formulas that you want to locate within your worksheet. Note: the search will only take place on the selected worksheet.

Tools on Edit Menu

  • Replace – this is a find and replace tool. Use it to find specific content from your worksheet and replace it with whatever content you want. Suppose you have made a thousand entries on your Excel worksheet, there is a word 'citizens' recurring over three hundred times, and you want to replace it with 'residents. The only best thing to do is to find the word 'citizens' and replace with 'residents'.
  • Go to – you can use the 'Go To' command to take you to specific areas you want for instance you can go to a formula, comments, objects, and constants among others.

Do you still use Excel 2003?

See results

© 2012 Patrick Kamau

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: "https://hubpages.com/privacy-policy#gdpr"

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)