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 ►

How to Convert Text to Upper Case in Excel 2007

1. Convert text in a cell, say cell A1, into fully capitalized text in another cell, say B1, with the UPPER function. For example, type in B1 the following: =UPPER(A1). You can even copy the contents of B1 into A1 by right-clicking the mouse on B1, selecting Copy, then right-clicking A1, and selecting “Paste Special” and “Value.” (If you insert the formula instead, the reference will be circular and you’ll get an error.)
2. Convert the returned value of a formula using the following syntax: =UPPER(function). For example, if the original function in a cell is =IF(A1>B1,C1D1,A1), then change the cell contents to =UPPER(IF(A1>B1,C1D1,A1)).
3. Perform this capitalization conversion on more than one cell at once as follows. For a row of text, say A1 to A100, type in an empty cell, say B1, the following: =UPPER(A1). Highlight B2 to B100. Click 'Home.' Click 'Fill.' Click 'Down.' The B-column cells now range in contents from =UPPER(A1) to =UPPER(A100). Now just perform a special paste of the column as for the single cell in Step 1.

Read more ►

How to Make a Cell Reference Absolute in Excel

1. Start Microsoft Excel 2007 and open an existing workbook from your files or start a new blank workbook.
2. Click to select the cell where you would like to enter a formula where the cell reference is absolute.
3. Begin typing the formula into the cell. Type a dollar sign right before the column reference in the formula to make it absolute. For instance, you may type '$A1' into a formula. This means that wherever you copy and paste this formula, Excel will always keep the reference in column A.
4. Type a dollar sign right before the row number to make the row number absolute. For example, you can type 'A$2' inside of a formula. This means that the cell reference will always refer to the second row, no matter where you copy and paste the formula.
5. Use dollar signs before both the column letter and cell number to make the entire cell reference absolute. If you type, '$A$2' inside of a formula than that formula will always refer to cell 'A2.'
6. Continue typing the rest of your formula. You can include dollar signs into other cell references inside your formula if you need to.
7. Press the 'Enter' key on your keyboard to enter the formula into Microsoft Excel and view your calculation result.

Read more ►