Excel
Pages - Menu
(Move to ...)
Home
▼
Tuesday, February 28, 2012
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...
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...
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 stud...
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 clic...
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...
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 ...
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 form...
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 ...
Monday, February 27, 2012
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 th...
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' ...
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 ...
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 ...
Sunday, February 26, 2012
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 y...
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...
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 w...
‹
›
Home
View web version