Excel
Pages - Menu
(Move to ...)
Home
▼
Friday, June 28, 2013
How to Use a Fill Handle for Numbers in Excel 2003
›
1. Open Excel 2003 and click in cell A1. Type '1' in cell A1 and '2' in cell A2. Highlight these two cells. 2. Notice ...
Thursday, June 27, 2013
How to Delete a Named Range in Excel 2007
›
1. Open your Excel file. 2. Click 'Formulas.' 3. Select 'Name Manager.' 4. Highlight the named range. 5. Press ...
How to Make a Decision Tree in Excel
›
1. Draw a square in a blank Excel worksheet. In Excel 2007, click 'Insert,' then 'Shapes' and then click on a square. In E...
How to Upgrade From Excel 2003 to 2010
›
Office 2010 Installation 1. Place the Office 2010 installation disc into your computer or download Office 2010 from the Microsoft website....
How to Transfer Excel VB Data From Range to Array
›
1. Click the “View” tab on the 'Ribbon' menu. Click the “Macros” icon to display the “Macro” dialog. 2. Select an existing macro...
How to Format Drop
›
1. Open Excel 2010 and select a workbook that will contain the drop-down list. Click the 'File' tab and select 'Open.' Bro...
Wednesday, June 26, 2013
How to Hide Worksheets in Excel 2007
›
1. Select the worksheets you want to hide. Click the worksheet tab, such as Sheet1 or Sheet2 to select one sheet. To select at two or more...
How to Make an Invoice in Excel 2007
›
1. Click the round 'Office' button in the top left of the Excel worksheet. A drop down will appear with a list of icons on the lef...
How to Calculate the Percentage Change From the Previous Year in Excel
›
1. Enter previous and current year information in columns side by side. Give the column headings to indicate the first is the current yea...
How to Create Labels in Microsoft Office 2007 From Excel 2007
›
1. Open a new Excel spreadsheet. Type 'Last Name' into Cell A1. Move right across the first row of cells labeling each new cell wi...
Tuesday, June 25, 2013
How Can I Overlay Graphs?
›
1. Open the Excel worksheet that contains the data series. 2. Click and drag the cursor on the range of cells that will convert to a cha...
How to Fix a Faded MS Office Menu
›
1. Click 'Save' on your document. Sometimes this is all that is needed to move your cursor from a place (such as editing a cell in...
How to Add Borders to Multiple Cells in Microsoft Excel 2003
›
1. Select the cells to which you wish to add a border. Left-click on one cell, then hold and drag the cursor across the entire group of ce...
Monday, June 24, 2013
How to View or Hide the Toolbar in Excel 2007
›
View or Hide 1. Open Excel 2007. You will notice three distinct parts of the Excel 2007 window: The spreadsheet, the formula bar and the t...
How to Disable the Security Warning in Excel 2007 Macro
›
1. Open Excel 2007 and click the 'Office' button. Click 'Open.' Browse the files and locate the workbook. Click the workbo...
‹
›
Home
View web version