Friday, May 27, 2011

How to Recover Deleted Excel Files


Enable Automatic Recovery and Saving
1. 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 Worksheet
4. 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 worksheet.
6. Select 'Recover Unsaved Workbooks' to recover the new worksheet. For existing worksheets, select 'Versions.'
7. For new worksheets, select the draft from the pop-up windows that appears. For existing worksheets, select the version that lists 'when I closed without saving,' and then click 'Restore' to make this version the one that is current. This overwrites any changes in the opened file to the last automatically saved content in the worksheet.
8. Select 'File,' and then 'Save' to avoid any further data loss.
Use Document Recovery
9. Recover your worksheet from the Document Recovery pane appears, which appears if you haven't enabled the auto-save feature in your Microsoft Office products.
10. Click the arrow next to the worksheet you need to recover. Select 'Open' to view the recovered worksheet; select 'Save As' to open the worksheet and create a fresh version and select 'Delete' if you don't need the recovered version.
11. Select 'File,' 'Save' to avoid any further data loss.
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' is now blue. This tells you that the spreadsheet has been filtered by that column's data.
5.
You can apply additional filters. Click on the arrow in the 'WRITTEN' title cell, then click on '3/28/2008.' You now have only data that meets those two criteria, drafted on 3/25 and written on 3/28. You notice that both of those arrows are now blue.
6.
There are two ways to go back to your original data. You can remove all the autofilters. To remove all the autofilters at once, click on 'Data' then click on 'Filter' then click to remove the check mark on 'Autofilter.' This will restore all your data and remove the check boxes.
If you just want to restore your data one column at a time, click on the arrow, then click on 'all.' All the data in that column will be visible again.
The illustration shows both methods.
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 Sheet.'
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. Click and hold the left mouse button on column A and move the cursor to column C to highlight columns A, B and C. Click 'Home' and 'Format.' Select 'AutoFit Column Width.' This makes all the columns fit to the longest text in a cell in the column.
5. Highlight A, B and C again. Click the 'Data' tab. Click the button with an A above a Z and the arrow pointing down. This sorts the data by the person's name in alphabetical order.
6. Click the 'Office' button and 'Save' to save your address book.
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 the data.
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 Resources) offers information on formatting, filtering, making charts, using the worksheets (also known as spreadsheets), macros, importing data and lists the top issues Excel users report experiencing.
3. Read an Excel introductory book (be sure to purchase the correct version of Office/Excel, such as Excel 2010, the latest version as of November 2010). Options include 'Excel 2010 For Dummies' by Greg Harvey (who also wrote 'Excel 2010 All-in-One for Dummies'), 'Learn Excel 2007 Essential Skills with the Smart Method' by Mike Smart, 'Microsoft Excel for Beginners' by Web Wise Seminars or 'Excel for Beginners' by D. Larisch. Look for a book with plenty of screenshots and step-by-step tutorials.
4. Enroll in an Excel class, offered around the country at many community colleges and schools. Adult education or continuing education courses are short-term and usually require no prior Excel experience or education. Options include the Wake Technical Community College in Raleigh, North Carolina, offering a beginning Excel 1 class, plus options to further education with intermediate Excel training.
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 chart.
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 theme.
Read more ►

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


Test the theory
1. 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 formula should read='The sum of 2 2 is 'SUM(A1,B1)
6. Click anywhere else on the table and cell A3 will now show: 'The sum of 2 2 is 4.'
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 the options provided on the right.
6. When you are done formatting, click 'OK.'
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 example, if A1 contains the number 10.54, cell B1 will display the number 10.
4. Type another decimal number in cell A5.
5. Copy cell B1 and paste it into cell B5 to put a copy of the integer formula in B5. Click out of the cell to show the integer value of A5 in B5. As you copy and paste the integer formula, Excel automatically adjusts the parameters to find the integer value of A5 rather than A1.
6. Use the integer function in an actual spreadsheet to drop the decimal values of a number and leave only the whole number.
Read more ►

Tuesday, May 24, 2011

How to Make Bullets in Excel Entries


Insert a Bullet to a Cell
1. 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.” The cell will contain a line break. Repeat the “Alt” and “7” or “Alt” and “9” keyboard shortcut to insert the bullet symbol on the new line.
Insert a Bullet to a List
5. Open the Excel worksheet that contains the list.
6. Add a bullet to a list in one cell by double-clicking the cell.
7. Place the insertion point on the line where you wish to insert the bullet.
8. Click the “Insert” tab on the command ribbon.
9. Click the blue “Symbol” button in the “Symbols” group. A chart with symbols displays.
10. Click the “Font” text box arrow. Select your preferred font. For example, “Arial Narrow.”
11. Scroll to view the symbols. For example, certain fonts display squares, diamonds, flags and arrows. Click your preferred bullet symbol.
12. Click “Insert.” Click “Close.” The selected symbol appears on the selected line in the cell.
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 for the control.
3. Click in the 'Enabled' row of the 'Properties' window, then type 'False' to indicate that the option button is unable to process input. Note that the command button, which you created in Step 2, is enabled by default.
4. Click the 'Frame' control on the tool box, then drag on the userform. Click the button control you made in Step 1, then press 'Control' and 'X' simultaneously to cut this control to the clipboard.
5. Click the 'Frame' control, then press 'Control' and 'V' simultaneously to paste the button inside the frame. Repeat the cut and paste with the option button to paste it into the frame as well. By placing both controls into the frame, you've made one group that contains both controls. You'll now write code that checks a property of each control.
6. Double click the userform to display the programming window, then paste the following program into the window. This program iterates through each control in the frame, reading the 'Enabled' property you set in step 3, and printing the value of that property.Private Sub UserForm_Click()Dim ct As ControlDim s As StringFor Each ct In Frame1.ControlsIf ct.Enabled = True Thens = ct.Name ' is enabled.'Elses = ct.Name ' is disabled.'End IfMsgBox sNextEnd Sub
7. Click the 'Run' menu's 'Run' command to display your userform, then click anywhere on the form that doesn't have a control. Your program will run, displaying message about the 'Enabled' property described in Step 3.
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. Click the 'OK' button to save the changes to number-rounding.
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 series.
Read more ►

Blogger news