How to Use Paste Special in Microsoft Excel 2007

1.
Select the data you would like to work with and choose 'Copy.' Copying can be performed by right clicking your mouse on the area or clicking the copy icon in the Home Tab of the Ribbon. The Ribbon is the group of icons and tools located directly above the work area.
2.
Click the 'Paste' drop-down menu located in the Home tab on the Ribbon. Select 'Paste Special.'
3. Click on the cell or range of cells you would like your data to affect and click the
'Paste' drop-down menu again. Choose 'Paste Special.'
4.
Choose the function you would like to perform from the 'Paste Special' dialog box and click 'OK.' Your function will be performed as directed. There are numerous options available. For example, you can transpose a list of data to appear in reverse order. You can paste the copied value into another sheet or workbook and link them so that it automatically updates each time you edit the original cell.

Read more ►

How to Change Positive Data to Negative on Microsoft Excel

1. Click 'Start,' 'All Programs,' 'Microsoft Office' and then 'Microsoft Excel 2010.' Click 'File' and 'Open.' Locate your file and click 'Open.'
2. Double-click the cell containing the number you wish to change from positive to negative. Enter the negative symbol before the first number and press 'Enter.'
3. Select 'Number' from the drop-down list in the Number group of the Home tab of the ribbon bar. Click the expander arrow in the lower right of the Number group or 'Alt,' 'H,' 'F' then 'M' to show all the formatting options.
4. Select one of four options for displaying negative numbers on the Number tab. Click 'OK.'
5. Click 'Conditional Formatting' > 'Highlight Cell Rules' > 'Less Than' to set conditional formatting. Enter '0' (zero) in the first box and select an option from the second. Click 'OK.'

Read more ►

How to Add Numbers in Microsoft Excel if they Meet Certain Criteria

1. Select 'More Functions' from the 'Sum' drop-down menu in the 'Editing' section on the 'Home' tab. This opens the 'Insert Function' window.
2. Type 'sumif' in the 'Search For A Function' field and click the 'Go' button. Verify that 'SUMIF' is highlighted on the 'Select a Function' pane and click the 'OK' button. This opens the 'Function Arguments' window.
3. Click in the 'Range' field and enter the range of the data that needs to be tested; for example A1:A25 will test each cell starting with A1 and ending with A25 to see if it matches the criteria. The ':' represents 'through.'
4. Click in the 'Criteria' field and either type the criteria or enter a cell value. The cell value should contain the criteria.
5. Click in the 'Sum_Range' field and enter the range of cells that need to be added; for example, B1:B25 will sum any values that match the criteria. The results are displayed in the lower-left corner of the window next to 'Formula result =.' Click the 'OK' button.

Read more ►

Animate Objects in Microsoft Excel

Download and Install Excel 3-D Animation Engine
1. Open a browser and go to Microsoft's Download Center.
2. Locate the 3-D Animation Engine under Office products add-ons.
3. Click 'Download' and 'Run' to begin the program download.
4. Click 'Yes' to download and run the program on your computer.
5. Click 'Unzip' to open the file. Save the file to your desktop for easy access.
6. Click 'OK' to complete the program's installation.
Open and Configure Excel 3-D Animation Engine
7. Double-click on the 3-D Animation Engine file to open it. The program will automatically open in Excel 2007.
8. Click on the Macro warning box to enable Macros in this program. Click 'OK.'
9. Delete the animation example that is in the work space by clicking on the shape and hitting the backspace key. The program configuration is complete.
Animate an Excel Object
10. Click the Insert tab on the tool ribbon on the top of the spreadsheet.
11. Click 'Shapes' and choose a shape or object to animate. Pick an area on the work screen to place the animated object and click on that area. The shape will appear on the screen.
12. Left-click on the shape and choose 'Format Shape' to adjust the size, shape, color and angle of the shape. Close the 'Format Shape' box when finished.
13. Change the size of the shape by clicking on one of the handles on the box surrounding the shape and dragging the handle to increase or decrease the shape's size.
14. Click the 'Animate!' button to animate the object when you have finished formatting.
15. Click 'Save' to save the image. Type in a name for the image in the dialog box and click 'OK.' The image can accessed through Excel to be used in a spreadsheet or exported to a PowerPoint presentation.

Read more ►

How to Create Footers in Microsoft Excel 2003

