How to Set the Default Font Size in Excel 2003

1. Open Excel 2003 and select the 'Tool' on the menu bar. Select 'Options.' The Options dialog box appears.
2. Click the 'General' tab. Select a font in the 'Standard Font' drop-down list. Select a size for the font using the 'Size' drop-down list.
3. Click 'OK' to confirm your changes. Excel will prompt you to restart for your changes to take place. Once you restart Excel, your new worksheets will be based on this new font.

Read more ►

How to Reset the Autofilter Area in MS Excel

1. Open the worksheet in which you would like to clear the filter.
2. Click the 'Filter' button on the column heading. It looks like a funnel in Row 1.
3. Click 'Clear Filter from
.' For example, if you have a filter in column A, click 'Clear Filter from A.'

Read more ►

How to Create Multiple Charts in Excel

1. Open up a new spreadsheet in Microsoft's Excel program.
2. Enter your data in the columns provided in the spreadsheet. For example, let us say you have three sets of data. You will use columns A, B, and C to record your data. Simply click on A1, and type your first number. Hit Enter, and your cursor will move to A2. You will follow this process until you have entered all three sets of data.
3. Click cell A1. Then, press Control and the letter A at the same time. Your three sets of data should be highlighted.
4. Click Insert on your toolbar. Experiment with different types of charts. You have the choices of Column, Line, Pie, Bar, Area, Scatter and Other Charts. Simply click the chart style you like, and it will appear on your screen.

Read more ►

How to Add Subtotals in Excel

1. Create the list of numbers to be added. Make sure to label the top of each column with a heading.
2. Highlight the column of numbers to be added by clicking on the number at the top of the column. Once all of the data is outlined and highlighted in blue, the numbers are ready to be added.
3. Go to the 'Data' tab at the top of the Excel toolbar.
4. Select 'Subtotal' from the 'Outline' section, which is on the far right side of the toolbar.
5. Confirm the column being added. Make sure that the function is set to 'Sum.' If it isn't, select 'Sum' from the 'Use Function' drop-down menu. Click 'OK' at the bottom off the confirmation screen to add the subtotals.

Read more ►

How to Restore Previous Excel Files

Files Never Saved
1. Open Excel.
2. Click 'File,' then 'Recent'.
3. Select 'Recover Unsaved Workbooks'.
4. Select your file and click 'Open'.
5. Save your file.
Previously Saved Files
6. Open your file.
7. Click 'File' then 'Info'.
8. Click 'Versions' and select the one labeled 'when I closed without saving.'

Read more ►

How to Find Copy Results in Excel 2003

1. Open the Excel 2003 spreadsheet in which you want to locate and copy data.
2. Type 'Ctrl' 'F' on your keyboard to open the 'Find' dialog box. Alternatively, click the 'Edit' pull-down menu near the top of the spreadsheet and select 'Find' from the list.
3. Type the data you want to find in the 'Find What' box. You can enter numbers or letters or a combination. Use the 'Options' menu to select special features, such as enabling the 'Match case' option to distinguish uppercase and lowercase letters in your search.
4. Click 'Find Next' to locate the next appearance of your search term in the spreadsheet. Alternatively, click 'Find All' to generate a list of all appearances of your search term and click an item in the list to go to that location in the spreadsheet.
5. Type 'Ctrl' 'C' on your keyboard to copy the contents of the cell you are in. Alternatively, click 'Edit' to open the pull-down menu and click 'Copy.'
6. Move your cursor to another cell, a different spreadsheet or document in another program and type 'Ctrl' 'V' to paste the copied data into the new location.

Read more ►

How to Edit the Legend in Microsoft Excel

Microsoft Excel 2007
1. Highlight a chart by clicking on it.
2. Click on the “Design” tab near the middle of the top of the page.
3. Click on “Select Data”, the fourth icon from the top left of the page. A box titled “Select Data Source” will appear.
4. Click on the name of the “Legend entry” that you wish to edit.
5. Press the “Edit” button. The “Edit” button is located directly above the list of the names of the legend entries in your chart. When you press the “Edit” button, a box titled “Edit Series” will appear.
6. Type the name that you wish to title the “Legend entry” into the box titled “Series name”.
7. Click “OK”. This will edit the legend and return you to the “Edit Series” box.
8. Add another “legend entry” to the legend by clicking on the “Add” button. The “Add” button is located directly to the left of the “Edit” button. When you press the “Add” button, another box titled “Edit Series” will appear.
9. Type the name that you wish to title the new “legend entry” into the box titled “Series name.”
10. Insert the values for the x-coordinates in the “Series X values” box.
11. Insert the values for the y-coordinates in the “Series Y values” box.
12. Click “OK”. This will edit the legend and return you to the “Edit series” box.
13. Repeat this process if you wish to add or edit any additional legend entries.
14. Click “OK” when you are finished.
Microsoft Excel 2003
15. Highlight a chart by clicking on it to modify its legend. A menu will appear.
16. Select “Source Data…” from the menu. It is the third option from the top of the menu. A box titled “Source Data” will appear.
17. Click on the tab labeled “Series”. It is one of two tabs displayed at the top of the “Chart Wizard” box.
18. Highlight the “Data series name” you wish to change.
19. Place your cursor in the text box titled “Name.” Type the name that you wish to title the “Legend entry” into the box.
20. Press the “Finish” button when you are done.

