formula

There are a number of way in which you can copy formulas in MS Excel. You can use the Autofill feature or select the cells you want to copy to, enter the formula in the active cell and press Ctrl + Enter. These methods work very well for you in ... Excel unless you have hundreds of rows that you would like to copy. Let's say you have 100 classes listed in Column A of your spreadsheet and Column B lists the in-state tuition price of each class. Wouldn't it be nice to enter a formula that calculates the price for each class and displays the results in Column C? The practice of selecting hundreds of ... (view more)

In Excel 2007 you now have the ability to prevent the Formula bar from displaying more than one line of text. In this way, the worksheet is not obscured by the Formula bar when a cell with a large amount of content is selected. One of my subscribers ... wrote to me inquiring if this was an option in Excel 2003 or earlier version. I hated to tell him, but the answer is no. This feature is new in Excel 2007 and there is no equivalent of it in earlier versions. What folks did in the past, in earlier versions, was turn off the display of the Formula bar completely by clicking View | Formula Bar. ... (view more)

A reader asked if there was any formula in Excel that would convert a date shown in the European format of day-month-year to the U.S. version of month-day-year. Technically, it may not be necessary to do this. Excel maintains dates as numeric values ... and displays them using various formats. If the dates are numeric values in your worksheet, then you can simply change the format and the dates will be displayed in the U.S. format. The day you see in a worksheet could instead be a text value rather than a numeric value. To see if the date is truly an Excel date or text value, you can change the ... (view more)

When you have a list of numbers and you want to show totals, you don't need to start Windows' built-in Calculator to total them. MS Word can calculate totals and averages and do other simple calculations. If the numbers change, you'll need to update ... the calculations, though. Place the insertion point in a blank cell below or to the right of the numbers you want to total. To do so: Click the AutoSum (looks like a sideways letter M) button on the Tables and Borders toolbar to calculate totals automatically. Choose Table | Formula to make other types of calculations instead. This reveals the ... (view more)

There are several different methods of entering time into a cell. Take a look below to see them. After you've read all about it, open MS Excel and take them for a test drive. I find that if I use a function I'm more likely to remember it the next ... time I need it. To enter the current time into a cell you can use a keyboard shortcut: Select a cell and press CTRL + Shift + ; To enter the current time into a cell by using a formula that returns the current date and time: Enter the formula: =NOW () To get a formula that calculates the current time, change the format of the cell containing the NOW ... (view more)

After you enter text, numbers or a formula into a cell, you may need to change it. You can always retype the entry, if it's short. If it's long, you can easily edit it instead. One way to do this is to click in the formula bar and make changes. When ... the mouse pointer is over the formula bar, it appears as an I-beam, which looks like a capital I. This makes it easy for you to click between letters to place the insertion point where you want to begin making corrections. Sometimes it's easier to make a minor change to the contents of a cell rather than start over from scratch. You can edit the ... (view more)

Suppose your Excel worksheet has a long list of numbers to add. You can sum them instantly using Excel's AutoSum feature. Don't count on your fingers or pull out a calculator; Excel can calculate more quickly and accurately. Even more importantly, ... whenever a number changes, Excel instantly recalculates and displays the corrected sum. You can use either of these two methods to total the numbers using Excel: Click the cell below the list to make it the active cell. Click the AutoSum button. Excel surrounds the cells it thinks you want to total with a moving border. Press Enter or click the ... (view more)

You can add special symbols to the number format in Excel, such as symbols that are not included in the currency or accounting formats. The "CHAR" formula displays the symbol; to add a symbol to the new format you create, copy the symbol to the Type ... box. For example, to create a format with the Euro symbol: Enter the formula =CHAR(128) in the cell. Press F2 and F9 to delete the formula and leave the value in the cell. In the Formula bar, select the € symbol, and press Ctrl+C (copy). Select another cell. Press Ctrl+1. Select the Number tab, and choose Custom. In the Type box, press ...<a href="/news/1242/adding-special-symbols-number-format-ms-excel" class="more-link">view more