Sunday, June 16, 2013

How to Make Excel 2003 the Default


1. Click 'Start' and type 'regedit' in the Windows search box. Click 'regedit.exe' from the list of files that appears.
2. Locate the 'HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options' key and right-click on the 'Options' folder. Click 'New' and 'DWORD Value' and enter 'NoReReg' for the Dword Value. Right-click on the 'NoReReg' value that you created and click 'Modify.' Type '1' in the 'Value Date' box and click 'OK.'
3. Open Excel 2003 and select 'Detect and Repair' from the 'Help' menu. Click 'Start' and click 'OK' when the process finishes.
Read more ►

How to Delete Cells in Microsoft Excel


1. Select the cell or range of cells you want to delete. To select multiple cells, click in the first cell and drag down or over to the last cell.
2. Go to the 'Edit' menu and choose 'Delete.' A dialog box pops up.
3. Decide how you want your data moved to fill the space of the deleted cells. Choose 'Shift cells left' to have the data in the rows with the deleted cells slide over. Choose 'Shift cells up' to have the data in the columns with the deleted cells move up. All formulas will adjust accordingly.
4. Delete an entire row or column in Excel by choosing 'Entire row' or 'Entire column.' All data under a deleted row shifts up and all data to the right of a deleted column shifts to the left.
5. Click 'OK' to confirm to Excel you want to delete the cells.
6. Clear the contents of a cell without removing the actual cell by selecting the cells you want cleared and pressing 'Delete' on your keyboard. The data is removed from the cell, but all formatting remains. To clear formulas or comments from the cells, choose 'Clear' from the 'Edit' menu and then click what you want cleared.
Read more ►

How to Combine a Graph


1. Open the Excel Program.
2. Click the 'File' tab on the command ribbon. A list of commands appears.
3. Click 'Open.' Select the workbook to open.
4. Click the 'Insert' tab on the command ribbon.
5. Click and drag on the categories and data cells for the chart.
6. Click the arrow next to the chart style in the 'Chart' group.
7. Click to select the preferred chart type, for example, '2-D Column.' The data converts to an embedded chart. The 'Chart Tools' ribbon appears with three tabs: 'Design,' 'Layout' and 'Format.'
8. Click the 'Design' tab on the 'Chart Tools' ribbon.
9. Click one data series on the chart to display as a different chart type. For example, one color column. If no data series is selected, the whole chart will change.
10. Click the 'Change Chart Type' button in the 'Type' group. The 'Change Chart Type' dialog window opens with a gallery of charts.
11. Click a different chart type. For example, 'Line.'
12. Click 'OK.' The selected data series converts to the new chart type. Two different chart types appear on the screen.
13. Edit the combined chart, if preferred. To bring a data series closer to the other data series, right-click one data series. A list of options appears. Click 'Format Data Series.' A 'Format Data Series' dialog window opens. Select the radio button for 'Secondary Axis.' Click 'Close.' The chart converts.
Read more ►

Saturday, June 15, 2013

How to Create a Multiple Stacked Chart in Excel 2003


1. Open your Microsoft Excel spreadsheet filled with your data sets.
2. Click your cursor on the 'A1' cell. Hit the 'Control' ('Ctrl') button and then press the 'A' key without letting go of the 'Control' button. You will see the cells where you have typed your data become highlighted. Keep in mind that you need at least two sets of data to create a stacked column chart.
3. Click 'Insert' on your toolbar.
4. Click Column. Select one of the 'stacked' column styles. You can choose, for example, a cylindrical stacked column or a conical stacked column. Excel will turn your data into a chart, and that chart will appear on your screen.
Read more ►

How to Create a Combination Chart in MS Excel


1. Open a blank worksheet in Microsoft Excel.
2. Create a data table. For instance, enter time values in column A, such as the months of the year. In column B, enter a column heading for your first data series, such as number of items sold, followed by the data values. Enter a second data series in column C, such as average price, with each data value lining up with a value in column A.
3. Highlight all of the data you want to plot in a chart, including both data series.
4. Click the 'Insert' tab. In the 'Charts' group, select the chart type you want to use for the first data series. For instance, to create a basic column chart, click 'Column' and select a '2D Clustered Column Chart.' The chart will appear on the worksheet with the data values you entered.
5. Click the data series on the chart that you want to make into a different chart type. Make sure only one data series is selected.
6. Click the 'Design' tab. In the 'Type' group, click 'Change Chart Type.' Choose the chart type you want. For instance, to change the series to a line graph, select 'Line with Markers' in the 'Line' group. Click 'OK.'
7. Change the second data series to have a secondary vertical axis. To do so, select the data series in the chart. Click the 'Layout' tab. In 'Current Selection,' select 'Format Selection.' Click 'Series Options' in the dialog box. Click 'Secondary Axis' under 'Plot Series On.' Click 'Close.'
8. Add labels to the vertical axes by clicking the 'Layout' tab. In the 'Labels' group, click 'Axis Titles.' Select 'Primary Vertical Axis' and choose a title option. Do the same for 'Secondary Vertical Axis.' Click each axis in the chart and enter a new title.
9. Select the chart by clicking the bounding box around it. Browse through the 'Design, Layout and Format' tabs. You can make changes to the chart style, outline and layout, as well as format specific chart elements.
10. Click the 'Microsoft Office Button' and choose 'Save as' to save the combination chart and data.
Read more ►

