How to Remove Certain Colors in Excel 2007

1. Open the Microsoft Excel 2007 document.
2. Highlight the cells that you want to remove color from.
3. Scroll to the top of the screen and click the 'home' tab.
4. Scroll to the right where there are six boxes stacked on top of one another. Click on the box that says 'normal.' This will remove all color and restore the cells back to normal.
5. Scroll to the paint-bucket icon.
6. Click on it to reveal a drop-down menu.
7. Scroll down to where its labeled 'no fill' and click on it. This removes background color.
8. Scroll to the icon that is a letter 'A' with a color pallet beneath it.
9. Click on this to reveal a drop-down menu.
10. Scroll to where it labeled 'automatic' and click on it to make it black.

Read more ►

How to Create a Pivot Table in Excel

Create a Basic Pivot Table From an Excel List
1. Ensure your data source contains all data elements you want to include in your report. All data ranges need to have labeled rows, columns and associated data values.
2. Select the 'PivotTable and Pivot Report' option from the Data menu. This option launches a wizard to aid you in creating a report.
3. Choose the 'Microsoft Office Excel List or database' data source option from the wizard. This option specifies that your data resides in an internal spreadsheet.
4. Specify PivotTable as your desired report. This triggers the data range prompt to appear.
5. Highlight the range that contains the data you would like to include. Start from the top left corner of your data set and end with the bottom right cell.
6. Decide whether you want the report to display in the worksheet with the raw data or in a separate worksheet. Although it is cleaner to have the report in a new worksheet, there is no functional difference between the two options.
7. Drag and drop the data objects from the pivot table field list onto the worksheet. The report areas include space for row, column, data and page field values. You can move the objects around until the report layout is satisfactory.
Make a Pivot Table From Multiple Ranges
8. Follow Steps 1 and 2 in Section 1.
9. Choose 'Multiple Consolidation Ranges' as your data source. This will allow Excel to pull from more than one list.
10. Specify how many page fields you want, from zero up to four. You can either create them manually or allow Excel to create them.
11. Add all ranges that contain report data. You can add, delete and browse for additional .xls files that include relevant information.
12. Complete Steps 6 and 7 in Section 1.
Generate a Pivot Table From External Files
13. Follow Steps 1 and 2 within Section 1.
14. Choose 'External Data Source.' Excel lists five options as possible data sources: dBase, Excel, HT8PRD, MS Access Database and Visio Database Samples.
15. Specify the appropriate data source(s). Browse through your directory to select the correct file.
16. Complete Steps 6 and 7 in Section 1.

Read more ►

How to Create Bins in Excel 2007

Creating Bins in Excel 2007
1. Click the Microsoft Office link in your start box and click on Microsoft Excel 2007. Microsoft Excel 2007 is the green icon, located among the choices of Microsoft programs.
2. Click 'Data Analysis,' located in the analysis group on the data tab. In the dialog box after clicking data analysis, click 'Histogram' and then click OK.
3. Type your desired input range in the 'Input Range' box.
4. Type your desired range to create a new bin in the 'Bin Range' box.
5. Click 'New Workbook' which is located under 'Output Options.' Check the 'Chart Output' check box then click OK. Your new bin within the workbook is created.

Read more ►

How to Use the Selection Pane in Excel

1. Start Microsoft Excel 2007, and open an existing workbook from your files that contains multiple images that you would like to view with the selection pane.
2. Click to select any one of your images so you can gain access to the Format ribbon. You can tell an image is selected, because it will be surrounded by white sizing handles and the 'Format' tab will appear at the top of the Excel screen.
3. Select the 'Format' tab to display the Format ribbon. This ribbon displays all the settings you can use to format images in Excel.
4. Choose the 'Selection Pane' button in the 'Arrange' section of the Format ribbon. The 'Selection and Visibility' pane will appear on the right side of the Excel screen. This pane displays a list of all the images that appear in the Excel worksheet.
5. Click the button with a picture of the eye to the right of the names of the pictures to hide any of the pictures. Clicking the button again to display the eye will make that image visible.
6. Choose the 'Show All' button at the bottom of the 'Selection and Visibility' pane to show all of the pictures in the workbook. Choose the 'Hide All' button to hide of the pictures.
7. Select the name of a picture and use the up and down arrow buttons at the bottom of the selection pane to change the order of the images on the worksheet.

Read more ►

How to Write Macros in Excel 2010

