How to Convert Excel 2007 to Dbf

1. Download a converter program designed to save Excel 2007 files to dbf format. There are a number of such programs on the market. Some of them are free and others are available at a reasonable cost. Please see the Resources section for links to some of these converter programs.
2. Open Microsoft Excel 2007 and create the spreadsheet you want to convert. Save the file in Excel 2007 format to your hard drive or to your network shared drive.
3. Close the Excel spreadsheet and open your conversion program. Choose 'import data into database.' You can choose to import the data from the Excel 2007 spreadsheet into a database you have already opened, or you can import the data into a database file on your hard drive or network share.
4. Click 'OK' to begin the import process. Choose the appropriate format for each field in the spreadsheet, i.e. text for labels and notes and currency for pricing data.
5. Close the converter program and open your database program. You can open the dbf file you have created in Microsoft Access or dBase. Review the data to make sure all of the fields were imported successfully.

Read more ►

How to Make an Invoice in Access

1. Open Microsoft Access. Go to 'File,' 'Time Billing' under the 'Office.com Templates' section. You can also type “Office.com Templates” in the search box, in the upper right corner.
2. Open the 'Time Billing' folder. Select the 'Time Billing' template to show the 'Project List' window.
3. Select the “Reports” drop-down menu and click “Invoice.” A new window will open with Microsoft Access default information. Delete or add pertinent information relating to your organization in the fields to create your invoice.

Read more ►

How to Connect Excel to SQL Using Visual Basic

1. Open Excel, then type a list of names in one column and ages in an adjacent column. Label the tops of these columns with the text 'Names' and 'Ages.' This step creates a database of sample data for your SQL program to fetch. You can create a table with different data if you'd like.
2. Drag a selection region around the table, then type 'MyTable' in the text box to the left of the formula bar. This creates a range name for the sample data, which your program will need to access the data.
3. Save the file as 'C:\MyDatabase.xlsx,' then close the file.
4. Press 'Control,' followed by 'N' to create a new spreadsheet. You'll store your SQL program in this sheet.
5. Press 'Alt,' followed by 'F11' to enter the VB development environment, commonly abbreviated as the 'IDE.' Developers write and sometimes execute VB programs in this IDE.
6. Click the 'Insert' menu, then click the 'Module' item. This action creates a new code window for you to enter your SQL program listing.
7. Click the 'Tools' menu heading, then click 'References.' Place a check in the checkbox labeled 'Microsoft ActiveX Data Objects.' This action makes visible the database objects that Excel needs to run the SQL query.
8. Paste the following program into the new code window.Sub sqlVBAExample()Dim objConnection As ADODB.ConnectionDim objRecSet As ADODB.RecordsetSet objConnection = New ADODB.ConnectionobjConnection.ConnectionString = 'Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myDatabase.xlsx;Extended Properties=''Excel 12.0 Xml;HDR=YES'';'objConnection.OpenSet objRecSet = New ADODB.RecordsetobjRecSet.ActiveConnection = objConnectionobjRecSet.Source = 'Select * From myTable'objRecSet.OpenRange('D10').CopyFromRecordset objRecSetobjRecSet.CloseobjConnection.CloseSet objRecSet = NothingSet objConnection = NothingEnd Sub
9. Click one of the program's statements, then press 'F5' to run the program.
10. Press 'Alt,' and then 'F11' to return to the Excel spreadsheet. The spreadsheet will display the results of the SQL connection that your program established. The results include the database table you created earlier.

Read more ►

How to Make Column Titles in Excel 2007

1. Open an Excel worksheet.
2. Click on a cell above a column. The selected cell will show a heavy black outline. The column and row headers will change to a different color.
3. Enter the column title.
4. Edit or format the title for a custom look. For example, you can change the font, font color, size and alignment. Click on the 'Home' tab and use the commands in the 'Font' and 'Alignment' groups to change the format of your column title.
5. Save the worksheet.

Read more ►

How to Use Radio Buttons in Excel

