How to Delete the VBA Project

1. Launch any program which is part of the Microsoft Office suite. Common Microsoft Office programs include Word, Excel, PowerPoint, Access and Outlook.
2. Press the ALT and F11 keys simultaneously on your keyboard. This will open the VBA editor.
3. Right-click in the left pane on the name of the VBA project you would like to delete and select 'Remove.' The VBA editor will now delete that project from your system.

Read more ►

How to Create a ZIP File for Excel Spreadsheet

1. Right-click 'Start' and then click 'Explore.'
2. Right-click on the Excel file and then point to 'Send To.'
3. Click 'Compressed (ZIP) Folder.'
4. Double-click the ZIP folder and then click 'Extract all files' in order to open it as a 'Read-Only' file. (Note: If you would like to extract the ZIP folder and make a copy of it, click 'Extract all files' after you double-click it. Follow the steps in the wizard to complete the process.)

Read more ►

How to Insert a Watermark Into Excel 2007

1. Open Excel 2007 by clicking the Windows Start icon, selecting the 'All Programs' link and clicking the 'Microsoft Office' folder. Click 'Microsoft Excel 2007' to open the program. Click the Microsoft Office icon and select 'Open' to open an existing spreadsheet, or click 'New' to create a new spreadsheet.
2. Click the 'Insert' tab on the top navigation bar, located above the navigation ribbon.
3. Select the 'WordArt' menu from the Text group.
4. Click a style to use for the word art. You can choose any style that appeals to you or is appropriate for the type of document you are watermarking.
5. Type the word you wish to use for the watermark. For example, type 'Draft.'
6. Click the 'Format' tab on the navigation ribbon if it is not already visible, and then click 'Text Fill' in the WordArt group. Select 'No Fill' from the Text Fill drop-down list.
7. Select 'Text Outline' in the WordArt group on the navigation ribbon. Then select the 'Automatic' option from the drop-down options.
8. Click 'Send to Back' in the Format tab's Arrange group on the navigation ribbon. The watermark appears behind the text and characters in the Excel 2007 spreadsheet.

Read more ►

How To Remove Data From the External Data Range in Excel 2007

1. Select the range of data to be removed from the external data range within the spreadsheet.
2. Click on the 'Data' tab. Click on the arrow next to the 'Refresh' field in the 'Connection' group.
3. Click on the 'Connection Properties' option and then click on the 'Usage' tab. Click on the box next to the 'Remove data from the external data range before saving the workbook' field.
4. Close out of the dialog box and click on the 'Refresh Data' option from the 'Data' tab. The data will be fully removed from the external data range.

Read more ►

How to Rename an Excel Worksheet

1. Open Microsoft Excel and the file you want to change.
2. Double-click on the tab for the worksheet that you want to rename. (The tabs are at the bottom of the Excel window.) The sheet's name becomes highlighted.
3. Type in the new worksheet name.
4. Press Enter to accept the changes.

Read more ►

How to View Two Excel 2007 Spreadsheets on Separate Screens

Excel's 'Side-by-Side' View
1. Open the first Microsoft Excel 2007 file with which you want to work.
2. Open a second instance of Excel 2007. Go to the 'Start' menu in the lower left-hand corner of the computer desktop, choose the 'All Programs' list and click on Microsoft Office Excel 2007. Click the 'Office' button in the program, select 'Open,' and double-click on the second file that you want to open and view.
3. Click the 'View' Ribbon in Excel 2007. Click the 'View Side by Side' option in the 'Window' group to view the spreadsheets stacked vertically side-by-side. Click the 'Synchronous Scrolling' button in the 'Window' group to control the scrollbar separately for each spreadsheet file. Click the 'Full Screen' option in the 'Workbook Views' group to expand the viewing area. Right-click anywhere on the screen and choose 'Close Full Screen' to close this view.
4. Click 'Save Workspace' in the 'Window' group from the 'View' Ribbon. Type a name for the file and a directory location and click 'Save.' Re-opening this file saves the side-by-side view of the two files.
Split Screen Option (Windows 7)
5. Open the first Excel 2007 file which you want to view. Click the 'Maximize' button in the top-right corner of the Excel screen.
6. Open the second Excel 2007 file you want to view in a new instance of the Excel program. To open a new instance of the program, either click the Excel application from the 'All Programs' list within the 'Start' menu or right-click the Excel 2007 shortcut on your computer desktop or Taskbar and choose 'Microsoft Office Excel 2007.' In the new instance of the program, open the second file you want to view. Click the 'Maximize' button in the program to maximize the file's view.
7. View the files in split screen mode. With the second Excel 2007 file open, maximized and selected, press first the Windows logo key in the lower left corner of the keyboard. Hold the Windows logo key down and then press the 'right' arrow key to shift the file to the right side of the screen. Click once on the first Excel 2007 file to select it. Repeat the process of holding the Windows logo and the 'left' arrow keyboard keys to place the file on the left side of the screen.