1. Open the view menu. Scroll to the “View” tab on the command bar.
2. Access the page header/footer menu. Select “Header And Footer” from the “View” menu. A header /ooter properties box will open.
3. Select the footer. To add text to the footer, click on the “Custom Footer” button.
4. Create text for the footer. Enter the desired text for all sections: left, right and center.
5. Insert text into the footer. Click on the “Okay” button when you have finished entering the desired text. This will bring you back to the header/footer properties box.
6. Insert the footer into the spreadsheet. Click on the “Okay” button to add the footer into the spreadsheet.

Read more ►

How to Unhide Columns in Microsoft Project

Unhide Columns in Microsoft Project
1.
'Click' the column header to the right of the position in which the new column should appear, as in Image 1. This action will select and darken the entire column.
2.
'Click' the 'Insert' option from the menu bar, as displayed in Image 2. This will cause a drop-down menu to appear.
3.
Click 'Column' from the drop-down menu. This will bring up a dialogue box entitled 'Column Definition,' as in Image 3. This feature allows you to select the column to be displayed.
4.
Click the down arrow to the right of the 'Field Name' text box. This will cause a list of fields to display, as in Image 4. Select the name of the column you wish to unhide from the list.
5.
Click the 'Best Fit' button at the bottom of the Column Definition dialogue box to display the hidden column as in Image 5. You may also add a column by clicking 'OK,' but that will require manual column-width adjustment.

Read more ►

How to Crop Images in Excel

1. Start Microsoft Excel 2007 and open a workbook from your files that contains an image that you want to crop.
2. Select the image you want to crop by clicking on it. The image will be surrounded by a thin, black border and light blue sizing handles once it is selected.
3. Choose the 'Format' tab at the top of the Excel 2007 screen to display the Format ribbon. Locate the 'Size' section of the Format ribbon. This section is on the right side of the Format ribbon.
4. Click the 'Crop' button and thick, black lines should appear on the corners and sides of the selected image.
5. Hover your mouse over one of the black borders on a corner or a side and your cursor will change to two borders overlapping each other.
6. Crop the image by clicking your mouse on the border and dragging inwards while holding the mouse button down. The part of the image you are moving over will disappear.
7. Release your mouse button and view the effects. Continue to use this same process to crop other parts of the image.

Read more ►

How to Remove Fractions in Excel

1. Launch Microsoft Excel 2010 and open the spreadsheet that contains or will contain the numbers that need to be displayed without fractions.
2. Click a cell or highlight (Select) a range of cells by clicking on one cell and holding the mouse button down while dragging the cursor across a range of cells. Release the mouse button to select the highlighted range. You can also click directly on a column letter or row number to select the entire column or row. Add or remove from the current selection by holding down the 'CTRL' key while selecting the cells you do not want changed.
3. Right-click any of the selected cells and click 'Format Cells' from the context menu.
4. Click the 'Number' tab in the 'Format Cells' dialog box.
5. Click the desired format for the display and storage of the numbers in the selected cells. Make preference adjustments on the right side of the dialog box using the instructions at the bottom of the dialog box. The 'Sample' box will display a preview of the format for any data in the selected cell.

Read more ►

How to Change Interval of Category Axis in an Excel Chart

1. Start Microsoft Excel 2007 and open a spreadsheet from your files that contains a chart to which you want to change the interval of the category axis.
2. Click in the white area of the chart so the whole chart is selected. You can tell the entire chart is selected because a light blue outline will surround the entire chart.
3. Select the 'Format' tab at the top of the Excel screen to display the 'Format' ribbon. Locate the 'Current Selection' group-it is the first group in the 'Format' ribbon.
4. Click the 'Chart Elements' arrow to display the drop-down list. This is the top option in the 'Current Selection' section of the 'Format' ribbon. Choose '(Category) Axis' from the drop-down list.
5. Press the 'Format Selection' button right underneath the 'Chart Elements' drop-down list. The 'Format Axis' dialog box will appear on the screen. Click 'Axis Options' if necessary to display the options for changing the interval of the category axis.
6. Type the number of units you have to use in the 'Interval between tick marks' text box at the top of the 'Format Axis' dialog box.
7. Click the 'Close' button to close the 'Format Axis' dialog box and return to your Excel chart. You will now see that the interval for the category axis has changed.

Read more ►

How to Create a Bar Chart in Microsoft Excel 2003

