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 ►

How to Print a Large Excel Spreadsheet

1. Set the print area by selecting the top left corner of the area you wish to print, and dragging to the bottom right. This will create an outline around the area you wish to print. Click 'File,' 'Print Area' and 'Set Print Area.'
2. Click 'File' and 'Print Preview.'
3. Set the page size to the paper you will be using. The standard is A4.
4. Set the scaling. Try checking 'Fit to one page(s) wide by one page(s) tall' box. If the percentage showed in the toolbar changes to below 40 percent, the text will probably be too small to read. If not, click on the page to view a print preview and check if the spreadsheet is big enough to be understood. Choose a bigger percentage if not.
5. Reset the margins. You may need to click the 'Margins' icon in the toolbar to show the margins if they do not show up automatically. Drag along the margin to shrink it, and create more usable space.
6. Click 'Print.'

Read more ►

How to Auto Fill in a Cell in Excel

1. Click the first cell that you want to include in the data range.
2. Type the first value for the series.
3. Type the second value in the next cell to establish a pattern.
4. Click the first cell and drag your mouse to the second cell to highlight both cells.
5. Hover your mouse over the Fill Handle, located in the lower-right corner of the highlighted cells.
6. Drag the Fill Handle across the range of cells that you want to auto fill.

Read more ►

How to Make a Drop

1. Type the entries you want in the drop-down box. Place one word in each cell in a single column. For example, you may want a drop-down box in cell A1 limited to red, yellow and blue. Type 'Red' in cell 'B1,' 'Yellow' in cell 'B2' and 'Blue' in cell 'B3.'
2. Click on 'Data > Validation > Settings' in Excel 2003 or 'Data > Data Validation > Data Validation' in Excel 2007.
3. Click on 'List' in the Allow box.
4. Enter the location of the inputs for the list box. In the above example, the inputs are in cells B1 to B3, so enter '=B1:B3.' Click on the 'In-cell drop-down' box if it isn't already checked.
5. Click on 'OK.'

Read more ►