Read more ►

How to Fix an Excel 2007 File That Crashes When Saving

1. Open Excel 2007 and click the 'Microsoft Office Button.'
2. Select 'Open,' and browse to the file you would like to repair.
3. Select the drop-down arrow next to the Open button to view the open options.
4. Select 'Open and Repair' and then 'Repair' if you want to repair as much of the file as possible. Select 'Extract Data' if repairing the file does not work.
5. Click the 'Microsoft Office Button' and then choose 'Excel Options.' Select the 'Save' option and make sure the 'Save AutoRecover Information' box is checked as a pro-active measure against file corruption.
6. Select the 'Microsoft Office Button' and then 'Save As.' Select 'Tools' and then 'General Options.' Check the box 'Automatically Create Backup' as a pro-active measure in the event that your workbook becomes unrepairable.

Read more ►

How to Use Multiple Logical Functions in MS Excel

1. Make a list of all conditions to test for in the correct order. For example, in a scenario where a customer who spends $100 or more receives a 20 percent discount if they are a member of your store, but only 10 percent if they are not a member, the conditions to test for are has the customer spent $100 or more and is the customer a member?
2. Decide which of the six functions you will need to use. See the link in the Resources section for a description of each function and what it returns. In our example, we need to use the IF function to perform a logical test. The AND function will be nested in the IF function to test whether the customer has spent at least $100 and if he is a member. The OR function will determine if the customer has met one of the conditions to qualify for a discount.
3. Structure the formula beginning with the IF statement and nest the other functions. In the example above, set up the worksheet as follows: enter 20 percent in cell B1 for membership discount, 10 percent in cell B2 for non-membership discount, and $100 for the minimum purchase in cell B3. List the names of the customers starting in cell A6, each customer's purchase amount in B6 and Membership status ('Yes' or 'No') in C6.
4. Enter the following formula in D6: =IF((AND(C6='Yes',B6>=$B$3)),B6*$B$1, IF((OR(B6>=$B$3)),B6*$B$2,'No Discount')))
This AND function tests whether the customer is a member and if she has spent at least $100. If both conditions are true, multiply the purchase amount by 20 percent to determine what the discount is. The OR function tests whether the customer has spent at least $100 even if she is not a member. If she meets this condition, multiply the purchase amount by 10 percent. If none of the conditions are true, the cell will display 'No Discount.'

Read more ►

How to Sort Alphabetically in Excel

1. Create your spreadsheet using the Microsoft Excel columns. Place the names you want organized in one column, with one name in each cell. In the soccer example, you could list them 'Last name, First name,' such as in this example: 'Robbins, Johnny,' 'Ferguson, Anne,' and so on.
2. Select a cell from the column you want to organize alphabetically by left-clicking. The soccer spreadsheet will be organized by last names, and you could click 'Robbins, Johnny,' 'Ferguson, Anne,' or any of the listed names.
3. Choose the 'Sort A to Z' button to sort in ascending alphanumeric order or the 'Sort Z to A' button to sort in descending alphanumeric order in the top task bar. If you chose 'Robbins, Johnny' in the soccer example and clicked the 'Sort A to Z button', it would sort: 'Adams, Douglas,' as the first name and 'Zahn, Monty' as the last name and 'Robbins, Johnny,' somewhere in between.

Read more ►

How to Print Comments in Excel

1. Start Microsoft Excel and open a spreadsheet that contains comments that you would like to print along with your spreadsheet.
2. Choose the 'File' menu and click 'Page Setup' to bring up the 'Page Setup' dialog box. Within the 'Page Setup' dialog box, you can make different changes that will affect the pages of your spreadsheet.
3. Click on the 'Sheet' tab at the top of the 'Page Setup' dialog box to show the sheet page setup options.
4. Locate the 'Print' section of the 'Sheet' options, in the center of the 'Page Setup' dialog box.
5. Select either 'At end of sheet' or 'As displayed on sheet' options from the 'Comments' drop-down menu. The 'At end of sheet' option will print the comments from the spreadsheet at the end of each sheet, and the 'As displayed on sheet' option will print the comments just as they appear on the spreadsheet while it's open on your screen.
6. Press the 'OK' button with your mouse to close the 'Page Setup' dialog box and set Excel to print comments that appear on your spreadsheets.
7. Print the spreadsheet by choosing the 'File' menu, clicking on 'Print' and then printing from the 'Print' dialog box.

Read more ►

How to Add a Histogram in Microsoft Excel for Macs

