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 ►

How to Use Excel Effectively

Learning Excel
1. Open the program, and from the Help menu (the blue '?' button), access office.microsoft.com. You'll be asked to identify or let Microsoft identify the installed versions of Office products on your system. A browser will open.
2. Select the 'Tutorial' option on the help screen, which now displays in the Internet browser.
3. Select the first tutorial offered, explaining the differences between Excel 2000, 2003 and Excel 2007 and 2010. Follow onscreen instructions and lessons. Learning the improvements to the newer versions is key to efficiently using Excel.
Options
4. Select 'Options' from the Office Button in Excel 2007 and the File tab in Excel 2010 at the bottom of the window and make changes to the default options to make the basic program operation as personally efficient as possible for its regular use. In both versions, the Quick Access Toolbar can be customized to place buttons for commonly used commands. In Excel 2010, the Ribbon can also be customized.
5. Select 'Backup file when saving' In the 'Save' tab. This is unchecked by default. Back-up files are critically important, especially if converting from Excel 2000 or 2003 to the new versions. When the active workbook is saved, the older copy will be renamed with an 'wbk' file extension, allowing the file to be used again if the 'xlsx' file becomes corrupted or damaged.
6. Customize the Quick Access Bar and the Ribbon with commands used frequently. The Quick Access Bar, if placed below the ribbon (default is above ribbon) and customizing options resembles the tool bars that would have been used in earlier versions of Excel.

Read more ►

How to Skip Printing Rows That Have a Cell Value of Zero in MS Excel 2003

1. Open the Excel file you want to print.
2. Select 'Data' from the menu bar, then select 'Filter' and follow the right arrow to select 'AutoFilter' from that menu. Each of your column headings will now have buttons with down arrows next to them.
3. Click on the arrow button in the column that contains zeroes you want to suppress. For example, let's say your spreadsheet lists employee names in column A and the number of hours they worked in column B. You don't want to print any rows where the employee worked zero hours. You would click on the column B arrow.
4. Click on '(Custom...)' from the drop-down box to bring up the Custom AutoFilter setting. In the drop-down box under your column B heading, select 'does not equal' and in the empty drop-down box to the right of it, select '0.'
5. Click 'OK.' Your list is now filtered and rows with zeroes are hidden.
6. Print your document.

Read more ►

How to Convert True

1. Click the 'Developer' tab at the top of an Excel worksheet. Then click the 'Insert' drop-down menu in the 'Controls' group.
2. Click the check box image in the 'Form Controls' section of the drop-down menu. This changes your mouse pointer to a cross.
3. Click anywhere in the worksheet to insert the check box with a description next to it.
4. Right-click the description next to the check box, then left-click the description until you see a blinking text cursor.
5. Press 'Backspace' or 'Delete' to erase the description that is automatically shown. Then type your own description. Click outside the description area in a blank cell when you are finished. For example, type 'Sales quota met?' as a description.
6. Right-click the check box, and click 'Format Control' on the pop-up menu to bring up a 'Format Control' window.
7. Click the 'Control' tab at the top of the window.
8. Click in the 'Cell link' text box and type the cell to which you want to link the check box. For example, click in the cell link text box and type 'A1.' Cell A1 will now show either 'TRUE' or 'FALSE' depending on whether the check box is checked or unchecked.
9. Click 'OK' to close the 'Format Control' window.

Read more ►

How to Make Bingo Cards in Excel

