How to Prevent Excel 2003 From Automatically Converting Dates to Julian

1. Log on to your computer and open Microsoft Excel 2003. Open a new or existing spreadsheet.
2. Click the 'Format' menu and choose 'Cells.' Highlight the 'Date' option.
3. Click the date format you want to use and click 'OK.' Enter a date in the cell to make sure it displays properly.

Read more ►

How to Convert Excel 2003 AutoFormat PivotTables to Excel 2007

1. Open Excel 2007.
2. Click 'File,' 'Open.' Double-click the Excel 2003 workbook that contains the PivotTable. The workbook opens in Compatibility Mode.
3. Click the Microsoft Office Button in the upper-left. Click 'Convert.' Click 'OK' to confirm.
4. Click 'Yes' and the newly converted workbook will open and is ready to use.
5. Click 'File,' 'Save' to confirm the new settings.

Read more ►

How to Write Sideways in Excel

1. Open Excel to a blank spreadsheet or open an existing spreadsheet.
2. Click a cell you want to add text to. Click the 'Home' tab on the ribbon if it is not already open. Click the 'Text Orientation' button in the Alignment group. The button has no name but shows the letters 'ab' with an arrow underneath pointing diagonally.
3. Select the type of rotation you want. You can select 'Vertical text' to have letters appear vertically one at a time in your cell or select 'Rotate up' or 'Rotate down' to face your text left or right.
4. Type the text as you would normally. Press 'Enter' to see your text align sideways.

Read more ►

How to Print Head Rows on Each Page in Excel

1. Click 'Insert.'
2. Select 'Header and Footer.'
3. Click on the left, center, or right header, depending on which one you want to use.
4. Type in your header.
5. Print your spreadsheet and the header will display on every page.

Read more ►

How to Insert Time Into an Excel Spreadsheet

Static Time
1. Select the cell where you wish to enter the time.
2. Press 'Ctrl' 'Shift' ';'.
3. Click the 'Format' menu and select the 'Cells' option.
4. Click the 'Numbers' tab.
5. Select 'Time' from the drop-down list and select your preferred format in the second column. You can also create a custom display format. When you're finished, click 'OK.'
Dynamic Time
6. Select a cell in your spreadsheet and type '=NOW()' into the cell.
7. Press 'Enter.' The time and date are displayed in the default format.
8. Change the format by following steps 3 to 5 in Section 1.

Read more ►

How to Add a Column Number in Microsoft Excel 2003

1. Choose a cell on your spreadsheet to display the result of your formula.
2. Click the 'Insert Formula' button next to the formula bar.
3. Select 'Lookup and Reference' from the drop-down list of function categories.
4. Select 'COLUMN' from the list of functions and click 'OK'.
5. Provide a reference for the 'COLUMN' formula to use. If you want to use the cell you selected in Step 1, do not enter a reference; if you want to use a different cell, enter that cell's coordinates in the reference box.
6. Click the 'OK' button. Your cell will now display the numerical value of the column you selected.

Read more ►

How to Calculate Linear Regression Using Excel

1. Type these data pairs starting in cell c3. For this and the remaining steps, press the 'Tab' key where a comma is shown. These numbers are data pairs collected from a hypothetical science experiment. In this experiment, assume there's the possibility of a linear relationship between 'x,' the first column of numbers, and 'y,' the second column.X, Y1, 5.22, 7.83, 10.74, 13.95, 16.5
2. Type these additional three columns, starting with the first cell to the right of the cell containing 'y.' These columns are factors in the calculations for the slope, y-intercept and R values of linear equations of the form y = mx b. Letter 'm' is the slope, 'b' is the y-intercept and 'R' is a measure of how closely the computed line matches the actual data points. The closer 'R' is to 1.0, the closer the data points are to forming an actual line whose 'm' and 'b' values are those you're computing.xy, x^2, y^2c4*d4, c4*c4, d4*d4
3. Select the second row you just typed, then click the lower-right corner of the rightmost cell. Drag downward until the selection is five rows high. This action extends the formulas to all the x-y data pairs.
4. Type these additional six cells starting at cell b11. These cells contain summations of the columns you entered in the previous step.n, sum of x, sum of y, sum of (xy), sum of (x^2), sum of (y^2)count(c4:c9), sum(c4:c9), sum (d4:d9), sum (e4:e9), sum (f4:f9), sum(g4:g9)
5. Type these formulas starting in cell c14. These are squares of two of the summation calculations you entered in the previous step.(sum of x)^2, (sum of y)^2c12^2, d12^2
6. Type these labels and calculations starting in cell c17. These are the slope, y-intercept and 'R' values of the estimated line, as described in step 2. After entering these final calculations, look first at the 'R' value, 0.9994. This number is close to 1.0, which means the line you calculated is close to fitting the data points. Next, compare how close the slope, 2.87, is with the value 3.0, which is the slope of the actual line used to create data points for this article. Last, relate the y-intercept value, 2.21, to the value 2.0, which is the y-intercept of the linear equation used to create data points for this article.slope, (B12*E12-C12*D12)/(B12*F12-C15)y-intercept, (D12-D17*C12)/B12R, (B12*E12-C12*D12)/SQRT((B12*F12-C15)*(B12*G12-D15))

Read more ►

How to Use Excel to Calculate a Confidence Interval