Read more ►

How to Change the Source of an Excel Pivot Table Using VBA

1. Create a PivotTable object in VBA so that you can update the source. Copy the code below and put it in your macro or function.Dim ptMyPivotTable As PivotTable
2. Connect your PivotTable object with your actual Pivot Table. Copy the code below.Set ptMyPivotTable = ActiveSheet.PivotTables(1)
3. Update the SourceData property of your PivotTable object to the new values. You can do this by copying the VBA code provided. Substitute your desired data range in place of 'A1' in the example.ptMyPivotTable.SourceData = Range('A1').CurrentRegion.Address(True, True, xlR1C1, True)To reference a range on a different sheet, you can use the following code.ptMyPivotTable.SourceData = Sheets('mySheetName').[A1].CurrentRegion.Address(True, True, xlR1C1, True)
4. Update the data actually displayed in your Pivot Table by using the VBA command below.ptMyPivotTable.RefreshTable
5. Release the resources you used in your PivotTable object by setting it equal to Nothing.Set ptMyPivotTable = Nothing

Read more ►

How to Convert Integers to Minutes Seconds in Excel

1. Double-click the Microsoft Excel 2010 icon on your computer's desktop with the left mouse button. This will open the program and display a blank spreadsheet.
2. Double-click a cell on the blank spreadsheet that appears after the program opens with the left mouse button. This will place the text cursor into the cell and allow you to enter data.
3. Press the '=' key on your keyboard. This informs Microsoft Excel 2010 that you would like to create an equation in that cell rather than simply display text.
4. Enter the integer you wish to convert to a minutes-and-seconds format using your keyboard.
5. Press the '/' key on your keyboard. This represents the division mathematical function.
6. Type '86400' using your keyboard. This represents the number of seconds in a day.
7. Press the 'Enter' key on your keyboard. This will calculate the equation and convert your integer into a decimal number.
8. Right-click the decimal number calculated in step seven with the right mouse button. This will automatically open a pop-up menu.
9. Single-click the 'Format Cells...' option from the pop-up menu to open the 'Format Cells' screen.
10. Single-click the 'Custom' option listed in the 'Category:' section on the left side of the 'Format Cells' screen with your left mouse button. This will automatically cause the 'Type:' section to appear.
11. Single-click the 'mm:ss' option listed in the 'Type:' section with your left mouse button. This option represents a format of minutes, followed by a colon, then seconds.
12. Single-click the 'Ok' button on the lower-right side of the 'Format Cells' screen. This will close the 'Format Cells' screen and automatically return you to your spreadsheet. The cell you entered data into will now display your integer in a minutes-and-seconds format.

Read more ►

How to Add Percentages to a Chart in Excel

1. Open the Excel 2010 spreadsheet where your chart is located.
2. Click on the first cell in the empty column -- or row if your data is arranged by rows -- next to the data table that makes up your chart. Type in the name of the column or row that you want to display as percentages in your chart, followed by the word 'percentage' or simply the '%' sign.
3. Enter the following formula into the cell just below, or to the right of, your header cell:=A2/sum(A:A)Change 'A2' to the first cell in the column or row that contains the data series you want to display as percentages. Change 'A:A' to the column letter or row number of the column or row where the targeted data series is located. Press 'Enter' to complete the formula.
4. Move your mouse over the fill handle in the lower right corner of the cell with your formula in it. Click and hold the mouse button, then drag your mouse toward the end of your data table. When you reach a cell that is level with the last cell in your data table, release the mouse button. Excel fills the entire row or column with your formula.
5. Click on the column letter or row number where your formulas are located. Click the 'Home' tab, then click the drop-down arrow in the 'Number' area of the ribbon. Choose 'Percentage' from the drop-down menu. The numbers in that column or row all turn into percentages.
6. Click on the data series on your chart where you want to add your percentages, then click the 'Layout' tab at the top of the screen, followed by the 'Data Labels' button in the Labels area of the ribbon. Choose one of the four data label options available in the drop-down menu.
7. Click on the data label attached to the first data point in your chart, then click it again to edit the label. Place your cursor into the formula bar at the top of the spreadsheet. Type in a '=' sign into the formula bar, then click on the cell from the series of percentages that you created which contains the percentage for the selected data point.
8. Press 'Enter.' The percentage appears on your chart. Repeat this process for every data label on your chart.