1.
Open a new, blank Excel worksheet. Select cells 'A1' through 'E6.' Use your mouse by clicking on the first cell and dragging down and across while holding the mouse button, or use your keyboard by clicking inside the first cell, holding down the 'Shift' key and using the arrow keys on your keyboard.
2.
Click the 'Border' dropdown, which is on the 'Formatting' toolbar in Excel 2003 or earlier and on the 'Home' tab of the ribbon in the 'Font' group in Excel 2007. Click the 'All Borders' option to apply borders to all of your selected cells.
3.
Keep the cells selected and change the height and width of the cells. In Excel 2003 or earlier, go to the 'Format' menu, point to 'Row' and choose 'Height.' In Excel 2007, go to the 'Format' dropdown from the 'Home' tab and select 'Row Height.' Enter '90' for the height and click 'OK.' Go back and select 'Column Width,' enter the number '15' and click 'OK.'
4.
Center the cell selection on your spreadsheet. In Excel 2003 or earlier, click 'File' and go to 'Page Setup,' and then click the 'Margins' tab. In Excel 2007, go to the 'Page Layout' tab of the ribbon, click on 'Margins' and choose 'Custom Margins.' Select 'Center on Page Horizontally' and 'Center on Page Vertically,' and then click 'OK.'
5.
Click on cell '4C.' Go to the 'Insert' menu in Excel 2003 or earlier, point to 'Picture' and select 'AutoShape.' In Excel 2007, go to the 'Insert' tab and select 'Shapes.' Choose a shape for the 'Free' space and insert it into cell '4C.' Right-click the shape and choose 'Add Text,' then type the word 'Free.' Right-click again and choose 'Format AutoShape.' Add color to the shape on the 'Colors and Lines' tab, and go to the 'Font' tab to change the font, if desired.
6.
Select cells 'A1' through 'E1.' Right-click and choose 'Format Cells.' Go to the 'Font' tab and choose a large, bold font size and color, such as 'Arial Rounded Bold,' size '24' in red. Go to the 'Alignment' tab and select 'Center' in both the 'Horizontal' and 'Vertical' dropdowns. Click 'OK.' Enter an upper case 'B' into cell 'A1,' 'I' into 'B1' and so on, entering the word 'BINGO.'
7.
Save the bingo card template. When you are ready to use it, enter the numbers, letters, words or symbols you want to use in random order, making each card unique. Print them out on cardstock or heavy paper.

Read more ►

How to Run a Pivot Table

1. Click and hold the mouse button over the top-left cell in the data that you want to create a table out of. Drag the mouse to the bottom-right cell of the data and release the mouse button.
2. Select the 'Insert' tab at the top of the screen. Then click the 'PivotTable' button located at the left side of the toolbar. Click 'OK' in the window that opens up. You will be taken to a new page that contains your PivotTable.
3. Place a check mark next to the fields in the field list that you want to compare. The field list is the window to the right of the Excel sheet. It contains one long space for your different fields, and four smaller ones that correspond to parts of the PivotTable. When you place the check marks, Excel will move the field into one of the smaller boxes and your table will start to take shape.
4. Drag and Drop the fields into the boxes where you want them. The 'Row Labels' box will put the data in a column on the left side of the PivotTable. The 'Column Labels' box will put the data in a row across the top. The 'Values' box will put the data into the middle of the PivotTable, sorting it based on the row and column labels. The 'Report Filter' box will allow you to filter the entire PivotTable by the fields in the box. Use the labels to set up your data, and put the data that you want to analyze in the 'Values' box.
5. Click on the field in the 'Value' list and choose 'Value Field Settings.' You can now change how the PivotTable will report the data form that field. It defaults to a count, essentially a '1' if there is data and a '0' if there isn't. You can change it to 'Sum,' where it will add the values together, or several other mathematical functions.
6. Use the 'Refresh' button in the toolbar if your original data has changed. Excel essentially takes a snapshot of the data when it creates the PivotTable. If you change the data, you have to refresh the PivotTable before you will see the changes. Likewise, if you need to change the columns in your original data field, press the 'Change Data Source' button and you can choose a new data set.
7. Click on the blue question mark in the upper-right corner to access the Microsoft Online Help for Excel 2010. From there you can learn about all the other features and functions of PivotTables. While the majority of what you will do in PivotTables will involve simply move fields around, as you get more advanced there are a ton of options to make more complicated tables.

Read more ►

How to Fix Circular Formulas in Excel

