How to Create Invoices in Microsoft Word From Excel 2007

1. From a new blank workbook in Excel, click the 'Office' button and then the 'New' icon to display the 'New Workbook' dialog box. Under the 'Microsoft Office Online' section, choose 'Invoices' to view the invoice templates that are available for free download. Filter out customer-submitted templates, if desired, by clicking on the 'Hide customer submitted templates' icon at the top of the screen.
2. Preview the available templates by single-clicking on each one to view the template in the preview pane to the right. Click on the 'Download' button once you've selected the desired template. You will briefly see a status window until the file download is complete (downloading times are usually minimal, but will vary depending on the speed of your Internet connection). A new Excel window showing your template will pop up after the download has completed.
3. Select the cells containing data in this new worksheet, then right-click the selected data and choose 'Copy.'
4. With the Excel window still open, launch Microsoft Word. In the 'New Blank Document' screen, click the 'Paste' menu button in the 'Clipboard' group on the 'Home' tab. Choose 'Paste Special' to launch the 'Paste Special' dialog box.
5. Under the 'Paste As' section, choose the 'Microsoft Excel Binary Worksheet Object' option and then click 'OK.' Your invoice template will be pasted into Word as an Excel object. In order to enter your data into the template and temporarily alter the ribbon to show Excel commands, double-click the Excel object.

Read more ►

How to Sort a Row or Column in Excel

1. Start Microsoft Excel and open the file you want to change.
2. Drag over the two or more columns or rows that you want to sort.
3. Open the Data menu and select Sort. The Sort dialog box appears.
4. Select the Continue with the Current Selection option to sort a single column or row.
5. Select the Expand the Selection option to sort a series of columns or rows.
6. Choose Ascending or Descending to determine the sort order.
7. Click the Options button in the Sort dialog box.
8. Select 'Sort top to bottom' in the Sort Options dialog box to sort a column.
9. Select 'Sort left to right' in the Sort Options dialog box to sort a row.
10. Click OK in the Sort Options dialog box.
11. Click OK in the Sort dialog box.

Read more ►

How to Change the Pivot Table Default Settings in Excel 2007

1. Open your Microsoft Excel 2007 application on your computer. Click on any cell in the range you want to use for your pivot table.
2. Click on the 'Insert' tab and then click on the 'PivotTable' button from the Table group. Click on the 'Create PivotTable' button. The 'Create PivotTable' dialog box will then appear.
3. Change any defaults in the 'Create PivotTable' dialog box. For instance, you can click on the 'Use an external data source' option. Click on 'OK' once you've finished changing any of the default selections.
4. Continue to create your pivot table by clicking on any of the options in the 'PivotTable Field List' box. Click on the 'Update' button when you finish.
5. Change the display defaults by clicking on the 'Options' tab and then selecting the 'Options' button in the 'PivotTable' group. Click on the 'Layout and Forms' tab and then click on the 'For error values show' option.
6. Click on the box next to the 'For empty cells show' field. Click on the 'OK' button and the default display options will be changed.

Read more ►

How to Add a Spell

1. Click the 'View' drop-down menu and then the 'Toolbars' submenu. Make sure that the toolbar that will hold the spell-check button is visible by verifying that there is a check mark next to it or selecting it, if there is no check mark, to make it visible.
2. Click the 'Tools' drop-down menu and select 'Customize.'
3. Select the 'Commands' tab in the 'Customize' dialog box.
4. Select the 'Tools' category and scroll down until the 'Spelling' button is visible. The button will have the letters 'ABC' and a check mark on it.
5. Click and drag the 'Spelling' button from the Customize dialog box to the place on the toolbar where it will reside, and then release the mouse button. While the Customize dialog box is active, you can drag the button to a new location on the toolbar.
6. Click 'Close' to close the Customize dialog box.

Read more ►

How to Insert a Date in Microsoft Excel

Excel 2007
1. Right click on the cell and choose 'Format Cells.'
2. Click on the 'Number' tab.
3. Click on 'Date' in the 'Category' list box.
4. Choose the date format by clicking on one of the formats in the 'Type' box. For example, click on '3/14.'
5. Press 'OK.'
Excel 2003
6. Right click on the cell, the click on 'Format Cells.'
7. Left-click on the 'Number' tab.
8. Scroll to the 'Date' field and highlight it.
9. Scroll to the date format you'd like to use in the 'Type' box.
10. Click on 'OK.'