1. Enter the alpha value in cell A1. The alpha value equals 1 minus the confidence level. For example, if your confidence level equals 96 percent, you would enter 0.04 in cell A1.
2. Enter the standard deviation in cell A2. For example, if your standard deviation equals 1.1, enter '1.1' in cell A2.
3. Enter the sample size in cell A3. For example, if your sample size equals 3,000, enter '3,000' in cell A3.
4. Enter 'CONFIDENCE(A1,A2,A3)' in cell A4 and Excel will display the confidence interval. In this example, Excel will display '0.041245769' meaning your confidence interval equals plus or minus 4.12 percent.

Read more ►

How to Get Rid of Gridlines in Microsoft Excel 2007

Remove Gridlines from Excel
1. Open an existing or new Microsoft Excel 2007 spreadsheet.
2. Right-click with your mouse on the 'Tools' menu, located on the top toolbar.
3. Locate and right-click on 'Options.'
4. Select the 'View' tab.
5. In the 'Windows Options' section, located in at the bottom of the pop-up window, right click in the check box next to: 'Gridlines.' Click 'OK' to save your changes.
Remove Gridlines from Excel Print Job
6. Open an existing or new Microsoft Excel 2007 spreadsheet.
7. Right-click on the 'File' menu, located on the top toolbar.
8. Locate and right-click on 'Page Setup.'
9. Select the 'Sheet' tab.
10. In the 'Print' section, located in the middle of the pop-up window, right-click in the check box next to: 'Gridlines.' Click 'OK' to save your changes.

Read more ►

How to Insert a Grid in Microsoft Excel 2003

1. Click 'Insert' in the top toolbar of Microsoft Excel 2003. It's the third option after 'File.'
2. Select 'Picture' and then 'Clip Art' from the drop-down menu.
3. Type 'Grid' in the box labeled 'Search.' This box is located on top of the 'Clip Art' box that opened on the left-hand side of the screen.
4. Press the 'Go' box to begin searching for the different types of grids available to insert into your Microsoft Excel 2003 document.
5. Double-click the box of the grid you want to insert into the document. This will place the grid into Excel automatically.
6. Hold down the 'Ctrl' and 'S' buttons on the keyboard at the same time to save the changes in your Microsoft Excel 2003 document.

Read more ►

How to Make Posters in Excel

1. Open Excel. Click on the 'File' menu at the top of the screen once it opens. Select the 'Page Setup' command.' Choose the 'Page' tab.
2. Adjust the page scaling to '200%' and click on the radio button next to 'Landscape' for the page orientation. Click on the 'Margins' tab.
3. Click into the text boxes for the top, bottom, left, and right and type '0.5'. Click into the text boxes under 'Header' and 'Footer' and type '0.' This will adjust the margins of each sheet of paper.
4. Click the 'Zoom' tab and set the zoom rate to '40 percent.' Click on the 'OK' button.
5. Click on cell 'A1' and highlight the range 'A1:M42.' This should encompass four full sheets of paper (you can see where the sheets begin and end by the dotted lines on the screen). Click the 'File' menu at the top of the screen, click the 'Print Area' command, and select 'Set Print Area.' Excel will now only print those four pages
6. Click on the 'View' menu and select 'Toolbars'. Click on the 'Drawing' option if it doesn't have a check mark by it to display the 'Drawing' toolbar.
7. Click the Rectangle tool on the 'Drawing' toolbar (it will look like a rectangle). Click on the top left corner of cell 'A1' and drag your mouse to the bottom right corner of cell 'M42.' This will create a blank rectangle across the four pages that will be your poster.
8. Click on the paint can icon on the 'Drawing' toolbar to open the effects menu. This menu will provide you with a list of color options to fill the rectangle with. Click on the 'Fill effects' button to add a picture to your poster.
9. Click on the word art icon on the 'Drawing' toolbar to add text to your poster. Click anywhere on the poster to add a text box. Type what you like in the poster.
10. Click the 'File' menu and select 'Print' when you are ready to print the poster. Click 'OK' to begin printing.
11. Tape the separate sheets of paper which print out together to form the poster. Hang the poster in your office or classroom.

Read more ►

How Do I Change Margins on an Excel Spreadsheet?

Change Margins by Dimension
1. Open Microsoft Excel.
2. Click the 'File' button on the menu and then click the 'Page Setup' button.
3. Click the 'Margins' tab and then enter the size you want the margins to have.
Change Margins Graphically
4. Open Microsoft Excel.
5. Click the 'File' button on the menu and select the 'Print Preview' option.
6. Select the 'Margins' button and then drag the margin handles to change their size.

Read more ►

How to Delete an Excel 2007 Button Face ID

1. Open the Microsoft Excel 2007 application on your computer and then click the 'Microsoft Office' button. Click the 'Open' option.
2. Select the Excel 2007 spreadsheet file that contains the button face ID you want to remove. Click the 'Open' button again.
3. Click the 'Developer' tab and then click the 'Macros' option from the 'Code' group. The 'Macros in' list will then appear,
4. Click the workbook containing the macro for the button face ID. Select the name of the macro for the button face ID in the 'Macro name' box.
5. Click the 'Delete' button and then the macro and button face ID will be completely removed. Click the 'Microsoft Office' button and then click the 'Save' option to save all of your changes.

Read more ►

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 ►