Friday, May 27, 2011

How to Recover Deleted Excel Files

Enable Automatic Recovery and Saving1. Open Excel and select 'File,' 'Help,' and then 'Options.'2. Select 'Save' and set the number of minutes between automatic saves in the provided check box.3. Check the box to 'Keep the last autosaved version if I close without saving' if it is not already checked.Recover Earlier Versions of an Excel Worksheet4. Open Excel and select 'File.' If you are recovering an existing worksheet, select 'File,' and then 'Open' to select that worksheet.5. Select 'Recent' to recover a brand-new file that you have not yet saved. Select 'Info' to recover an existing...
Read more ►

How to Use Autofilter in MS Excel

1. Look at your data and decide what columns (or rows) you want to be able to sort with. Highlight those columns or rows and select 'Data' on the main menu. Then select 'Filter' and then click on 'Autofilter.'2. You now have drop down arrows in each title box. Each arrow can be clicked on to filter your data according to that column. Whatever you click on will become the only data visible.3. If you go to the 'DRAFT' title cell and click on the arrow, then click on '3/25/2008' in the autofilter column, you will be left only with data that matches.4. Notice that the arrow in 'DRAFT'...
Read more ►

Thursday, May 26, 2011

How to Email One Sheet in an Excel 2007 Workbook

1. Open the Excel file that you want to send. With the tabs at the bottom, find and click on the worksheet in the file that you want to email.2. Click on the 'File' menu, and select 'Send to.' Select 'Mail Recipient.'3. Pick the selected worksheet in the notification dialog box that appears. Click on the 'OK' button.4. Type the email address of the recipient in the 'To:' field. Write a message, and click on 'Send this Shee...
Read more ►

How to Make an Address Book in Excel

1. Click the 'Start' menu and go to 'All Programs.' Select 'Microsoft Office' followed by 'Microsoft Excel' to open Excel.2. Type 'Name' in cell A1 of the spreadsheet, type 'Address' in cell B1 and type 'Phone Number' in cell C1.3. Enter the data for your address book, starting in the second row. Enter the information based on the headers you create in Steps 2 through 4, so column A has the person's name, column B has the person's address and column C has the person's phone number. If you plan to alphabetize your address book, you may want to enter the names in a last-name-first format.4....
Read more ►

How to Alphabetize in Excel 2003

1. Open Excel 2003 and select a worksheet containing data. Click 'File' on the menu bar and select 'Open.' Search your files for the workbook. Click the workbook and select the 'Open' button. The workbook opens.2. Highlight the range of data that you want to sort. Include the column headers in your highlighted range. The column headers are important, for when you decide which columns you want to sort.3. Select 'Data' --> 'Sort.' The Sort dialog box appears. In the 'Sort By' drop-down list, select a column header that you want to sort by. Select 'Ascending.' Click 'OK' to alphabetize...
Read more ►

How to Learn MS Excel Fast

