How to Insert Check Boxes

Inserting a Check Box in Word (2010)
1. Display word's developer tab. Click on the 'Office' button, then 'Word Options,' followed by 'Customize Ribbon.' Check the 'Developer' box if it is not already selected. Click 'OK.' The developer tab should appear.
2. Click on the developer tab. Find the controls group. Click on 'Legacy Tools.' Click on 'Check Box Form Field.' The box appears on your document.
3. Move or resize the check box as needed, using the cursor.
4. Click 'Restrict Editing' in the 'Protect' group on the developer tab. a 'Restrict Formatting and Editing' box should appear. Check the box that says, 'Limit formatting to a selection of styles' and 'filling in forms' (under 'Editing Restrictions'). The tab asks you if you're ready to start enforcing the restrictions. Mark 'Yes, Start Enforcing Protection.'
5. Type a password in the box that pops up, or leave it blank for no password protection to later edit the check boxes.
Inserting a Check Box in MS Infopath
6. Click 'Insert,' then 'More Controls' or press 'Alt,' 'L' and 'C' buttons simultaneously. A tab called 'Insert Controls' shows up. Click the box next to it.
7. Change the text label for your check box by clicking on the default text and typing yours. Change the size and locations of check boxes by selecting them and typing the 'Alt' and 'Enter' keys simultaneously. Choose your desired size on the 'Size' tab.
8. Change the border style or color of your check box by selecting the appropriate check box, then clicking 'Format,' followed by 'Borders and Shading.' Choose the style and color you want for your border and check box.
Inserting a Check Box in MS Excel (2010)
9. Follow Step 1 in Inserting a check box in Word.
10. Drag your mouse over the 'Insert' group on the developer tab. Click on the check box image under the 'Form Controls' group.
11. Change the default text on the check box label by clicking on it and typing your own label. Resize text or the check box by selecting them and browsing 'Font' or 'Formatting' options under the 'Format' menu.

Read more ►

How to Make a Form in Excel

1. Turn on your computer and open the Excel program. A blank workbook will automatically open at start-up.
2. Create your form the way you'd like it to appear, including entering formulas.
3. Format the form using borders, shading, color and text formatting until you are satisfied with the appearance.
4. Unlock the cells where you'd like users to be able to enter data. To do so, select these cells, then click 'Format/Cells/Protection' and make sure the 'Locked' feature is not checked.
5. Select your print area. To make the process even simpler for users, select the area of the spreadsheet that should be included when printing, then click 'File/Select print area'.
6. Protect your form from changes. The final step to creating a form in Excel is to protect the form by clicking 'Tools/Protect/Protect Sheet'. After you do this, users will only be able to change the cells you selected, making all of your labels, formulas and other fields safe from changes.

Read more ►

How to Make Gridlines Print in Microsoft Excel 2007 Spreadsheets

1.
Select the 'Page Layout' tab. It is located on the 'Ribbon,' the group of icons above the work area in Excel.
2.
Put a check in the 'Print' box. Once on the Page Layout Tab, look toward the right side and you will see a group called 'Gridlines.' This will cause the gridlines to show when you print your spreadsheet.
3. If you change your mind and would like to have the gridlines hidden on print jobs again, simply remove the check from the 'Print' box.

Read more ►

How to Create a MS Excel Skin

1. In MS Excel, select 'Format' from the Menu Bar.
2. Select 'Sheet.'
3.
Select 'Background.'
4.
Click on the picture you would like to use as a skin.
5.
Click on the 'Insert' button.

Read more ►

How to Put a Decimal Place in Excel 2003

1. Open Excel 2003 and select the 'File' drop down menu. Click 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook opens.
2. Review the spreadsheets in the workbook and locate a workbook that needs decimal places in the data. Highlight the range the contains data that needs a decimal place.
3. Select the 'Format' drop down menu and select 'Cells.' Click the 'Number' tab. Select the 'Number' option in the left 'Category' section. Change the decimal places to '1.' Click 'Ok.' The decimal places are added to the Excel 2003 spreadsheet.

Read more ►

How to Use Excel's FREQUENCY Function

1. Remember the formula breaks down to the following: FREQUENCY(data_array,bins_array). Data is the set of values for which you will compute the frequencies. If you don't enter any data in the cell, you'll receive zeros in return. Bin is how you want the data broken down, or the ranges into which you want the data to fall.
2. Note that the FREQUENCY function will always give you one more frequency than data entered. For example, if you're a teacher and you enter in the test scores of 20 students, then you'll receive 21 frequency values.
3. Set up your worksheet to contain the data and the ranges you desire. Using the test score example, column A should contain individual test scores (data) and column B should contain the ranges corresponding to specific letter grades (bin).
4. Select vertical cells in column C plus one cell more than the number of cells used in column B. Enter '=FREQUENCY(A1:A#,B1:B#)' in the formula bar, replacing '#' with the last row number for your column A and B cells.
5. Press the following after you enter the function in the formula bar: 'Control' 'Shift' 'Enter' if you're working in a Windows-based program or 'Command' 'Enter' if you're working on a Macintosh/Apple computer.
6. View your results and notice the one additional number at the end of column C.