1. Install the StatPlus-Mac LE (full link in Resources). This free add-on provides Mac users with statistical analysis tools. Excel 2011 for Mac does not include Microsoft's Analysis ToolPak.
2. Restart your Mac to complete the installation process and add StatPlus to your Excel installation.
3. Open Microsoft Excel and select 'File,' and then 'Open' to either open an existing workbook or start a new one.
4. Enter your bin values, which display as the horizontal axis values on your histogram, in a single row or column, one per cell. These are the labels that display at the bottom of your histogram to label each bar.
5. Enter your numeric data in a single column or row -- one per cell -- that corresponds. Histograms can only compare qualitative data, so do not enter non-numeric values in this column. For frequency histograms, these values are your frequency data.
6. Select 'Basic Statistics,' and then 'Descriptive Statistics' from the menu in Excel. The StatPlus installation automatically adds these menu options to your Excel installation.
7. Enter the values of the cells containing the numeric data values.
8. Enter the values of the cells containing the X-values, or bin numbers.
9. Select 'Advanced Options,' and then check both the 'Plot Histogram' and 'Overlay' boxes. Select 'OK' to let StatPlus create the histogram from your data.
10. Insert the graph into the current worksheet if you wish to include the histogram along with the table of data, or open a new worksheet on to put the graph into its own worksheet.

Read more ►

How to Work With Pictures in Excel 2007

Inserting the Picture File
1. Open the Excel worksheet.
2. Click the 'Insert' tab on the command ribbon.
3. Click the 'Picture' button on the 'Illustrations' group.
4. Click the saved image file from the 'Picture Library' or other location, such as the Desktop. The picture file appears over the worksheet. The 'Picture Tools' ribbon appears with tabs, such as 'Format.'
Editing the Picture
5. Click the 'Format' tab in the 'Picture Tools' ribbon. The ribbon displays four groups of commands: Adjust, Picture Styles, Arrange and Size.
6. Select a command and click the down-arrow, such as Brightness or Contrast from the 'Adjust' group. For example, to adjust the brightness, you can point over the list of increments ranging from ' 40%' for an extremely bright look to '-40%' for an extremely dark look.
7. Click the down-arrow on 'Picture Styles' to view the variety of frames and effects for your picture. Point over the command button to display a preview of the effect. For example, your picture can convert to a framed picture when you point over the 'Simple Frame, White' button.
8. Click a command button from the 'Size' group. For example, adjust the picture size by inserting values in the height or width text boxes. Click the 'Crop' command to display dark crop marks on the outer edge of the picture. Click and drag these crop marks to adjust the borders and delete unwanted items from the picture.
9. Click and drag the picture to move it anywhere on the worksheet.
10. Save this Excel file.

Read more ►

How to Create a Drop

1. Open an Excel spreadsheet. Click in an empty cell and type the first item for the drop-down list. Press 'Enter' and then type the second entry. Continue doing this for all entries in the list you need.
2. Click the cell where you want a drop-down list. Click and drag across multiple cells to highlight all of them if you want them all to have the drop-down list.
3. Click the 'Data' tab on the Ribbon and then click 'Data Validation' in the Data Tools group.
4. Click the drop-down menu under the Settings tab and select 'List.' Click the button beside the Source text box to open the reference box. Click and drag over the cells that contain the options for the menu to select all of them, and then click the button beside the selected area on the dialog box. Make sure both the 'Ignore blank' and 'In-cell drop-down' options are checked.
5. Click the 'Error Alert' tab. Type 'Invalid Entry' in the Title text box. Type 'You have made an invalid selection. Please try again' in the Error Message text box. If a user does not select an option from the drop-down list, this error message flashes on the screen.
6. Click the 'OK' button to close the Data Validation dialog box. The drop-down list appears in all of the highlighted cells. Save the spreadsheet.

Read more ►

How to Force Excel 2007 to Be Backwards Compatible With 2003

1. Open Excel 2007 and select the 'Office' button. Select 'Excel Options.' The Excel Options dialog box appears.
2. Select the 'Save' option on the left side of the Excel Options dialog box. Select 'Excel 97 -- 2003 Workbook' in the 'Save Files in this format. Click 'OK.'
3. Click the 'New' icon on the Quick Access Toolbar. A new Excel 2007 workbook opens displaying the Excel 2003 compatibility mode message.

Read more ►

How to Make Lower Case Data All Caps in Excel 2007

1. Find the cell that contains the lower case information. Make note of the cell number. Cells in Excel are marked by a letter (column) and number (row). The first cell in a spreadsheet is A1.
2. Click in an empty adjacent cell where you want the upper case information to go. Formulas take existing data and change it based on the type of formula used. This information is then saved in its own separate cell where the formula was typed. Do not enter the formula in the cell that contains the lower case information. If you type the formula in the lower case cell, the words are deleted by the formula text.
3. Enter the formula '=UPPER(cell number)' into the cell. Use the cell number for the lowercase information. Do not enter the quotation marks.
4. Press the tab or enter button to exit the cell.

Read more ►