Read more ►

How to change the default font setting in Word 2003

1. Open Microsoft Word.
2. Right-click your mouse in the blank document. The Font dialog box will display.
3. Make any changes you want in this box. You can change the font, its style and size, as well as color and effects.
4. Click the 'Default' button in the lower left corner of the Font dialog box when you are done.
5. Click 'Yes' on the pop-up that appears. This will make your newly chosen settings the default for each future blank document.

Read more ►

How to Graph Two Lines in Excel 2007

Line Graph
1. Open the Excel file that contains the data you need to graph. To make two lines using a line graph, you will need two columns of numerical data. If you want the data to have labels, you should include a header in the cell at the top of each column.
2. Select the data that you want to include in the Line Graph. If your desired information is the only data in the two columns, you can simply click and hold the button on the letter above the first column, then move the mouse to the second column and release the button. If your data is not the only information in the column, click and hold on the top-left cell, then drag the mouse pointer to the bottom-right cell, and release it.
3. Select the 'Insert' tab at the top of the Excel 2007 window. Click the 'Line' button in the 'Charts' area and choose either the 'Line' or 'Line with Markers' option. Your two line graph will appear on the screen.
4. Right-click in the open space of the chart if you need to add custom labels to the x-axis. Choose 'Select Data' from the list of options. Press the 'Edit' button in the 'Horizontal Axis Labels' area. Select the labels from your spreadsheet, which will normally be located on a column just to the left of the data columns, and click 'OK'. Click 'OK' again and the labels will update.
Scatter Graph
5. Open the Excel file that hold your information. When using a scatter graph to make two lines, you will need to have data arranged in two sets of two columns. Select the first two columns that you want to use.
6. Select the 'Insert' button at the top of the window. Click the 'Scatter' button under the 'Charts' area. You will see five options. Choose any option other than 'Scatter with Only Markers' to create a graph that will include lines. You will see a graph appear on the spreadsheet that has one line.
7. Right-click on the graph and choose 'Select Data'. Click the 'Add' button under 'Legend Entries'. A small 'Edit Series' window will appear.
8. Type in a name for the series under 'Series Name'. This can be whatever you want. Click the box next to 'Series X Values' and choose the data from the first column of the second set. Once you have selected the data, click the box again to return to the 'Edit Series' box. Click the box next to the 'Series Y Values' and select the data from the final column. Click the box again, then click 'OK'. The graph will now show two lines on it.

Read more ►

How to Lock Unlock an Excel Spreadsheet

Locking
1. Open the Excel spreadsheet you want to lock.
2. Click the green 'File' tab on the ribbon.
3. Click the large, square 'Protect Workbook' button.
4. Select a permissions level. Choose 'Mark as Final' to make the spreadsheet read-only. This option does not require a password and only discourages, but does not prevent, editing.
5. Choose 'Encrypt with Password' if you want to prevent anyone from opening the spreadsheet without a password. Type the password in the box and click 'OK.' Excel will prompt you to re-enter the password. Re-enter the password and click 'OK' again.
6. Choose 'Protect Current Sheet' if you want to set a password for opening the spreadsheet and want to restrict editing of specific cells or areas. Enter the password in the box and click on the various items you want others to be able to do. Whatever you do not check off will be disallowed. Click 'OK' when you are satisfied. Excel will prompt you to re-enter the password. Re-enter the password and click 'OK' again.
7. Choose 'Protect Workbook Structure' if you want the structure to remain intact while allowing others to make most changes. Users will not be able to delete or move sheets but otherwise, they will be able to add rows and make calculation and style changes. Enter the password and click 'OK.' Excel will prompt you to re-enter the password. Re-enter it and click 'OK' again.
Unlocking
8. Open the Excel file you want to unlock. If it is fully encrypted such that no one can open it without a password, Excel will prompt you for a password at this point. Enter the password and click 'OK.'
9. Click the 'File' tab. You should see the word 'Permissions' written in orange; this lets you know that the worksheet is protected in some way.
10. Click 'Protect Workbook' and select the protection option that is highlighted in orange. This indicates the level of protection you used to lock the spreadsheet in the first place.
11. Enter the password to unprotect the spreadsheet. Click 'OK.' You will be able to make any edits to the spreadsheet.
12. Save the document. The next time you open it, you will not need a password.