How to Make a Line Graph in Microsoft Excel


1. Arrange the data in either rows or columns. Excel makes the decision as to how to best graph the line based on the data input you provide. You need at least two sets of data to create the axes for your chart. For example, build a line graph using one row or column that provides time periods, such as months or quarters, and the other row or column listing gross sales.
2. Select the data in the rows or columns to include in the line chart. Click and drag your mouse across the data in the Excel spreadsheet to include it.
3. Click the Insert tab and review the available types of Chart. Select 'Line' from the options offered.
4. Review the embedded chart in your spreadsheet. To move the chart to its own sheet, select it. The Chart Tools display, which adds several tabs, including Design, Format and Layout. From the Design tab, click 'Move Chart,' which resides in the Location group. Select 'New sheet' from the 'Choose where you want the chart to be placed' options.
5. Modify the title, which defaults to 'Chart1' by selecting the Layout tab. In the Properties group, click the 'Chart Name.' Enter the name and press the 'Enter' key.
6. Modify the layout by using a pre-determined format from Excel. Select the line chart. The Chart Tools become available. Select from among the options available in the Chart Layouts group from the Design tab.
7. Add titles to the axis. Click the chart to active the Chart Tools. From the Layout tab, review the Labels group. Select 'Axis Titles,' and enter the axis name for the primary horizontal and vertical axes.
Read more ►

How to Delete a Macro in Excel


1. Start Microsoft Excel 2007, and open a spreadsheet from your files that contains at least one macro that you want to delete.
2. Select the 'Developer' tab from the top of the Excel screen. The 'Developer' ribbon will be displayed just under the tab.
3. Find the 'Code' group in the 'Developer' ribbon and click the 'Macros' button. The 'Macro' dialog box will open onto your Excel screen.
4. Choose the name of the macro you want to delete from the list that appears in the 'Macro' dialog box. The macro name will be highlighted in black once it is selected.
5. Click the 'Delete' button on the right side of the 'Macro' dialog box to instruct Excel to delete the selected macro. A dialog box will appear asking you if you are sure you want to delete the selected macro.
6. Choose the 'Yes' button to confirm that you want to delete the selected macro. The macro name will be deleted from the list in the 'Macro' dialog box and the dialog box will close.
7. Repeat the steps above to delete any additional macros from the open spreadsheet.
Read more ►

Friday, June 14, 2013

How Do I Exit From the Header in Office 2007 Windows Vista?


1. Look at the top of your Word program window and locate the text 'Header and Footer Tools.'
2. Under 'Header and Footer Tools,' click 'Design.' The 'Design button will be immediately below the words 'Header and Footer Tools.'
3. Click the red 'X' on the far right side of the Design menu that says 'Close Header and Footer,' under it.
Read more ►

How to Make a Second Line in One Cell in MS Office Excel on Mac


1. Position your cursor inside the cell at the exact place you want to create a new line, such as at the end of the first line.
2. Hold down the 'Option' and 'Command' keys on your keyboard.
3. Press 'Enter.' Release the 'Option' and 'Command' keys. You now have a new line.
Read more ►

How to Calculate a Year


1. Click on a blank cell where you want to enter your formula calculation and display the year-to-date average.
2. Begin your formula calculation by clicking the 'Average' function. You can find this formula in one of several places in different versions of Excel. In Excel 2010, it is easily accessible on the 'Auto Sum' menu, available on both the 'Home' tab and the 'Formulas' tab. Or you can always manually type in '=AVERAGE().'
3. Select the cells you want to use in the average. If they are all in the same row or column, click and drag your cursor across all of the cells you want. If they are not in the same row or column, click on them one by one while holding the 'CTRL' key on your keyboard. Also select the cells that you want to include as the year progresses and that do not have data in them yet. As soon as you enter the data, the program automatically includes it in the average. Be sure that these cells are blank, and do not display zeros or dashes; otherwise, the program calculates zeros into the average. Excel indicates which cells you have highlighted with colored lines as well as by displaying the cell numbers (such as 'A1, A2') in the cell where you are creating the formula.
4. Press the 'Enter' key on your keyboard to complete the formula. Excel calculates and displays the average in the cell where you put the formula calculation. Each time you enter data into the blank cells that you included in the formula, the running average changes accordingly.
Read more ►

