How to Make the Cursor Stop Highlighting

1. Launch the Microsoft Excel project in which you wish to stop the cursor highlighting.
2. Select a single cell with your cursor. The cursor highlights a range of cells only if extended-selection mode is turned on.
3. Turn extended-selection mode off by pressing the 'F8' key.
4. Select a single cell with your cursor. The cursor will highlight only the individual cell. Extended-selection mode has been turned off.
5. Restart your system if the problem persists.

Read more ►

How to Combine Worksheets Inside an Excel Spreadsheet

1. In Excel 2007, click on the 'Data' tab and choose 'Consolidate' from the Data Tools group. For earlier versions of Excel (97-2003), click on 'Data->Consolidate.'
2. Define the reference ranges using the Reference box. Specify the first range you want to consolidate.
3. Click 'Add.' The reference you defined in Step 2 will appear in All References.
4. Repeat Steps 2 and 3 until you have defined everything you want to consolidate. Then click 'OK.'

Read more ►

How to Make a Map Using Excel

1. Create the information you want to appear on the map, such as statistics for a region. Enter the name of the place (such as city, state, or country) in column A and the number or statistic in column B.
2. Once you have your data for your map, click File and Save. Highlight and select all your data rows and columns by holding the left button down and dragging it until all your data is selected.
3. Go to the top of the screen and use your mouse to click Insert, followed by Map. Move your cursor (which will no longer flash now) and move it the part of the Excel page where you want your map to be.
4. Holding down the left mouse button, drag your cursor across the Excel page to show how large you want the map. You will need to start from the top left corner of your desired map area and drag it down to the bottom right.
5. Wait for Microsoft Excel to display a pop-up menu, listing the maps available. Read through the list, select the one you want, and click OK.
6. Excel will then find boundary names to match the data you entered (such as the region, city or state). If it cannot automatically find the information you are looking for, a pop-up menu labeled Resolve Unknown Geographic Data will appear with other name options; choose one and click Change or select Discard if you cannot find a match.
7. Microsoft Excel will then generate a map based on statistics and data you entered. Look it over to make sure all the statistics and names are correct; if not, go back to your saved data, fix it and re-save.

Read more ►

How to Remove Scroll Bars in Pages

1. Open the document or spreadsheet from which you would like to remove the scroll bars.
2.
Select 'Tools' from the toolbar menu. Next, choose 'Options,' then click on the 'View' tab.
3. Uncheck the boxes next to 'Horizontal Scroll Bar' and 'Vertical Scroll Bar.' Then click 'OK.' (These options are in the 'Show' area under the 'View' tab in Microsoft Word; they are located in the 'Window Options' area under the 'View' tab in Microsoft Excel.)
4. To show the scroll bars again, repeat steps 1 and 2. Next, place checks in the boxes next to 'Horizontal Scroll Bar' and 'Vertical Scroll Bar.' Click 'OK' when finished.

Read more ►

How to Calculate Percentages in Excel

1. Type the amount in a cell. For example, a student received a score of 48 out of 60 on a test and wants to find his percentage. The student would type 48 in cell A1.
2. Type the total in an adjacent cell. In the example, the student would type 60 in cell B1.
3. Type '=amount cell/total cell' in an adjacent cell to the total cell. Replace amount cell and total cell with the cell addresses of the amount and total. In our example, the student would type, '=A1/B1' in cell C1. The total will display 0.8 in cell C1.
4. Highlight the cell with the decimal, and click '%' button under the 'Home' tab to convert the decimal to a percentage.

Read more ►

How to Create Macros in Excel 2003

1. Open the Microsoft Excel 2003 application on your computer. Click on the 'Tools' option from the top toolbar menu and then click on the 'Options' button.
2. Click on the 'Security' tab and then click on the 'Marco Security' option. Click on the 'Security Level' tab and choose either the 'Medium' or 'Low' option.
3. Click on the 'Tools' option and then scroll over the 'Marco' option. Click on the 'Record New Macro' button.
4. Enter a name for your macro in the 'Macro name' box. The first character in the name must be a letter and not a number.
5. Choose where you want to store the macro on your computer from the 'Store macro in' box. Enter a description for your macro in the 'Description' box. Click on the 'OK' button.
6. Perform the task that you want for your macro within the Excel spreadsheet, and then click on the 'Stop Recording' button when you're finished. For example, you can select a cell, press the 'Enter' key and then select the 'yellow' highlight color from the toolbar. Now, every time you press the 'Enter' key in a cell it will be highlighted in yellow.

Read more ►

How to Merge Sheets in Excel 2007