Using Radio Buttons in Excel 2003
1. Open the worksheet to which you want to add radio buttons. Open the 'Control Toolbox' by going to the 'View' menu, pointing to 'Toolbars' and selecting 'Control Toolbox.' The toolbox appears as a floating toolbar.
2. Click the radio button control in the 'Control Toolbox.' If you are not sure which control this is, hover your mouse over each button in the 'Control Toolbox' and click on the one that says 'Option Button.'
3. Click onto the worksheet where you want to place the first radio button and drag the box to 'draw' the size you want it to be.
4. Right-click the radio button, point to 'Option Button Object' and click 'Edit.' Delete the 'Option Button' text and type in your desired text for the first radio button. Click outside of the box to stop editing and apply your text.
5. Right-click the radio button and select 'View Code' to add a macro to the radio button. Right-click the radio button and select 'Properties' to change other properties of the button. Click the 'Exit Design Mode' button in the 'Control Toolbox' to leave design mode and enable the radio button.
Using Radio Buttons in Excel 2007
6. Display the 'Developer Tab.' Click the 'Office Button' and click 'Excel Options.' Select the 'Show Developer Tab in the Ribbon' check box under 'Top Options for Working With Excel' and click 'OK.'
7. Go to the 'Developer' tab and click 'Insert' in the 'Controls' group. Click 'Option Button' under 'ActiveX Controls.'
8. Click onto the Excel worksheet and drag the mouse to draw the radio button onto the page.
9. Click 'Design Mode' in the 'Controls' group of the 'Developer' tab. Right-click the radio button, point to 'Option Button Object' and click 'Edit.' Delete the 'Option Button' text and type in your desired text for the first radio button. Click outside of the box to stop editing and apply your text.
10. Right-click the radio button and select 'View Code' to add a macro to the radio button. Right-click the radio button and select 'Properties' to change other properties of the button. Click the 'Exit Design Mode' button in the 'Control Toolbox' to leave design mode and enable the radio button.

Read more ►

How to Merge Two Columns in Excel 2007

1. Open Excel and search for a spreadsheet that contains two columns you want to merge. Select 'Open' on the Quick Access Toolbar and search for the spreadsheet on your computer. Locate the spreadsheet and click 'Open.'
2. Insert a blank column beside the columns you want to merge. Select the column beside the columns you want to merge and click on the column header. For example, if you want to combine Column A and B, click on the column header C. Once the column header is selected, the entire column is highlighted. Right click on the column header, and select 'Insert.'
3. Use the concatenate function in the first cell of the new column. Click on the cell that will display the first set of merged data. Click on the 'Formulas' tab on the ribbon and select 'Text.' Select 'Concatenate' from the list of available functions. The Function Arguments window opens.
4. Click in the 'Text1' box and select the first cell in the first column that you want merged. The cell data will appear in the 'Text1' field. Click in the 'Text2' box and select the first cell in the first column that you want merged. The cell data will appear in the 'Text2' field. Click 'OK.' The data is now merged.
5. Copy this formula from the first cell to the remaining cells that you want merged. Copy the first formula by right clicking on the cell and selecting 'Copy.' Highlight the remaining cells in the newly copied column and select 'Paste.' Your data is now merged.

Read more ►

How to Calculate Daily Percentage Change in Excel 2007

1. Type 'Beginning of Day' in cell A1, 'End of Day' in cell B1 and 'Percent Change' in cell C1 in Excel 2007.
2. Type the day's beginning value in cell A2. For example, if a stock's price is $40 at the start the day, type '40.'
3. Type the day's ending value in cell B2. In the example, assume the stock closed at $45. In this case, type '45' in cell B2.
4. Type '=(B2-A2)/A2)' in cell C2. In the example, you get the result '0.125.'
5. Select the 'Home' tab, and click the 'Number' box.
6. Select 'Percentage' under 'Category.'
7. Choose the amount of decimal places you want your percentage to have, and click 'OK.'

Read more ►

How to Make a Alphabetized Mailing List in Microsoft Excel

