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 ►

How to Add Chart Legends in Excel 2010

1. Double-click the Excel 2010 file that you want to work with to open up the spreadsheet.
2. Click anywhere on the chart to select it. Then click the “Layout” tab at the top of the screen.
3. Click the “Legend” button, which is located in the Labels area of the ribbon. Choose one of the four direction buttons to place the legend above, to the right, to the left or below the chart. Alternatively, click either of the “Overlay” buttons to place the legend at the right or left side of the chart, overlapping the chart itself.
4. Right-click the legend on the chart, and choose “Format Legend” from the pop-up menu. The Format Legend window will appear.
5. Select any of the options on the left side of the window other than “Legend Options” to adjust how the legend will appear on your chart. These settings will let you add a filled-in background, adjust the border color or style, add a shadow element and adjust the edges of the legend. Click “Close” when you are done adjusting the legend’s appearance.

Read more ►

How to Make a Grid in Excel

1. Decide on the size of each cell, and how many rows and columns to use. This example creates a grid of cells that is nine rows long and seven columns wide with cells measuring 1-inch square.
2.
Click on cell A1 in the upper left and while holding the left mouse button, drag the selection to cell G9 in the lower right.
3. From the 'Format' menu, choose 'Row,' then 'Height' to display the 'Row Height' dialog box. Excel measures the row height in points, with roughly 72 points per inch. Enter a row height of 72, then click 'OK' to close the dialog.
4. From the 'Format' menu, choose 'Column,' then 'Width' to display the 'Row Width' dialog box. Excel measures the column width in the number of standard characters that fit into the width, with roughly 13 characters per inch. Enter a row width of 13, then click 'OK' to close the dialog.
5.
If the grid is too big to fit on one page, reduce the cell dimensions or adjust the page numbers by choosing the 'File' menu, then 'Page Setup.' In this case, the left and right margins of the page are reduced to 0.5 inches each.
6. With the cells still selected, choose the 'Format' menu, then 'Cells' to display the 'Format Cells' dialog box.
7.
Click the 'Borders' tab.
8. Click on a 'Style' in the right 'Lines' box to define the border appearance.
9.
In the left 'Presets' box, click the 'Outline' and 'Inside' buttons to draw borders on the grid.
10. Save or print the grid as needed.
11.

Read more ►

How to Convert XPS Files

1. Download and install an XPS file converter. You can download such a program from sites like 'Verydoc.com/', 'NovaPDF.com' and 'OpenXML.biz/XPSconvert.html'.
2. Launch the XPS converter program. Most likely, there will be a new desktop icon for the program. If not, you can find it under 'Start,' 'All Programs'.
3. Click and drag the XPS file into the main viewing area of the converter program.
4. Select an output location. Depending on the program you are using, there most likely is a browse button that allows you to select any location on your computer as a save location.
5. Select an output format, if you are given the option. Most XPS file converters simply convert the file into a PDF. Click 'OK' and the file is converted to the desired file format.

Read more ►

How to Learn Excel VBA Online

1. Learn Excel VBA. Look for nonmacro solutions before you start messing with VBA. If you don't know Excel's capabilities well, you're likely to write macros that do things you could accomplish instead with good spreadsheet design and a few mouse clicks.
2. Navigate to Microsoft's VBA for Excel 2003 training page. There is no equivalent page for Excel 2007, but you won't need version-specific knowledge until you've mastered the fundamentals of VBA.
3. Watch the introductory videos and work through the textual tutorials that introduce programming with VBA. There are three courses. Complete them, do the practice sessions and take the tests.
4. Complete the VBA tutorials at xlpert.com and xl-vba.com. Xlpert offers a free eight-lesson course, while xl-vba's course has 23 lessons. The writing doesn't sparkle and there's a lot missing (to encourage you to buy a complete course), but the material will reinforce what you learned from Microsoft's site. Repetition is useful when learning a new language.
5. Build a spreadsheet that does something useful for you, then turn it into a macro-driven application. When you feel stymied--and you will from time to time--press the F1 key to activate Excel VBA's help system. You can learn VBA entirely from the help system, but it would be very hard if you're not already a programmer.
6. Visit Microsoft's developers' forums to research problems and ask questions of other programmers. A link below leads to the forums page where you'll find a list of several Excel-related discussion groups.

Read more ►

How to Define a Table in Excel 2007

1. Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.
2. Click on the 'Insert' tab at the top of the document.
3. Find the 'Tables' group, then click on 'Table.' The 'Create Table' dialog box will appear.
4. Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.
5. Check the 'My Table Has Headers' box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.
6. Hit the 'OK' button at the bottom of the Create Table dialog box to create your table.

Read more ►

How to Calculate Population Standard Deviation Using Excel