1. Open Excel on your computer. Click the 'View' tab on the ribbon and then click the 'Macros' icon.
2. Enter a descriptive name for the new macro. Do use spaces in the macro name. Create a sample macro to use during the process of learning to write a macro in VBA. Therefore, enter the macro name 'Change_Worksheet_Names' in the macro name field and then click 'Create.' The Microsoft Visual Basic for Application window opens and displays a 'Module (Code)' window with the blank 'Sub Change_Worksheet_Names()' code document.
3. Continue creating the sample macro, which changes all of the generic 'Sheet1,' 'Sheet2' worksheets in a workbook to a value from a header or title cell in each worksheet. For example, if you enter the title for each sheet in cell 'A1' of each worksheet, this macro changes the name displayed at the bottom of each worksheet to the value in the referenced cell -- in this case 'A1.' To create the macro using VBA, enter the following code between the 'Sub Change_Worksheet_Names()' and 'End Sub' tags:Dim myWorksheet As WorksheetFor Each myWorksheet In Worksheets'The next line of code verifies that cell A1 in each worksheet is not empty. This text is a code 'remark.' The single quote mark at the beginning of the line informs Excel not to include this text in the macro code. Remarks are a good way to leave notes in VBA code that explain commands or syntax used.If myWorksheet.Range('A1').Value
'' Then'This command renames the worksheet to the text value in cell 'A1' of the first worksheet.myWorksheet.Name = myWorksheet.Range('A1').ValueEnd If'The 'Next' command instructs Excel to repeat the above code commands until it has finished renaming all the worksheets in the active workbook.Next
4. Click the 'Save' icon beneath the menu bar in the VBA editor window. Enter a name for the Excel template that contains the macro code. Select 'Excel Macro-Enabled Workbook' as the file type and then click 'Save.' Close the VBA editor window.
5. Test the macro for the sample VBA code. Enter a header or sheet title name in cell A1 of each worksheet. For instance, enter 'Daily,' Weekly' and 'Monthly' in cell A1 of three worksheets. The tabs for each worksheet at the bottom of the Excel window should read 'Sheet1,' 'Sheet2' and 'Sheet3,' respectively.
6. Click 'Macro' on the 'View' tab. Highlight the 'Change_Worksheet_Names' macro and then click 'Run.' The worksheet tab names at the bottom of the window change to 'Daily,' 'Weekly' and 'Monthly.'

Read more ►

How to Insert Error Bars in Excel 2007

1. Open the Microsoft Excel 2007 application that contains the chart that you want to add error bars to.
2. Click on the area of the chart where you want to add the error bars. Click on the “Format” tab and then click on the arrow next to the “Chart Elements” box.
3. Click on the chart element from the list that you want to add the error bars to. Click on the “Layout” tab and then click on the “Error Bars” option from the “Analysis” group.
4. Select the “Error Bars with Standard Error”, “Error Bars with Percentage” or “Error Bars with Standard Deviation” option.
5. Click on the “More Error Bar Options” button and then click on the “Vertical Error Bars” or “Horizontal Error Bars” option.
6. Click on the “OK” button and the type of error bars you selected will appear on your chart.

Read more ►

How to Paste a Function in Excel 2003

1. Click to select the cell that you want to copy. To select multiple cells, click and drag your mouse to highlight the range or hold down the Ctrl key and click each cell you wish to copy.
2. Press Ctrl C on your keyboard to copy the cells, or click 'Edit' and then 'Copy' on the main toolbar.
3. Click in the blank cell where you want to paste the formula.
4. Right-click, then choose 'Paste Special,' or click 'Edit' and then 'Paste Special' to display the 'Paste Special' dialog box.
5. Select the 'Formulas' radio button, then click 'OK.' The formulas or functions are pasted into your spreadsheet.

Read more ►

How to Add the Microsoft Date Time Picker in Excel 2007

1. Download Microsoft Windows Common Controls-2 6.0 from the Microsoft website.
2. Extract the .cab file's contents. Newer Windows versions open .cab files directly. Older versions need extraction software such as WinZip or WinRAR.
3. Run the 'mscomct2.bat' file. This installs the Microsoft Date Time Picker.
4. In Excel, click the Office button on the screen's top left corner. Select 'Excel Options.' The 'Excel Options' window will open.
5. Click 'Popular' from the top of the left column.
6. Check the box next to 'Show Developer tab in the Ribbon.' Close the window. Excel's ribbon now contains the Developer tab to the far right.
7. Click on the Developer tab to show its controls. Click the 'Insert' button, and select the bottom right icon, which shows additional ActiveX controls. The 'More Controls' window will open.
8. Choose 'Microsoft Date and Time Picker Control 6.0 (SP4)' and close the window. Your mouse cursor will turn into cross hairs.
9. Click and drag anywhere on your spreadsheet to create a date box.

Read more ►

How to Create Multiple Directories From an Excel Spread Sheet

1. Click on the 'Office' button.
2. Mouse over 'Save As.' This displays an options list. Click on the type of file you want to save. For example, 'Excel workbook.'
3. Click on the directory you want to save the file in, or click on the 'New Folder' icon to create a new directory. For example, click on 'My Documents' or create a new folder called 'My business tax documents.'
4. Enter the name of your file in the 'File name' box.
5. Click on 'Save.'
6. Repeat steps 1 to 5 to save the file to as many directories as you wish.

Read more ►

How to Record an Excel Macro

1. Open the Tools menu and select Macro, then select Record a Macro.
2. Fill in the blanks - the macro name, description, shortcut-key combination and worksheet where the macro will be available - in the Record Macro box that appears. The macro can be available from only one worksheet or from any worksheet.
3. Click on OK.
4. Notice that the word 'recording' appears in the lower left of the Excel screen while recording is in progress.
5. Perform a series of keystrokes or mouse actions. The macro will record them. You can record any normal Excel action.
6. Open the Tools menu and choose Stop Recording to complete the macro.
7. Activate the macro by pressing the shortcut keys you have selected or by selecting the macro from a list on the Tools menu. The macro will then reproduce the series of keystrokes you recorded.