How to Tab Over in Excel 2003


1. Launch Microsoft Excel 2003.
2. Click 'Tools' at the top of the window.
3. Click 'Options.'
4. Click the 'Transitions' tab at the top of the window.
5. Click the box to the left of 'Transition Navigation Keys' to remove the check mark, and then click 'OK.'
Read more ►

How to Change the Display of Axes in Excel


1. Start Microsoft Excel 2007 and open an existing workbook that contains a chart that you would like to change the display of the axes.
2. Click the chart that you want to change the display of the axes so it is selected. The chart will have a light blue border surrounding it, indicating that it is selected.
3. Choose the 'Axes' button in the 'Axes' section of the 'Layout' ribbon. A drop-down menu will appear.
4. Point to 'Primary Horizontal Axis' to view the options for changing the display of the primary horizontal axes. The display options for your primary horizontal axis will be displayed in a menu. Click on the title and description that you want to apply to your primary horizontal axis.
5. Select the 'Axes' button in the 'Layout' ribbon once again and point to 'Primary Vertical Axis.' Click on a title and description for the display option you want to apply your primary vertical access.
Read more ►

How to Import a Web Page to Excel 2007


Import Data from Web Page
1. Open both your Internet browser and Microsoft Excel 2007 program. Go to the web page that you want to import into Excel.
2. Go the Data tab on the user interface in Excel. In the 'Get External Data' command set, click 'From Web.' A 'New Web Query' box will appear on the screen.
3. Type in the web page that you want to import into Excel, if it does not automatically appear in the 'New Web Query' box. Select the 'Import' button. Excel will then give you the option to select the cell in which you want the web page information to be placed.
4. Select either Existing Worksheet or New Worksheet. If using an Existing Worksheet, choose the cell column and row. Press 'Okay' when complete. The information from the web page will then appear in the worksheet.
Copying and Pasting web page into Excel 2007
5. Copy the web page information by highlighting the information you want on the web page and pressing 'Control' and 'C' (Ctrl C) at the same time.
6. Go to Excel, select the cell in which you want the information to appear. Press 'Control' and 'V' (Ctrl V) at the same time to paste the information. You can also select 'Paste Special' in Excel by single right-clicking on your mouse. 'Paste Special' will give you the option to add the hyperlink or web page text to the Excel cell.
7. Click 'Okay.' The information will appear in the selected cell.
Export web page into Excel
8. Go to the web page that you want to import into Excel.
9. Right-click with your mouse and choose 'Export to Excel.' This will take you directly to Excel.
10. Select 'Import' on the 'New Web Query' box. The 'Import Data' box will appear.
11. Select the 'New or Existing Worksheet' and cell in which you want the data to appear. Click 'Okay.' The web page data will appear in Excel.
Read more ►

Thursday, June 13, 2013

How to Create a Visio Network Diagram From Excel Data


1. Start Visio and click on the 'File' tab. Click 'New' in the left pane and select 'Network.' Choose 'Detailed Network Diagram' and click 'Create.'
2. Drag a ring network shape or Ethernet shape from the 'Network and Peripherals' group onto the page. Drag the appropriate devices from the 'Computers and Monitors' or 'Network and Peripherals' section onto the page.
3. Connect the device shapes to the network shape. Click on the network or Ethernet shape and hover the mouse pointer over the yellow, diamond-shaped control handle. When the pointer changes to a four-way arrow, drag toward the first device to draw a connector. Repeat with the remaining devices.
4. Import Excel data into the diagram. Go to the 'Data' tab. Click on 'Link Data to Shapes' in the 'External Data' group. The Data Selector Wizard opens.
5. Select 'Microsoft Excel Workbook' as the type of data source you want to use and click 'Next.' Browse to the workbook you want to use and click 'Insert.' Complete the wizard.
6. Drag a row of the imported Excel data to a shape in the diagram to add it to the shape data. Repeat for the remaining shapes and information.
Read more ►

How to Open XLSM, XLSX, XLSB, XLTX, XLTM and XLAM Files in Excel 2003 and 2002


1. Go to the Microsoft Download Center (link in Resources) and select 'Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats,' located under the 'Popular downloads' heading. Click the 'Download' button on the right side of the ensuing page.
2. Click 'Run' if you are using Internet Explorer; click 'Open' if you are using Google Chrome; click 'Save File,' then double-click the downloaded file if you are using Mozilla Firefox.
3. Click 'Yes' if you are prompted by the User Account Control window. Read the license terms and select the 'Click Here to Accept the Microsoft Software License Terms' check box if you agree to the terms and wish to continue with the installation. Click the 'Continue' button.
4. Close Excel and any other Microsoft Office programs that are currently running after installation is complete, then open Excel to enable the Compatibility Pack. You can now open, edit and save all Excel 2007 or 2010 file formats in your edition of Excel.
Read more ►

Blogger news