How to Password Protect an Excel 2007 File

1. Open the Excel 2007 file. Click the 'Office Button' located in the top-left corner.
2. Select 'Prepare' from the list. Click the option to 'Encrypt Document.' Enter a password. Click 'OK.' Re-enter the password. Click 'OK.'
3. Select 'Save As' from the list. Click 'Tools' located in the lower-left corner of the 'Save As' box. Select 'General Options' from the list. Set a password to open or modify the file. Click 'OK.' Re-enter the password. Click 'OK.'
4. Click the Microsoft Office Button and select 'Save.'

Read more ►

How to Insert a Tick Mark in Excel

1. Reveal the Developer tab, if necessary. In Excel 2007, click the 'Office' button and choose 'Excel Options.' In the Popular options set, check the box labeled 'Show Developer tab in the Ribbon.' In Excel 2010, click 'File' then 'Options.' Choose 'Customize Ribbon' in the Categories pane and check 'Developer' in the list of tabs.
2. Click the 'Developer' tab. Choose 'Insert' and from the Form Controls group choose the small box with a check mark in it.
3. Draw a box with the cursor to define the location and size of tick mark and its label. These remain changeable.
4. Click on the text, marked 'Check Box 1,' delete that text and add your own.
5. Right-click anywhere in the form and choose 'Format Control...' to set the form's formatting properties, such as color and lines. Choose the 'Control' tab to determine whether the box begins with a tick or without one. Add 3-D shading if you like.

Read more ►

How to Copy VLookup to Multiple Rows

1. Open the Excel 2010 file where you want to copy the VLookup function down to multiple rows.
2. Click on the cell that contains your VLookup formula. Place your cursor into the formula bar located just above the spreadsheet so that you can edit the formula.
3. Place dollar sign symbols in front of any ranges that you don't want to change when you copy your formula down. Excel uses relative references when copying formulas, so if your VLookup function referenced the range A1:D10 and you copy that formula down one cell, the range would change to A2:D11. By placing dollar signs in front of each reference element, such as $A$1:$D$10, you ensure that the reference will not change when you copy the formula. This is especially important when copying VLookup formulas, as the table range should remain constant. Press 'Enter' when you are done making changes.
4. Click the cell that contains the VLookup formula. Move your mouse to the small, black box, called a fill handle, in the lower right corner of the cell. Your mouse cursor will change into a plus sign when you are correctly positioned over the box.
5. Click and hold the mouse button on the fill handle. Drag the mouse down the spreadsheet until you reach the last row where you want the VLookup formula to reside. Release the mouse button, and the formula will be instantly copied to all the rows between the original cell and the cell where you released the button.

Read more ►

How to Enable Scrolling in Excel 2007

1. Open the Microsoft Excel 2007 file on which you want to enable scrolling.
2. Click on the 'Microsoft Office' button from the top of the page and click on the 'Excel Options' button.
3. Click on the 'Advanced' button from the left side of the Excel Options dialog box.
4. Click on the box next to the 'Zoom on Roll with Intellimouse' option so it's deselected.
5. Click on the 'OK' button, and you should now be able to scroll throughout your worksheet.

Read more ►

How to Change the Case in Microsoft Excel 2007

1. Open the Excel worksheet that has the case you want to change.
2. Decide which case you want to use. You can choose from uppercase, lowercase or proper case (the first letter is capitalized).
3. Use a blank cell, row or column next to the cell you want to change. If there is not a blank cell, row, or column, right-click next to the cell you want to change, select 'Insert' and choose whether you want to insert a new row or column. You can delete this later. If you need to change the entire spreadsheet, start with the column available at the end of the spreadsheet.
4. Enter '=' and the function for the case you want to change to in the blank cell. Use 'LOWER,' 'UPPER,' or 'PROPER.' For example, if you wanted to switch to lowercase, you would enter into the cell '=LOWER.'
5. Next to the case function enter a parenthesis. Inside the parenthesis, enter the cell reference for the first cell where you want to change the case. For example, if you are changing the case of the text in cell A1 to lowercase, you would have entered '=LOWER(A1)' at this point.
6. Highlight the cell you entered the function in and the rest of the row(s) or column(s).
7. Click the 'Home' tab located at the top of the screen and click the 'Fill' button. Select 'Down,' 'Right,' 'Up,' or 'Left' depending on the direction of the cells in which you're changing the case. If you need to change cells in more than one direction, then click 'Fill' again and select the next direction. The text with the case change will appear.
8. Highlight the cells with the case change, right-click, and select 'Copy.'
9. Click the first cell with the old case, which would be cell A1 in the example. Click the 'Paste' button and select 'Paste Special.' Select 'Values' in the box that opens and click 'OK' to paste the converted text. This will paste the new case into all the cells.
10. Delete the duplicate cells by highlighting them and pressing the 'Delete' button. If you had to insert a new row or column, select the row or column, right-click, and click 'Delete.'