1. Add the numbers in the first column of your Excel 2007 document. For example, add the numbers 15.4,13.2,11.1,12.5,11.3 and 13 in A2, A3, A4, A5, A6 and A7.
2. Click on the 'A9' cell for this example. This is the cell where you will calculate the standard deviation. When you calculate another standard deviation, choose any cell at the bottom of the list of numbers you are using.
3. Click on the 'Formulas' tab while you are in the 'A9' cell. Click on 'Statistical' on the drop-down menu.
4. Click 'Insert Function' on the top left-hand side of the Excel spreadsheet. The 'Insert Function' window will pop open.
5. Click on the drop-down menu of 'Or select a category.'
6. Scroll down the 'Select a function' window. Choose 'STDEV,' which is the function of standard deviation based on the sample.
7. Click 'OK.' The 'Functions Arguments' window will pop open. Ensure that on 'Number 1' cell, A2:A7 is populated. If A2:A7 is not populated, enter A2:A7 manually. Click 'OK.'
8. The standard deviation has been successfully calculated in the 'A9' cell. In this example, the calculated value of the standard deviation is 1.560449.

Read more ►

How to Insert a Checkbox in Excel 2007

1. Click on the 'Developer' tab.
2. Click 'Insert' then 'Check Box' under 'Form Controls.'
3. Click where you want the check box to appear on the spreadsheet.
4. Click 'Properties' on the 'Developer' tab. Edit the properties you want to have on your check box.

Read more ►

How to Select Multiple Entries From the List in Excel 2003

1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office' in the list of programs, then click 'Microsoft Excel' to open the software.
2. Click the 'File' ribbon tab at the top of the Excel software. Click 'Open' to view the 'Open' dialog window. Double-click the Excel file you want to use.
3. Click the first cell you want to select. Hold the 'Ctrl' key and use the mouse to click each cell you want to select.
4. Right-click one of the selected cells and select 'Copy.' The cells' contents copy to the Windows clipboard. You can now move the content to a new program window or copy the cells to a new spreadsheet.

Read more ►

How to Align Decimal Points in a Word Table

1. Open the saved Word table.
2. Click the “View Ruler” button at the top of the right vertical scroll bar to display the horizontal ruler and left ruler near the document.
3. Click the “Tab” selector at the top of the left ruler to bring up the “Decimal” tab. The “Decimal” tab symbol displays one horizontal line, one vertical line and a decimal on the right side. Usually, this “Decimal” symbol appears on the third click.
4. Click and drag the cursor on the column that will contain the decimal tab stop. This column will appear highlighted.
5. Click the horizontal ruler where you wish to insert the decimal tab stop. A dashed vertical line will temporarily appear where you clicked.
6. Click in the cell. A vertical bar will indicate where the decimal will line up.
7. Type the number with the decimal point. Continue typing numbers in the column. The decimal points will line up vertically.

Read more ►

How to Change Default Fonts in Excel

Change the Font Attributes in a Worksheet
1. Select the cell, or group of cells, that you want to format. To select one cell, place the mouse pointer on the cell and click the left mouse button. To select a group of adjacent cells, click on one of the cells and drag the mouse pointer to highlight all the cells in the group.
2. Locate the font box on the tool bar. Click the arrow on the right side of the box to see the drop down menu. The menu contains the various fonts.
3. Change the default font. Use the scroll bar on the right side of the menu to see all the fonts available. Click on a font to select it.
4. Change the font size. Click on the font size box, located on the right side of the font box, to select a new font size. You can also increase the font size with the 'Increase Font Size' button or decrease it with the 'Decrease Font Size' button.
Change the Font Attributes in a Workbook
5. Open the 'Options' dialog box. Click on 'Tools' on the tool bar and select 'Options.' This opens the Options dialog box in which you can change the default attributes of your workbook.
6. Change the default font. Click the 'General' tab and then click the arrow in the 'Standard font' field. Select a new font from the list.
7. Change the font size. Click the 'Size' box and select a new font size.
8. Click 'OK' when you have finished making your changes. You will have to restart Excel in order for the changes to take effect.

Read more ►

How to Install Word, PowerPoint and Excel Only

1. Place your Microsoft Office disc into the optical drive of your computer to begin the installation.
2. Enter the Microsoft Office product key in the field and click 'Continue.' Accept the software agreement and again press 'Continue.'
3. Click the button 'Customize' and select the tab 'Installation Options' to display the list of all programs included in the Microsoft Office package.
4. Right-click on each program in the list except Microsoft Word, Excel and PowerPoint, and select the option 'X Not Available' from the menu. This will prevent those unneeded programs from installing
5. Click the button 'Install Now' on the bottom of the installation window.
6. Restart the computer when prompted to finish up the Microsoft Office installation process.

Read more ►

How to Disable a Macro in Excel 2003

1. Open Excel 2003. Select 'Tools' on the menu bar. Click 'Macro' and 'Security.' The Macro Security dialog box appears.
2. Select 'High.' This will disable all macros that are not from a trusted source. Select 'Very High.' This will only allow macros to run if they are in a trusted location. So using these two choices will disable any macros that are not from trusted source or in a trusted location.
3. Click 'OK' to confirm the macro security changes in Microsoft Excel 2003.

Read more ►