How Do I Create a Histogram Using Continuous Data in Excel 2007?

1. Open the Microsoft Excel 2007 application on your computer. Enter the continuous data into the spreadsheet.
2. Make sure to create one column with an input range of continuous data and another column with a bin range of data, which must be entered in ascending order.
3. Click on the “Data” tab and then click on the “Data Analysis” option from the “Analysis” group. The Analysis Tools dialog box will then appear.
4. Click on the “Histogram” option and then click on the “OK” option. Click on the “Collapse Dialog” button in the “Input Range” section and select the input range of data that you want represented in your histogram.
5. Click on the “Collapse Dialog” button again to return to the Analysis Tools dialog box. Click on the “Collapse Dialog” button next to the “Bin Range” section and select the bin range data in the spreadsheet.
6. Click on the “Collapse Dialog” button. Click on the box next to the “Labels” field if you want labels included with the histogram.
7. Make any changes to the setting in the “Output options” section to meet your preferences. Click on the box next to the “Cumulative Percentage” field so that it’s deselected.
8. Click on the “OK” button to save the changes. The histogram with the continuous data will then appear on the spreadsheet.

Read more ►

How to Remove Trailing Commas in Excel

1. Open the worksheet that contains the data from which you want to remove trailing commas.
2. Right-click the header of the column directly to the right of the data column that you want to clean. Click 'Insert' in the menu to insert a new function column.
3. Type the following in the cell in the formula column adjacent to the first data cell:=IF(RIGHT(A1,1)=',',LEFT(A1,LEN(A1)-1),A1)Substitute the cell address of your first data cell in place of all instances of 'A1' in the above example.
4. Press 'Enter.' Excel first determines whether the rightmost value in the data cell is a comma. If so, it determines the number of characters in the cell using the 'Len' function and then returns only the leftmost N minus 1 characters, thus omitting the comma. If no comma is detected at the end of the string, then Excel returns the original cell value.
5. Right-click the formula cell and click 'Copy.' Paste the formula into the cell directly to the right of all cells from which you want to clean the commas. Excel will perform the comma-trimming function on all cells and return the update value in the formula column.
6. Highlight all formula cells, then right-click the array and choose 'Copy.'
7. Highlight the original data cells, then right-click the array and choose 'Paste Special.' Click the radio button next to 'Values,' then click the 'OK' button. Excel will copy the output strings from the comma-less formula cells into your original data cells as static character strings.
8. Highlight the formula column, then right-click the array and click 'Delete' from the menu. This will delete the formula column now that a permanent copy of the formula output has been saved in the original data column.

Read more ►

How to Change the Size of a Microsoft Office Drop

1. Open Microsoft Word by double-clicking the Word shortcut icon on your desktop or by clicking 'Start', pointing to 'Programs' or 'All Programs' and then finding Word in your programs list.
2. Click 'Tools' on the toolbar and then click 'Customize'. The 'Customize' dialog box will open.
3. Click on the 'Toolbars' tab. Make sure the name of the toolbar that contains the drop-down list you want to make wider or thinner has a checkmark beside it.
4. Leave the 'Customize' dialog box open and click on the drop-down box that you want to resize. You will notice that it will now have a thick black line around it.
5. Move your mouse to one of the outer edges of this thick black line. When you see a line with two arrows pointing right and left, click the box with your mouse and drag it to the size you want it, whether it is larger or smaller. When you are finished, close the 'Customize' box.

Read more ►

How to Convert Excel 2007 to 2003

1. Open Excel 2007 if your computer has it. Click on the Windows icon at the top left-hand side of the screen and scroll to 'Open.' Click the command and browse your computer for the Excel 2007 file (it will have a file extension of '.xlsx'). Click on the file to select it, then click 'Open.'
2. Let the file open. Click on the Windows Icon and scroll to 'Save As.' Click on 'Excel 97-2003 Workbook.'
3. Name the file (the program will automatically name the file the same name as the 2007 version) in the space provided. Browse through your computer folders to find where you want to save it. Click 'Save.' The file can now be opened with earlier versions of Excel.
4. Download the Microsoft Compatibility Pack if you don't have Excel 2007 (www.Microsoft.com/downloads/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466). Click 'Download' once the page opens.
5. Click on the 'Run' button when the download screen appears. Click to accept the EULA and click 'Continue' to start the install. Click 'OK' once the pack has been installed. You should now be able to open Excel 2007 docs with Excel 2003 and earlier.