Read more ►

How to Convert Quattro Pro for Windows to Excel

1. Go to 'My Computer' and double-click on 'Control Panel.'
2. Double-click on 'Add/Remove Programs' to open the list of installed programs on your PC. Wait for the list to be propagated before doing anything.
3. Search for Microsoft Excel. If you installed Excel as part of an MS Office suite, look for Microsoft Office instead. Click on the program to bring up a list of options on the right side of the window.
4. Click the 'Add/remove' button among the list of options. This opens up an installation wizard.
5. Click on the 'Add or Remove Features' option in the window that appears to bring up a list of available addons to install. Click on the 'Quattro Pro 5.0 Converter under Microsoft Excel for Windows' program, then click on 'Run From My Computer' to install the converter to your PC.
6. Click 'Update Now' to finish the installation.
7. Open Microsoft Excel, then go to 'File' then 'Open' to open a window listing files on your computer.
8. Search for the Quattro file you want to convert, then double-click on the file to open it.
9. Click on 'File' then 'Save As' to open up the save dialog.
10. Select 'Microsoft Excel' or any Excel file type in the file selection at the bottom of the dialog. Name your file in the line above the file selector and click 'Save.'

Read more ►

How to Use the Inverse Log Function in Excel

1. Start Excel.
2. Generate the inverse of a common -- base 10 -- logarithm in cell 'A1' by typing '=POWER(10,B1)' and entering the logarithm desired in cell 'B1.' You can replace the first 10 inside the parentheses with any base you choose.
3. Generate the inverse of a natural logarithm -- base 2.8172 -- in cell 'A2' by typing '=EXP(B2)' and entering the logarithm desired in cell 'B2.'

Read more ►

How to Make a Cumulative Frequency Table

1. Construct your spreadsheet to have three columns. One of these columns will be your observation interval, the second will be the number of observations you make per interval, and the third will be the cumulative frequency column.
2. Construct your table to contain as many rows as you have observation intervals (e.g., if you are going to make an observation every hour for one day, you will have 24 rows).
3. Write your observation intervals down in the first column. As in the above example, if you are making an observation each hour for one day, your 24 rows in this column will be numbered individually, 1 through 24.
4. Note the number of observations you make during each time interval in the second column. For example, if you observe 3 birds at your feeder at the 1-hour time mark, write the number '3' in that column. The next observation period, you may see only 2 birds.
5. Keep a running total of how many observations you have made during each time period in the third column. For example, if during time period one you observe 3 birds, after writing '3' down in your second column, also write '3' in the third column. At the second observation period you observe 2 birds, you will record '2' in the second column, but add this number to the number in the cumulative frequency column to give you the entire number of birds observed since your observations began (in this case, 5).
6. Continue writing observations at each observation interval, adding the total to the cumulative frequency and recording it in the third column.

Read more ►

How to VLookup Two Values in Excel 2007

1. Open the Excel 2007 file that contains the table you want to work with.
2. Right-click on the column letter above the leftmost column on your table. Choose 'Insert' to create a new column.
3. Select the top cell in your new column. Type '=XXYY' into the cell, where 'XX' equals the cell reference to the first cell in the first column you want to search through with VLookup, and 'YY' is the second column. Press 'Enter' and you will see the entries in those columns compressed together into the new column. For example, if 'here' was in the first column, and 'there' was in the second, your new column would read 'herethere.'
4. Move your mouse over the bottom-right corner of the cell with your formula. Click the mouse and hold down the button,and then drag the mouse down until your reach the last row in your table. Release the mouse button and Excel will copy your formula down the entire length of the table.
5. Click on the top cell in your new column. Press 'Ctrl' and 'A' to select the entire table. Click the 'Home' tab at the top of the screen. Click the 'Sort and Filter' button, which you can find in the 'Editing' area of the ribbon. Choose 'Sort A to Z.' VLookup will not return good values if the first column is not ordered from lowest to highest.
6. Select any cell outside of the data table. Enter the following formula into the cell: =VLOOKUP('XX',YY:ZZ,2) where 'XX' is equal to the two values that you want to search for, 'YY' is the top-left cell in the data table, 'ZZ' is the bottom-right cell in the data table and '2' is the column number where you want to search for your result. When entering your search values, remember to place them together without spaces, so if you were searching for the number '1' in one column and the word 'trucks' in a second column, you would enter '1trucks.' Press 'Enter' to complete the formula and get your result.