Read more ►

How to Use a Fill Handle for Numbers in Excel 2003

1. Open Excel 2003 and click in cell A1. Type '1' in cell A1 and '2' in cell A2. Highlight these two cells.
2. Notice the fill handle in the lower right hand corner of these highlighted cells. Point to the fill handle. Your mouse will become a thin black ' .' This is your indicator that the fill handle can be dragged to fill in the sequence.
3. Drag the fill handle down a few cells. Notice the rest of the sequence is automatically populated in the cells.

Read more ►

How to Delete a Named Range in Excel 2007

1. Open your Excel file.
2. Click 'Formulas.'
3. Select 'Name Manager.'
4. Highlight the named range.
5. Press 'Delete.'

Read more ►

How to Make a Decision Tree in Excel

1. Draw a square in a blank Excel worksheet. In Excel 2007, click 'Insert,' then 'Shapes' and then click on a square. In Excel 2003, click on the 'Rectangle' autoshape button on the drawing toolbar and drag the square to your worksheet.
2. Right-click on the square and click 'Add text.' Type the major decision into the box. For example, you might be deciding whether to save or spend a recent windfall, so write 'Save or Spend' in the box.
3. Select a 'Line' shape from the toolbar. Click on the right edge of the square and drag the line to a length of an inch or two (you can change the lengths of the lines at a later time by clicking and dragging on them). In the above example, you would draw two lines of equal length (one for 'Spend' and one for 'Save').
4. Draw two more squares at the end of the lines, repeating the process for inserting a square from Steps 1 and 2 to draw the square and insert text. In the given example, write 'Spend' in one text box and 'Save' in the other. This creates your first set of branches.
5. Repeat the above process to as many branches as you need to your tree.

Read more ►

How to Upgrade From Excel 2003 to 2010

Office 2010 Installation
1. Place the Office 2010 installation disc into your computer or download Office 2010 from the Microsoft website.
2. Follow the prompts to initiate the installation of Office 2010. If you have downloaded a version of the software, you may be prompted to unzip the files. For CDs, you will have to enter a product key, which can be found on your CD case.
3. Click 'Customize' in the 'Choose the installation you want' dialog box.
4. Right click and then click 'Not available' for all programs except for Excel 2010.
5. Click 'Install now' to install Excel 2010.
Excel 2010 Download
6. Visit the Microsoft Excel 2010 website.
7. Purchase a copy of Excel 2010. Click 'Download' to download a copy of Excel to your computer or click 'Ship it' to receive a disc.
8. Follow the instructions for installation. For CDs, place the CD into your CD drive and follow the on screen prompts. For downloads, follow the on-screen prompts after downloading the file from the Microsoft website.

Read more ►

How to Transfer Excel VB Data From Range to Array

1. Click the “View” tab on the 'Ribbon' menu. Click the “Macros” icon to display the “Macro” dialog.
2. Select an existing macro name in the list box if you want to add the ability to copy data from a range of cells to an array. Click “Edit” to open the Visual Basic editor. If you want to write a new macro, type the name into the “Macro name” text box and click “Create.'
3. Declare an array variable as a 'Variant' data type. The following example declares the array 'RangeArray':Dim RangeArray As Variant
4. Assign the data cell range to the array. Continuing the example, assign the cells A1 through A10:RangeArray = Range('A1', 'A10')
5. Access the data in the array. To confirm that the example has worked, display the third value in the range with a message dialog:MsgBox RangeArray(3, 1)

Read more ►

How to Format Drop

1. Open Excel 2010 and select a workbook that will contain the drop-down list. Click the 'File' tab and select 'Open.' Browse your files and select the workbook. Click the 'Open' button. The workbook opens.
2. Highlight the range of cells where the drop-down list will be displayed. Select the 'Data' tab, then select 'Data Validation.' The Data Validation dialog box appears.
3. Click the 'Settings' tab. Change the 'Allow' drop-down list to 'List.' In the 'Source' drop-down box, type 'Yes,No,Maybe.'
4. Click the 'Input Message' tab. The input message will appear as the user uses the drop-down list. Use it to add helpful information. In the 'Title' field, type the title of your Input message. Add additional details in the 'Input Message' field.
5. Click the 'Error Alert' tab. The error alert tab informs the user of data input mistakes when the user manually types the wrong information, instead of using the options from the drop-down list. Select the 'Stop' icon in the 'Style section. In the 'Title' field, type the title of your Error message. Add additional details in the 'Error Message' field. Click 'OK.'
6. Click in one of the fields of the highlighted cells. Notice the drop-down list and input messages that appear.

