How to Rotate a Worksheet in MS Excel 2003

1. Select the entire table you want to rotate by left clicking at the top, left cell, dragging the mouse down to the bottom, right corner, and releasing.
2. Press 'Ctrl' and 'C' at the same time to copy your table.
3. Select a cell somewhere outside of the table you're rotating. You can even select a cell on a different worksheet entirely.
4. Click the black, down arrow under 'Paste' in the Clipboard section of the Home tab. Select 'Paste Special.'
5. Click the 'Transpose' check box, then click 'OK' to paste the transposed data.

Read more ►

How to Create an Email Distribution Mailing List in Excel

1. Open Microsoft Excel. Start with a new blank document.
2. Type column headers across row one. Your emails created from the distribution list can include any type of personalized information you desire. The most important column that must be included is the actual email address, so be sure one column header says 'Email' or 'Email address' to make this clear. Alternately, you may include first and last names or other information that will be unique for each email.
3. Enter the data for each recipient on a separate row. The first recipient in the email distribution list will be listed on row two, directly under the column headers. Type the email address in the appropriate column and any other information required by your distribution list, such as the recipient's name.
4. Save the Excel document under any file name you choose. Your email distribution list is now complete.

Read more ►

How to Calculate Subtotal

Calculating a Subtotal in a Few Easy Steps
1. Obtain a data set. This means that you need to have a set of numerical values listed. Using the example of a checking account deposit, this would be the checks and/or cash amounts that you need to deposit. Deposit slips have blank boxes for you to fill in these values.
2. Write your values down. For instance, you may have a check for $50.27, a check for $85 and $75 in cash that you wish to deposit. In the section for checks on your deposit slip, you would write 50.27 and 85.00. In the blank section for cash, you would record 75.00.
3. Add your data set. Using a calculator or just old-fashioned math skills, you should total your figures. In this example, you would perform the following operation: 50.27 85.00 75.00 = 210.27. This is your subtotal.
4. Perform any additional mathematical steps to your subtotal. Once you've obtained the subtotal, you may need to complete additional steps. For instance, if you are depositing money, but you want to keep out some of the money, you have to subtract from your subtotal. In this example, assume you want to keep out $15.50 from the deposit. You would subtract this amount from the subtotal, as illustrated with the following equation: 210.27 - 15.50 = 194.77. Your final deposit would be $194.77.

Read more ►

How to Set the Defaults for an Excel Comments Box

Set Excel Comment Defaults in Windows XP
1. Right-click the desktop, avoiding any icons. Select 'Properties' to open the 'Display Properties' dialog box.
2. Go to the 'Appearances' tab. Click the 'Advanced' button to open the 'Advanced Appearance' dialog box.
3. Select 'Tooltip' from the 'Item' list near the bottom of the dialog box.
4. Select the new default color for Excel comments in the 'Color1' box. Choose a default font in the 'Font' box, a font size in the 'Size' box and a font color in the 'Color' box.
5. Click 'OK' to apply the changes. Close any open dialog boxes.
Set Excel Comment Defaults in Windows Vista
6. Right-click the desktop, avoiding any icons. Select 'Personalize' to open the 'Personalize' window.
7. Select 'Windows Color and Appearance.'
8. Click 'Open Classic Appearance Properties for More Color Options' at the bottom of the 'Windows Color and Appearance' window to open the 'Appearance Setting' window.
9. Click the 'Advanced' button to open the 'Advanced Appearance' dialog box. Select 'Tooltip' from the 'Item' list near the bottom of the dialog box.
10. Select the new default color for Excel comments in the 'Color1' box. Choose a default font in the 'Font' box, a font size in the 'Size' box and a font color in the 'Color' box. Click 'OK' to apply the changes. Close any open dialog boxes or windows.
Set Excel Comment Defaults in Windows 7
11. Click the 'Start' button. Type 'Window Colors' into the 'Instant Search' box at the bottom of the Start menu and press 'Enter.' The 'Windows Color and Appearance' window will open.
12. Click 'Advanced Appearance Settings' at the bottom of the window.
13. Select 'Tooltip' from the 'Item' list near the bottom of the dialog box.
14. Select the new default color for Excel comments in the 'Color1' box. Choose a default font in the 'Font' box, a font size in the 'Size' box and a font color in the 'Color' box.
15. Click 'OK' to apply the changes. Close any open dialog boxes or windows.

