How to Determine Quarter in Excel 2003

1. Open Microsoft Excel.
2. Type a date in cell A1. For example, type '4/11/2010' in cell A1.
3. Type the following formula in cell A2, '=CHOOSE(MONTH(A1),'Q1','Q1','Q1','Q2','Q2','Q2','Q3','Q3','Q3','Q4','Q4','Q4') '-' RIGHT(YEAR(A1),2).' Cell A2 now displays 'Q2-10.'

Read more ►

How to Footnote in Excel

1. Select the 'Page Layout' tab.
2. Click on the dialog box launcher on the 'Page Setup' group. The dialog box launcher is the little arrow in the bottom right corner of the box. The 'Page Setup' window will pop up.
3. Click on the 'Sheets' tab.
4. Locate the 'Comments' drop down menu. Select 'At end of sheet.' This will make sure all of your footnotes appear at the bottom of the document.
5. Click 'Print.' All comments that are hyperlinked to a cell will be included below the spreadsheet.

Read more ►

How to Print a Chart in Microsoft Excel With Lines

1. Open the Microsoft Excel document that you want to print with gridlines.
2. Click on the worksheet tab that you want to print, in the bottom left of the document.
3. Highlight all of the cells and gridlines that you want to print.
4. Click on the 'Page Layout' tab and find the 'Print Area' group. Click 'Set Print Area' to select the highlighted cells as the printable area of the document. This is an optional step. Note that if you do not set the print area, Excel will only print the data and its accompanying cells.
5. Locate the 'Sheet Options' group in the 'Page Layout' tab. Place a checkmark next to 'Print' in the 'Gridlines' section.
6. Preview the document by pressing 'Ctrl' and 'F2' simultaneously. This opens the 'Print Preview' window. Click 'Close Print Preview.' Make necessary changes and repeat this step until you are happy with your document.
7. Click the 'Office' button in the top left of the window and select 'Print.' Click 'OK' to print the document with lines.

Read more ►

How to Create Graphs in Excel with Multiple Columns

1. Enter the data for the desired chart into an Excel spreadsheet. Title any columns or rows as required.
2. Highlight all data you wish to include in the chart. To highlight cells, click your mouse, and while holding down, drag it to include all desired information.
3. Click the 'Insert' tab, and in the charts group, click 'Column.' Select the 2-D stacked column chart and it will be generated automatically.
4. Edit the layout and style of the chart, label the various components and edit the size of the chart by clicking on the chart to generate a chart tools tab with three sub-tabs of design, layout and format.
5. Save your work by clicking 'File' then 'Save As' and a window pops up. Insert a name for the file and click 'Save.'

Read more ►

How to Merge a Last Name and First Name in Excel 2007

1. Launch Microsoft Excel. Locate the spreadsheet that contains your name information and open the file.
2. Click in the first cell of an empty column beyond the spreadsheet area that contains your data. Click 'Insert Function' from the 'Function Library' group of the 'Formulas' command tab and choose 'Text' from the list in the dialog box.
3. Select 'Concatenate' from the 'Select a function' list and click on the 'OK' button. Click in the 'Text1' box in the dialog box and enter the ID of the cell that contains the part of the name--last or first--that you want to be the first part of your concatenated text. To choose the cell by clicking on it instead of entering its ID, click on the 'Collapse Dialog' button. It looks like a set of spreadsheet cells with a small red arrow pointing up toward the top left corner of the button. Once the dialog box is out of your way, click on the cell that contains your desired data, then click on the 'Restore Dialog' button. This button has a small red arrow pointing down from a box that represents a cell boundary.
4. Type a double quote mark into the 'Text2' box, followed by any text you want to appear between the two parts of the name, then another double quote mark. If you're combining last name first, then first name, you'll want a comma and a space between the names, so you'll type ', ' in the 'Text2' box. If you're combining first and last names in that order, you'll only need a space between them, so just type ' ' in the 'Text2' box.
5. Type the ID of the cell that contains the second part of the name into the 'Text3' box in the 'Function Arguments' dialog box. The ID consists of a reference to the cell by its column letter and row number. To choose by clicking on the cell that contains your data, click the 'Collapse Dialog' button next to the text field, click on the data cell, then click the 'Restore Dialog' button.
6. Click on the 'OK' button when you have finished entering or selecting all your data and cell IDs. Your concatenated text now shows in the cell, while the 'Formula Bar' at the top of your document shows the formula you constructed in the 'Function Arguments' dialog box.
7. Propagate your formula down the column of cells by placing your pointing device at the bottom-right corner of the cell in which you entered your formula and dragging down till you reach the end of your data. When you release the pointing device, you'll see your formula applied throughout the column, with the cell references updated to use the data from each row.