Read more ►

How to Place a Picture in a Cell in Microsoft Excel 2007

1. Select the cell of the spreadsheet into which you want to insert a picture.
2. Open the 'Insert' tab. This tab is located in between the 'Home' and 'Page Layout' tabs at the top left of the screen in the Ribbon, Office 2007's menu system.
3. Press the 'Picture' button, located in the Illustrations section (second from the left).
4. Navigate to the location of the picture you intend to insert and double-click the file to insert the picture into the selected cell of your Microsoft Excel document.

Read more ►

How to Create a Scrolling Section in an Excel Spreadsheet

1. Split the screen. To split the screen horizontally, place the cursor over the dash above the scroll bar at the far right of the spreadsheet just above the up arrow. The cursor becomes two lines with up and down arrows when placed over the dash. Left click on the dash and drag down under the last row you wish to freeze. The spreadsheet has been split into two sections. Each section can be scrolled independently. To split the screen vertically, place the cursor over the dash at the far right of the bottom scroll bar just after the right arrow. Click and drag to the end of the last column you wish to freeze. The spreadsheet can be split into four sections.
2. Freeze the panes. On the top menu, select 'View.' In the 'Window' section, under the 'View' menu, choose 'Freeze Panes.' Choose the first option, 'Freeze Panes.'
3. Scroll through the spreadsheet. When scrolling, check to see that the column headers and row descriptions you need are frozen. If you need to re-adjust the splits, return to 'Freeze Panes' under the 'Window' sub-menu, below 'View,' and choose 'Unfreeze Panes,' and try again.

Read more ►

How to Use the Drop

1. Open Excel 2007 and select a workbook. Press 'Control' and 'O.' Browse your computer for the Excel workbook. Click the workbook and click 'Open.' The workbook opens.
2. Select a cell or group of cells to apply the data validation. Select the 'Data' tab and click 'Data Validation.' Select 'Data Validation' from the drop-down list. On the 'Settings' tab, select 'List' from the 'Allow' drop down criteria. Type 'Yes,No,Maybe' in the 'Source' field.
3. Click the 'Input Message' tab. Check the option for 'Show Input Message When The Cell Is Selected.' Type the title of your input message in the 'Title Field.' Type a custom message for the input message in the 'Input Message' field.
4. Click the 'Error Alert' tab. Check the option for 'Show Error Alert After Invalid Data Is Entered.' Type the title of your error alert in the 'Title Field.' Type a custom message for the error message in the 'Error Alert' field. Click 'OK.'
5. Click a cell and notice the appearance of the drop-down list. Data validation has added drop-down boxes in Excel.

Read more ►

How to Protect One Cell in an Excel Spreadsheet

1. Open the Excel spreadsheet that contains that data and cells that you want to separately protect. Click on the individual cell that you want to lock.
2. Click on the “Format” option from the top tool bar menu. Click on the “Cells” option and then click on the “Protections” tab.
3. Click on the box next to the “Locked” field. Click on the “OK” button and you’ll be returned to the spreadsheet.
4. Click on the “Tools” option from top tool bar menu. Scroll over the “Protection” option and then click on the “Protect Sheet” option.
5. Type a password that will protect the cell from being unlocked by anyone else and then click on the “OK” button. The single cell in your spreadsheet will now be protected.

Read more ►

How to Remove a Check Box in Excel

1. Open the Excel file that contains the check box you want to remove.
2. Click the 'Design Mode' option on the 'Controls' group of the 'Developer' tab.
3. Click once on the check box that you want to delete. Press the 'Delete' key on your keyboard. Repeat this step for each check box that you want to remove.

Read more ►

How to Use Excel's TAN Function