Read more ►

How to Find Cells With Strikethrough in Excel

1. Open Microsoft Excel. Hold the 'Control' key and press the 'F' key on the keyboard. The combination opens the'Find' function.
2. Click on the 'Format' button in the 'Find and Replace' window. Click on the 'Fonts' tab.
3. Check the 'Strikethrough' checkbox in the 'Effects' section and click the 'OK' button.
4. Click the 'Find all' button in the 'Find and Replace' window.
5. Look at the bottom of the 'Find and Replace' window. All the cells with 'Strikethrough' are listed at the bottom of the window.

Read more ►

How to Convert Hours to Seconds in Excel

1. Open a new workbook in Microsoft Excel.
2. Enter the time in a blank cell such as 6:20:35 in A1.
3. Click on a blank cell and enter the following formula: =(HOUR(cell)*60*60) (MINUTE(cell)*60) SECOND(cell), where cell refers to the cell reference that contains the time. The formula extracts the hour, minutes, and seconds from the time. It multiplies the hours by 60 to convert into minutes, then multiplies by 60 again to get seconds. The minutes are multiplied by 60 to get the seconds, and the seconds are added to the calculation to get the total seconds.For example, the formula =(HOUR(A1)*60*60) (MINUTE(A1)*60) SECOND(A1) would bring back 22,835 seconds.
4. Format the cell as general by right clicking on the cell and selecting the 'General' category in the 'Number' tab of the 'Format Cells' window.

Read more ►

How to Change the Password in Excel

1. Open the Excel spreadsheet you want to edit. If the file already has a password configured, enter the password and click 'OK.'
2. Click 'File' in the main menu toolbar and select 'Save As.' In the window that opens, click the 'Tools' button to open a dialog box for advanced settings.
3. Click 'General Options.' In the text box labeled 'Password to modify,' enter a new password for your Excel file. Press 'OK.'
4. Click 'Save' to save your new password settings. The Excel file saves to the hard drive and the password is modified.

Read more ►

How to Convert Phone Numbers in MS Excel

1. Open Microsoft Excel. Open the file you’d like to work on by going to “File”, then “Open,” or begin a new workbook using the blank workbook that opens by default.
2. Select the cell that has the numbers typed to be converted to a phone number format. If you have multiple cells that need to be converted, select them all by holding the left mouse button and dragging the mouse.
3. Locate the “Format” option on the toolbar and click once. This will bring up a drop-down menu. Click on “Cells” to bring up a formatting box. You can also pres “Ctrl” “1” to bring up the box.
4. Click “Special” on the “format cells” box. This will bring up four options on the right-hand side, click on “Phone Number” and then click “OK.” This will close the box and format the number to the correctly display in phone number format.

Read more ►

How to Remove a Title Chart in Excel 2003

1. Open the Excel 2003 chart that contains the title you wish to delete.
2. Click the chart title once.
3. Hit the 'Delete' key to delete the chart title in Excel 2003.

Read more ►

Excel Macro Online Tutorial

1. Navigate to the Brown University Excel macros tutorial listed in References. The guide walks you through running macros, creating macros, and running macros using toolbar buttons and shortcut keys. The guide offers plenty of examples and an advanced section on how to edit macro code. The instructions for creating and running the macros are applicable to Excel 2003, but the concepts are the same for Excel 2007.
2. Go to the Help With PCs website listed in the References section. This website includes an Excel macros tutorial, complete with screen shots to help you see what actions you are performing. The beginning tutorial is a guide to creating a simple macro and playing it back. The guide is applicable to Excel 2003.
3. Load the Florida Gulf Coast University website listed in References. Click on 'Macros' toward the bottom on the page to take you to an Excel 2007 online macros tutorial page. The site also offers a variety of other basic help for Excel 2007, accessible by clicking on any menu item.

Read more ►