1. Click the Windows 'Start' button. Type 'excel' in the search text box. Press 'Enter' to open the Excel software.
2. Press 'Ctrl' and 'O.' In the dialog window that opens, double-click the XLSX file that contains multiple sheets you want to combine.
3. Click the 'DigDB' menu item at the top, then click the 'Table' sub-menu item, then click 'Append Tables in this File.' A configuration window opens.
4. Click each sheet you want to combine, and click the 'Add' button. If you want to combine all sheets together, select 'All Sheets,' and then click 'Add.'
5. Click 'OK' to combine the spreadsheets. Notice the original, first spreadsheet has all the combined data. Press 'Ctrl' and 'S' to save the changes.

Read more ►

How to Convert Date to Day of Week in Excel

Convert Replace Date with Day of Week
1. Open the Excel workbook in which you want to convert and replace the date data with day-of-week data. If this workbook is not available, open up a new file for practice. If using a practice workbook, enter sample date data in mm/dd/yyyy format.
2. Left click with the mouse to select the column or row that contains the range of date data.
3. Select 'Format' from the menu.
4. Select 'Cells' from the drop-down list.
5. Select the 'Number' tab on the 'Format Cells' pop-up window.
6. Select 'Custom' in the 'Category' list.
7. Enter 'dddd' in the 'Type' field to display the date as day-of-week, with the day entirely spelled out (Monday, for instance).Enter 'ddd' in the 'Type' field to display the date as day-of-week, with the day abbreviated to standard three-letter abbreviation (Mon, for instance).
Convert Date to Day of Week, Without Replacing Initial Data
8. Open the Excel workbook in which you want to convert and replace the date data with day-of-the-week data. If this workbook is not available, open up a new file for practice. If using a practice workbook, enter sample date data in mm/dd/yyyy format. This article will presume that the date data is located in column 'A,' with the header 'Date' in cell 'A1.'
9. Determine where you want the day-of-week data located. Label that column header with DOW (cell 'B1,' for example).
10. In 'B2,' enter the formula '=TEXT(A2,'dddd')' to display the date as day-of-week, with the day entirely spelled out (Monday, for instance).
Or, you can enter the formula '=TEXT(A2,'ddd')' to display the date as day-of-week, with the day abbreviated to standard three-letter abbreviation (Mon, for instance).
Press 'Enter' to move the cell cursor out of cell 'B2'.
This is with the understanding that cell 'A1' contains the label 'Date' and cell 'B1' contains the label 'Day of Week' and that the first date is located in cell 'A2' and the first cell to be populated with the day of the week is cell 'B2'. If your workbook is set up differently, adjust the location of the formula to the desired location of the day-of-week data and adjust the formula accordingly to refer to the correct cell.
11. Return the cell cursor to cell 'B2'. Select 'Edit' from the menu.
Select 'Copy' from the drop-down list.
12. With the cell cursor, select the entire range where you want the day-of-week data. Select 'Edit' from the menu, and select 'Paste' from the drop-down list; this will paste the formula that you entered in cell 'B2' through the entire range of cells.

Read more ►

How to Import Excel Spreadsheets Into Access

1. Save your spreadsheet data in Excel using the 'File,' 'Save' menu. Although Access recognizes a range of alternate formats, including dBASE and text delimited, it is best to use the native Excel format for your saved file. Access is configured to import Excel files directly and provides options for continuing to work with the data in both products after the import process.
2. Start Microsoft Access and open the database into which you want to import your Excel data. You can create a new, empty database in Access by clicking 'File,' 'New' and selecting the 'Blank Database' option. Provide a name for the file when prompted. Click 'File,' 'Get External Data,' 'Import' and select the Excel format. Locate your spreadsheet subdirectory and import your spreadsheet into Microsoft Access. If you are using Microsoft Access version 7, you can also click the 'External Data' tab at the top of your screen and select 'Excel' as the format to import the spreadsheet data. You can append the data to an existing table or create a new table for your Excel spreadsheet data.
3. Select the worksheet or range you want to import from the Import wizard and click 'Next.' Select the Excel column headings you want to import as field names and verify that you want to create a new table or append data to an existing table. Click 'Next' to continue. You can change field names, skip fields that you do not want to import and select indexing options, including a primary key for sorting your spreadsheet data in Access. Click 'Finish' when you are satisfied with your selections.
4. Review the Table Analyzer wizard results to verify the structure of the database tables that Access has created from your Excel worksheet. The wizard will divide tables containing duplicate information into separate tables so that each category of data is stored only once. Verify field placement within tables, select the primary key used for sorting and correct any typographical errors prior to completing the import process.