Read more ►

How to Hide Worksheets in Excel 2007

1. Select the worksheets you want to hide. Click the worksheet tab, such as Sheet1 or Sheet2 to select one sheet. To select at two or more adjacent sheets, click the first tab then hold the 'Shift' key and click the last tab. To select more than one nonadjacent sheets, click the first tab then hold the 'Control' key and click the other tabs you want to hide. To select all sheets, right-click any sheet tab then choose 'Select All Sheets' on the shortcut menu.
2. Click 'Format' in the Cells group located on the Home tab above the worksheets.
3. Select 'Hide and Unhide' under Visibility and click 'Hide Sheet.'

Read more ►

How to Make an Invoice in Excel 2007

1. Click the round 'Office' button in the top left of the Excel worksheet. A drop down will appear with a list of icons on the left and a list of 'Recent Documents' on the right.
2. Click 'New,' the first icon at the top of the list on the left of the drop down. A new screen will pop up automatically defaulting to 'Blank and recent' in the box on the left of the screen and 'Blank Workbook' at the top of the middle box.
3. Click 'Invoices' in the box on the left of the screen under the header 'Microsoft Office Online.' The middle screen will change to show thumbnails of various invoice designs.
4. Click through the various invoices to view the different options available. If this is your first time using a template, information to the right of the middle box will appear asking you to accept using these forms. Click 'I Accept' if you accept the terms of the templates. Once you've clicked that, you will never need to click it again and instead will see larger thumbnail views of the template you currently have selected.
5. Click 'Download' once you have found a template that fits your business needs. The template will download and open. Modify appropriate areas to show your company name and information.
6. Click the 'Office' button in the top left. In the drop down, click 'Save' to name and save your template where you will remember it.

Read more ►

How to Calculate the Percentage Change From the Previous Year in Excel

1. Enter previous and current year information in columns side by side. Give the column headings to indicate the first is the current year information and the second is the prior year information.
2. Name the next column 'Percent Change,' and click on the first row in that column that has data in the fields for current and previous years.
3. Enter the following formula into the cell; '=(cell with current year info)-(cell with prior year info)/(cell with prior year info).' For example, if the first row to have data in it is Row 6, the current year information is in Column C, the prior year information is in Column D, and the column being used to show the percentage of change is Column E, the formula '=(c6-d6)/c6' would be entered into Cell E6.
4. Format the result to a percentage. Right-click on the cell and choose 'Format cells.' Choose 'Percentage' from the list along the left of the next window. Choose the number of decimals to show.
5. Copy the formula for the cell down to the rows below. To quickly do so, place the cursor in the lower right corner of the cell until a ' ' appears. Press the left mouse button and hold it down as you drag the mouse down to the final row for which the formula is needed. Notice that the formula adjusts itself to each row; therefore, the cell below e6 shows the formula as '(c7-d7)/d7.'

Read more ►

How to Create Labels in Microsoft Office 2007 From Excel 2007

1. Open a new Excel spreadsheet. Type 'Last Name' into Cell A1. Move right across the first row of cells labeling each new cell with the information you need in order, such as 'First Name,' 'Title,' 'Address,' 'City' and 'Zip Code.'
2. Type in the relevant information for each mailing label you need on the column below the row heading. For example, type in the last name for each contact underneath the 'Last Name' column.
3. Highlight the entire section of columns and rows with the mailing label information, including the top row headers. Navigate to the 'Formulas' tab and click 'Define Name.' Type in a name for the address list, such as 'Invitations' or 'Mailing List.'
4. Save the spreadsheet and close the Excel 2007 program. Open a new Word 2007 document. Navigate to the 'Mailings' tab and click 'Start Mail Merge.' Select 'Labels.'
5. Use the drop-down menus to select the specific type of labels you are using. Check the code on the back of the label's packaging if you aren't sure what type you have.
6. Click 'OK' and then click the Microsoft Office button at the upper-left end of the window. Select 'Word Options.' Choose 'Advanced' and then click the check box labeled 'Confirm file format conversion on open.'
7. Click 'OK.' Navigate back to the 'Mailings' tab and click 'Select Recipients.' Choose 'Use Existing List.' Click the name of the Excel spreadsheet you saved earlier and choose 'OK.'
8. Click 'Match Fields.' Use the drop-down menus to match the headers you created in the Excel spreadsheet with the various fields that will appear on the mailing label, such as 'First Name' and 'Last Name.'
9. Select 'Preview Results' to ensure the mailing labels look correct. Click the 'Finish Merge' link and then select 'Print Documents' to print the labels.

Read more ►