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 the fill handle in the lower right hand corner of these highlighted cells. Point to the fill handle. Your mouse will become a thin black ' .' This is your indicator that the fill handle can be dragged to fill in the sequence.3. Drag the fill handle down a few cells. Notice the rest of the sequence is automatically populated in the cel...
Browse » Home » All posts
Friday, June 28, 2013
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 'Delet...
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 Excel 2003, click on the 'Rectangle' autoshape button on the drawing toolbar and drag the square to your worksheet.2. Right-click on the square and click 'Add text.' Type the major decision into the box. For example, you might be deciding whether to save or spend a recent windfall, so write 'Save or Spend' in the box.3. Select a 'Line' shape from the toolbar. Click on the right edge of the square and drag the line to a length of an inch or two (you can change the lengths...
How to Upgrade From Excel 2003 to 2010
Office 2010 Installation1. Place the Office 2010 installation disc into your computer or download Office 2010 from the Microsoft website.2. Follow the prompts to initiate the installation of Office 2010. If you have downloaded a version of the software, you may be prompted to unzip the files. For CDs, you will have to enter a product key, which can be found on your CD case.3. Click 'Customize' in the 'Choose the installation you want' dialog box.4. Right click and then click 'Not available' for all programs except for Excel 2010.5. Click 'Install now' to install Excel 2010.Excel 2010...
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 name in the list box if you want to add the ability to copy data from a range of cells to an array. Click “Edit” to open the Visual Basic editor. If you want to write a new macro, type the name into the “Macro name” text box and click “Create.'3. Declare an array variable as a 'Variant' data type. The following example declares the array 'RangeArray':Dim RangeArray As Variant4. Assign the data cell range to the array. Continuing the example, assign the cells A1...
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.' Browse your files and select the workbook. Click the 'Open' button. The workbook opens.2. Highlight the range of cells where the drop-down list will be displayed. Select the 'Data' tab, then select 'Data Validation.' The Data Validation dialog box appears.3. Click the 'Settings' tab. Change the 'Allow' drop-down list to 'List.' In the 'Source' drop-down box, type 'Yes,No,Maybe.'4. Click the 'Input Message' tab. The input message will appear as the user uses the drop-down...
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 adjacent sheets, click the first tab then hold the 'Shift' key and click the last tab. To select more than one nonadjacent sheets, click the first tab then hold the 'Control' key and click the other tabs you want to hide. To select all sheets, right-click any sheet tab then choose 'Select All Sheets' on the shortcut menu.2. Click 'Format' in the Cells group located on the Home tab above the worksheets.3. Select 'Hide and Unhide' under Visibility and click...
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 left and a list of 'Recent Documents' on the right.2. Click 'New,' the first icon at the top of the list on the left of the drop down. A new screen will pop up automatically defaulting to 'Blank and recent' in the box on the left of the screen and 'Blank Workbook' at the top of the middle box.3. Click 'Invoices' in the box on the left of the screen under the header 'Microsoft Office Online.' The middle screen will change to show thumbnails of various invoice designs.4....
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 year information and the second is the prior year information.2. Name the next column 'Percent Change,' and click on the first row in that column that has data in the fields for current and previous years.3. Enter the following formula into the cell; '=(cell with current year info)-(cell with prior year info)/(cell with prior year info).' For example, if the first row to have data in it is Row 6, the current year information is in Column C, the prior year...
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 with the information you need in order, such as 'First Name,' 'Title,' 'Address,' 'City' and 'Zip Code.'2. Type in the relevant information for each mailing label you need on the column below the row heading. For example, type in the last name for each contact underneath the 'Last Name' column.3. Highlight the entire section of columns and rows with the mailing label information, including the top row headers. Navigate to the 'Formulas' tab and click 'Define Name.'...
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 chart.3. Select the “Insert” tab on the command ribbon.4. Click the arrow in the lower-right corner of the “Charts” group to launch the dialog box. The “Insert Chart” dialog box opens with a gallery of sample charts.5. Select a 2-D chart. For example, choose the bar, column or line.6. Click “OK.” The worksheet data converts to an embedded chart. The “Chart Tools” ribbon appears.7. Click one data series in the chart’s plot area.8. Click the “Design”...
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 Excel) that blocks certain menu commands. If 'Save' is one of the faded items, click anywhere in the document to move your cursor from its current position.2. Examine the title bar at the top of your Office program window. This will tell you the title of the document as well as the program and other information. If the title bar contains the words 'Read Only,' you can save the file under a different name to allow access to the toolbar items. In this case, click...
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 cells to highlight them. When you release the mouse button, all the cells will stay highlighted.2. Right-click on the group of highlighted cells to access the Cell Properties menu. Select “Format Cells” to access the border menu. Then scroll to the “Border” tab to change the border.3. Under the “Border” tab, you can select a premade border under “Presets.” Or you can devise a custom shape and size for the border by clicking on the different border shapes...
Monday, June 24, 2013
How to View or Hide the Toolbar in Excel 2007
View or Hide1. Open Excel 2007. You will notice three distinct parts of the Excel 2007 window: The spreadsheet, the formula bar and the toolbar. The toolbar includes seven different tabs: Home, insert, page layout, formulas, data, review and view. The traditional functions such as file, save, save as and print are under the Office button in the upper left corner.2. View the toolbar located near the top of the screen. This will be your default option. On Excel 2007, the toolbar is referred to as the ribbon. Rather than just a list of headings with drop down menus, Excel 2007 toolbar has a visual...
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 workbook and the 'Open' button.2. Notice the security warning across the top of the Excel workbook. Click the right 'Options' button on the security button.3. Select 'Enable Content.' Click 'Ok.' The security warning is disabled and the macros are functional in the workbo...
Subscribe to:
Posts (Atom)