Read more ►

How to Reduce Padding in Excel 2007 Cells

1. Start Excel 2007 and open the spreadsheet from which you want to remove padding.
2. Highlight the columns from which you want to remove the padding. Place the cursor between any two highlighted column headers. The cursor changes to a double arrow. Double click and the width reduces to the minimum needed to display the contents of the column or columns.
3. Highlight the rows from which you want to remove padding and double click between rows to remove it.

Read more ►

How to Use a Cell as a Checkbox in Excel 2007

1. Open the Microsoft Excel 2007 file to which you want to add checkboxes, then click on the “Microsoft Office” button. Click on “Excel Options” at the bottom of the window.
2. Click to select the box next to the “Show Developer tab in the Ribbon” field, then click “OK.”
3. Click on the “Developer” tab, then click “Insert” in the “Controls” group. Select the “Check box” option from the “Form Controls” section.
4. Use your mouse to select the cell in your worksheet in which you want the checkboxes to appear.
5. Click the “Developer” tab again and select “Properties.” Click the box next to the “Checked” field to make sure a check mark can be displayed in your added checkboxes.
6. Click “OK” and the checkboxes will be added to your worksheet.

Read more ►

How to Use Excel's CONVERT Function

1. Learn the syntax for CONVERT. It's CONVERT(number,old_unit,new_unit) where number is the value to convert, old_unit is the current units of the value and new_unit is the units to which to convert the value.
2. Install the Analysis ToolPak if CONVERT returns the #NAME? error value. Select the Add-Ins menu item from the Tools menu, check the box next to the Analysis ToolPak and click on the OK button to install the Analysis ToolPak.
3. Interpret the error values for CONVERT. It will return the #VALUE! error value if the number is not a numerical value. CONVERT will return the #N/A error value if either unit does not exist or the units are for different measures.
4. Refer to the CONVERT function help topic in Excel for the complete list of units that can be used with CONVERT. This list is extensive and includes all standard units of measure.
5. Look at some examples of CONVERT. =CONVERT(6,'C','F') will return 42.8. 'C' stands for Celsius and 'F' stands for Fahrenheit. 6 degrees C is therefore equal to 42.8 degrees F. Similarly, =CONVERT(6,'in','ft') will be 0.5 because 6 inches is equal to half a foot. =CONVERT(6,'ft','sec') will return the #N/A error value because feet and seconds measure different things.

Read more ►

How to Separate the First Name Last Name in Excel

1. Open Excel 2010 and click the 'File' tab. Select 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook opens.
2. Highlight the column containing the combined first and last name. Right-click the column and select 'Insert' to insert a blank column. This will provide the column for the last name once the split has occurred.
3. Click the 'Data' tab and click 'Text To Columns.' The Text To Columns dialog box appears. Click 'Next' and check 'Space.' Click 'Finish' to split the first and last name in the workbook.

Read more ►

How to Use Indirect in Excel 2007

1. Start Excel 2007. Open the workbook containing a cell or range to which you refer in another cell.
2. Click inside the cell in which you want to refer to the first cell or range and enter the formula you want to use. For example, if you want cell A2 to contain the sum of cells E4 through E21, enter the formula '=SUM(E4:E2)' into cell A2.
3. Click inside the cell in which you want to indirectly refer to the same cell or range.
4. Click inside the Formula Bar. Type '=Indirect( )' and enter the cell reference containing the reference to the range or cell to which you want to indirectly refer. For example, if you want to refer to the sum of cells E4 through E21, which is entered in cell A2, the formula would be '=INDIRECT($A$2).'
5. Press the 'Enter' key. Save the changes to the worksheet. If you change the reference or contents of cell A2 (or whatever cell to which you are indirectly referring), the cell containing the indirect function will change to reflect the contents of that cell.

Read more ►

How to Make Lined Columns in Microsoft

Insert a Separator Line Between Columns in Word
1. Open the Word document.
2. Click the 'Page Layout' tab on the command ribbon.
3. Click the down-arrow for the 'Column's button in the 'Page Setup' group. A list of column formats appears.
4. Click the 'More columns' button. A 'Columns' dialog window displays a list of column formats.
5. Click the preferred format or type a value in the text box. For example, type '3' to set three columns.
6. Select the check box for 'Line Between.'
7. Click 'OK.' A vertical separator line appears between the columns.
Insert Line Borders for Excel Columns
8. Open the Excel worksheet.
9. Click the 'Home' tab on the command ribbon.
10. Click and drag the mouse to select a range of cells or a column. The column and row headers change color.
11. Click the down-arrow on the 'Borders' button in the 'Font' group. This button is located between the 'U' and paint can symbols. A list of border styles appears.
12. Click the preferred border style. For example, 'All Borders' outlines every cell. You can opt to draw borders for certain cells or columns.