How to Remove a Sort in Excel 2007

1. Click the 'Office' button at the top left of the Excel interface, then click 'Excel Options,' 'Popular' and 'Edit Custom Lists.' In versions of Excel earlier than 2007, click 'Tools,' 'Options,' then 'Custom Lists.'
2. Click the list you want to delete to select it.
3. Click 'Delete,' then click 'OK.'

Read more ►

How to Sort by Time in Excel 2007

1. Place titles in the top boxes of every column that you wish to fill. For example, if you are listing phone calls, you might want to list the time, date, name and length of the call.
2. Format each column by clicking on the first box under the title box and then holding the 'Shift' key while you press the 'down' arrow. When the number of boxes you will be use are selected, choose the 'Home' tab to see the 'Numbers' group. Click 'Time' for the time column. The rest of the columns can be formatted in the same way but use the option of 'Date' or 'Number.'
3. Highlight the column again to choose a specific format for time and click on the small arrow at the bottom-right corner of the 'Number' group box. This will bring up the 'Format Cells' menu and show all the options available for formatting the text listed. Within the 'time' option, there are several specific formats from which to choose.
4. Group all the completed entries used so far by highlighting them and then sort the entries by the time. Choose the 'Data' tab and then look at the 'Sort and Filter' group. Choose the 'Sort' option to open the menu. Pick the column that holds the time value as the sorting column and then the 'A to Z' option for the earliest to latest time.

Read more ►

How to Enable Macros in Microsoft Excel 2007

1. Click the Microsoft Office button located in the upper left corner of the computer screen.
2. Select 'Excel Options' from the menu.
3. Click 'Trust Center' to open the 'Excel Trust Center.'
4. Select 'Trust Center Settings.'
5. Click 'Macro Settings' to modify the settings for macros within Microsoft Excel 2007.
6. Select 'Enable all macros' to allow all macros in your spreadsheets to run.

Read more ►

How to Make a Line Graph That Compares Two Things in Excel

1. Open a new Microsoft Excel 2010 spreadsheet.
2. Click on cell 'B1.' Enter the name of the first set of data you want to include in your graph. This name will appear as a label next to the line on the graph. Click on cell 'C1' and do the same for the second set of data.
3. Click on cell 'A2.' Enter the X-axis labels into the cells in this column. While the 'Y-axis' in a line graph is always numerical, the X-axis can display numbers, dates, times or even text.
4. Enter your data into the cells just under the headers in columns 'B' and 'C.'
5. Click any cell in your data table. Select the 'Insert' tab at the top of the screen. Click the 'Line' button under 'Charts' and choose one of the line chart types. You can choose a regular line chart, on which each line is plotted based on its value; a stacked line chart, on which the second data set is added to the first; and a 100 percent stacked chart, on which each line is plotted as a percentage of the sum of the lines. Click your selection to create the chart. Excel automatically colors the lines differently to provide contrast between the two data sets.

Read more ►

How to Divide Excel Pivot Table Data Into Separate Spreadsheets Within the Same Workbook

1. Click on the worksheet in the Excel file that contains the Pivot Table. You can do this by clicking the appropriate worksheet tab at the bottom of the spreadsheet window.
2. View the Pivot Table and identify the summary calculations along its right side. Pivot Tables can create many different types of calculations, but all are based on the groups indicated in the Pivot Table, and the results of these calculations appear to the right of each group's row.
3. Double-click a result calculation in a single row of the Pivot Table. All the records from the original spreadsheet that comprise that Pivot Table group are instantly copied and pasted into a new spreadsheet in the same workbook. The column headers remain intact.
4. Click back to the worksheet that contains the Pivot Table.
5. Double-click the result calculations for each of the other rows in the Pivot Table, using this same process. Excel creates a new spreadsheet for each group. You will have to click back to the Pivot Table worksheet after creating each spreadsheet so you can move on to the next row. Since the Pivot Table contains groups that summarize all the original spreadsheet data, the entire data source is divided into separate spreadsheets after you finish this process.
6. Click the worksheet tabs at the bottom of the Excel window to view the different spreadsheets in this workbook.

Read more ►