1. Make a table that contains all of the data you want represented in your bar chart. Be sure to include column and row labels and numerical quantities when making your table.
2. Highlight all of the data in your table--including the column and row labels--and click the “Chart Wizard” button on the toolbar. The “Chart Wizard” button looks like a tiny column chart.
3. When the Chart Wizard appears, select “Bar” from the “Chart Type” menu, then select the subcategory of bar chart you would like to create. Click the “Next” button.
4. Use the “Data Range” box if you need to modify the data set. Select “Rows” from the “Series In” option to sort your data by row or “Columns” to sort your data by column. Click “Next.”
5. Enter titles and labels for your chart to make it easy to read. Excel will offer you a preview of how the chart will appear while you work.
6. Use the “Axes,” “Gridlines,” “Legend,” “Data Labels,” and “Data Table” tabs as additional tools for modifying the appearance of your bar chart. Each tab modifies a specific part of your bar chart. Click “Next” when you are finished modifying the appearance of your chart.
7. Select “As New Sheet” to place your bar chart in a new Excel spreadsheet or select “As Object In” to place the bar chart in the same spreadsheet that you built your data table. Click “Finish” to complete the creation of your chart and place it on a spreadsheet.

Read more ►

How to Synchronize Spreadsheets in Excel

Linking Separate Excel Workbooks Together
1. Open the workbook with the data you expect to be shared in Excel. This is the source workbook.
2. Open the workbook you want the data to be replicated in. This is the destination workbook.
3. Select the cell in the source workbook you want the data to come from, and enter 'Ctrl C' to copy it.
4. Switch to the target workbook, and select the cell you want the data to appear in.
5. Enter 'Ctrl V' to paste the reference in. If you examine the formula, you'll see that prior to the row and column entry, there will be a reference to the drive location (or network location) and the file name of the source workbook. An example would look like this: [C:\Book1.xlsx]Sheet1!A1. This means that Excel will pull the value from the linked file.
Synchronizing Worksheets In The Same Workbook
6. Open your workbook in Excel.
7. Hold down the 'Ctrl' key while clicking on multiple worksheet tabs. Be sure to leave one tab unselected when you do this. This will ensure that any edits you make on one tab will be replicated across all selected tabs, with data entered in the corresponding cells.
8. Click the tab that's not part of the group to undo the tab group selection. This will get Excel to revert to 'normal mode,' where changes in one tab only affect that tab.

Read more ►

How to Add an Analysis Toolpack in Excel 2003 GPO

1. Launch Excel 2003. To install the Analysis Toolpak on a version of Excel that was installed through a GPO (Group Policy Organization), you need a privileged account, or you must talk to your network administrator to unlock the procedure.
2. Click on the 'Tools' menu item. Navigate through the drop-down menu and select 'Add-Ins'. A dialog box will appear; this will show all the add-ons currently available.
3. Check the check box that says 'Analysis Toolpak.' You may need to click on the 'Browse' button to load it; it will be listed as Analysis.xla in the Add Ons folder for Excel. If you do not see it, you may need to reinstall Excel 2003 from your installation media. If prompted 'Do you want to install the Analysis Toolpak?', click 'Yes' to install it.
4. Click the 'Tools' menu item; there will now be a 'Data Analysis' entry added to the drop-down menu.

Read more ►

How to Insert a Dynamic Date in Excel

1. Start Microsoft Excel 2007, and open a spreadsheet from your files into which you want to insert a dynamic date. Or, you can start a new, blank spreadsheet.
2. Select the cell you want to insert the dynamic date into by clicking on it. The cell will be surrounded by a thick, black outline once it is selected.
3. Type the formula '=today()' (without the quotation marks) into the selected cell. This formula will instruct Excel to insert the current date into the cell where the formula is entered.
4. Press the 'Enter' key on your keyboard or the green check mark on the formula bar to input the formula into Excel. Excel will then accept the formula and display the current date into the cell where you typed the formula. The date will be updated every time the 'Enter' key is pressed when you are working in the workbook where the formula has been inserted.
5. Use the procedure above to insert the dynamic date into any other cells in the open spreadsheet that you would like to display the current date.

Read more ►

How to Adjust the Color of Excel Bars in a Bar Chart

1. Open the formatted workbook and double-click the specific bar element you wish to change.
2. On the 'Patterns' tab in the 'Area' section of the 'Format Data Series' dialogue box, click your preferred color. You can preview it in the 'Sample' box in the lower left corner.
3. Click the 'OK' button. The chart will show the new color choice.
4. Save the changes to the chart and workbook.

Read more ►

How to Import a Word Doc Into an Excel Spreadsheet

1. Open Excel and click the 'Insert' tab in the toolbar at the top of the page. You can import a picture, chart or file here.
2. Click the 'Object' button and then click the 'Create from File' tab.
3. Click 'Browse.' A list of your folders and files will open. Select the Word document you want to import and click 'Insert.'
4. Click 'OK.' The Word document will now appear in your Excel spreadsheet. Click on the newly created object to move it to the desired position in the spreadsheet.

Read more ►