How do I average these grades that are in columns across. Here are the grades... 42/50, 20/30, 25/25, 13/15, and 87/100. These are in cells B2 thru F2. ...

The contents of my spreadsheet have an * at the beginning of the text in several of the cells (i.e. *Doe, John). When I attempt to do a...

I have four worksheets that I'd like to print as a one-fold landscape booklet. This means I need to print two worksheets on one side of a page, but I can't...

help retreve unsaved file

When I insert a Combo Box in Excel, then right click and choose Properties to specify the input and output ranges, the Control Tab does not appear on...

I've tried searching, I've used contextures.com but couldn't find the right help. I have an extremely large table: A2:C49918 Column A = Zip Codes Column B =...

Hi, I don't know how to to get excel to open\save an invoice from which the date it was writen? eg. I have a date formula on a invoice template I downloaded...

A 1 10 2 17 Want formula for cell b1 that will look at A1, if = 14, then A1*.5 . If A1 is =15, then it would multiply the first 14*.5, then from 15 on...

How Can I configure my Outlook Express for this discussion group? Ajit -- Knowldege is Power

Hi, I've got a simple excel spreasheet with 10 columns. I'd like to be able to add a scrollbar from the third one to the eighth one so that when I move the...

I CAN NOT GET A FORMULA TO WORK CONSISTANTLY =VLOOKUP(B7,Q:R,2,FALSE) I AM LOOKING TO HAVE THREE COLUMNS OF SCORES R-S-T A LIST OF TITLES IN COLUMN Q, AND...

When I use the arrow keys to navigate a worksheet, the cursor just disappears.

I have a column of values that look like: 00000000007310F0000 all cells are 19 chars in length, and the 15th char is alpha. I need to map the 15th alpha...

I received lots of mailing lists that are saved as a Word .doc, and are formatted as mailing labels. But I need them in either a .csv or .xls format. The...

It seems to be slowing me down as it records actions. i'd like to turn the feature off. Is there a way?

Hello all. We have the need to export a file from excel to a semicolon delimited text file. Is there a way to do this from Excel directly? If not, does...

I have column data that is grouped. When I apply protection to the worksheet it is not possible to show hidden columns or hide displayed columns. I want users...

Two identical pivot tables referencing the same source file. However about 10% of the data is sorted differently i.e. the sort order varies. However, the sum...

how do I get an invoice number to advance to the next number?

I just downloaded the excel template "Loan Calculator with extra payments" and was wondering if the extra payments went toward interest or principal?