Browsing all articles tagged with Microsoft Excel 2003

How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007

Microsoft Excel is a database program used practically by a lot of people at home and office. Most of the businesses and companies are using the program to tabulate data and information. This program has so many features that anyone who utilizes it should understand every bit of information and command, to use it effectively. One of the most useful features in Microsoft Excel is the Paste Special. It gives users the capability to do array of known function. Through this feature, user can create related formulas and perform mathematical functions to transpose data.

There are different ways on how to use Paste Special as some users utilize different kinds of Excel program. So, to help out all Microsoft Excel users, below are the procedures in using Paste Special in Microsoft Excel 2003 and Microsoft Excel 2007 as this is the most common program of Microsoft Excel that is being used nowadays.

Before discussing the procedures in using the feature, it is vital to know first what this program is about. Well, the Paste Special command is just like Paste command. It can select arrange cell content, cell formats and calculated numbers. This command can copy contents and format the original data, which is accessible once the desired selection is finally cut or copied. Learning the basics of what is it, is as well understanding how it could be used in Microsoft Excel program.

To help Microsoft Excel users, listed below are the ways on how to use the feature. The procedures given are use in different Microsoft Excel Program. So, choose for the one that contains the same program to what you are using.

How to Use Paste Special in Microsoft Excel 2003

  • Open the computer and the files containing the data to copy. Open another Microsoft Excel spreadsheet. You can access the program through the Start Button.
  • Once the entire needed database is already open, then from the spreadsheet containing the data to copy, highlight the cells that need to be copied. On the new spreadsheet, right click the cell where to paste the copied data.
  • From the menu, select the “Paste Special”. Then choose your own command from the displaying menu.
  • Hit the “OK” button. After hitting the “OK”, it will paste the exact command given.

Using the Microsoft Excel 2003 for Paste Special is very easy. However, there are still things to keep in mind using Paste Special in Microsoft Excel 2003. Firstly, if the paste information is not correct, immediately, choose “Undo” located at the “Edit” menu. It is vital to remember that the clipboard will stack things, so it is necessary to clear the clipboard from time to time to avoid pasting the wrong data.

How to Use Paste Special in Microsoft Excel 2007

  • Choose the data you want to copy and then select “Copy”. There are two procedures on how to copy the data. First, right click the mouse within the area of spreadsheet and choose “Copy” or through the copy icon from the Ribbon Home Tab. If you are not familiar with Ribbon, it is the numbers of tools and icons located above the working area.
  • On the Ribbon Home Tab click the drop down menu on “Paste” and click the “Paste Special”.
  • Click the cell or array of cells where the data to be displayed and click again the drop down menu of “Paste” and choose the “Paste Special”.
  • From the “Paste Special” dialog box, opt for the operation you want to do and then click “OK”. In this given command, the operation is good after you have done it correctly. There are so many choices available. For instance, you are able to transpose the list of information that you have to display in a reverse manner. You may be able to paste the value copied from another workbook or spreadsheet and then link it so that every time you edit the original cell it automatically update.

You can follow these procedures for Paste Special feature in Microsoft Excel 2007. The same with the Microsoft Excel 2003, once you pasted an incorrect data, click the Undo button instantly. In addition, as much as possible read first all the commands that you need to click to ensure of giving the right instructions to Excel.

Paste Special feature in Microsoft Excel will definitely let you have an easy Excel use when it comes to adding notes and list to spreadsheet. So, better keep in mind all the procedures taken in this article to make you capable of the right procedure in using Microsoft excel.

How To Upgrade Microsoft Excel 2003 to Microsoft Excel 2010

Microsoft Excel 2010 is more attractive in layout. However, the tools and commands are not in places where they were in 2003 versions. Many users will face problems to find out necessary commands to perform their tasks. The commands are not missing, but they are hidden. You will have to add the necessary commands to your customizable toolbar which is now called ribbon in the latest versions of the Office software.

Collect the Microsoft Excel 2010 software with necessary license keys. You can buy the software disk from a software shop or you can download the software from online. After collecting the software, you should uninstall the previous version, as this is recommended. However, you can run multiple versions of office software in the same computer. To uninstall a program you should go to the control panel, then go to add/remove programs. From the program list, select the program and click on the change/remove button. The program will be removed. It is better to restart the computer after uninstalling a program.

Multiple versions can be installed in the same computer. For this, you will have to follow the sequence of installation. For example, if the versions Office XP, Office 2003, and Office 2010 have to be installed in the same computer; then at first install the Office XP, then install the Office 2003, then install the Office 2010. Earlier version should be installed first. Otherwise the program will not work properly. If the system is a Terminal Server, then Microsoft does not allow to run multiple versions of MS Office. To run several versions you will have to disable the Terminal Services.

If a version is uninstalled from the computer, then the program will be installed again maintaining the same order to keep the software work correctly. Some difficulties may occur in the shortcuts. Office XP, Office 2000, and Office 97 use same shortcuts. It is suggested by the Microsoft to add version numbers to the shortcuts. This will help to distinguish the versions. To know more about these procedures you can visit the Microsoft sites.

As the differences between the versions 2003 and 2010 are significant, it will be better to read a guide to clarify the layout and differences of the Excel 2010. For the convenience of the users here are 5 resources which can help them to learn about the Excel 2010. The resources are, Menu-to-ribbon Guide, Mapping Workbook, Migration Guide, Switch to Excel, Upgrades’ Guide etc. Some information about the Excel 2010 has been discussed below from the Migration Guide.

The users of Excel 2003 will obviously ask the question where the toolbar buttons and commands are. For your convenience, you can go to the File tab, then go to Help, then click on Getting Started under Support. A web page will be opened, click on the links that you want. Clicking on any 2003 command you will be able to see the exact location of the command in 2010 version. Menus and toolbars are replaced with ribbons which at the top of the program window. There are different commands and buttons organized into groups in each tab. After starting the Excel 2010 Home tab appears. Most commonly used commands are in the Home tab. New users should be attentive about the commands which are in the groups of Cells and Editing. Necessary commands for formatting columns, rows, and sheets, deleting, and inserting are there.

To open, create, print, save, protect, preview, convert, or send files click on File tab. Use the Insert tab for adding Pivot Tables, charts, hyperlinks, header and footer, excel tables etc. When you will need to set page margins then go to the Page Layout tab. There you will be able to set page breaks and print area also. For finding functions, defining names, and troubleshooting formulas go to the Formulas tab. For checking spelling and revising the workbook the user should go to the Review tab. View tab is for arranging windows, switching between the worksheet views etc. You can make your tasks easier by customizing the ribbon. To do this right-click the ribbon group, then click on Customize the Ribbon. Commands can be added to the groups also. There are several add-ins in Excel 2010, just follow the guides to manage the add-ins.