How to Use Excel Cell Data to Reference a Sheet Name

1. Create a workbook in Excel. It will start with three worksheets, shown by tabs along the bottom of the screen. By default, these are named 'Sheet1,' 'Sheet2' and 'Sheet3.' Sheet1 will be active.
2. Enter ''Sheet2' in cell A2. Enter ''Sheet3' in cell A3. Note that both of these prepend the word 'Sheet' with a single quote ('), to indicate that it's a text value.
3. Click on the tab for Sheet2 and enter 'Orange' in cell A1.
4. Click on the tab for Sheet3 and enter 'Screwdriver' in cell A1.
5. Click on the tab for Sheet1, and in cell B2, enter the following formula: '=INDIRECT('''A2''!A1')' (without the quotation marks before the equals sign or after the final parentheses). Once you hit 'Enter,' the formula will evaluate, and the cell will show the word 'Orange.' The INDIRECT() function is substituting the contents of cell A2 into the normal cross-sheet cell reference format. This gives the same result as if you'd entered ' =Sheet2!A1' into cell C2.
6. Copy cell B2 and paste it into cell B3. Cell B3 will now show the word 'Screwdriver.' This is because the relative reference in the formula you entered is now pulling the name of the worksheet from cell A3 rather than A2.

Read more ►

How to Convert Excel 2007 Files to dBase

1. Find out what formats the database you're importing into can accept. Nearly all of them can take comma-separated values (CSV), and many can accept legacy Excel formats, such as XLS.
2. Click the 'Office' button (the round button at the upper left with the Microsoft Office logo on it). On the menu that pops up, select 'Save As.'
3. Select the appropriate file type (either CSV or XLS) from the drop-down menu at the bottom of the dialog box that opens up. Click on the 'Save' button.
4. Import the file in dBase or FoxPro to make sure that everything worked appropriately and the data is in the right place.

Read more ►

How to Make a Word Search With Microsoft Excel

1. Make a list of the words that you want to appear in your word search. The number of words should correlate to the size of the word search: larger grids can contain more words than smaller grids. Relate the words to a common theme such as animals, colors or family members.
2. Open Microsoft Excel. Select the rows and columns that you want to appear in your word search by clicking in box A1, holding down the mouse button, and dragging the cursor to highlight other boxes. For example, select boxes A1 through Y25 to make a square 25-by-25 word search.
3. Click the 'Home' tab and select 'format' under the 'cells' section. Click 'column width' in the menu and type '2' in the box that appears. Click 'OK.' While the cells are still selected, click the 'center text' symbol under the 'alignment' section.
4. Type the words from your list into the Excel spreadsheet. Type one letter per cell and make words read in the vertical, horizontal and diagonal directions.
5. Type random letters in the remaining cells. Type fragments of words that already appear in the search to make it harder to find the real words. The word search is completed as soon as you fill all the cells.
6. Format your word search. You can select all the cells (as you did in step 2) and put a border around the word search by right clicking and selecting the 'borders' button from the menu that appears. Change the style of the letters by selecting the cells and selecting a new font, size or color in dropdown menus under the 'font' section. Type the search words from your list in step 1 below the grid of letters or on a separate page.
7. Print your word search or email it to friends or family. Print multiple copies if you are playing a game as a group or if you are a teacher who has prepared this word search for students.

Read more ►

How to Set a Password on Excel 2007

1. Open the Excel spreadsheet to which you want to add a password. Click the Microsoft Office Button, select 'Save' and select a location to save the spreadsheet.
2. Click the Microsoft Office Button, select 'Prepare' and choose 'Encrypt Document' from the list. An 'Encrypt Document' dialog box appears.
3. Enter a password into the text box and click 'OK.' Confirm the password on the next menu by entering it again into the text box and click 'OK.' If you entered the password correctly, the dialog box will disappear. Save the spreadsheet again.

Read more ►

How to Recover a Protected Password in Excel 2007

Excel 2007 Password (Software)
1. Download Excel 2007 Password from the Last Bit website (see Resources). Double-click the downloaded installer to set up the application. Click quot;Startquot; then quot;All Programsquot; and quot;Excel 2007 Passwordquot; to open it.
2. Click quot;Startquot; then click the folder icon to locate the Excel document you want to recover. Click quot;Open.quot;
3. Wait for Excel 2007 Password to crack the password. If it is successful it will prompt you for payment to release your password to you; if it is not successful it costs nothing.
Excel Key (Shareware)
4. Download Excel Key from the Passware website (see Resources). Double-click the downloaded installer to set up the application. Click quot;Startquot; then quot;All Programsquot; and click the application to open it.
5. Click quot;Recoverquot; to locate your Excel 2007 document for which you want to recover the password. Click quot;Openquot; to load it.
6. Wait for Excel Key to search the file. If it manages to crack the password it will display it in the quot;Passwords foundquot; tab of the program. If you have a trial version, it will display the first two letters or numbers of your passwords, but you have to buy the full version to read the rest.
7. Check the passwords displayed on quot;Passwords found.quot; It displays the quot;File-open passwordquot; the quot;File-modifyquot; and any quot;Workbookquot; and quot;Worksheetquot; passwords it might find. Close Excel Key when you are finished.
Excel Password Recovery Master (Shareware)
8. Download Excel Password Recovery Master from the Rixler Software website (see Resources). Double-click the downloaded installer to set up the application. Click quot;Startquot; then quot;All Programsquot; and click the application to open it.
9. Click the folder icon next to quot;Excel document name.quot; Locate your Excel 2007 document, select it and click quot;Open.quot;
10. Wait for Excel Password Recovery Master to recover your passwords.
11. Make a note of the quot;Open,quot; quot;Write,quot; quot;Workbookquot; and quot;Shared Workbookquot; passwords it can recover. Click quot;Open document in Microsoft Excelquot; if you want to otherwise close Excel Password Recovery Master.

Read more ►

How to Remove Excess Area in an Excel 2007 Graph

1. Move your cursor over the white space behind the graph until you see a cursor with four arrows in a cross.
2. Click the mouse to select the 'Resize' function.
3. Click on one of the circles located on the corners or sides of the graph and drag until the graph fills the chart area as desired. This will remove any excess white space in the chart.

Read more ►

How to Make a Guest List on an Excel Template

1.
Open Excel. It doesn't matter if you are in a blank workbook or an existing spreadsheet. If you are using Excel 2003 or earlier, click 'File' and then 'New.' If you are in Excel 2007, click the Office button and then click 'New.'
2.
Type 'Guest List' into the 'Search Online' box in the 'Templates' section if you are using Excel 2003. In 2007, click 'Microsoft Office Online' under templates, and then type 'Guest List' into the 'Search Microsoft Office Online for a Template' box. Click 'Go.'
3.
Click on a template in the 'Search Results' box to preview it. When you have found the basic template you like, click the 'Download' button. The guest list template will open as a new Excel worksheet.
4.
Make changes to the way your guest list looks. If you want to use a different graphic than the one on the template, click the picture to select it. Go to the 'Insert' menu of Excel 2003 and point to 'Picture,' and then click on 'Clip Art.' Go to the 'Insert' tab in Excel 2007 and click on 'Clip Art' in the 'Illustrations' group. Find a clip art that suits your event and insert it. You can format fonts and alter colors by selecting a cell or range, right clicking and choosing 'Format Cells.' Change text by clicking on the words you want to change, selecting them with your mouse and typing the text you want.
5.
Save your guest list in your My Documents or another folder. Give it a name that pertains to your event, such as 'Party Guest List.' As you decide who you will invite, type the names and addresses in the appropriate location.
6.
Sort your list after you have entered all of your guest information. This will help you make sure you didn't forget anyone, and also ensure that there are no duplicates on your list. Start by clicking the square between A and 1 in the top left corner of the guest list. This will select your entire sheet. In Excel 2003, go to the 'Data' menu and click 'Sort.' In Excel 2007, go to the 'Data' tab and click 'Sort.' Make sure 'Header Row' is selected and click 'OK.'

Read more ►

How to Add a Bullet in Excel

1. Start Microsoft Excel and open a spreadsheet.
2. Point to the cell that you want to add the bullet to with the mouse and double-click the left button to edit the cell.
3. Hold down the 'ALT' key and press the '7' key on the number pad. When you release these keys, a bullet will appear in the cell. When using a laptop keyboard, an additional key may be necessary if it does not have a number pad. The key sequence for a bullet on a laptop is 'ALT' 'Fn' '7.'
4. Hit 'ALT' then 'Enter' to go to the next line in a cell. Once your cursor moves to the next line, enter the bullet keystrokes to get a bullet on the next line. Repeat this sequence to add as many bullets as needed to a cell.

Read more ►

How to Install Microsoft Excel Features

Microsoft Vista
1. Click on the 'Start' button, then click 'Control Panel.'
2. Click on 'Programs,' then click on 'Installed Programs.'
3. Click on 'Excel,' then click 'Change.'
4. Click 'Add or Remove Features' and 'Next.'
5. Click on the Microsoft Excel features you want, then click on 'Upgrade' or 'Install Now.'
Windows XP
6. Click on 'Start,' then click on 'Control Panel.'
7. Click on 'Add or Remove Programs,' then click 'Change or Remove Programs.'
8. Click on 'Excel,' then click on 'Change.'
9. Click 'Add or Remove Features,' then click 'Next.'
10. Click on the Microsoft Excel features you want and click on 'Upgrade' or 'Install Now.'

Read more ►

How to Use the Excel OnTime Method

Specific Time
1. Click on the 'Developer' tab. If you do not see it, then click on the 'Microsoft Office' button. Click the 'Excel Options' button. Click on the 'Popular' tab. Check the 'Show Developer tab in the ribbon' check box. Click the 'OK' button.
2. Click the 'View Code' icon in the Controls section.
3. Type the following code:Private Sub Workbook_Open()Application.OnTime TimeValue ('13:00:00'), 'YourProcedure'End SubThis tells excel to run the procedure, or macro, named YourProcedure to run at 1 p.m.
Lapsed Time
4. Click on the 'Developer' tab.
5. Click the 'View Code' icon in the Controls section.
6. Type the following code:Private Sub Workbook_Open()Application.OnTime Now TimeValue ('00:05:00'), 'YourProcedure'End SubThis tells excel to run the procedure, or macro, named YourProcedure to run five minutes from now.

Read more ►

How to Insert Footnotes in Excel 2003

1. Right-click on the cell that will link to the footnote. Select 'Hyperlink.'
2. Click 'Place in This Document' when the 'Insert Hyperlink' menu opens.
3. Enter the name of the cell that will include the footnote in the 'Type the cell reference' box. For example, if you were going to include the footnote in A27, you would type 'A27' here.
4. Click 'OK.'
5. Click on the cell (e.g., A27) that will include the footnote, and type the footnote information. The cell that you clicked on in Step 1 will now link to this cell when you click it.

Read more ►

How to Insert a Row in Excel 2007

1. Click on any cell in the row below the location where you would like to insert a new row. For example, if you'd like to add a row above row 11, click on a cell in row 11.
2. Locate the 'Cells' group on the Microsoft Excel 'Home' tab. It is located at the upper-right-hand corner of the screen.
3. Click on the 'Insert' drop-down button located in the Cells group (the first button displayed).
4. Select the 'Insert Sheet Rows' option.

Read more ►

How to Use Column Headings in Excel

How to Freeze Column Headings
1. Start Microsoft Excel. Open the worksheet in which you want to freeze the column headings.
2. Click inside of the first cell in the row just beneath the one containing the column headings.
3. Go to the 'Window' menu in Excel 2003 and select 'Freeze Panes.' Go to the 'View' tab in Excel 2007 or 2010 and click 'Freeze Panes' in the 'Window' group. Select 'Freeze Panes' from the drop-down list. Excel freezes the rows above and the columns to the left of the cell you select, so if your heading is in 'Row 1' and you click inside cell 'A2,' only the first row will freeze. When you scroll down the page, the row with the headings will be 'frozen' so that you can still view the headings as you move down the worksheet.
4. Unfreeze the row if desired. Go to the 'Window' menu in Excel 2003 and click 'Unfreeze Panes.' In Excel 2007 or 2010, go to the 'View' tab, click 'Freeze Panes' and select 'Unfreeze Panes.'
How to Print Column Headings on All Pages
5. Start Microsoft Excel. Open the worksheet in which you want to print the column headings.
6. Go to the 'File' menu in Excel 2003, click 'Page Setup' and go to the 'Sheet' tab. In Excel 2007 or 2010, go to the 'Page Layout' tab, click the 'Page Setup' dialog launcher in the bottom right corner of the 'Page Setup' section and go to the 'Sheet' tab.
7. Select the 'Row and Column Headings' check box in the 'Print' section of the dialog box in Excel 2003, 2007 and 2010 to ensure that the column headings print.
8. Click the button at the right end of the 'Rows to Repeat at Top' box in all versions of Excel. This reference button gives you access to the worksheet. Simply click the row number to select the row containing the column headings. Click the reference button once more. This enters the reference for the row number that you want to print into the 'Rows to Repeat at Top' box.
9. Click 'OK.' When you print the worksheet, the heading row will print at the top of every page.

Read more ►

How to Calculate a Z

1. Open Excel 2007 and a blank spreadsheet.
2. Enter all of your data in one column. Each separate piece of data should be in its own cell.
3. Click on an empty cell within the spreadsheet and then calculate the mean of your data by entering an average function in the formula bar and hitting 'Enter.' The mean will be displayed in the empty cell. If your data was listed in cells B3 to B52, your function would look like this: 'Average (B3:B52).'
4. Click on another empty cell within your spreadsheet and then calculate the standard deviation of your data by entering a standard deviation function in the formula bar and hitting 'Enter.' If your data was listed in cells B3 to B52, your function would look like this: 'STDEV (B3:B52).'
5. Click on an empty cell in the spreadsheet and then click on the 'fx' button, located beside the formula bar. Enter the cell number that you would like to calculate a z-score for in the 'X' box. Enter the mean you calculated in Step 3 in the 'Mean' box. Enter the standard deviation you calculated in Step 4 in the 'Standard_dev' box.
6. Click 'OK.' The z-score for the number you entered in the 'X' box will be displayed in the empty cell you selected in Step 5.

Read more ►

How to Set a Date Range in Excel

Set Start and End Dates
1. Click any cell in an Excel spreadsheet, then click the 'Home' tab. Click the 'Short date' item from the dropdown list in the 'Numbers' panel. This tells Excel to display the number you entered in the cell as a date.
2. Type any date in the cell you just formatted, in this format 'm/d/yyyy.' For example, type '1/1/2001.'
3. Use the instructions from step 1 to format the cell two columns to the right of the first cell you formatted. Type the ending date of your range in this cell.
4. Click in the cell that's in between the two cells containing your dates, then click the '=' sign to tell Excel that you're entering a formula instead of a number or text. Click the cell with the ending date, the press '-' to indicate a subtraction calculation.
5. Click the start date, then press 'Enter.' Excel will enter the number of days between the start and the end dates.
Set Start Date and Duration
6. Click a cell in a spreadsheet, then click the 'Home' tab's 'Short date' item in the 'Numbers' panel.
7. Type the starting date of your range. For example, type '1/1/2001.'
8. Click the cell immediately to the right of your start date, then type the number of days you want for your date range. For example, if your range spans three days, type '3' in the cell.
9. Use the instructions from steps 1 to format the next cell to the right as a short date. Press '=' to indicate a formula, then click the start date's cell, followed by pressing ' .'
10. Click the cell to the left, then press 'Enter.' Excel will calculate the ending date of your range, by adding the start date to the number in the cell to the left, which is the number of days in your range.

Read more ►