I have a spreadsheet that I have to keep adjusting some of the columns
in order to fit the headings.  I'm thinking that it is only sizing wide
enough for the data in the cells and not taking into account the
heading width.  Is there a way that I can adjust the column width so

Can I have excel take the last number in a column of 31 rows, only if it's
not a zero. And return that number to a given cell?
Thank You

Hello, Folks
I need to have a column of values on one sheet equal a row of values on a
different sheet. i.e.: 'sheet2'A1='sheet1'A1; 'sheet2'A2='sheet1'B1;
'sheet2'A3='sheet1'C1; etc. Is there a way to do this using edit/fill or

Is there a facility to reform my excel file of names and addresses  which
is
all caps to normal Cap/Lower case names cells??
Plesae reply to both dk.weiss@verizon.net and Group

Hi! I am trying to get Excel to copy content of some cells to next sheets,
depending on the number I put in last cell. IE A1:A3 have some text. Now, if
I put number (2,3,4 or 5) in A4, I wanted to copy A1:A4 to Sheets 2,3,4 or5,
depending which number I put in A4 (if 2, then to ...

I am having a problem with Excel displaying "##########" in my cell, instead
of the text I have entered.
My text contains hyphens and "Alt-Enter" values to control line-breaks in
the wrapped text.

I created a fill-down formula that goes all the way to the bottom of the
worksheet and now I can't open the file at all.  I need the data that is
contained on the worksheet's first 500 rows.  I've tried opening in safe
mode, but that doesn't work.  Is there a way to get to it, ...

Have an MRP generated Excel spreadsheet that lists Supplier shipments which
includes a calculated field indicating if a shipment is on time (date due is
subtracted from date received, which is not shown), 0 or a negative number.
I have used a pivot table to count the number of ...

Hi!
I need to get a total from a worksheet that has hundreds of amounts in it.
However, I only need the total of the amounts that were marked with have BOLD
font. Please help me I don't have much experience with EXCEL.

I need to deduct  tax from a calculated total , i.e.  
Col A=Qty
col B- price of item
col C = sum of col a and b

I have been using the "get external data" utility for a few years now where
I work. I go out to a data site with refresh every 5 minutes. I retain the
data in adjacent cells one after another to produce a trend line. I do this
for a 12 hour duration to show production output ...

Is it possible for a formula to translate the contents of a cell to get
a worksheet name?
For instance, I have a sheet named John Smith and a sheet named
Employees. In the sheet named Employees in cell A1, I have the

I need to accumulate data from several countries with different date-format
than US. Like some send us the .txt files with following data:
-------File1.txt-----------------------------
Actual Data:    1/1/2004    Account Open

I have just come back to excel after a couple of year away, and fustrated
that I can't remember how to do things!
I have three cells C6(provisional),D6(confirmed),E6(rejected), I want to be
able to input a value to one cell, but only if the other two are blank.  A

whats the keyboard short cut for inserting a row in Excel , deleting a row