In excel how do I protect the format of a cell but let the user change the
cell value?

Use of hyperlink formula's can allow much movement around a sheet, some used
in header would move down to max or min values in a sheet will submit example
at end of this post.  
the following works for use "in-document" to move progressively down a

I have a spreadsheet with the following Columns:
A = Last Names
B= First Names
C = Extentions

I have a list on a master sheet and need to link the list items to a specific
cell oon other sheets. I want it to be the same cell on each sheet but I want
it to grab the next item on the list as the sheets progress. Is there a way
to do this.

sheet1 cell I3, I want to creat a LIST VALIDATION, when the drop down is
selected it will show sheet2 column A choices, no biggie so far, but based on
the list validation choice, I want it to return the value in the
corresponding row in sheet2 column b in cell I3 IE:

hi, trying to see why formula does not work.  the first example works except
for wrong use of variable at end (184 needs to be 183 with an offfset);  
purpose:  hyperlink "dn" to subsections of sheet.  use:  cntrl-shift-enter,  
for array.

hi, trying to make a hyperlink work, that is used "in" document where
sub-destinations are all -progressively id'd as "dn" by the friendly name in
the hyperlink.
the problem is the reference to the column / cell the formula currently

I have to move through at least 5 folders just to get to the folder I want to
save my file in, why cant Excel or any other application remember where I
saved last and just take me there?

I use several linked files at work, I noticed the links hadn't
updated
properly in a few of the files, I opened a file and had to F2 a cell
link and the correct numbers then were displayed. I noticed at the

I entered data from a classroom test.  The answers were in A-B-C-D
format, rather than 1-2-3-4 format.
Now, I want a pie chart displaying the percent of the class that chose
'A', the percent that chose 'B', the percent that chose 'C' and the

worksheetA = contains some  manual entry plus data from monthly file
(worksheetB)
worksheetB = monthly file that gets updated from another system
worksheetC = contains parameters of the search

I am trying to sort only the left 6 characters of a column.  I could not find
where I could select and sort only the first 6 characters so I created
another column 'B' and used the B1=LEFT(A1,6).  I used the formula box to
verify format and the result was correct, but when I hit ...

How do I add times together in order to get the total hours I worked?
i.e.: I worked 8hrs and 57minutes (8:57) on Monday, 8hrs and 26minutes
(8:26) on Tuesday, and 7hrs and 37 (7:37) minutes on Wednesday.
What formula could I use to get the total hours I worked? The formula should ...

I have just installed Office 2007 and when I went to open one of my older
spreadsheets none of the page tabs are showing. When I open the spreadsheet
on another machine the tabs are still there.
How do I get page 2, 3 and so on to appear as tabs at the bottom?

How do I subtract the time difference from another time difference?
i.e -
I have 6:34pm (time I left) in G12 and I have 8:58am (time I came in) in
G11. I found the difference between the two times by using formula: