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 ►

How to Make a Monthly Budget on Excel

1. Click 'Start' > 'All Programs' > 'Microsoft Office' > 'Microsoft Office Excel.'
2. Click cell 'A1,' type 'Expenses,' click cell 'B1' type 'Amount,' click cell 'D1,' type 'Income' and then click cell 'E1' and type 'Amount Earned.'
3. Click cell 'A2,' type the name of a monthly expense (rent, car payment, food etc.) press the 'Enter' key, type the name of another expense and then continue in this manner until all expenses you plan to incur are listed in column A. Repeat this step, clicking on cell D2 and entering sources of income on each line instead of expenses (income from each job, tips, interest, gifts, etc.)
4. Click cell 'B2,' type the amount of money you plan to spend on the expense in cell A2, press the 'Enter' key, and then continue typing in the anticipated amount you will spend on each expense. Repeat this step, clicking on cell E2 and entering amounts corresponding with each source of income. You will now have lists of all of your planned expenses and sources of income.
5. Click cell B2, hold down the mouse button and then drag the mouse down to select the values of all planned expenses.
6. Click the 'Auto sum' button under the 'Editing' group on the ribbon (the main toolbar at the top of the Excel interface.). A total of all planned expenses will appear underneath column B.
7. Repeat steps 5 and 6, selecting cell E2 instead of B2. The total of all planned income sources will appear under column E2.
8. Click on an empty cell underneath the lists press '=' click on the cell containing the total of all income, press '-' and then click on the cell containing the total of all expenses and press 'Enter.' The cell will display the difference between planned income and expenses (the amount of money you will have left over after you pay all your planned expenses.).
9. Hold the 'Control' key, press 'S,' enter a name for the budget in the space provided and then click 'Save.'

Read more ►

How to Hide the Excel Pivot Table Data Area

1. Move the data you want to hide to the right. The easiest way to hide a large data field is to hide everything that lies on the right side of a selected column. Therefore, start by moving all the data you want to hide to the right. Click on 'Pivot Table Wizard' on the Pivot Table Toolbar. Now click on 'Layout.' Drag and drop the columns to arrange the data in such a way that all the data you wish to hide is to the right of the column(s) that will be visible and click 'OK.'
2. Click on the first column from the left. Now go to the Pivot Table Toolbar and click on the icon that looks like a list with a green plus sign on the side (fifth icon from the left). A new window, titled 'Show Detail,' will appear. Here, select only the fields for which you wish the data to show. If you select no fields at all, only the data in the very first column will show. You can also hide the data in the fist column if you so desire.
3. Click on the first column. Click the icon from the Pivot Table Toolbar that looks like a list with a red bar on the side (fourth icon from the left). The data in the column will now disappear. If you press the same button again, the data will reappear. This way, you can hide all the data in the data area of the Pivot Table. If you wish to keep all the column headings and hide the data beneath the headings, simply click on the fourth icon (which hides data in one column) once for each column.

Read more ►

How to Add a Custom Menu to an Excel Toolbar

Adding a Custom Menu to a Toolbar
1. Open Microsoft Excel.
2. Display the toolbar that contains the menu where you want to add your command.
3. Open the Tools menu and select Customize.
4. Select the Commands tab.
5. In the Categories box, click New Menu.
6. Drag New Menu from the Commands box to the desired location on toolbar.
7. Right-click the new menu and select Name.
8. Type a name for the menu in the Name box. Press Enter.
9. Now add commands to the new menu, following the steps in the next section.
Adding a Command to a Menu
10. Open the Tools menu and select Customize.
11. Select the Commands tab.
12. Click your new menu on the toolbar. A box will appear below it.
13. In the Categories box, select the category for the command.
14. Drag the command you want from the Commands box to the new menu's box on the toolbar. When the menu displays a list of menu commands, point to the location where you want the command to appear on the menu on the toolbar, and then release the mouse button.

Read more ►

How to Convert Lotus 123 Files to Excel

From Lotus 123
1. Open your file in Lotus 123.
2. Go to the 'File' menu, select 'Save As,' and save it as a Microsoft 97 file (*.xls).
3. Open the resulting .xls file in Excel.
From Excel
4. Open Excel.
5. Locate the Lotus 123 file (with an extension of *.wk4 in most cases).
6. Click 'Open.' Excel will prompt you for approval before converting the file.
7. Go to the 'File' menu, and select 'Save As' to save a copy of the file as an Excel native format.

Read more ►

How to Create Diagonal Lines in a Cell in an Excel Spreadsheet

1. Open Microsoft Excel by double-clicking the Excel icon on your screen or selecting 'Programs' from the 'Start' menu and then selecting 'Microsoft Excel.'
2. Select the cell you would like to place the diagonal line in by clicking on it once. The cell will be highlighted with a bold border around it to indicate that it has been selected.
3. For Excel versions before 2007, move your cursor to the 'Format' pull-down menu and select the first item: 'Cells.' A pop-up box will appear named 'Format Cells.' Select the tab that says 'Border' within the box.
4. For Excel 2007 or more recent versions, within the 'Home' tab at the top of the page, click on the down-facing arrow next to the image of a box within the 'Font' section. This is called 'Format Cells.' This arrow will select a pull-down menu. Select the last entry: 'More Borders.' The 'Format Cells' pop-up box will appear within the 'Borders' tab.
5. Select either the left or right diagonal line amongst the line options surrounding the sample box. Your selection will show up as an example in this box.
6. Confirm your selection by pushing 'OK.' The box will close and you will to your spreadsheet with the diagonal line appearing in the cell.

Read more ►