1. Launch Microsoft Excel 2010.
2. Type 'First Name' in the top cell in the first column (Cell 'A1') and press 'Tab' on the keyboard to save the contents of the cell and move to the top cell in the second column (Cell 'B1').
3. Type 'Last Name' in the top cell in the second column and press 'Tab' to save the contents of the cell and move to the top cell in the third column. Continue this pattern for 'Address 1,' 'Address 2,' 'City,' 'State' and 'Zip.' Add other fields as needed and add their title to the top row.
4. Right-click on the letter at the top of the column which contains the zip code. Click 'Format Cells' from the context menu. Click 'Special' in the 'Category' column and click 'Zip Code' or 'Zip Code 4' in 'Type.' Change the locale if necessary and press 'OK' to save the changes.
5. Click or navigate to the second cell in the first column (Cell 'A2') and type in the first name of the first person or business on the mailing list. Press 'Tab' to move across the columns and fill in all of the available information. Press 'Tab' twice to leave a cell blank if necessary.
6. Fill in all of the addresses and click 'File' and 'Save As' to name and save the file.
7. Click the letter 'A' above the first column and hold down the mouse button. Drag the mouse across the top letter of each column that contains data to select them.
8. Click 'Data' from the ribbon at the top of the program and click 'Sort' from the 'Sort Filter' group.
9. Click the arrow in the 'Sort By' and change the selection to reflect the column which is to be sorted by, such as 'Last Name' or 'Zip Code.'
10. Click the arrow in the 'Order' group and choose whether to sort in ascending or descending mode. Click 'OK' to sort all selected cells as a group.

Read more ►

How to Highlight Alternating Rows in Excel

Using Excel Table Style
1. Open the Excel worksheet with the data you want to highlight.
2. Click the 'Home' tab on the ribbon, then click 'Format as Table.' Excel asks you where the data for your table is. Click 'OK' to accept the range Excel highlighted, or enter the range manually. Click back to 'Home' if the 'Design' tab opens. Click 'Format as Table' again.
3. Select the alternate shading that you want. You can select from the 'Light,' 'Medium' or 'Dark' shading groups. Your table should now have alternating rows highlighted.
Using Conditional Formatting
4. Open the Excel worksheet with the data you want to highlight.
5. Select the range you want to have alternating rows. To select the entire sheet, click the little triangle to the left of 'column A' and above 'row 1.' To select some rows instead of the whole sheet, place your cursor over the first row number you want to select until you see a black arrow. Click and drag down until you have selected all the rows you want.
6. Click the 'Home' tab on the ribbon, then click 'Conditional Formatting.' Select 'New Rule' from the bottom of the menu.
7. Select the last rule in the top window, 'Use a formula to determine which cells to format.' You should see an empty line pop up in the middle of the pane.
8. Enter the following under 'Format values where this formula is true':=MOD(ROW(),2)=0
9. Click 'Format.'
10. Select the 'Fill' tab and choose a color from the color grid. Click 'OK.' Your color appears in the preview pane where you typed the rule.
11. Click 'OK.'

Read more ►

How to select non

1. Select your first cell by clicking your mouse button on it. The cell will now be shaded grey. If you want to select an entire row or column, click its heading (such as 'B' or '13') in the frame around the spreadsheet.
2. Hold the control key (command key on an Apple computer) and click the mouse button on another cell. Both cells will now be shaded grey. Any action, such as copy, will now apply to both cells. An unlimited number of cells can be selected as long as the control key is held down.
3. Re-click an already-selected cell with the control key pressed down to unselect it without affecting the selection of other cells. Letting go of the control key and clicking an unselected cell with select it and remove any existing selections from the clipboard.

Read more ►

How to Extract Information From Cells in Excel 2003

1. Open your Excel 2003 workbook file.
2. Highlight the cells from which you want to extract data. You can do this by either placing the cell in one corner of the block you want to work with, holding the 'Shift' key down and using the arrow keys to expand the block; or you can click and drag across the block.
3. Click 'Edit' and 'Copy' using the top menu. You have now extracted a copy of all the data in the cells including formulas, formatting and values (the actual numerical values that show on your spreadsheet).
4. Navigate to where you want to place and review the extracted information. Click 'Edit' and 'Paste Special' from the top menu.
5. Choose 'Values' from the pop up box to paste the numerical values of the extracted cells. This choice will ignore the formulas that produce the values.
6. Choose 'Formulas' to copy the formulas for each cell. This will ignore the values of each cell, and produce new values when you insert new data into the cells that apply to the formulas.
7. Choose 'Formats' to copy shading, borders and other formatting features from cells and ignore the contents of the cells.

Read more ►

How to Create a Drop