1. Enter your input values into a row or column in a blank spreadsheet. The 'input value' refers to the angle, represented by the 'x.' Let's assume you enter an input value of 5 and you enter it in cell A1.
2. Click your cursor in a different cell and type the formula '=Tan(A1).' This gives you the result of -0.14255. This number represents the tangent of your angle.
3. Change the number of decimal points in your answer if necessary. Go to 'Format' and 'Cells.' Select the 'Number' tab, then 'Number' and enter the number of decimal points you would like.
4. Compare your answers with the most popular tan values: 'Tan(0 degrees) = 0.0000;' 'Tan(30 degrees) = 0.5773;' 'Tan(45 degrees) =1.000;' 'Tan(60 degrees) = 1.7320;' 'Tan(90 degrees) = infinity.'

Read more ►

How to Set Row Height in Excel 2007

1. Open the Excel spreadsheet. Select the rows for which you want to set the row heights. Click on a row in the left column to select the entire row. Press and hold 'Ctrl' and click more rows to select multiple rows, or click the diagonal arrow in the top-left corner of the spreadsheet, above the first row, to select every row.
2. Click the 'Home' tab from the Ribbon if it's not already selected. Click on 'Format' from the Cells section and select 'Row Height.' This opens a dialog box.
3. Type a number into the text box and click 'OK.' This sets the row height for your selected cells to the number you entered.

Read more ►

How to Use Autofill With Numbers in Excel 2007

Autofill the Same Number
1. Type the number in the first cell that you would like to contain that number.
2. Click on the cell to highlight it.
3. Click the small square in the lower-right corner of the cell and hold the mouse button down.
4. Drag the square in whichever direction you would like to AutoFill. Release the mouse button when all desired cells are highlighted. The value is copied into the cells.
Autofill a Sequence
5. Type the first two numbers of your sequence in the first two cells in your list. For instance, to start an integer sequence in the 'A' column you would type '1' in cell A1 and type '2' in cell A2.
6. Highlight the cells that contain the first two numbers in your sequence.
7. Click the small square in the lower-right corner of your selection and hold the mouse button down.
8. Drag the square in the direction that you would like to autofill. Release the mouse button when all desired cells are highlighted. Sequential values are copied into the highlighted cells.

Read more ►

How to Enable Extra Rows in Excel 2007

1. Select the row above which you want to place the new row. You can do this by left- or right-clicking the row number on the left-hand side. For example, if you want to insert a single row between rows three and four, select row four. If you want to insert three rows between rows three and four, select rows four, five and six by clicking on row four, holding down the left mouse button and dragging the cursor down over rows five and six to highlight them as well. To select rows that are not adjacent to each other hold down the 'Ctrl' key and click on the rows you wish to highlight.
2. Click the 'Insert' option at the top of the screen. Navigate down to 'Rows' and click the left mouse button. If done correctly, the new row or rows will appear above the row you've selected. In the case of multiple or non-adjacent rows, they will all appear at once. Alternately, you can right-click the row below where you want to insert a new one. Choose 'Insert' from the box that pops up and select 'Rows.' This will perform the same function.
3. Hold 'Ctrl' and press 'Y' on your keyboard to repeat the row insert. The insertion operation that is repeated will be the same one you just performed. This means if you inserted three rows, then you hold down 'Ctrl' and press 'Y,' three new rows will be inserted.

Read more ►

How to Use Spin Buttons in Excel

1. Use Excel to create your chart or document. Note: Be sure to save your work every few minutes.
2. Open the 'Developer' tab, select 'Controls,' and then 'Form.'
3. Select the 'Insert' option on that tab. You will see this with a little folderlike icon and some tools.
4. Click on your Excel document where you want the spin button to appear. The place where you click is where the upper-left hand corner of the button will appear.
5. Select the 'Properties' option from the 'Developer' tab and 'Controls.'
6. Start setting your options for the spin button. Let's say that you decided on the age of a person. Select a standard age, such as 25. Then select a starting (minimum) age, such as 21. Next, select an ending (maximum) age, such as 100. Then select the increments in which the numbers go up, such as one year at a time, five years, etc. Finally, fill in the spot that asks for cell information.
7. Click to save your changes and then once again click to save your Excel document.

Read more ►

How to Split a Merged Cell

1. Right click on the merged cell. Click 'Format Cells.'
2. Click on the 'Alignment' tab.
3. Uncheck the 'Merge Cells' check box by clicking on it.
4. Click 'OK'. The merged cells are now split.
5. Click on the icon for merged cells on the menu bar if available to enable or disable merged cells when needing a quick shortcut.

Read more ►