How to Change the Toolbar in Excel 2007

1. Locate the Quick Access Toolbar in Excel 2007. It will be either next to the Office button or under the ribbon.
2. Right-click on the Quick Access Toolbar and select 'Customize Quick Access Toolbar.' Check or uncheck the 'Show Quick Access Toolbar Below the Ribbon' box to place the toolbar where you want it.
3. In the ribbon, navigate to the feature you want to add to the Quick Access Toolbar.
4. Right-click on the feature you wish to add, and a menu will appear.
5. Select the 'Add to Quick Access Toolbar' option. The feature should now be on the toolbar.

Read more ►

How to Make a Time Line in Microsoft Excel

1. Gather all the information you need for the time line.
2. Open Microsoft Excel. Click on the Excel desktop icon or find Excel in the Start Menu under 'All Programs.'
3. Click the 'File' tab and pick 'New' to start a new spreadsheet.
4. Add a title to your time line. Click 'Insert' and then choose 'Header and Footer.' Type the title in the header section. Format the title to suit your needs and click 'OK.'
5. Move a few rows down the spreadsheet and input the first date. You can format the cells all at once or individually. If you are including times in your chart you may want to format the cells separately.
6. Format the descriptions so they appear vertically instead of horizontally in your time line. Highlight the cell or groups of cells you want to change. Click the 'Format' tab. Choose 'Cells.' When the format window opens pick 'Alignment.' Change the number in the 'Degrees' box. The diagram on the side displays the look of the angle you chose.
7. Create borders around the cells or the entire time line. Highlight the cells. Select 'Format' from the menu bar. Now pick 'Borders' and choose the type of border to use from the list provided.
8. Add a background color to specific cells. Select the cells you want to add color to. Choose 'Fill Color' or select the paint brush from the draw tool bar at the bottom of the screen. Pick a color and click 'OK.'
9. Insert pictures into the time line. Choose 'Insert' from the menu bar and then click on 'Picture.' Choose a file from your computer or a clip art from Excel's clip art gallery.
10. Save the time line. Select 'File' from the menu bar and then click 'Save' from the drop-down menu.
11. Print your time line. Click 'File' on the menu bar. Pick 'Print' from the drop-down menu and click 'OK.'

Read more ►

How to Manipulate Data in an Excel 2007 Pivot Table

1. Open Excel 2007 and select a workbook containing data. Click the 'Office' button and select 'Open.' Browse your files and select the workbook. Click the 'Open' button to open the workbook.
2. Highlight the data you want included in the PivotTable. Select 'Insert' on the menu bar, and then select 'PivotTable.' A drop-down menu appears. Select 'PivotTable' again. Click 'OK.'
3. Add fields to the PivotTable by checking fields from the right 'PivotTable Field List.' By default, the fields appear in the column section. Manually drag the fields to any of these sections (row, totals or filter) to see how manipulating them changes your pivot table.

Read more ►

How to Convert Excel Time Difference to Decimal Number

1. Click a cell where you want the decimal representation of the time difference to appear.
2. Type '= A1 * 24' and then press 'Enter.'
3. Change the cell location 'A1' to the actual location where your time difference appears. For example, if the time difference is 1:15 and appears in cell C3, type 'C3' into the formula instead of 'A1.' Pressing 'Enter' for this result will give you the decimal result '1.25.'

Read more ►

How Do I Graph on a Secondary Axis in Excel Office Professional 2003?

1. Click on the data series on the chart that you want to plot on a secondary axis. For example, if you have a chart that shows price and volume and you want to display volume on a secondary axis, then click on 'volume.'
2. Click on 'Selected Data Series' on the Format menu.
3. Click on the 'Axis' tab, then click on 'Secondary axis.' Excel inserts a secondary axis into your worksheet.

Read more ►

How to Create a Pivot Table from Multiple Worksheets

1. Open the workbook in which you want to create the PivotTable.
2. Click 'PivotTable and PivotChart Report' on the 'Data' menu.
3. Follow the instructions in the wizard. For the first step, you will be asked to identify the source for your data. Click the black box on the right-hand side of the source data box. This will disconnect the source box from the wizard.
4. Select the data ranges in the worksheets you need data from. Start with the first range and then move on to the next. The wizard will automatically put a comma between each range of data you select.
5. Click the black box on the right-hand side of the source box again to attach the box back to the wizard. Click 'Next' in the wizard until you reach the end and then click 'Finish' to exit the wizard and create the PivotTable.

Read more ►

How to Calculate Days by Subtracting Two Dates in Excel

1. Launch Microsoft Excel and open a new worksheet. Type the date in one cell. For example, type '1/1/2010' in cell A1.
2. Type your first date in cell A1. For example, input the date '1/1/2010.'
3. Type your second date in cell B1. For example, input the date '3/14/2011.'
4. Select the cell C1, type '=' and click the date in cell B1. Then type '-', click the first date and press 'Enter.' Cell C1 now shows 438, the number of days between the two dates you input.

