Monday, May 28, 2012

How to Freeze the Top Rows in an Excel 2007 Document So They Appear at the Top of Every Page

1. Open the Excel 2007 spreadsheet.2. Identify the row or rows at the top of the spreadsheet that you wish to freeze. Often just the first row is needed for this. You may choose multiple rows if desired.3. Click in the first row of the spreadsheet that is not to be frozen. That is, click any cell in the first row at the top of the spreadsheet that will be a part of the rows that will scroll. All other rows above this row will become frozen.4. Click the 'View' tab at the top of the Excel 2007 ribbon bar.5. Identify the 'Window' group on the 'View' tab. Click the menu arrow that appears...
Read more ►

Sunday, May 27, 2012

How to Calculate a Moving Average in Excel

1. Open a new worksheet in Microsoft Excel. Enter dates and their corresponding data points in two columns. For instance, to analyze monthly revenue figures, enter each month in column A and the corresponding revenue figure next to it in column B. A year's worth of data, then, would fill cells A1 through A12 and B1 through B12.2. Determine the time interval of the moving average you want to calculate, such as a three-month or six-month moving average. Go to the last value of the first interval and click on the corresponding empty cell to the right. Using the example from Step 1, if you want...
Read more ►

How to Convert Open Office Files to Microsoft Excel