1. Open Microsoft Excel or download a free trial program. Explore the in-program tutorial options by clicking the 'File' tab in the top-left corner of the screen and selecting 'Help.' Double-click the 'Getting Started' button to open the Microsoft Excel website or click the blue question mark 'Microsoft Office Help' button to open a searchable database of information. Type in a word or phrase such as 'cells,' 'sorting data' or 'columns.'2. Visit the Microsoft Excel website for Excel tutorials, videos, plus setting-up and getting-started instructions. The Microsoft Excel support center (see...
Read more ►

Wednesday, May 25, 2011

How to Make Trend Charts With Excel

1. Create a chart with names and grades. This can be mock information. In cell A1, type 'Names' and in cell B2 type 'Grade'. Enter the names and grades for 10 students.2. Click the Insert tab. Click the down arrow under the Column option. Select the first option under the 2-D Column row. A chart will appear.3. Right-click on one of the bars in the graph. Go to Add Trendline.4. Select the Linear radio button, then click 'Close.' A trendline has been added to the chart for a trend cha...
Read more ►

How to Apply a Theme to a Worksheet

1. Open the Excel worksheet.2. Click the 'Page Layout' tab on the command ribbon.3. Click 'Themes' in the 'Themes' group. A gallery of 'Built In' theme samples appears.4. Point over the theme samples to preview the effect. The column and row headers also change in format.5. Click the preferred document theme. Examples include 'Concourse' with red hyperlinks and 'Newsprint' with 'Times New Roman' fonts.6. Type the data in the worksheet. The data formats with the preferred the...
Read more ►

How Can I Put Text a Formula Into the Same Cell in an Excel Spreadsheet?

Test the theory1. Open a new workbook or spreadsheet and click in cell A1. Type the number 2.2. Click in cell A2 and type the number 2 there.3. Click in cell A3 and type:=SUM(A1,B1)4. Press 'Enter' or click elsewhere on the spreadsheet and the cell will show the number 4 (as this is the sum of 2 2). Note that the function bar (the long white strip next to the 'fx' symbol) still shows the formula '=SUM(A1,B1).'5. In the function bar, place your cursor after the equal symbol and type:'The sum of 2 2 is 'Include both quotation marks and the space after 'is' but no other spaces.The complete...
Read more ►

How to Format Numbers in Excel 2003

1. Open your Excel worksheet and select a group of cells. Press the left mouse button and drag over the cells.2. Click 'Format' on the top menu bar. A list of options for formatting your worksheet will appear.3. Click on the 'Cells' option. This will open a window of tabbed options for formatting cells.4. Click on the 'Numbers' tab (it's the default tab). You will see a list of categories of numbers on the left and options for formatting them on the right.5. Click on the category you want to format (Number, Currency, Accounting, etc.) and choose how you want these numbers to appear using...
Read more ►

How to Drop Decimal Places Without Rounding in Microsoft Excel

1. Open a blank worksheet in Excel and type a decimal number in the A1 cell. Use this worksheet for practice before applying the procedure to an actual file.2. Type the 'integer function' into cell B1 as follows: f=INT(A1). The integer function lops off the decimal value of a number leaving only the whole number digits to the left of the decimal place. The formula in cell B1 instructs Excel to find the integer value of cell A1 and place that value in cell B1.3. Click any other cell in the spreadsheet to exit from cell B1. The cell will now display the integer value of the number in A1. For...
Read more ►

Tuesday, May 24, 2011

How to Make Bullets in Excel Entries

Insert a Bullet to a Cell1. Open the Excel worksheet.2. Double-click the cell where you wish to insert the bullet symbol.3. Press “Alt” and “7” using the numeric keypad on the keyboard. A black bullet appears in the cell. To create a bullet with a white interior and a black outline, press “Alt” and “9” on the numeric keypad. If you prefer a different bullet style, click the “Insert” tab on the command ribbon. Click “Symbol” in the “Symbols” group. Select a font. Select the bullet symbol. Click “OK” and “Close.”4. Add more bulleted lines in the same cell by pressing “Alt” and “Enter.”...
Read more ►

How to Check Each Control of a Group in Excel VBA

1. Click the 'Developer' tab's 'Visual Basic' button to enter the VBA programming environment, then click the 'Insert' menu's 'Userform' item to create a new form on which to place controls. If the 'Developer' tab does not appear among your menu choices in Excel, you may need to turn on its display in Excel's options.2. Click the 'Button' control on the tool box, then drag on the userform to create a button. Click the 'OptionButton' control from the tool box, then drag on the userform to create an option button. Right click this button and click 'Properties' to display a list of attributes...
Read more ►

How to Stop Rounding in Excel

1. Open the Excel workbook that currently uses rounded numbers. Click on the affected worksheet.2. Highlight the cell(s) that hold the numbers. Do so by clicking a single cell, dragging the cursor across several cells, clicking a row number or a column letter.3. Right-click on the highlighted cell(s). Select 'Format Cells' from the menu, which opens the Format Cells dialog box.4. Select the 'Number' tab. Click 'Number' in the Category pane. Press the up arrow next to the Decimal Places box to increase the number of digits after the decimal, such as '5' or '7' places after the point.5....
Read more ►

How to Plot a Titration Curve on Excel

1. Open a new worksheet in Excel, and create two column headings with the titles 'Titrant Amount' and 'pH Level.' Fill out the two columns with the data you have measured.2. Highlight your entire data set, including your column headings, by clicking and dragging your mouse across it.3. Click the 'Chart Wizard' button in the toolbar. Click the XY (Scatter) chart type to select it, then select a 'Scatter with data points connected by smoothed Lines' chart. Click 'OK'; Excel will generate the chart with the smoothed titration curve on top of the data seri...
Read more ►

Blogger news