Read more ►

How to Use Excel to Generate Random Samples

1. Determine a range of numerical data in an Excel worksheet from which you want to generate a random sample. For example, generate a random sample from the numbers 1 through 10 listed in the first column in cells A1 through A10.
2. Click the 'Data' tab at the top of Excel and click 'Data Analysis' in the 'Analysis' group.
3. Click 'Sampling' in the 'Analysis Tools' list, then click 'OK.' This brings up a small window called 'Sampling.'
4. Click the button with the red arrow next to box called 'Input Range' in the 'Input' section. This shrinks the sampling window to a single row in which you can enter an input range.
5. Click and hold the left mouse button in the top left cell of the range of data from which you want to generate a random sample. For example, click and hold the left mouse button in cell A1.
6. Drag the mouse to the bottom right cell in the range of data, then release the mouse button. This shows the range of cells that contain the population data in the sampling window. For example, drag the mouse to cell A10 and release. Excel shows '$A$1:$A$10' in the sampling window.
7. Click the button with the red arrow in the sampling window to expand the window to its original size and show the other options.
8. Click the 'Random' button in the 'Sampling Method' section of the sampling window and type the number of samples you want Excel to generate in the box titled 'Number of Samples.' For example, click the 'Random' button and type '10' in the box.
9. Click the 'New Worksheet Ply' button in the 'Output options' section to tell Excel to place your sample in a new worksheet.
10. Click 'OK.' Excel generates a list of random samples and lists them in a column in a new worksheet with the first sample in cell A1. In the example, Excel lists random numbers between 1 and 10 in cells A1 through A10 in a new worksheet.

Read more ►

How to Add a Drop Down Calendar in Excel 2007

1. Make sure the Developer tab is showing in the ribbon (the toolbar at the top of the page). If it isn't, then click the 'Office' button at the top left, then choose 'Excel Options'. This will bring up a pop up window. Put a check mark in the 'Show Developer Tab in the Ribbon' option, then click 'OK'.
2. Click on the 'Developer' tab. Click on the small arrow below the 'Insert' tab and choose 'ActiveX Controls'. Click the last icon in the list ('More controls').
3. Choose 'Calendar Control' and press 'OK'.
4. Click on a cell in your worksheet where you would like to place the calendar. Click the 'Design Mode' button to turn off design mode and return to normal operation.

Read more ►

How to Create a Template for Excel 2003

1. Open Excel 2003 and locate a workbook that you want to base you template on. Click 'File' and 'Open' on the menu bar. Search your computer for the workbook. Click the workbook and select the 'Open' button. The workbook opens.
2. Review the workbook and decide what information will remain in the workbook after it becomes a template. Information that would remain would be date formulas, contact information, company logo and other information relevant to your project. Remove any information that refers to a specific customer or vendor if this workbook will be used for all of customers and vendors.
3. Save the workbook by clicking 'File' on the menu bar. Click 'Save As.' Change your save as type to 'Template.' Type a template name in the 'File Name' field. Click 'Save.' Your template is now saved and is available for use in your future projects.

Read more ►

How to Use the Option Buttons in Excel

1. Open Excel. Click 'File' and 'New' in the menu bar. Select 'Blank Workbook' from the pane on the right side of the Excel window.
2. Turn on the Forms toolbar. Right-click in the gray area of any toolbar. Select 'Forms' from the displayed list.
3. Add a group box. Select 'Group Box' from the 'Forms' toolbar. Click and drag in the spreadsheet with the mouse to create a group box of the desired size.
4. Rename Group Box 1 by highlighting the text and typing an appropriate name.
5. Create the option button. Click on 'Option Button' in the 'Forms' toolbar. Click in the desired area of the group box to paste the option button.
6. Customize text for the option button. Right-click the option button. Select 'Edit Text' from the displayed menu. Type the new name.
7. Change the appearance of the option button, if desired. Right-click the option button. Select 'Format Control'. Add color and select line style and weight.
8. Create more option buttons by repeating Steps 5, 6 and 7. Use the arrow keys on the keyboard to align or reposition the option buttons.
9. Save the file. Click 'File' and 'Save' in the menu bar. Name the file. Click the 'Save' button. Click on 'File' and 'Close' in the menu bar to close the file.

Read more ►

How to Export OpenOffice Calc to XML

1. Open your Calc spreadsheet in OpenOffice.org's Calc program.
2. Click 'File' in the top menu and select 'Save As'. Alternatively, hold the 'Ctrl' and 'Shift' keys down and press 'S'.
3. Click the drop-down menu next to 'Save as type' and select 'Microsoft Excel 2003 XML (xml)'.
4. Enter a new name for your spreadsheet if one is not automatically chosen. If you previously saved this document the original file name is filled in. You can use this file name without overwriting the original file, since the extension will be different.
5. Click 'Save' to export your Calc spreadsheet in XML format.

Read more ►

How to Make a Thermometer Chart in Microsoft Excel