1. Download and install the Open Office suite if it isn't already on the computer.2. Open 'Open Office Calc.'3. Click the 'Open' icon (folder that's open) at the top of the program.4. Choose the Open Office file you want to convert to Microsoft Excel and click 'Open.'5. Click the 'File' menu and choose 'Save As' and a window will appear.6. Select the drop box labeled 'Save as type,' and choose one of the listed types of Microsoft Excel formats. The format you select will be determined by the version of Microsoft Excel you plan on using to open the converted file (such as Microsoft...
Read more ►

How to Plot a Scatter Chart in Excel 2007

1. Enter labels into the first row of two columns and enter the data beneath it.2. Click and drag the mouse over all of the data you entered into your spreadsheet to highlight it, including the labels.3. Click the 'Insert' tab on the menu. Click 'Scatter' in the Charts section and select one of the five scatter chart types. Excel creates the scatter chart and displays it on the spreadshe...
Read more ►

How to Close MS Excel

1. Navigate to the 'File' tab in the top left-hand corner of the Excel program. Click on 'File' and click on the 'Save As' tab underneath 'File.' In the pop-up window, type in the name of the workbook and navigate to the location where you want it saved. Click 'Save.' This will ensure that none of your information is lost.2. Point your mouse cursor to the upper right-hand corner of the Excel program and hit the 'X' symbol to close out your workbooks. Do this with each open workbook.3. Navigate your cursor to the very upper-left hand corner of the Excel program and click on the Excel symbol....
Read more ►

How to Change a Cell to 26Pt in Microsoft Excel

1. Open Excel 2007. Click the 'Office' button and select 'Open.' Browse your computer for the spreadsheet you wish to revise; after you locate it, click on it. Click the 'Open' button and the document will open.2. Click a cell, then click the 'Home' tab. Select the 'Font' group and click the 'Font Size' drop-down box. Change the 'Font Size' to 26; the type in the cell is adjusted to 26 points.3. Save your changes by clicking the 'Save' icon in the Quick Access Toolb...
Read more ►

How Do I Set a Dropdown List Box in Excel to Allow Multiple Selects?

1. Open the spreadsheet you want to create the drop-down list for in Excel.2. Locate an area on the spreadsheet to house the list of data items that will appear in the drop-down list box. This can be in any location, or on a separate worksheet tab.3. Type the list in several cells of a single column. Place each list item in the cell below the prior item.4. Select the cells in your spreadsheet that will use the drop-down list box. Use the mouse and drag over the range of cells that are currently empty.5. Click the 'Data' menu and select the 'Validation' command. A pop-up box will appear.6....
Read more ►

How to Remove Blank Non

1. Open the Microsoft Excel spreadsheet that you want to filter.2. Highlight the range of cells that you want to include in the filter. You can highlight multiple cells by clicking while holding down the 'Shift' key.3. Open the 'Data' menu at the top of the window, expand the 'Filter' submenu and select 'AutoFilter.' This will add an arrow button to the top of each highlighted column.4. Click on the arrow button on one of the columns and select '(Blanks)' from the drop-down menu to show all blank cells and remove all non-blank cells.5. Click on the arrow button on one of the columns...
Read more ►

How to Unshare a Workbook in Excel 2007

1. Open the workbook you would like to unshare in Microsoft Excel 2007.2. Go to the 'Review' tab and go to the 'Changes' section.3. Click on 'Share Workbook' and go to the 'Editing' tab.4. Uncheck the 'Allow changes by more than one user at the same time. This also allows workbook merging' box. Click ...
Read more ►

How to Lock an Excel 2003 Spreadsheet

1. Launch Excel and open the spreadsheet which you want to protect.2. Click the 'Tools' menu, expand the 'Protection' submenu and select 'Unprotect sheet.' This step will allow Excel to reinitialize the protection of the spreadsheet. If the spreadsheet is password protected, you may have to type in the current password.3. Click the 'Tools' menu again, expand the 'Protection' submenu and select 'Protect sheet.' The 'Protection' dialog box will open.4. Click the actions which you wish to allow users to perform on the sheet in the 'Allow all users of this worksheet to' list. For example,...
Read more ►

Saturday, May 26, 2012

How to Remove Locked Cells in Excel 2003

1. Open Excel 2003 and click the 'File' drop down menu. Select 'Open.' Browse the files and locate the workbook. Click the workbook and the 'Open' button. The workbook opens.2. Click the worksheet that contains the locked cells. Click the 'Tools' drop down menu and select 'Protection.'3. Select 'Unprotect Sheet.' If a password was applied to the protection, you will be prompted to enter the password. Click 'Ok.'4. Click the 'Format' drop down list and select 'Cells.' Click the 'Protection' tab and de-select the 'Locked' option. Click 'Ok.' The lock is removed from the cel...
Read more ►

How to Use Excel to Calculate Total Time

1. Enter the starting date and time in cell A1 using the format 'month/day/year hour:minutes AM/PM.' For example, if your starting time is 7:15 a.m. on July 15, 2010, you would enter '7/15/2010 7:15 AM' in cell A1.2. Enter the ending date and time in cell A2 using the format 'month/day/year hour:minutes AM/PM.' For example, if your ending time is 7:15 a.m. on July 17, 2010, you would enter '7/17/2010 7:15 AM' in cell A2.3. Enter '=A2-A1' in cell A3 to find the number of days between the two times. Excel will automatically display the total time. In this example, Excel would automatically...
Read more ►

How to Make All of the Columns the Same Size in Microsoft Excel

Using a Mouse1. Open the Excel worksheet with data in columns.2. Hover your cursor over the letter of the first column you wish to select. When the black down arrow appears, click and drag across to the last column you want to select.3. Hover on the line between any two selected column letters--it doesn't matter which two--until you see a black symbol with two arrows pointing in opposite directions. Click and drag left to make the columns narrower or drag right to make them wider. All the selected columns should now be of equal width.Using the Menu4. Open the Excel worksheet with data...
Read more ►

Friday, May 25, 2012

How to Use the Date Function in Excel to Show Next Month

1. Open Excel 2007 and type '2010' in cell A1. Enter '10' in cell A2 and '11' in cell A3. This information will be used as reference data in the Date function. Enter the Date function '=Date(A1,A2,A3)' in cell B1. This function will display a numerical representation of the date 10/11/2010.2. Format how the date displays by right-clicking cell B1 and selecting 'Format Cells.' Click the Number tab and pick the 'Date' category. Select a date format. Click 'OK.'3. Change the formula in cell B1 to add 30 days to the current day to display the next month. Enter the following formula: '=DATE(A1,A2,A3...
Read more ►

How to Create a Linear Chart Using Excel 2007

1. Open Microsoft Excel from the 'Start' menu and wait for the application to load.2. Enter the data you want to convert into a chart into cells on a spreadsheet. Include labels for each column in row 1. Ensure that the X and Y values are in their own columns and each row contains the X and Y value that should be graphed together on the chart.3. Click and drag from the top-left cell to the bottom-right cell to highlight all the data you want to include in the chart.4. Click the 'Insert' tab on the top of the screen.5. Click 'Scatter,' and then choose the chart type you wish to use. As...
Read more ►

Blogger news