1. Create the list of selections that you want listed in the drop-down box. Select a tab other than the one on which the drop-down box will appear. Type each selection in an individual cell. The cells in which the selections are listed should be sequential. For example, selections 'A,' 'B' and 'C' would be listed in cells A1, A2 and A3. A list of selections may also be created in the same tab on which the drop-down box will be created.
2. Select the cell in which you want to create the drop-down box. Click the 'Data' tab and locate the 'Data Tools' group. Select the 'Data Validation' option. This action will open a separate dialog window.
3. Click the 'Settings' tab on the Data Validation window. Select the 'List' option from the 'Allow' menu. Click the 'In-Cell Drop-Down' check box.
4. Click the 'Source' field. Click the tab that contains the list of options you created in Step 1. Click once in the first cell of the selection string and drag to the last cell while holding down the mouse button. Click the 'OK' button on the Data Validation window.

Read more ►

How to Sort a Table in Word 2003

1. Open Microsoft Word 2003.
2. Create a table or modify an existing table. It should contain several columns with every cell filled.
3. Place your cursor inside the table and left-click anywhere on it.
4. Click 'Table,' and then 'Sort.' You may have to click the arrow to expand your options.
5. Choose a column heading to sort in the drop-down menu under 'Sort.'
6. Choose a type. 'Text' is for sorting alphabetically. With 'Number,' you sort by value. 'Date' lets you sort chronologically.
7. Choose ascending or descending. Ascending will arrange text from A to Z, numbers from least to greatest, and dates from earliest to latest. Descending does the opposite.
8. Choose 'Using,' and then select which fields or words you want to sort by.
9. Repeat steps 5 through 8 for 'Then by.' Do this if you only want to include more than one column as a basis for sorting.
10. Indicate whether you have a header column. Select 'Header row' to exclude the first row in sorting.

Read more ►

How to Switch to Manual Calculation in Excel

1. Open Microsoft Excel and start a new blank workbook or open an existing workbook from your files.
2. Choose the 'Formulas' tab to display the 'Formulas' ribbon at the top of the screen.
3. Click the 'Calculation Options' button in the 'Calculation' section of the 'Formulas' ribbon to view the drop-down list of options. Choose 'Manual' from the list of options to switch to manual calculation. This will tell Excel that you want to switch from automatic calculation to manual calculation.
4. Enter your formulas into your Excel workbook as usual. When you press the 'Enter' key after typing a formula, it will no longer automatically calculate your formula without you specifically instruction it to.
5. Select the 'Calculate Now' button in the 'Calculations' section of the 'Formulas' ribbon. Every formula that you have entered into the current Excel workbook will now be calculated.

Read more ►

How to Make a Calendar in Excel 2007

Add Calendar Control to Worksheet
1. Display the 'Developer' tab of the ribbon. Click the 'Office Button.' Click the 'Excel Options' button. Select the 'Show Developer Tab in the Ribbon' check box under 'Popular Options.' Click 'OK.'
2. Go to the 'Developer' tab. Click Insert and choose 'ActiveX Controls.'
3. Click 'More Controls' and select 'Calendar Control' in the 'More Controls' list. Click 'OK.' Excel inserts a calendar control in 'Design View,' which allows you to edit and customize the control.
4. Right-click the Calendar Control and click 'Calendar Object.' Select 'Properties' to open the 'Calendar Controls Properties' dialog box. Select options for the font, color and other aspects of the control. Click onto the worksheet when finished.
5. Click on the calendar control and click on the date you want to add to the worksheet. Excel automatically enters the date into the selected cell.
Make Printable Calendar from Template
6. Click the 'Office Button' and select 'New.'
7. Type 'calendar' into the 'Search Templates on Office Online' box. Press the 'Enter' key. A gallery of template options opens.
8. Select the calendar template you want to use. Click the 'Download' button. The calendar opens as a new Excel file.
9. Click inside of a date on the calendar to which you want to add a note or reminder. Type directly into the empty space on that date. Go to the 'Page Layout' tab. Click 'Themes.' Click the 'Colors' drop-down arrow to select a different color scheme. Select 'Fonts' to change the fonts on the calendar.
10. Click the 'Save' button on the 'Quick Access Toolbar,' enter a name for the calendar and click 'Save.' Print the calendar if desired.

Read more ►