If i have a sheet that takes info from another sheet, and i update inf
in the second sheet, is there a way to "refresh" the first sheet s
that it is updated with the new data in the second sheet?  
Currently I'm closing and reopening the sheet for it to update, but i'

I'd like to set the limits of my worksheets to maybe 5 rows after the last entry, so that when I scroll to the bottom, I'm not scrolling to 65,000.
Is there a way to do this in Excel 2002?
Thanks,

on clicking the currency symbol on the formatting toolbar (Excel 2000) I
keep getting the ? sign. To use the Euro symbol ?, I have to take the long
route - Format > Cells > Currency and specifiy the Euro symbol.
Is there any way of changing the currency symbol on the formatting ...

I am trying to design a form in Excel 2002 and I'd like to use text boxes
but I'd like them to print without a border.  I can't seem to find any way
to turn the border off.  Is there a way to format the text box so I can do
this?  TIA.

Hi --
I am trying to create a method of instructing a range of cells (60 columns x
8 rows) to only show a resulting number from a formula if it is a totally
whole number.  I do not want to use any formula results if it contains any

I'm having another brain-dead moment and I hope someone can resuscitate!
I'm putting formulas in various cells on a worksheet and some of them are
displaying the results and some are just showing in the cell as the formula.
How can I get them all to display results.  I swear that ...

I have code on a button that changes a data entry cell to locked but
cannot seem to change its BackColor  Below is the code for locking it.
What do Ineed to do to change the BackColor to Gray
Sheets("Level 2 Support Team Member").Range("b10").Locked = True

I can protect locked cells in a sheet using Tools->Protection->Protect
Sheet.  But I seem to have to do that for each sheet of my workbook,
entering the password twice and specifying what I want to allow each time!
Is there a way to specify a protection of all sheets at one time?  ...

I have a workbook comprised of several sheets.  I have formulas that I
am entering into one or two cells in columns C or D, then copying the
formatting to the rest of the cells in the same row, up to AK or AL.
I want to know if it's possible to set up an 'end column' so when I

Can I add a second X axis value on both left and right sides of a chart?  
At present scrolling the chart to the right there are no axis label
values to easily read the chart.
Beemer

I was wondering if there was a way to setup an Excel
spreadsheet that has a bunch of email addresses in it, to
send an email (through Outlook) to everyone in the
spreadsheet?  (Pushing a button, or running a macro or

I track numbers on a daily basis over a period of a month (keeping
running list of the numbers).  
Generally it is a smaller number subtracted from a larger number an
that result is then subtracted from the next day's value, then tha

When I import data to the excel-document that exceed the size of the cell, the cell will expand vertical. I want the text to be horizontal. How can I do that? I use text-boxes for import.
When I use the fuction display "full screen" in some of my excel documents, I dont see the ...

i would like to sum a series of numbers in columnB and put in cell C1.
which rows to sum depends on hard inputs in cells A1 (13) and A2 (29).  in
other words, i want to sum the numbers from B13 to B29 in this case.  i know
i can do this by setting C1 to:  =sum(b13:b29), but the rows ...

I can't figure out which function/formula to use.
sheet1!A1 has a reference that gives a value of sheet2.
sheet2!B1 has a text value "happy camper"
I want sheet1!A2 to have a formula that gets the sheet name from sheet1!A1