EXCEL

1.Changing the Color of Excel Comments In Microsoft Office Excel,

Comments appear in little yellow boxes by default. Here’s how you can change the color of a comment:

1. Right-click its border, and then click Format Comment from the shortcut menu.

2. On the Colors and Lines tab, choose a color from the Color list.

Changing the default color for comments is a little more involved; here’s how to do it:

1. Right-click any blank area of your Windows desktop, and then click Properties from the shortcut menu.

2. Click the Appearance tab, and then click the Advanced button.

3. Select ToolTip from the Item list.

4. Click the arrow next to the Color box, and then choose a color for your comments.

5. Click OK.

2.Copying a Worksheet

Here’s how to copy a worksheet to another place in your Excel workbook:1. Click the tab of the worksheet that you want to copy.2. Leave your mouse pointer on the tab.3. Press and hold down the CTRL key.4. Press and hold down your left mouse button and drag the worksheet that you want to copy to the left or right. Watch for the little black arrowhead that follows your mouse pointer as you drag left or right.5. When you release the mouse button, Microsoft Office Excel inserts a copy of the worksheet where the arrowhead is pointing.

3.Zooming to Fit a Selection

1. Select the range of cells that you want to focus on.

2. Click the View tab, and then click Zoom to Selection.

4.Create Random Numbers

Sometimes it's useful to have random numbers in a Microsoft Office Excel spreadsheet—even if it's just for creating test data. To put a random number in a cell, type the formula =RAND(). For bulk random numbering, copy that formula to a large number of cells—each will be random.

5.Enter a Fraction in a Cell

Microsoft Office Excel can display, and take data entry as, fractions as well as decimal numbers. To enter a fraction, simply prefix it with a zero and a space. So to display the fraction one-third, type 0 1/3. This will display 1/3 but will have an underlying value of 0.33333333.

6.Step Through Formulas

When you're writing complex formulas, a slight difference in brackets, for example, can entirely change the result of the calculation of a formula. Microsoft Office Excel adheres to the standard order of precedence for calculations, with percentages, exponents, multiplication, and division performed in that order before finally calculating addition and subtraction. For example, 7+5*3 = 22, because the 5*3 is calculated first. (7+5)*3 = 36, because the parentheses force the addition to be completed first.
If you're unsure how Excel is evaluating a formula:1. Click the cell, click the Formulas ribbon, and then click Evaluate Formula in the Formula Auditing section.2. Click the Evaluate button to watch as each part of the formula is successively calculated, ensuring that each step of the calculation is valid.

7.Paste into Non-sequential Cells in Excel

You can use the CTRL key for multiple selections. Sometimes, you want to copy a formula or piece of data into a series of non-sequential cells in Microsoft Office Excel. You can do this quickly without having to paste into each cell individually.

1. Copy the data from the source cell.

2. Hold down the CTRL key as you click to select each destination cell.

3. After all the cells are highlighted, paste the data by pressing CTRL+V. You have to paste only once.

Similarly, you can type data into a series of cells simultaneously.

1. While holding down the CTRL key, click all the cells that you want to type the same text (or value) into.

2. Type the entry, and then press CTRL+ENTER. The text will be added to all the selected cells.

8.Creating a Watermark in Excel

To add a watermark at the top of your Microsoft Office Excel worksheet:

1. In your Excel file, click Insert, and then in the Text section, click Header & Footer.

2. With your pointer in the center section of the header, click Picture in the Header & Footer Elements section of the Design tab, browse your hard disk drive to find the picture you want, and then click OK.

3. You may need to press ENTER several times to center the watermark on the page.

9.Organize Colored Cells More Efficiently

When using the filter option for large Microsoft Office Excel worksheets in the 2007 Microsoft Office system, you can filter the document by color. Click the down-pointing filter arrow on your filtered column, and then click Filter by Color. The colors display as a list, from which you can select the color that you want to display.

10.Working with Large Formulas

With previous releases of Microsoft Office Excel, working within the formula bar at the top of the worksheet can be cumbersome, because although the formula bar expands when necessary, it often overlaps the sheet itself. To get around this in the 2007 Microsoft Office system, pause on the bottom of the formula bar, and then drag it to adjust it to any size you need. This adjustment gives you a larger working area and makes it easier to navigate a document sheet that has large formulas.

11.Showing Formulas in Microsoft Office Excel Instead of Their Results

Sometimes in an Excel worksheet you want to display formulas instead of their results. Here’s how:1. Click the Office button, and then click Excel Options at the bottom of the menu.

2. Click Advanced, click Display options for this worksheet, click Show formulas in cells instead of their calculated results, and then click OK.

12.Copy Data from a Table in a Web Page to Excel

If you see a data table on a Web page and you want to import it into Microsoft Office Excel:

1. Copy the URL (address) of the page.

2. In Excel, on the Data tab, in the Get External Data section, click From Web.

3. In the New Web Query dialog box, paste the URL into the Address box.

4. Select the table that contains the data you want to work with, and then click Import.

5. In the Import Data dialog box, indicate where you want the data to appear, and then click OK.

13.Turn Multiple Hyperlinks into Text in Microsoft Office Excel

1. Select the cell or group of cells that contain hyperlinks, right-click, and then click Copy.2. Select the cells where you want your text to go (this might be the same selection as in step 1).3. Right-click, and then click Paste Special.4. In the Paste section, click the option that you want applied to the text (such as Values or Comments), and then click OK.