Read more ►

How to Create Microsoft Flow Charts

1. Open Excel 2010 and click the 'Insert' tab. Select 'SmartArt.' Click the 'Process' category in the left task pane. Click on the different process flow charts in the center task pane. Select a flow chart. For example, select the 'Basic Bending Process' flow chart. Click 'OK.' The SmartArt flow chart and Text Pane appear.
2. Type your flow chart tasks in the bulleted 'Text' pane. Move to each shape in the flow chart by pressing the 'Enter' key as you complete each task. Click on the outside border of the flow chart pane.
3. Notice the new 'SmartArt' tab on the ribbon. Use the 'Design' tab to add color schemes to the flow chart. Click the 'Change Colors' button to add a new color scheme to the flow chart. Save your changes by clicking the 'Save' icon on the Quick Access Toolbar. The Quick Access Toolbar is located above the ribbon.

Read more ►

How to Remove a Hyperlink in Excel 2003

1. Right-click the cell with a hyperlink.
2. Click 'Hyperlink.'
3. Select 'Remove Hyperlink.' The hyperlink is now removed from your Excel document.

Read more ►

How to Set Page Breaks in Microsoft Word 2003

1. Set your cursor where you want to page break to occur. Scroll to the “Insert” tab and the click on “Break.” Select “Page Break” from the drop down menu.
2. Insert a page break using hotkeys. Select where you wish for the break to occur and the press hotkeys “CTRL ENTER” to create the break.
3. Remove a page break. To remove a page break, left-click on the page that the break begins and press the “Backspace” button to delete the added page.
4. Insert a custom page break. Scroll to “Insert” and then select “Break.” You can choose several custom breaks including: page break, a column break and a text wrapping break. Select the desired break by clicking on the corresponding radial button.
5. View page breaks in print layout. Click on “View” and then click on “Print Layout.” This will show you what the printed version of your document will look like, including any added breaks.

Read more ►

How to Align Images in Excel

1. Open Microsoft Excel 2007 and open a workbook from your files that contains at least two images you wan to align to each other.
2. Hold down the 'Shift' key on your keyboard and click to select the first image you want to align. Continue holding down your shift key and click to select any other images that you want to align in relation to the first image. Once selected, the images will be surrounded by a thin, black line and white sizing handles.
3. Select the 'Format' tab from the top of the screen (if necessary) to display the Format ribbon. Locate the 'Arrange' section in the Format ribbon. The Arrange section is the second to last section in the Format ribbon and contains all the commands related to arranging images in Excel.
4. Click the 'Align' button from the Arrange section in the Format ribbon to display a drop-down menu of the options you can use to align the selected images.
5. Choose to align the images left, center, right, top, middle or bottom by choosing a selection from the Align drop-down menu. The selected images will immediately align according to the direction you chose from the drop-down menu.

Read more ►

How to Graph Linear Equations in Excel 2007

1. Open a new document in Microsoft Excel 2007.
2. Enter 'x' in the top left cell. Press 'Tab' and enter 'y' in the next cell over.
3. Enter a series of values in the first column under 'x' (cells A2 and down). These values will make up the parameters of the horizontal axis. For instance, enter '-5' in cell A2. In the next cell down, enter '-4' and onward: -3, -2, -1, 0, 1...all the way up to 5.
4. Define the name of the x values so you can enter the formula for the 'y' column. Use your cursor to highlight the cell values in column A. In other words, highlight cell A2 and drag your cursor down to the last cell in column A. Click the 'Formulas' tab. In the 'Defined Name' group, click 'Define Name.' Enter 'x' in the 'Name' field and click 'OK.' This tells Excel that all the numbers in column A are equal to a value of x.
5. Enter a linear equation in cell B2. The equation will appear in the Formula Bar. With the format y=mx b, type '=m*x b.' When you go to a new cell, Excel will calculate the result of the formula, which will now appear in the cell.
6. Copy the formula you entered is Step 5 to the other cells in column B. Select cell B2, which contains the formula. Click the 'Home' tab. Under 'Clipboard,' click the 'Copy' icon. Highlight all the cells below B2. In the 'Clipboard' group, click 'Paste.' Select 'Formulas.' This will add the formula to each cell. You'll now see the y-value for each corresponding x-value.
7. Select all the cells to begin making a graph for the data.
8. Click the 'Insert' tab. Click the type of chart you want in the 'Charts' group. For the purpose of making a linear graph, choose 'Scatter.' This will plot the x and y values against each other. Choose the chart subtype you want. To show a simple line graph with your data points, click the 'Scatter with Smooth Lines and Markers' icon.
9. Click the chart to display the 'Chart Tools' tabs. Use the 'Design' tab to change the chart's layout and style. Click the 'Layout tab to make modify the position of title and axis labels. Select the graphed line and click the 'Format' tab to adjust shape styles.
10. Click the 'Microsoft Office Button,' and click 'Save as' to save the data and graph.

Read more ►