How to Open Excel 2003 in Safe Mode

1. Locate the icon for opening Excel 2003 by clicking the 'Start' button and selecting 'All Programs,' then 'Microsoft Office,' then 'Microsoft Office Excel 2003.' Don't click the icon yet.
2. Hold down the 'Control' key on your keyboard while you left-click 'Microsoft Office Excel 2003.' You should click the left mouse button normally, but continue to hold down the 'Control' key until you see a Windows message prompt.
3. Select 'Yes' when Windows prompts you for confirmation of running Excel in safe mode. Excel will open after you click 'Yes.'

Read more ►

How to Make a Combo Box in Excel 2003

1. Open Excel on your computer, and open a new spreadsheet. Somewhere in the spreadsheet, enter the data that will appear in the combo box. For example, you might enter data between cells C4 to C10.
2. Go to the 'Forms' toolbar, and select 'Combo Box.'
3. Drag your mouse over the cells that you want the combo box to encompass. Once you release your mouse click, the combo box will appear.
4. Right-click on the new combo box,, and choose 'Format Control' from the menu. Specify the cell range of your data in the 'Input Range' field; in the above example, you would enter C4:C10, because those are the cells that hold your data.
5. Go to the 'Cell Link Box,' and enter the number of the cell where you want the index value of items selected in the combo box to appear. Click 'OK.'

Read more ►

How to Execute a Macro in Excel 2003

1. Open Excel 2003 and select the workbook that will use the macro. Click 'File' on the menu bar and select 'Open.' Browse your files and locate the workbook. Click the workbook and select 'Open.'
2. Click 'Tools' on the menu bar and select 'Macro.' Select 'Macros.' Select your macro from the list of available macros.
3. Click 'Run.' The macro is executed on the workbook.

Read more ►

How to Calculate the Percent of a Quarter Passed in Excel

1. Open a new Microsoft Excel spreadsheet.
2. Click on cell 'A1' and enter the first day of the quarter. Then click on cell 'A2' and enter the last day of the quarter. Finally, click on cell 'A3' and enter in the date with which you want to determine the percentage of the quarter passed.
3. Click cell 'B1' and enter in the following:=A3-A1This will tell you how many days into the quarter you are. Click cell 'B2' and enter the following:=A2-A1This will tell you how many total days there are in the quarter.
4. Click on cell 'B3' and enter the following:=B1/B2This will give you your percentage in decimal form. Right-click the cell and choose 'Format cells.' Select 'Percentage' from the list on the left side and click 'OK.' Your result will now display as a percentage.

Read more ►

How to Make the Lines Print When Working With Excel 2003

1. Open the spreadsheet you're working on in Excel 2003 and highlight the cells you want to print.
2. Go to the 'Formatting' toolbar and click the arrow beside the 'Borders' button to expand it. Select 'All Borders' from the list. If the 'Borders' button is not visible in the 'Formatting' toolbar, click the 'Toolbar Options' arrow at the end of the toolbar to expand it. Choose 'Add or Remove Buttons,' 'Formatting' and 'Borders.' Alternatively, you can select 'Format' and 'Cells' from the menu to open the 'Format Cells' dialog box. Select the 'Border' tab and click 'Inside' from 'Presets.' Select the single, solid line style from the 'Line' section. Go to the 'Border' section and click the top, middle, left and right borders. The thumbnail in the dialog box now shows borders around and between the selected cells. Click 'OK' to apply them.
3. Click the 'Print Preview' button in the 'Standard' toolbar. The border lines are displayed in print preview, signifying how the spreadsheet will look when it's printed.
4. Click the 'Print' button at the top of the window. The 'Print' dialog box opens. Choose 'Selection' in the 'Print what' section and click 'OK.'

Read more ►

How to Set Page Break Views in Microsoft Excel 2003

1. Create a page break. To create a page break, left-click on the cell rows that you wish for a page break to occur by clicking on the corresponding row number to the left; the entire row will become highlighted when you left-click on the row number.
2. Access the “View” menu. Scroll to the “File” tab on the command bar and then select “Page Break Preview.”
3. Use the page break preview menu. Once inside of the page break preview menu, you will be able to see where page break occurs on the spreadsheet, because it will have a double grey line highlighting it.
4. Adjust where page breaks are located. To adjust page breaks, simply left-click on the grey page break link and hold the mouse button in as you drag the page break where desired.

Read more ►

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 ►