1. Close any open Excel windows.2. Click 'Start' and then click 'Run' from Windows XP; click the 'Microsoft' button and then click 'Run' from Vista; or click the 'Microsoft' button, then type 'Run,' then click 'Run' from Windows 7.3. Type 'excel.exe /unregserver' into the text box and then click 'OK.'4. Type 'excel.exe /regserver' into the textbox and then click 'O...
Browse » Home » Archives for December 2013
Saturday, December 28, 2013
How to Calculate the P
Calculate Correlation1. Open the workbook that contains your data in Excel 2007.2. Determine the cell addresses that contain the two ranges of data that you want to compare. For example, if your data is contained in the first 20 rows of columns 'A' and 'B,' then the two cell address ranges for your data are 'A1:A20' and 'B1:B20.'3. Click a cell that you want to use to calculate the Pearson correlation coefficient 'r.'4. Type '=PEARSON(A1:A20,B1:B20)' -- without the quotes -- in the cell. Substitute the addresses of your data ranges in place of these sample ranges.5. Press 'Enter.' Excel...
How to Send a Microsoft Excel 2007 Worksheet As an Email
Sending an Excel File Via E-mail1. Power on your computer and open your e-mail server or log in to your online e-mail.2. Click the button 'New' to create a new message. Enter the recipient's e-mail address in the 'To' field. Enter a subject line and any other text, if desired.3. Click on the 'Attach' button or in some cases, the button that looks like a paper clip. A window appears with a button marked 'Browse.'4. Click on the 'Browse' button and navigate to the folder where your Excel file is located. Once selected, the e-mail client will store it as part of the e-mail. Some e-mail clients...
How to Insert a Row in Microsoft Excel 2003
How to Add a Single Row1. Open an Excel Worksheet or create a new one.2. Highlight the row header immediately below where the new row should appear.3. Select 'Insert' on the menu bar.4. Click 'Rows' from the drop down list. The new row is now found above your highlighted selection.How to Add Multiple Rows5. Open an Excel Worksheet or create a new one.6. Highlight the number of row headers immediately below where the new rows should appear.7. Select 'Insert' on the Menu Bar and click 'Rows' from the drop down list. The new rows will be inserted above your highlighted selecti...
Friday, December 27, 2013
How to Use Correlation on Excel 2007
1. Open Microsoft Excel 2007. Click on the 'File' option, then select 'Open.'2. Locate the Excel file that contains the different variables for which you want to calculate the correlation coefficient, then click 'Open.'3. Select the data you want to compare by highlighting the data with your mouse. Click on the 'Data' tab, then click the 'Data Analysis' option from the 'Analysis' group.4. Click the 'Correlation' option, and the Correlation dialog box will appear. Click on the button in the 'Input Range' field to make sure the correct fields are selected.5. Select the 'Columns' or...
How to Use Microsoft Excel to Draw Control Charts and Graphs
Excel 20071. Open a new file by clicking on the “Office” button and choosing “New.”2. Type “control chart” into the ‘Search Microsoft Office Online for Templates’ box.3. Click on the control chart that appears, then click the “Download” button. The file will download and automatically open. At this stage, you can tailor the control sheet to fit your needs, perhaps by changing the titles in the columns or by placing different totals in the boxes.4. Graph the control chart. Highlight the text by left clicking at the top left corner of the data and then dragging the cursor to the bottom right....
How to Insert a Watermarked Picture in Excel 2007
1. Open your Excel document. Select the 'Insert' tab.2. Click the 'Picture' icon on the ribbons bar. Search for the file or picture on your computer. A new window will appear; select the file. Select 'Insert' and the picture will appear in the document.3. Drag and click the picture into the position you would like.4. Double-click on the photo for the picture toolbar to appear. On the toolbar, click 'Format Picture.'5. Select 'Watermark' under the 'Image Control/Color' tab. Lighten or darkened your watermark as necessa...
Thursday, December 26, 2013
How to Get Microsoft Excel Cells to Shade Gray When Highlighted
1. Open the Microsoft Excel program on your computer. It is usually found in the 'Start' menu under 'Microsoft Office' in most computers.2. Open a new spreadsheet or select an existing spreadsheet to edit. To open a new spreadsheet, click 'File' and 'New' at the top left-hand side of the program. To open an existing spreadsheet, click 'File' and 'Open.' You can then browse your hard drive for an existing spreadsheet.3. Select the cell or cells you wish to fill. Click on the cell once to highlight it. If you wish to choose a group of cells, hold down the 'Shift' button while selecting cells.4....
How to Use the Paste Special Command in Excel
Switching Rows of Cells to Columns or Columns to Rows1. Select the cells that you want to switch.2. Open the Edit menu and select Copy.3. Select the upper left cell of the paste area. The paste area must be outside the copy area.4. Open the Edit menu and select Paste Special.5. Select the Transpose check box.6. Click OK.Pasting Only Values, Formulas, Comments, or Cell Formats7. Select the cell or range of cells you want to copy.8. Open the Edit menu and select Copy.9. Click the cell you want to paste the information into, or click the upper left boundary of the cell range you...
How to Copy an Array to a Range in Excel 2007
1. Open Excel and load the worksheet with the data sets you want to use to feed an array formula.2. Select a cell and enter the array formula. For example, if you wanted to have the formula multiply the number in B1 by the number in C1, you'd enter the formula =B1*C1. Hit 'Ctrl'-'Shift'-'Enter' to make sure it's entered as an array formula.3. Select the cell with the newly entered array formula. Hit 'Ctrl'-'C' to copy it.4. Select the other cells in the range you want in the array formula. Hit 'Ctrl'-'V' to copy the array formula throughout the ran...
How to Create Named Ranges in Excel 2007
1. Launch the Microsoft Excel program by double-clicking the program's shortcut on the desktop or by selecting 'Microsoft Excel' from the 'Start', 'Programs' or 'All Programs' menu.2. Click the 'Office Button' in the upper left corner of the program window and select 'Open.' Click the down arrow to the right of the 'Look in' text box to browse to the folder that contains the file you want to work with. Select the file, and click 'Open.' If you are creating a new spreadsheet, Click the 'Office Button' and select 'New.' Select 'Workbook' and click 'OK.' A blank spreadsheet should be displayed....
Wednesday, December 25, 2013
How to Make a Striped Line on a Bar Graph in Excel on a Mac
1. Double-click the Excel icon on the Dock or find the program in your Applications folder and double-click it. Open the Excel graph through the File menu. Alternatively, find the graph on your hard drive and double-click it.2. Click on the a bar in your graph and click the 'Format' tab on your toolbar.3. Click the down arrow on the 'Shape Fill' button. Click 'Texture' and then 'More Textures.' Click the circle by the label 'Picture or texture fill.' Click the 'ClipArt' button. In the search box type 'lines' (without quotes). Press 'Enter.' A selection of graphic lines will appear on your...
How to Print or Page Setup in Excel 2007
1. Click the Office Button at the top left-hand corner. Select 'Print' from the options available and then select 'Print Preview.' In the Print Preview view you will see how the printed copy will look, as well as view and adjust the margins and view page setup options.2. Select 'Page Setup.' In the dialog box that appears you can set the spreadsheet to print in Landscape mode instead of Portrait. Click the 'Margins' tab to adjust the margins of your spreadsheet as well as vertical and horizontal alignment.3. Click the 'Header/Footer' tab. Enter any information you want to appear in the...
How to Make Drop Down Fields in Microsoft Excel
1. Start Microsoft Excel. Open a new blank spreadsheet, or open the spreadsheet to which you want to add a drop down list.2. Select the cell or the range of cells in which you want to make a drop down list.3. Open the Data Validation dialog by going to the 'Data' menu in Excel 2003 and selecting 'Validation,' or by clicking the 'Data' tab of the ribbon in Excel 2007 and selecting 'Data Validation.'4. Go to the 'Settings' tab. Click the drop down arrow under 'Allow' and select 'List.'5. Type each list item into the 'Source' box, placing a comma between each word in the list. Click 'OK'...
Tuesday, December 24, 2013
How to Find Duplicate Entries on Excel
1. Launch Microsoft Office Excel 2007 on your computer.2. Select the rows or columns where you want to find the duplicate entries. Point your mouse in the first cell and continue to hold down the mouse while you drag over the cells you wish to search.3. Click the 'Home' tab and then click 'Conditional Formatting' under 'Styles' in the top menu.4. Select 'Highlight Cells Rules' from the drop-down menu. Click on 'Duplicate Values.'5. Select 'Duplicate' under 'Format cells that contain:' in the Duplicate Values dialog box.6. Select a highlighting style from the drop-down menu in the Duplicate...
How to Have Three Secondary Axes on Excel 2007
1. Open the chart you want to work with by clicking the Office button, 'Open,' and selecting the file.2. Click the chart you want to add the additional axes to. This brings up the 'Chart Tools' tab in the top right corner of Excel.3. Click the 'Format' tab. Select the arrow under 'Chart Area' (in the 'Current Selection' group on the left side of the toolbar). This brings down a selection box. Choose the series you want to add an additional axis to.4. Click 'Format Selection.' Format Selection is directly below the 'Chart Area' tab.5. From the 'Series Options' tab (this should be the...
How to Convert Excel 2003 to PDF
1. Open the Microsoft Excel 2003 spreadsheet that you want to convert to PDF.2. Click the 'File' option from the top navigation bar.3. Select 'Print' from the context menu.4. Select 'Adobe PDF' from the 'Printer Name' drop-down box. A file dialog box will appear.5. Type a new name for the new PDF file.6. Specify a new location for the file, if desired, using the drive and folder navigators.7. Click the 'Save' button. The Excel 2003 file has now been saved as a PDF.8. Open the new PDF file in Adobe Acrobat or Reader and verify that it has was converted correct...
How to Create a UserForm in Excel 2007
1. Start Excel 2007 and open a new workbook. Click the Microsoft Office Button (on the upper left corner of your task bar), and select Excel Options. In the new pop-up window, click Popular, and check the box titled 'Show Developer tab in the Ribbon.' In Microsoft Office Excel 2007, click Visual Basic in the Code group on the Developer tab. You should now see the Developer Tab on the top of your screen.2. Click Visual Basic on the Developer tab. Visual basic can be found under Code group on the Developer tab. Now go the Insert menu and select User Form. You can now customize your User Form...
How to Calculate Variance in Excel 2007
1. Enter your data into one row in Microsoft Excel.2. Type '=VAR(' in a cell that does not have data. For example, if all of your data is in column A, then use cell B1 for the variance function.3. Highlight your data by clicking on the top of the data and dragging the mouse down to the bottom of the data.4. Type ')' in the cell with your variance function to close the function and then press Enter. The cell now displays the variance of your da...
How to Use Microsoft Excel COUNTIF
1. Open or create a Microsoft Excel worksheet with columns or rows of text in which you want to tally the number of cells containing a single word and nothing else. For example, you could have a column labeled 'Trip Date' and another column labeled 'City.' Let's say you want to find out how many times you went to Detroit in a month.2. Click the cell at the bottom of the City column. Although you can place the Countif formula in any location, for this example, we will be placing it beneath the City column to count the occurrences of the word Detroit.3. Type '=COUNTIF(range,criteria),' where...
Monday, December 23, 2013
How to Format Excel Margins
1. Click the 'Page Layout' button on the menu ribbon at the top of the screen.2. Click the 'Margins' button.3. Click 'Custom Margins' at the bottom of the menu.4. Click in each text box, and enter the amount you want the margins to be. Do the same for the header and footer.5. Check the two 'Center on Page' boxes to center the image horizontally and vertically, then click 'OK' to finalize the formatti...
Sunday, December 22, 2013
How to Adjust the Right Margin in Excel
1. Open Microsoft Excel.2. Click the 'Page Layout' tab.3. Click 'Margins' and select 'Custom Margins.'4. Change the value of the right margin to whatever you need.5. Click 'OK' to close the 'Custom Margins' b...
How to Make a Line Graph From a Data Table
1. Open the Excel worksheet.2. Click and drag to select the data and categories on the worksheet. A dark outline appears around the range of cells.3. Click the 'Insert' tab on the command Ribbon.4. Click the 'Line' arrow in the 'Charts' group. A list of chart thumbnails appears, such as '2-D Line' and '3-D Line.'5. Click the 'Line' button from the 'Line' section. The data converts to an embedded line graph that hovers over the worksheet. The 'Chart Tools' ribbon appears.6. Edit the chart using the buttons in the 'Design,' 'Layout' or 'Format' tabs, if preferred. The 'Design' commands...
How to Use Ticks in Excel
1. Open the Excel file.2. Click 'Developer Tools' on the command ribbon.3. Click the down arrow on the 'Insert' button in the 'Controls' group. A list of controls appears.4. Click the 'Check Box' button. This button displays a check mark inside of a square. The pointer changes to a ' ' symbol.5. Click on the cell to place the check box. A square and the text 'Check Box 1' display on the worksheet.6. Edit the text if desired. For example, delete 'Check Box 1' and type an item or a step to compile a list.7. Click the text to insert a check or tick in the check box. To remove the check,...
Friday, December 20, 2013
How to Plot a Secondary Axis on Microsoft Excel
Secondary Vertical Axis1. Open the spreadsheet in Excel that contains the chart to which you want to add a secondary axis. Click the 'Microsoft Office' button, then click 'Open' and then locate the file on your computer. Click 'Open' to open the file. Your existing chart should pop up on the screen when you open the spreadsheet. Depending on the type of graph you created, it could be a bar chart, line graph or other graph type.2. Click the data series in the chart you want to plot on a secondary axis.3. Click the 'Format' tab, then click 'Format Selection' in the 'Current Selection' group.4....
How to Open Excel 2007 in an Earlier Version of Excel
1. Go to the Microsoft Download Center online.2. Click on the Microsoft Compatibility Pack. Click 'Download.'3. Click 'Run' in the box that appears on the screen.4. Click 'Run' in the next box that appears on the screen.5. Check the box 'Accept' to accept the terms.6. Click 'OK' in the next box to appear on the screen. Wait for the loading to finish.7. Open Excel and double-click on the Excel 2007 file that needs to be opened. Wait for the file conversion to complete.8. Makes changes and work in the file, saving it when do...
Thursday, December 19, 2013
How to Insert a Tab Name in a Cell
1. Open Microsoft Excel. Choose the spreadsheet you want to work with.2. Click on the cell where you want to insert the tab name.3. Enter the following formula into the cell:=MID(CELL('filename',A1),FIND(']',CELL('filename',A1)) 1,2...
How to Convert Excel to DAT
1. Double click to open your Microsoft Excel 2010 file.2. Click the 'File' tab in the upper-left corner, then select 'Save As.'3. Click the drop-down menu to the right of 'Save As Type' and select 'CSV (Comma Delimited).'4. Click the 'Save' button, click 'OK' to save the active sheet, then click 'Yes' to keep the worksheet in CSV format.5. Right click the CSV file you just created, click 'Open With' and select 'Notepad.'6. Click 'File' at the top of the window, then click 'Save As.'7. Click the drop-down menu to the right of 'Save As Type' and choose 'All Files.'8. Click inside...
How to Change the Macro Security Levels on Excel 2003
1. Open the Microsoft Excel 2003 application on your computer, and then click the 'File' option from the top toolbar menu.2. Click the 'Open' option, and then select the Excel 2003 document you want to work with. Click the 'Open' button.3. Click the 'Tools' option from the top Excel toolbar menu, and then click the 'Options' button.4. Click the 'Security' tab in the new dialog box that appears on the screen. Click the 'Macro Security' option.5. Select the 'Security Level' tab and then select the 'Very High', 'High', 'Medium' or 'Low' option. Click the 'OK' button and close out of the...
How to Delete the First Five Characters in Excel 2007
1. Open your spreadsheet in Microsoft Excel 2007.2. Locate the cell that contains the text you need to truncate.3. Enter the following text in a new cell, replacing 'old_text' with the cell reference of the text you need to truncate.=REPLACE(old_text,1,5,'')As an example, to delete the first five characters from cell A1, you would enter:=REPLACE(A1,1,5,'')Alternatively, you can replace 'old_text' with the actual text encased in quotes. As an example, to delete the first five characters from the text 'truncate me!,' you would enter:=REPLACE('truncate me!',1,5,...
Wednesday, December 18, 2013
How to Calculate Business Quarters in Excel Not Based on Calendar Year
1. Open a new workbook in Excel and enter a list of random dates that can be used for testing.You can copy these example dates to your sheet beginning in cell A1:1/4/20102/11/20103/21/20104/28/20106/5/20107/13/20108/20/20109/27/201011/4/201012/12/20102. Determine the number value of the month in which your 'year' starts (e.g. January is 1 and November is 11). For this example, the year will start in October (month 8).3. Subtract one from your month value. In this example, the result would equal seven (7).4. Substitute your new value into the following equation:=MOD(CEILING(22 MONTH()...
How to Copy Formulas Without Changing Them in Excel
1. Open your Excel document.2. Click on the cell containing the formula you wish to work on.3. Locate your cell references in the formula shown in the Formula Bar. These will be a letter followed by a number, such as A3 or D14.4. Place a dollar sign ($) in front of the letter and number of the cell reference you don't want to change. Examples would be $A$3 or $D$14.5. Copy your formula to the other parts of your spreadsheet--you'll see that Excel does not change your cell referenc...
Tuesday, December 17, 2013
How to Center Horizontally and Vertically in Excel
Center Horizontally1. Click the cell or cells in which you want to center data horizontally.2. Click the 'Home' tab.3. Click the 'Center' button located in the 'Alignment' group. The Center button centers the text horizontally in the selected cell.Center Vertically4. Click the cell or cells in which you want to center data vertically.5. Click the 'Home' tab.6. Click the 'Middle Align' button located in the 'Alignment' group. The Middle Align button centers the text vertically, between the top and bottom of the ce...
Monday, December 16, 2013
How to Lock a Formula in Excel 2007
1. Select the cell containing the formula you wish to lock by highlighting it.2. Click on the 'Home' tab, which is located on the top of the Excel window.3. Navigate to the 'Cells' module, which is on the right half of the Excel window. Select 'Format.' A menu displaying cell formatting options will appear.4. Navigate to the 'Protection' section of the format menu. Click on 'Lock Cell,' highlighting the lock icon.5. Protect the sheet; until you do so, locking the formula cell will not take effect. Repeat steps 2 and 3. Select 'Protect Sheet' from the cell formatting menu. A dialog box...
How to Do Descriptive Statistics in MS Excel 2007
Analysis ToolPak1. Install the Microsoft Office Analysis ToolPak. Click the 'Microsoft Office Button' and then 'Excel Options.'2. Click 'Add-ins' and then 'Excel Add-ins' located in the Manage box. Click 'Go.'3. Select 'Analysis ToolPak' in the Add-ins Available box and click 'OK.' If you do not see the Analysis ToolPak option, click 'Browse' to locate it. Click 'Yes' to install it if a prompt signifies that it is not installed on your computer.Descriptive Statistics4. Collect the data you would like to analyze. The descriptive statistics tool will be used later to organize and interpret...
How To Calculate Mortgage Payments in Excel
1. Start a new, blank workbook in Excel. In Excel 2007, click the 'Office' button and click 'New'; then click 'Microsoft Online.' In Excel 2003, go to the 'File' menu and click 'New'; then go to the 'Templates' section of the task pane.2. Type 'mortgage calculator' in the 'Search Microsoft Online' box and click 'Go.' A list of possible templates will appear.3. Select the 'Mortgage Payment Calculator' template and click the 'Download' button. The Mortgage Payment Calculator template will open as a new Excel spreadsheet.4. Enter the mortgage loan amount in cell C7. Enter the interest rate...
Sunday, December 15, 2013
How to Prepare an Excel PivotTable
Using Excel Data1. Open the Excel file that has the information that you want to make into a PivotTable.2. Edit the range of data that you will use to remove any blank rows. Also place a column name in the top row, for any column that doesn't have one.3. Select any cell in the range of data that you want to use.4. Click on the 'Insert' tab at the top of the screen, and then click the 'PivotTable' button that appears on the toolbar. A small window will appear, and Excel will automatically select the entire range of data. Press 'OK' to continue, and the PivotTable will be created on a new...
How to Turn Off Sharing in Excel 2007
1. Launch Microsoft Excel and locate the 'Review' tab on the ribbon located on the top of the screen.2. Click the 'Share Workbook' tool located in the 'Changes' group to launch the 'Share Workbook' dialog box. You should see a check mark next to the 'Allow Changes' check box.3. Click the 'Allow Changes' check box to clear the check mark. Click 'OK' to save your changes and disable shari...
How to Interpret the Linear Regression Summary in Microsoft Excel 2003
1. Right-click on the regression line in your chart, and choose Properties. Check 'Display equation on chart' and 'Display R-squared value on chart'. Click OK.2. Look at the R-squared value displayed next to the regression line. The R-squared value represents the amount of variability in the data that is explained by the linear regression analysis. If all the data lies exactly on the regression line, the R-squared value will be 1. If the R-squared value is 0, that means there is no correlation between the two datasets.3. Turn your attention to the equation listed above the R-squared...
How to Create an Excel Spreadsheet to Figure Out Sick Leave
1. Type 'Vacation and Sick Leave Record' in cell E1. In cell E2, write the period that the sick leave worksheet is applicable to. For example, write '1/1/2010 to 12/30/2010.'2. Type the employee's name in cell A4. Optionally, type their maximum sick leave accumulation on the next line in days or hours.3. Type the word 'Month' in cell A6. Type the months January through December directly underneath, in the same column, with one month per row.4. Type the word 'Amount' in cell B6, the word 'Used' in cell C6 and the word 'Balance' in the cell D6.5. Enter the total number of the employee's...
How to Password Protect Excel 2003
1. In order to protect your Microsoft excel worksheet go to TOOLs menu select PROTECTION. From there you should see a menu like the picture on your left.2. From there you will be given a series of options that will allow you to protect a Microsoft excel worksheet, workbook or a range on your specific file. As you can see from the image on your left you can get very granular with this.3. Make your appropriate adjustments and then click OK. You should be prompted to retype the password. Once that is done make sure you save your changes and close the document and reopen it to see if your password...
Saturday, December 14, 2013
How to Create a Box Plot in Microsoft Excel 2007
Set Up the Plot Data1. Create a table with a column for each data set. In the table rows, add formulas for the calculations of (in order) the minimum, first quartile, median, third quartile and maximum for each data set using the Excel functions MIN, MAX, MEDIAN and QUARTILE (or PERCENTILE). This is the 'summary table.'2. Create a second table with the same rows and columns as above. This table will contain the values used for the plot. This is the 'plot data table.'3. Add a formula for each data set's maximum value in the plot data table that is the maximum minus the third quartile values...
How to Do Percentages With Excel 2003
1. Open Excel 2003, and open a workbook that contains a column with amounts and another column with totals. Click 'File' on the menu bar, and click 'Open.' Browse your files, and locate the workbook. Click the workbook and select the 'Open' button. The workbook opens.2. Click in the next available column in your workbook. Type '=.' Click in the first cell that contains the first amount. Type '/.' Click in the first cell that contains the first total, and press the 'Enter' key. A value is generated.3. Highlight the column containing this new formula. Click the '%' symbol on the...
How to Maximize a Sheet in Excel 2007
1. Open an Excel worksheet by clicking on the round 'Office' button in the top left-hand corner of Excel 2007. Select 'Open' from the drop-down menu on the left. Choose the file name of the Excel document that you wish to open.2. Click on the 'maximize' button in your Excel work window. You'll find it just to the left of the 'close' button in the top right corner. An 'X' identifies the close button, and a square, the maximize button. The maximize function changes your worksheet to maximum size within your open Excel document.3. Click on the 'restore down' button to make your worksheet smaller....
Friday, December 13, 2013
How to Sort and Filter in Microsoft Excel
1. Open Microsoft Excel and go to 'File' and 'Open' to open the document containing data you want to sort and filter. Highlight the document and click 'Open.' The document will open in a new window.2. Highlight the data you want to sort. You may select an entire worksheet, a column, multiple columns or specific data within a column.3. Complete a simple sort by selecting the 'Home' tab from the ribbon and from the 'Editing' group selecting 'Sort and Filter.'4. Click the appropriate option that matches your preferred sort. For example, if your data is a group of dates, click 'Sort Oldest...
How to Use Absolute References in Microsoft Excel
1. Enter a value into the cell you want to keep constant.2. Select another cell in the Excel spreadsheet for the formula that will use the absolute reference.3. Enter the formula. Use the dollar sign ($) in front of the row reference to keep to keep the row absolute or in front column reference to keep it absolute. For instance, '$C$21' is an absolute reference for cell 'C21,' while 'C$21' an absolute reference to row '21' but but a relative reference column '...
Thursday, December 12, 2013
How to Convert Word to Excel 2007
1. Launch Microsoft Word and open the document that you want to convert to Excel. Click once on the Microsoft Office button and select the 'Open' option. Locate the folder in which the document is saved in the 'Look in' section of the 'Navigation Pane.' Double click on the file name to open it. If you do not have either program, a free trial may be downloaded from the Microsoft site.2. Save the Word document as a text (TXT) file. Click once on the Microsoft Office button and select the 'Save As' option. Select a folder in which to save the text file using the 'Save in' menu. Use the 'Save...
How to Unlock Grayed Out Menus in Excel 2007
1. Position your cursor so that it is on one of the sheet tabs at the bottom of the screen. Make sure the sheet tab is highlighted.2. Right-click the sheet tab. Choose 'Ungroup Sheets' from the drop-down menu.3. Click one of the menus. All of the options should now be visible. If the options are still grayed out, right-click the sheet tab again and choose 'Ungroup Sheet...
How to Remove a Contribute Toolbar From Excel 2003
1. Open Excel. Customizations to the toolbar interface are always accomplished within the program. However, it does not matter what file is opened within Excel, or if the program window is open without any files loaded.2. Locate the 'Contribute' toolbar. It is important to see the toolbar when it is active so you can easily verify if the removal process was successful. As there are many toolbars, removing a single toolbar is not always obvious unless you are aware of its precise location in the program window.3. Click the 'View' menu. Select the 'Toolbars' submenu. If the 'Toolbars' submenu...
How to Open WB3 Files in Excel 2003
1. Launch 'Excel.'2. Go to 'File.' Select 'Open,' choose 'Quattro Pro/DOS' from the 'Files of Type' drop-down menu. Navigate to the folder where your WB3 file is located, and double-click to select the file.3. Go to 'File,' and select 'Save As.' Choose 'Excel 97-2003 Workbook (*.xls)' from the 'Save as Type' options. Click 'Sav...
How to Create Mailing Labels From an Excel Database
1. Open Microsoft Word. Click the 'Mailings' tab and click 'Start Mail Merge.' Select 'Labels.' The 'Label Options' dialog box will open, where you can set up the labels.2. Select the type of printer you are going to use under 'Printer Information.' Click the 'Label Vendors' list and select the manufacturer of your label sheets. Select the product number listed on your label sheet packaging from the 'Product Number' list. Click 'OK.' The sheet of labels is set up as a table in your document.3. Click the 'Mailings' tab, then 'Select Recipients' in the 'Start Mail Merge' group. Click 'Use...
Wednesday, December 11, 2013
How to Set Up Formulas in Excel 2007
1. Click the cell where you want to display the results.2. Press '=' on your keyboard to start a formula.3. Add a parenthesis and the name of the first cell you want to include in your formula. For example, your formula to this point should look something like this: =(A14. Add the operator -- ' ,' '-,' '*' or '/' -- you want this formula to perform. For example, =(A1 5. Type the location of the next cell for your formula and repeat Steps 3 and 4 -- minus the parenthesis -- until you have listed all the cells you want to include in your formula. For example, =(A1 A2 B1 B2 C1 C26. Add...
How to Change Appearance in Excel 2007
1. Choose a document theme to unite all of your Office 2007 programs with the same look. A document theme shares the same colors, fonts, lines, fill effects and other style choices. Select a document theme from the available choices or create a new document theme by going to Page Layout and selecting 'Themes.' Click on a document theme from 'Built-in' or 'Custom.' When you create a custom theme, save it under a new name.2. Click Page Layout View to adjust margins or add headers and footers. This feature is similar to the Print Layout view in Word.3. Use the different style choices to change...
How to Recover an Excel File That Was Saved Over
Using AutoRecover1. Click 'Start' and then 'Search.'2. Select 'All Files and Folders' when asked what you want to search for.3. Type in '*.xls' (without the quotation marks) under 'All or Part of the File Name.'4. Click on the arrow next to 'More advanced options' and make sure that the file type reads 'All Files and Folders.'5. Click the boxes next to 'Search System Folders' and 'Search Hidden Files.'6. Click 'Search.'7. Look for an earlier version of your file (it should have a similar name). When it appears, open it to see if it is the version you wa...
How to Freeze Rows Columns
1. Place the cursor in the cell directly below the row you want to remain visible (freeze) and directly to the right of the column you want to remain visible (freeze). For example, if you want Row 1 and Columns A through C to remain visible (freeze), place the cursor in cell D2.2. Click on the 'Window' menu.3. Select 'Freeze Panes.'4. Move the cursor through the spreadsheet and notice that Row 1 and Columns A through C are frozen. In other words, they always remain visible while the rest of the data move.5. Click on the 'Window' menu and select 'Unfreeze Panes' to remove the frozen...
Subscribe to:
Posts (Atom)