How to Fix Circular Formulas in Excel--Directly Referenced Cell
1.
To demonstrate this type of circular formula and the resolution of the problem a simple bank reconciliation spreadsheet is used. Set up an Excel spreadsheet as follows: in row 1 label Column A: Balance, Column B: Debit, Column C: Credit, Column D: To, Column E: Reference, Column F: Date and Column G: Cleared Bank.
2.
In row 2 enter: a $500 credit in the 'Credit' column, 'Deposit to open account' in the 'To' column, and a date in the 'Date' column. In the 'Balance' column on row 3 enter the following formula: =A3 C2-B2, with the intent that this formula would take the prior balance, add any deposits and subtract any debits. When you enter this formula you will get an error message stating that a circular reference has been created. You can either select 'OK' or 'Help' to fix the reference yourself or 'Cancel' to ignore the circular reference. If you select 'OK' or 'Help' a pop-up window will open that will give you more information about circular references.
3.
In addition to the pop-up window that provides more information about circular references a toolbar opens when you select 'OK' or 'Help.' This is the Circular Reference toolbar. If you select the drop-down arrow on the toolbar it will show all circular references in the current workbook. You can go directly to the circular reference by selecting it from the drop-down list.
4.
Fixing the circular reference can be done by first selecting the cell and then placing your cursor in the formula bar. This color codes the formula to the actual cells on the worksheet that are referenced in the formula. In this example, you can see that the cell A3 references itself in the formula.
5.
The algebraic equivalent to this would be the formula: x = x y - z, which would only hold true in one instance, where y and z = zero. To correct this formula, change the formula in A3 to reference cell A2 instead of cell A3. This can be done by typing directly into the formula bar, dragging the colored border that is around cell A3 so that it is around cell A2 or retyping the formula.
How to Fix Circular Formulas in Excel--Indirectly Referenced Cell
6. To demonstrate indirectly referenced circular formulas, we have simply added a column to the practice worksheet and labeled it 'Interest Paid.' In row 2 of that column enter the following formula: =A3*0.03, with .03 representing interest paid on the balance. In row 3 in the Balance column enter the following formula: =A2 C2-B2 D2. The algebraic equivalent to this would be the formula: x = w y z (x *.03).
7.
When you enter this formula you will get an error message stating that a circular reference has been created. You can either select 'OK' or 'Help' to fix the reference yourself or 'Cancel' to ignore the circular reference. If you select 'OK' or 'Help' a pop-up window will open that will give you more information about circular references.
8.
In addition to the pop-up window that provides more information about circular references a toolbar opens when you select 'OK' or 'Help.' This is the Circular Reference toolbar. If you select the drop-down arrow on the toolbar it will show all circular references in the current workbook. You can go directly to the circular reference by selecting it from the drop-down list. Since this is an indirectly referenced circular formula an arrow will point from the cell that has the circular reference back to the cell that refers to that cell. In this example, the arrow points from A3 back to D2, indicating that A3 refers to D2 for its calculation and that D2 refers to A3 for its calculation.
9. To correct this formula, change the formula in D2 to reference cell A2 instead of cell A3. This can be done by typing directly into the formula bar, dragging the colored border that is around cell A3 so that it is around cell A2 or retyping the formula.

Read more ►

How to Change Hyperlink Font in Excel 2003

1. Run Excel 2003 and open the spreadsheet that contains the hyperlink you wish to edit.
2. Click the cell above the cell that contains your hyperlink, then press 'Enter' to move down to your hyperlink cell. Doing so allows you to select the hyperlink cell without clicking on it and opening the link in a Web or file browser.
3. Click 'View' in the File menu, then click 'Toolbars' and 'Formatting' to activate the text formatting toolbar. Skip this step if the text formatting toolbar is already activated.
4. Click the 'Font' drop-down menu located in the Formatting toolbar and select the font that you wish to use for the hyperlink.
5. Click the 'Font Size' drop-down menu to choose the hyperlink's font size.
6. Click the 'Bold,' 'Italic' or 'Underline' icons to apply font formatting to the hyperlink.

Read more ►

How to Import Data From Multiple Spreadsheets

1. Open a new blank workbook. Begin the installation process by clicking the 'file' tab and selecting 'Options.' Select 'Customize Ribbon' in the 'Excel Options' dialog.
2. Select 'All Commands' in the 'Choose commands from:' drop-down menu. In the left-hand pane, select 'Compare and Merge Workbooks' and click 'Add.' You will be given the option of which ribbon you want to place the new function. Click 'OK.'
3. Put all of the worksheets and workbooks you want to merge into one folder in your hard drive. Locate the 'Compare and Merge Workbooks' function, which will have been saved in the ribbon of your choosing. Click it, and then select which workbooks you want to merge.

Read more ►