1. Open a blank worksheet in Excel. Enter headings for two columns of data, such as 'Month' and 'Total Clients' in cells A1 and B1. Enter the appropriate data into the column cells. The data should be building toward a goal.
2. Enter the goal number at the bottom of the column and enter the actual number reached in the cell beneath the goal amount, which will be the number in the last cell.
3. Skip a cell below the totals, and enter a formula to determine the percentage reached in the next cell. In the Formula Bar, use the formula total amount/goal amount. For example, the formula could be '=B17/B16.' Right-click the cell, select 'Format Cells,' select the 'Number' tab and choose 'Percentage.'
4. Select the cell with the percentage amount. Click the 'Chart Wizard' button in Excel 2003 or earlier and select a clustered column chart. In later versions of Excel, select the 'Insert' menu and choose a clustered column. In step 3 of the chart setup, go to the 'Axes' tab and clear 'Category (x).' On the 'Legend' tab, clear 'Show Legend,' and on the 'Data Labels' tab select 'Value.' Click 'Finish.'
5. Double-click the column of the chart. The Format Data Series dialog will open. Click the 'Options' tab and change the 'Gap Width' to '0.' Go to the 'Patterns' tab and click on 'Fill Effects.' On the 'Gradient' tab, select two colors, such as black and red, and select 'Horizontal' in the shading styles. Click 'OK' twice to apply changes and close the dialog.
6. Drag the left side of the chart toward the right, making the graph thinner. Right-click the chart and select 'Format Chart Area.' On the 'Patterns' tab, select 'None' for both Border and Area. Click 'OK' to apply the changes.
7. Add a circle auto shape at the bottom of the chart by selecting the autoshape from the drawing toolbar in Excel 2000 to 2003, or from the 'Insert' tab in later versions of Excel. Right-click the circle and select 'Format Shape.' Fill the circle with the same gradient colors used in the chart.

Read more ►

How to Break Hours Minutes Down into Increments for Excel

1. Open a new Microsoft Excel 2010 spreadsheet. Click on cell 'A1' and type in the time that you want to break down. Enter the time as 'hh:mm.'
2. Click on cell 'B1' and enter the following formula into the cell:=ROUND(A1*(1440/x),0)/(1440/x)Change each 'x' to be a number equal to the number of minutes in your desired time increments. If your increments are in seconds, change both instances of '1440' to '86400' and enter the number of seconds in each increment for 'x.' Press 'Enter' to complete the formula and a small number will appear in the cell.
3. Right-click cell 'B1 and choose 'Format Cells' from the drop-down menu. Click on 'Time' on the left side of the window that appears. Then choose the '37:30:55' option on the right side of the window. This format will allow you to view amounts over 24 hours correctly. Click 'OK' and the small number in cell 'B1' will be changed into your rounded time.
4. Click on cell 'C1' and enter the following formula:=B1/(0.00069444*x)Change 'x' to be the number of minutes in your increments. If your increments are in seconds, change the formula to read:=B1/(0.000011574*x)Change 'x' to be the number of seconds in your increments. Press 'Enter' to complete the formula and cell 'C1' will break your hours and minutes in cell 'A1' down into a number of increments.

Read more ►

How to Restore One Deleted Excel Worksheet

1. Click the 'Office Button' and select 'Save As' from the drop-down menu. Select Excel Workbook from the 'Save As' menu and type a new name for your workbook in the 'File Name' field. Press 'Save.' You will now have two workbooks---your original workbook before you made any changes with the 'deleted' worksheet intact, and the newly saved workbook with all of your changes. Only your newly created workbook will remain open.
2. Open your original workbook. You should now have both workbooks open.
3. Right click on the name tab of the 'deleted' worksheet in your original workbook and click 'Move or Copy...' when the menu appears. Under the 'To book' option, select your new workbook and choose where you would like the worksheet to appear in the 'Before sheet' option. Click 'OK.' Note that Excel takes you to your new workbook and the 'deleted' worksheet is displayed.
4. Check to make sure that links between worksheets, formulas and macros are functioning as expected. The next step will eliminate your original workbook, so be absolutely certain that your new workbook is correct before moving forward. If everything is in order, go back to your original workbook and close it.
5. Save your new workbook, renaming it with the original workbook name. The workbook with the 'deleted' worksheet will be overwritten with your now correct workbook.

Read more ►

How to Learn Excel 2003

1. Learn Excel directly from the maker using the resources available at Microsoft Office Online. This website offers courses ranging from 30 to 50 minutes that walk you through the basics of how to use Excel, so you can be on your way in just a couple of hours.
2. Check the website of your local community or technical college for introductory classes on Excel. These classes may be free or discounted compared to private university tuition. If you are a senior citizen you may be eligible for a discount on tuition. Most classes will focus on newer versions of Excel, but you can ask the instructor which functions are compatible with the 2003 version, and the basic operation of the software remains the same.
3. Teach yourself using the Help files that are included with Microsoft Excel. Simply open up Excel and press 'F1' on your keyboard to launch the Help panel. Browse to 'Training' and click on 'Get to know Excel 2003.' This will walk you through the basics of Excel.

Read more ►