I have a range in a worksheet which I named "Prices" using the "Name
Box" (The box that shows the Cell reference [A1 etc...])
I am trying to select a different range on another Worksheet and call
it "Prices", but whenever I type in the word "Prices", the original

Is there any way in Excel to reformat data so that data which is listed in
columnar format can be copied into rows. For instance if the data is listed
from cells a1:a4 and I want to reinput this data into cells a1, b1, c1 and d1.
Any help would be appreciated.

Is there any way to protect all the worksheets in a workbook without having
to go to each individual worksheet and using Tools > Protection > Protect
Worksheet?

I am setting up a 'report' of sorts in Excel (97), and I cannot
remember or find how to calculate the range when I have to add a
variable number of columns. I dont actually want to make a named
range, simply refer to a range in VBA.

In Sheet 1, I have this Data,
    Column 1
Row 1    Data 1
Row 2   

Sooner I have asked for an easy way to lock all the sheets in a spredsheet
and I got the very useful answer:
Sub LockDown()
   For Each ws In Worksheets

When I use Ctrl-F to quickly find an item in a spreadsheet, how do I setup to
make the found item hightlighted instantly instead just normal border around
the found item.  The hightlight is very helpful when look at a crowed spread
sheet.

I'm sure this is a very silly question, but I sometimes have a problem
pasting non adjaent cells.  I select the cells using the CTRL click then
copy, which always works fine, but sometimes when I try and paste the cells
elsewhere I get an error message saying I can't paste non ...

I have an Excel spreadsheet with currency.
If the value is $4.50 for example, it shows in the formula bar as 4.5 and
merges into Word this way.  I have set my options to precision as displayed.  
I have set my decimal places to 2.  I have tried a custom number format.

Im trying to find a way for excel to permanently remember words through out
the whole workbook with out having to do it over and over on each page, like
the autotext function in Word.

After opening a txt file all the page header appear after every 31
rows.
All exactly the same.
I want to create a macro to create a workable sheet, using text to

Hi, me again-thanks JMB for writing back but the font is so small I couldnt
read it- can you type the formula bigger I cant tell what is before sum and
what is between e2 and e25. Thanks

I have a columnumber in sted of a letter in my Excel. How can I change this
back to letters
so the top line is 1,2,3,4,5,6,
and not a,b,c,d,e

Is there a way to eliminate the colums on a spreadsheet that you do not need.
I have employees use spreadsheet in our office who are not Excel users and
end up entering data in colums not used in the spreadsheet. If I use column
a-f, how can I hav all columns past f through... ...

Hi, me again with another question....how can I add the entire row of my
numbers together- for example adding cell E2 thru to cell E25 (so, cell E2
plus E3 plus E$ and so on and so forth) to get a running total at the end of
each page?