Read more ►

How to Create an Application in Word or Excel

Create an Application in Word
1.
Start Microsoft Word. In Word 2003, go to the 'File' menu and click 'New.' In Word 2007, click the 'Office Button' and click 'New.'
2.
Type 'Employment Application' in the 'Templates on Office Online' box and click the 'Search' button. Select 'Employment Application 2-pp Online Form' in the 'Search Results' list. Click the 'Download' button, and an application will open as a new Word document.
3.
Enter your company logo by selecting 'Your Logo Here.' Go to the 'Insert' menu in Word 2003, point to 'Picture' and click 'From File.' In Word 2007, go to the 'Insert' tab and click on 'Picture.' Find the logo on your computer and insert it. Type the name of your business over 'Company Name.'
4.
Change any of the template example fields by selecting them and typing over the text. To alter the properties of a form field, double-click the gray field area, and the 'Form Field Options' dialog box will open. Select an option from a drop-down menu, or click the 'Add Help Text' button for more options.
5.
Save the application when finished. Before allowing an applicant to fill in an application in Word, open the document and save it with a new name, such as the applicant's name or the date, so that the original will not be changed.
Create an Application in Excel
6.
Start Microsoft Excel. Open a new, blank workbook. Insert a company logo by going to the 'Insert' menu in Excel 2003. Point to 'Picture' and click 'From File.' In Excel 2007, go to the 'Insert' tab and click on 'Picture.' Find the logo on your computer and insert it on the left side of the page. Enter a text box on the right side and type the name of your business inside it.
7.
Type the desired questions into cells on the spreadsheet. Leave empty the adjoining cells for the applicants to type into.
8.
Create 'Yes' or 'No' drop-down lists from which applicants can select an answer. Go to the 'Data' tab in Excel 2007 or the 'Data' menu in Excel 2003 and select 'Data Validation.' Go to the 'Settings' tab of the Data Validation dialog box.
9.
Select 'List' in the 'Allow' drop-down list. In the 'Source' field, type 'Yes,No' (without quotes). Click 'OK' to apply the drop-down list.
10.
Enter other data into the 'Source' field of the Data Validation box to create custom lists. Type a comma between each list item. When applicants click in the cell, they will be presented with a list of options from which to choose. Save the application when complete.

Read more ►

How to Change Macro Security Settings on Windows Vista

Changing Macro Security in Word or Excel 2007
1. Click the circular Office logo in the upper-left corner of the Word or Excel window, then click the 'Word Options' or 'Excel Options' button at the bottom of the menu.
2. Click the 'Trust Center' link on the left side of the screen, then click the 'Trust Center Settings' button.
3. Click the 'Macro Settings' link on the left side of the window to access the macro settings for the Office 2007 program you are using. The menus for Word 2007 and Excel 2007 are the same. The default selection is 'Disable all macros with notification.' To run your own macros, select 'Enable all macros.'
4. Click 'OK' to save your changes.

Read more ►

How to Keep Track of Changes in an Excel Document

Tracking Changes
1. Start Microsoft Excel and open the file you want to change.
2. Open the Tools menu and select Track Changes, then Highlight Changes.
3. In the Highlight Changes dialog box, select 'Track changes while editing.'
4. Select 'Highlight changes on screen.'
5. Open the When menu and select All.
6. Open the Who menu and select Everyone.
7. Click OK.
8. Click OK. This will save your changes and your file/workbook.
9. Enter your new changes.
Accepting or Rejecting Changes
10. Open the Tools menu and Track Changes menu and select Accept and Reject Changes option.
11. In the Select Changes to Accept or Reject dialog box, select 'Not yet reviewed' to see all changes or 'Since date' to see changes after a certain day.
12. Click OK.
13. In the Accept or Reject Changes dialog box, review the edits to the spreadsheet.
14. Select the Reject or Accept button for each edit.

Read more ►

How to Unfreeze a Window Pane in Excel 2007

1. Select the 'View' tab from the top menu in Microsoft Excel 2007.
2. Go to the 'Window' menu ribbon. Select 'Freeze Panes.'
3. Choose 'Unfreeze Panes' from the pop-up menu to unfreeze your Excel spreadsheet.

Read more ►

How to Install Office 2000 on Excel 2007

Installing Office 2000 without Excel 2000
1. Insert your Office 2000 installation CD. A dialog box should open.
2. Provide details about your name and organization as well as the 25-digit CD key to continue the installation process, then select the 'Next' button. You will be redirected to another dialog box containing the Office 2000 End-User License Agreement; read it. If you agree, select the 'I accept' option, then click 'Next' to continue with the installation process.
3. Select 'Customize' as your installation type, then select all Office 2000 component programs except Excel 2000.
4. Click on the 'Install now' button to finalize the installation process.
Installing Excel 2007 without Office 2007 component programs
5. Insert your Office 2007 CD. A dialog box will open, asking you to enter your Office 2007 key.
6. Enter your Office 2007 key, then select 'Continue.' You will be redirected to another dialog box, where you will accept the Microsoft Software Terms; accept the terms to continue.You will see another dialog box asking you to choose your installation type.
7. Install only Excel 2007 by selecting the 'Customize' option. Click the 'Installation options' tab, then choose the 'Not available' option for all of the component programs except Excel 2007. Click the 'Install now' button.