Read more ►

How to Add Multiple Sheets to a Workbook in Excel 2007

1. Open Excel 2007. At the bottom of the page, there are tabs you can use to select which sheet you want to view. These tabs are labeled 'Sheet 1,' 'Sheet 2,' and so on.
2. Right-click over one of the sheet tabs to insert a sheet. Click 'Insert,' select 'Worksheet,' and click 'OK.' Look down at the tabs to verify that a sheet was inserted. Repeat this to insert multiple sheets.
3. Hold down the 'Shift' key. Drag your mouse over the spreadsheet tabs to highlight the number of sheets you want to insert. You can insert multiple sheets by highlighting more than one tab.
4. Click 'Insert,' select 'Worksheet,' and click 'OK.' Look down at the tabs to verify that the extra sheets were inserted.

Read more ►

How to Create Forms in Excel 2007

1. Open an Excel 2007 spreadsheet. Type in column headers in the top row for each column you will enter data under.
2. Click and drag the mouse over the column headers only to select them. Do not highlight any other columns or select the entire row, including the blank cells to the right of the column headers or else Excel will not know which columns to use to create the form.
3. Click on the arrow button beside the Quick Access Toolbar at the top of the screen, then click 'More Commands' from the drop-down list that appears.
4. Click the 'Choose commands from' drop-down menu and click 'All Commands.' Scroll down the list and then double-click the 'Form' button. Click 'OK' to close the Excel Options dialog box.
5. Click the 'Form' button that you just added to the Quick Access Toolbar. Excel creates a form with the column headers that you may use to add new records to the spreadsheet.

Read more ►

How to Show Formulas in Excel 2003

1. Click on the square in the upper-left corner of the Excel 2003 spreadsheet to select all cells.
2. Press and hold the 'Ctrl' key on your keyboard after all the spreadsheet cells are selected.
3. Press '`,' the grave accent key, located in the upper-left hand corner of your keyboard below 'Esc.'
4. Release both buttons.

Read more ►

Step

1. Start Microsoft Excel. Double click on the Desktop icon and Excel will open with a blank spreadsheet. If you cannot locate the Desktop icon, click on the 'Start' or 'Microsoft' button, and then click on 'All Programs.' Click on 'Microsoft Office,' and then click on 'Microsoft Excel.'
2. Click on cell 'A1' and enter a name for the column. For example, if you are making a budget, then you might type 'Income.' Data in Excel are entered in columns for easy formatting and insertion of formulas and functions.
3. Enter your other column headings in row 1. In the budget sheet example, click on cell 'B1' and then type 'Amount,' then click on cell 'C1' and type 'Expenses' and then click on cell 'D1' and type 'Amount.' If you have other column heading you want to enter, click on cell 'E1' and continue working right through the worksheet.
4. Enter the data into your columns. Click on cell 'A2' and type your first item. In the budget example, this could be 'Mortgage.' Press the 'Right arrow' key to move the cursor to cell 'B2' and then type the corresponding amount. If your mortgage is '$1,000' then type '$1,000' into cell 'B2.'
5. Add up the numbers in a column by using 'Autosum.' Highlight all of the data in a column that you want to add, click the 'Home' tab and then 'Autosum' to add up the entire column. To highlight data in a column, left click on the top left of the first item and then drag the cursor to the bottom right of the column. You can also click on the column identifier to highlight the entire column. The column identifier is the number or letter at the very top of the column.
6. Format your cells by highlighting them, and then clicking on 'Format Cells.' The pop up window gives you a myriad of choices to align cells, choose borders and fill, and select the type of data you want in cells. In the budget example, you may want to make sure all of your entries are in dollars. Click on the 'Number' tab, click on 'Currency' and then choose the type of currency you would like to have by clicking on the down arrow next to 'Currency.'

Read more ►

How to Fix Broken Links in Excel 2007

1. Close all the workbooks that are open.
2. Open the workbook with the broken link.
3. Click 'Options' on the trust bar, and then click 'Enable this Content.'

Read more ►

How to Convert Date to String in Excel

1. Open Microsoft Excel, then open the document where you want to convert a date to string.
2. Type '=TEXT(' in the cell where you want to place the string.
3. Click on the cell with the date. This should put the cell reference (like A1) in the initial cell.
4. Type 0, 'MM/DD/YYYY') after the cell reference. Exchange 'MM/DD/YYYY' with the format of your date. In this case MM is the month, DD is the date, and YYYY is the year. Press enter and the cell should have a text (string) version of the date.

Read more ►