Read more ►

How to Use Excel's SUBTOTAL Function

1. Learn the syntax for SUBTOTAL. It is SUBTOTAL(function_number, reference_1, reference_2,...reference_i...,reference_n) where function_number is the number corresponding to the function to use for calculating the subtotal and reference_i are up to 29 references for which the subtotal will be calculated.
2. Examine the following function numbers and their corresponding functions: 1, AVERAGE; 2, COUNT; 3, COUNTA; 4, MAX; 5, MIN; 6, PRODUCT; 7, STDEV; 8, STDEVP; 9, SUM; 10, VAR; and 11, VARP. Note that these function numbers will include hidden values. Add 100 to these function numbers if you want the function to ignore hidden values.
3. Expect nested subtotals within the references to be ignored by the SUBTOTAL function to avoid counting them twice. Rows that are not included in a filter's result also will be ignored. SUBTOTAL will return the #VALUE! error value when any reference is a 3-D reference.
4. Enter the following values into the first column of an Excel spreadsheet:Row 1: Data;
Row 2: 110;
Row 3: 15;
Row 4: 165.
5. Look at some examples of SUBTOTAL based on the entries made in Step 4: =SUBTOTAL(9,A2:A4) will evaluate as SUM(110,15,165) or 290 because function 9 is the SUM function; =SUBTOTAL(1,A2:A4) will evaluate as AVERAGE(110,15,165) or about 96.67 because function 1 is the AVERAGE function.

Read more ►

How to Format Numbers in a Concatenate Function in Excel 2007

1. Click the cell in which you want to insert the concatenate function.
2. Type the function in this format:CONCATENATE('This is the contents of cell A1: ', A1, '. And this is the contents of cell B2: ', B2, '.')Anything you put in quotes, including numbers, will be reproduced as you wrote it. Outside of quotes, strings (like A1 above) will be interpreted as cell numbers, and the concatenate function will fill in the contents of that cell. For example, if cell A1 contains the number '123,' and B2 the number '456,' the above function would produce:This is the contents of cell A1: 123. And this is the contents of cell B2: 456.Remember, if you want to use fixed numbers in a concatenate function, enclose them in quotes.
3. Press 'Enter' to complete the addition of the function.

Read more ►

How to Define Cell Names in Excel 2003

1. Go to the Start menu and open Excel.
2. Decide which cells you would like to define. You can do this by highlighting them with your mouse. If you want to define multiple cells that are not next to each other, click on each of them and hold down the 'Ctrl' button.
3. Click on the name box, which is is directly above the 'A1' cell. Once you click on the cell, it will be ready for you to type the new name.
4. Type the new name for the cell(s). For example, if you are making a budget and you want to name the cells accordingly, you might name them 'debit' or 'bill.'
5. Press 'Enter' to save the name into the name box. If you forget to do this, your name will be lost.
6. Use the names to make your formulas simpler. Now you can use 'debit' as a part of your next formula. This simplifies everything.
7. Visit the Help section of Microsoft.com for more information on how to make formulas. There are a few things that you need to know to make your formulas work properly.

Read more ►

How to Replace All Occurrences of a Word in a Microsoft Word Document

1. Scan your document until you find an occurrence of the word that you want to replace.
2. Click your mouse to highlight the word.
3. Click the 'Home' tab at the top of the window.
4. Click 'Replace' in the 'Editing' section of the Ribbon at the top of the window.
5. Click inside the 'Replace With' field at the bottom of the window.
6. Type the word that you want to use as the replacement word, then click 'Replace All.'

Read more ►

How to Insert Page Breaks in Microsoft Excel 2003

1. Select the area where you wish to insert page breaks. To do this you will need to left-click on the area of the spreadsheet where you would like to insert a page break.
2. Insert the desired page break. Scroll to the “Insert” tab on the command bar and select “Page Break” to insert a page break.
3. Check “Print Preview” to see and edit page breaks. Scroll the “File” tab on the command bar and select “Print Preview” which will show you where your page breaks occur and how they will affect the printed spreadsheet. To see page breaks, left-click on the “Page Breaks Preview” and it will show you where your page breaks are.
4. Adjust page breaks as necessary. You can adjust the page breaks in the page breaks print preview menu simply by left-clicking on the corners and holding while dragging the page breaks where desired.

Read more ►