Hi, I'm new to excel, I apologize if this question is too basic.  I work for
an accountant, and I have to enter an account purpose and the account number
for that purpose in a cell right next to it.  Is there any way to enter the
purpose and make the set value of the account ...

Say you have a table (5x5, for argument's sake)-- along the top is
demand from customer A, on the bottom is demand for customer B. Say the
legend for both the rows and the columns is (0,1,2,3,4), and in the
table itself is the corresponding probability for each pair.

I have a workbook with 5 worksheets, N, S, E, W and Summary.
On the N, S, E, W worksheets in cell F15 is a sum calculation, =sum(B15:E15).
I want to link each of the 4 sums in F15 to the summary worksheet and then
get an overall sum.  

I have a spreadsheet that shows sales for the month.  Sometimes, there are so
many rows that you have to scroll down to see them.  I would like to be able
to display a static row at the bottom of the screen that shows total sales
dollars.  I would like for that row to always be ...

ASCII data typically have . separator for decimal. how to transform it into ,
separator?

Select certain visible/non-hidden areas
Hi.
How can I select certain visible/non-hidden areas only?
Eg 1:

I would like to have the current age calculated in an excel spread sheet and
am having trouble with the formula.  Any help appreciated.  TIm

after I sort colum (A) job numbers I end up with
job number that are the same but with a -E after the
job number the e stood for emergency but now it is a working job how can I
del all the rows that have the same job numbers but end with -E and keep the

Hey all,
I've gotten some great help (and learned alot) on formulas from a certian
Tech Forum, but I think we're possibly stuck on my problem now.. I was
hoping you guys and gals on the news group would be able to shed some light

How do I display quotation marks as text? For example:
="hello"&" Bob"
displays:
hello Bob

is there a way to shorten this macro to make it run faster
thanks
JD
Range("C:C,D:D,E:E,F:F,G:G,H:H,I:I").Select

Somehow the worksheet menu bar has been deleled. I've tried going into
customize toolbars and the worksheet menu bar does not appear on the
list. I'd like to know what caused this and how to fix it.

I have a column of numbers.  I want to make a column that adds a percentage
to the first column of original data.  Is this possible?
column_1   column 2
100            125

For many years I have been typing in the Excel Worksheets.  When I used
to hit the 'Enter' key, the cell below would be selected.  When I tapped
the 'tab' key, the cursor would move to the cell on the right.
Everything worked great and it was the way I liked it.

I need to calculate the average student grades on student profile sheets. for
example a student might recieve grades A, A, B, B, A - how do I get excell to
display A as the average grade?