Read more ►

How to Make a Cell Required in Excel 2007

Making Cells Required to Print Spreadsheet
1. Open Excel 2007. Check for the 'Developer' tab in the ribbon across the top of the screen. If you do not have the 'Developer' tab activated, click the round blue 'Microsoft Office' button in the top left corner. Click 'Excel Options' followed by 'Popular.' Check the box for 'Show Developer Tab in the Ribbon,' and then click 'OK.'
2. Click the 'Developer' tab, and then click the 'View Code' button under the 'Developer' menu. This will open Microsoft Visual Basic.
3. Copy and paste the following code into the blank window:[vba]Private Sub Workbook_BeforePrint(Cancel As Boolean)If Sheet1.Range('A1:B2').Value = '' ThenMsgBox 'Cannot print until required cells have been completed!'Cancel = TrueEnd IfEnd Sub[/vba]
4. Replace the 'Sheet1' and 'A1:B2' values within the code with the range of values you would like to require in your spreadsheet. For example, if you want to require the first 10 cells in column A of Sheet 2 of your spreadsheet, you would change the second line of the code to:If Sheet2.Range('A1:A10').Value = '' Then
5. Close Microsoft Visual Basic. Save your Excel file to make the code a permanent part of the file.
Making Cells Required to Save Spreadsheet
6. Open Excel 2007 and check to see if the 'Developer' tab is present in the ribbon across the top of the screen. If you don't see the 'Developer' tab, click the round blue 'Microsoft Office' button in the top left corner. Click 'Excel Options' followed by 'Popular.' Check the box for 'Show Developer Tab in the Ribbon,' and then click 'OK.'
7. Click the 'Developer' tab, and then click the 'View Code' button under the 'Developer' menu to launch Microsoft Visual Basic. Visual Basic allows you to view and organize any code you've added to a spreadsheet, as well as write or add new code.
8. Copy and paste the following code into the empty window within Microsoft Visual Basic:[vba]Private Sub Workbook_BeforeSave(Cancel As Boolean)If Sheet1.Range('A1:B2').Value = '' ThenMsgBox 'Cannot save until required cells have been completed!'Cancel = TrueEnd IfEnd Sub[/vba]
9. Customize the code by replacing the 'Sheet1' and 'A1:B2' values with the range of values you would like to require in your spreadsheet. For example, if you want to require the first 10 cells in column A of Sheet 2 of your spreadsheet, you would change the second line of the code to:If Sheet2.Range('A1:A10').Value = '' Then
10. Attempt to save the Excel sheet without filling in all of the required cells. If a message box pops up reading 'Cannot save until required cells have been completed!', your code is working correctly.

Read more ►

How to Build Pivot Tables in Excel 2007

1. Open Excel and open a spreadsheet on your computer that has data in at least 5 columns and 10 rows. Make sure this data has column headers.
2. Press 'Control' and 'A' to select all of the data in your spreadsheet. Click on the 'Insert' tab on the ribbon and select 'PivotTable.' Select 'PivotTable' again. Excel will open the Create PivotTable dialog box. In the section titled 'Choose the data that you want to analyze,' choose 'Select a Table or Range.' In the section titled 'Choose were you want the PivotTable report to be placed,' choose 'New Worksheet.' Click 'OK.' A new worksheet opens displaying an empty PivotTable.
3. Design your PivotTable by selecting a column header from the 'PivotTable Field List.' The column data will populate the PivotTable. Notice the field is dropped into the 'Row Labels' area of your PivotTable. You can move it around using the section titled 'Drag fields between areas below.' Add another field to the PivotTable by selecting it from the 'Pivot Table Field List.' Drag both fields to either the 'Column Labels' or 'Row Labels' and see how your PivotTable is impacted.
4. Add a field that includes a numerical value for these two column headers. Move this field to the 'Sum Values' field of your PivotTable. You should see data that is being summarized in a compact manner. You can display the summarized data as a count or sum value. If you want to change the type of value being displayed, click on the drop-down arrow next to the field in the 'Sum Values' field and select 'Value Field Settings.' Change the value to represent the type of summary you are looking for. Click 'OK.'

Read more ►

How to Use Page Orientation on Excel 2007

Selecting Page Orientation
1. Open Microsoft Excel 2007.
2. Click the 'Page layout tab.'
3. Click 'Page setup.'
4. Click 'Orientation' and click either 'Landscape' or 'Portrait.'

Read more ►