Read more ►

How to Remove the Blanks from a Pivot Table Add

Remove Blank Cells
1. Open Excel and open 'Pivot Table Options' in the Excel ribbon by clicking anywhere on the Pivot Table.
2. Click 'Pivot Table Options' to open the options box so you can make changes to the Pivot Table settings.
3. Click the 'Layout Format' tab and look to the 'Format' section.
4. Uncheck the box next to 'For empty cells show:' and then click 'OK.' Blank cells will no longer show up in the Pivot Table add-in.
Remove Blanks from Rows
5. Click on the Pivot Table report to open 'Pivot Table Options' in the Excel ribbon.
6. Look to the 'Active Field' section of the ribbon and click 'Field Settings.'
7. Click the 'Layout Print' tab when the 'Field Settings' box opens.
8. Uncheck the box next to 'Insert blank line after each item label' and click 'OK.' Blank lines will no longer appear after rows.
Remove Blanks from Item Labels
9. Select the item that has a blank from the Pivot Table report.
10. Click the 'Design' tab located in the Excel ribbon and then click 'Blank Rows.'
11. Select 'Remove blank line after each item label' and blank lines will no longer appear after item labels in the Pivot Table.

Read more ►

How to Use the Same Color for Multiple Line Charts

1. Turn on your computer and open Excel. Microsoft Excel is a spreadsheet program that helps you maintain data and compile charts, tables and graphs in a few easy steps. This program is available for PC and Mac computers and we will look at creating a graph in Excel.
2. Enter the data you want to include in your chart in the Excel spreadsheet. This is easy to do. You will place your 'Y-axis' data on the first vertical column and the 'X-axis' data across the first horizontal row. Start The vertical column on the second row so that you can place the information in each data box. For example, if you want to review 'Department Revenues' by each 'Quarter' you would place the 'Department Name' going down the first column with each 'Quarter' labeled across the top row: Q1, Q2, Q3, Q4.
3. Go to the menu to 'Insert > Chart.' Click this and follow the onscreen menus to select 'Line Chart.' Highlight the areas in the data sheet you want to use in the chart. You will be given the option to either include the chart on your existing data page or open a new page with just the chart on it.
4. Look at the chart that pops up and review it to make sure it is correct. This will be a color chart with the data represented by different colored lines. Now you need to change the colors into patterns.
5. Right-click on the first data line, which may be red, green, yellow or blue. Select 'Format Data Series.' A box will appear with several tabs over your chart. Make sure you have selected the 'Colors and Lines' tab. Confirm that you are on the correct line by the color that is in the color box. Choose the pattern under the 'Dashed' tab. Click 'OK' when you are done customizing the line. You can maintain the color of the line or change it to black.
6. Repeat Step 5 for all data lines, making sure to choose a different pattern for each information line.
7. Save the file and print.

Read more ►

How to Create the Input Form on Excel 2007

1. Plan your worksheet. Think about the type of information you will be keeping in the spreadsheet and set up your columns.The column headers will be used as the form labels next to the input boxes.
2. Set up your spreadsheet. Type in the column headers. Set the column lengths. Do not merge any cells in the column headers. Excel will not be able to generate an input form from merged cells. You can always make the columns bigger by changing the column width property.
3. Add the Form button to the Quick Access toolbar. Click the drop-down arrow on the Quick Access toolbar and then click 'More Commands.' A dialog box appears. Click the drop-down under 'Choose commands from:' and choose 'All Commands.' Stroll through the list and find 'Form.' Highlight 'Form' and click 'Add,' then click 'OK.' The Form button is now in your Quick Access toolbar.
4. Highlight the column headers. Click on the 'Form' button in the toolbar. Excel will generate an input form that will allow you to enter in new information into the columns. Notice your column headers on the left-hand side of the input form next to the text boxes.

Read more ►