How to Determine an MS Excel File Version

1. Click on the Windows “Start” button then on “Computer” to open Windows Explorer.
2. Browse your computer to find the Excel file.
3. Check the file extension. If it is '.xlsx' then the file was created with Excel 2007. The extension '.xls' indicates older program versions.
4. Right-click on the Excel file and choose “Properties” from the pop-up menu.
5. Select the tab “Details” (in Windows Vista or 7) or “Summary” then “Advanced” (in Windows XP).
6. Read the Excel version in the line “Type,” for example, 'Microsoft Office Excel 2003.'

Read more ►

How Can I See Excel 2003 Commands in Excel 2007?

1. Click the 'Office' button, and select 'Customize Quick Access Toolbar.' This action opens a pop-up window.
2. Select 'All Commands' from the 'Choose' menu. This action displays a list of available Excel commands that can be added to the Quick Access Toolbar.
3. Select a command from Excel 2003 that you want to view independent of the ribbon interface. Click the 'Add' button. Repeat this process for each Excel 2003 command that you want to view in the Quick Access toolbar. Click the 'OK' button when you have finished adding Excel 2003 commands.

Read more ►

How to Remove Hyperlinks in Microsoft Excel 2007

1. Open Excel using the 'Start' menu or another shortcut. You may also type 'Excel' in the Start menu search box and click on the resulting link.
2. Click the 'Open' option and select the spreadsheet you want to work with. Locate the cell containing the link.
3. Right-click the link you want to delete and click the 'Remove Hyperlink' option. Repeat for each link you want to remove.

Read more ►

How to Calculate Percentage Increases in Excel 2007

1. Type 'Beginning Number' in cell A1, and then type your beginning number in cell B1. For example, type '50' in cell B1.
2. Type 'Ending Number' in cell A2, and then type your ending number in cell B2. In the example, type '100' in cell B2.
3. Type 'Percent Increase' in cell A3.
4. Type '=((B2-B1)/B1)' in cell B3. In the example, your result will be 1, or 100%.

Read more ►

How Can I Disable All Double Clicking in Excel 2003?

1. Open the document you wish to disable double-clicking on in Microsoft Excel 2003.
2. Press the 'Alt' key on your keyboard and 'F11' key simultaneously. The VBA editor will appear.
3. Double-click 'Workbook' in the upper left window pane in the VBA editor. A new window will appear.
4. Copy and paste the following code into the new window:Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, _ByVal Target As Range, ByVal Cancel As Boolean)Cancel = TrueEnd Sub
5. Press 'Alt' and 'F11' simultaneously again to save the code and return to Excel. The string of code disables all double-click actions in the Excel workbook.

Read more ►

How to Create a Stacked Bar Graph in Excel

1. Click 'Start,' then 'All programs,' then 'Microsoft Office,' then 'Microsoft Excel.'
2. Press 'Ctrl' 'O,' then locate and open the Excel document which contains the data to be turned into a stacked bar chart.
3. Highlight the data that you want to create the chart from.
4. Click 'Charts,' then 'Bar,' then 'Stacked Bar.' The stacked bar chart will automatically appear in the worksheet. You have now inserted a stacked bar chart into your Excel document.

Read more ►

How to Allow a Shared Workbook

Microsoft Excel 2003
1. Launch Excel 2003, then open the Excel workbook you want to share with other users on the network.
2. Click the 'Tools' option on the menu bar, then click 'Share Workbook.' Wait for the 'Share Workbook' options dialog window to appear.
3. Click and enable the checkbox next to the label that reads 'Allow Changes by More Than One User at the Same Time. This Allows Workbook Merging.' Click the 'OK' button.
4. Click the 'File' > 'Save' option on the menu bar to save the permission changes to the workbook.
Microsoft Excel 2007 or 2010
5. Open Microsoft Excel, then open the workbook you want to share.
6. Click the 'Review' tab on the 'Office Ribbon,' then click 'Share Workbook.'
7. Click the 'Editing' tab, then enable the checkbox next to 'Allow changes by more than one user at a time. This also allows workbook merging.'
8. Click the 'Advanced' tab, then select options for tracking and updating changes to the shared workbook. Click 'OK.'
9. Save the workbook to save the sharing and permission changes for the file.

Read more ►

How to Keep Track of Changes in Excel 2003

1. Open Excel from the Start menu on your toolbar.
2. Open the file for which you'd like to track changes.
3. Go to Tools > Track Changes.
4. If you want to see the changes while you are editing, select 'Highlight Changes.' Then select the boxes labeled 'Track Changes While Editing' and 'Highlight Changes on Screen.' When making a lot of changes, you might not want this option on because it can be distracting.
5. Decide who gets to make changes on your worksheet. Select the 'Who' tab and choose the users who can make changes. If you choose 'Everyone,' your file will be shared on the network.
6. Select the 'When' option to decide when changes are tracked. The most popular is option is 'All.'
7. Click 'OK' to save your options.

Read more ►

How to Convert XML Files Into an Excel Spreadsheet

1. Open Excel.
2. Click the Microsoft Office symbol in the upper left-hand corner. Select 'Open' from the menu.
3. Find the XML document you want to convert and click 'Open.' If the document does not seem to be present where it should be, you may need to select 'XML Files(*.xml)' from the 'Files of type:' drop-down box.
4. A small dialog box will open titled 'Open XML.' In this box select the radio button titled 'As an XML table,' then click 'OK.'
5. If another dialog pops up that has a message relating to creating a 'XML schema,' simply click 'OK.' The XML file should be opened as a spreadsheet.
6. To complete the conversion, save the spreadsheet as an Excel file by clicking the 'Office' button, then 'Save.'

Read more ►

How to Print Grid Lines in MS Word

Show Gridlines
1. Open the Word document that contains your table or labels.
2. Select 'Table' and 'Show Gridlines' from the toolbar to make gridlines visible. You will see the grid lines on your page.
3. Select 'File' and 'Print Preview' from the toolbar. The grid lines will not be visible.
4. Press the 'Escape' key to return to your page.
Add and Print Borders
5. Select the table or labels containing the grid lines you want to print.
6. Click on 'View,' 'Toolbars' and 'Tables and Borders' in the toolbar to open the 'Tables and Borders' toolbar.
7. Expand the 'Border Color' button by clicking on its arrow. Then select 'Gray-25%' (a color similar to that used in grid lines) for the border color.
8. Expand the 'Border' button by clicking on its arrow. Then select 'All Borders' from the list. A border will be applied to your entire table.
9. Select 'File' and 'Print Preview' from the toolbar. The borders you just applied will now be visible. Press the 'Print' icon on the Print Preview page to print your table or labels with the borders.

Read more ►

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 ►