How to Create Tabs in an Excel Spreadsheet

1. Open Microsoft Excel. There will be multiple tabs at the bottom with the name 'Sheet' and a number for each tab. Each of these tabs is a separate worksheet. Click on the tab to open that worksheet.
2. Right-click on the tab and select 'Rename' to change the name on the tab.
3. Add tabs to the file by right-clicking on a tab and selecting 'Insert.'
4. Copy an existing worksheet as a new tab by right-clicking on a tab and selecting 'Move or Copy.' Choose where to place the new tab and select the copy check box to leave the original tab in its location.
5. Rearrange tabs by dragging them to a new location among the tabs.
6. Delete unused worksheet tabs by right-click on the tab for the worksheet that you do not want and selecting 'Delete.'

Read more ►

How to Paste Special in Microsoft Word

1. Start Microsoft Word and open an existing file or start a new document.
2. Copy the text you want to paste from another Word file or other application.
3. Place your cursor in your open Word document where you want to paste the copied text.
4. Right-click and choose 'Paste' from the shortcut menu. You can also use the keyboard shortcut of CTRL V to paste the text into the new location. After you paste, a clipboard will appear at the end of the pasted text.
5. Hover your mouse over the clipboard until an arrow appears to the right of the clipboard.
6. Click on the clipboard arrow to show a drop-down menu. These are your paste special options.
7. Choose 'Keep Source Formatting' to keep the formatting that was in the original document. 'Match Destination Formatting' matches the formatting of the pasted text to the surrounding formatting within the document to which you are pasting. 'Keep Text Only' pastes the text you have copied while ignoring any type of formatting.

Read more ►

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 ►