Read more ►

How to Use Excel to Balance a Checkbook

1. Open Microsoft Excel. Click cell “A1” and type “Date.”
2. Type “Check Number” in cell 'B1' and type “Description” in cell “C1.”
3. Click cell “D1” and type “Amount.” Type “Balance” in cell 'E1.'
4. Click the column “A” header at the top of your spreadsheet. Right-click the header and select “Format Cells” from the drop-down menu. Click the “Number” tab and click “Date” in the Category section. Select the format “3/14/01” in the Type section, and click “OK.”
5. Click the column “D” header and drag your mouse to column “E.” This action will select both columns. Click the dollar sign ($) located in the Number section on the “Home” tab.
6. Click cell “A1” and drag your mouse over to cell “E1.” Click the “Center” button in the Alignment section and the “Bold” button in the Font section. Click the arrow next to the “Border” button and select “Bottom Border.” If you have trouble finding a button, hover your mouse over a button to view a description.
7. Hover your mouse between column header “B” and “C.” Your mouse cursor will change to a vertical line with two arrows. Click your mouse and drag your mouse right to resize the column. Resize the column to 13.57 (100 pixels). Hover your mouse between column header “C” and “D.” Resize the column to 20.71 (150 pixels). Resize column D and E to 10.71 (80 pixels.)
8. Enter your beginning checking account balance in cell “E2.”
9. Enter the following formula in cell “E3” and press enter: =IF(A3,IF(ISNUMBER(FIND('Deposit',C3)),E2 D3,E2-D3),' ')
10. Click cell “E3” and hover your mouse over the lower-right corner of the cell. Your cursor will change to a plus sign ( ). Click the corner of the cell and drag your mouse down approximately 10 cells. This procedure copies the formula from cell “E3” and pastes it in the following cells. The formula adjusts to coincide with the row.
11. Enter the date of your first transaction in cell “A3” to activate the formula. If you omit this step, the register will not calculate your transaction.
12. Enter the check number in cell “B3,” if applicable. If the transaction does not involve a check, leave this cell blank.
13. Enter the transaction’s description in cell “C3.” If this transaction is a deposit, you must include the word “Deposit” in your description for the formula to recognize that the deposit is an addition to your balance.
14. Enter the amount of your transaction in cell “D3.” Cell E3 displays your current balance.

Read more ►

How to Increase the Height of a Row to Pixels in Excel 2007

1. Open an Excel spreadsheet. You will see on the left side of the spreadsheet that the rows are numbered (1, 2, 3, etc.).
2. Place the cursor on the line under the row you want to increase the height of. For example, if you want to increase the height of row 2, place the cursor on the line between row 2 and row 3. Note that the cursor changes from the usual arrow to what looks like a plus sign ( ).
3. Click your mouse and while continuing to hold it down, drag the row to increase (or decrease) to the height you want. When you click your mouse on the line between rows, you will see a small dialogue box appear that will say 'Height: 20.25 (27 pixels)'--or whatever height the row is.
4. To increase the height of several rows at once and to ensure they are all exactly the same size, place the cursor over the number of the first row in your selection. You will see that the cursor is now a black arrow. Do not place the cursor on the line as you did in Step 2.
5. While holding down the mouse, drag it to select as many rows as you want. Now perform Step 2.

Read more ►

How to Change the Default Owner Name for Microsoft Excel

Change owner name in Excel 2007
1. Launch Excel and click on the Windows icon at the top left-hand corner of the screen.
2. Select the 'Excel Options' button at the bottom of this window.
3. Click on the 'Popular' tab in the left column.
4. Change the 'User name' under the 'Personalize your copy of Microsoft Office' section at the bottom of the screen.
5. Click the 'OK' button at the bottom of the screen.
Change user name in earlier versions of Microsoft Excel
6. Launch the Excel and click the 'Tools' option at the top of the screen, then select the 'Options' choice.
7. Click on the 'General' tab.
8. Enter your desired user name into the 'User name' box.
9. Click 'OK' at the bottom of the window.

Read more ►

How to Automatically Use Absolute Cell Reference in Excel

1. Open Excel.
2. Click the empty box in the upper-left corner of the spreadsheet. This is the box that is to the left of column A and on top of row 1. This highlights every cell in the spreadsheet.
3. Click in the formula tab.
4. Press F4 to toggle to the absolute value reference. Since all cells are highlighted, this toggling will affect every cell in the spreadsheet.

Read more ►