I received a spreadsheet and opened it but it won't let me enter anything in
any of the cells.

When i tried using the vlookup function to look up time and display the cell
next to it, there was a glitch every 20 minutes or so (in the time typed in)
it would show the cell above the one it should.  I  was using a 5 min
interval in my 'time'.

I have a spread sheet that has locations in it formated as :   1A2, 1B2,
1C2,
1A3, 1B3, 1C3 , on and on  etc....
I need to sort it so all the 1A2's are listed, then the 1B2's then the 1C2's

Let’s say I am in an excel file, we will call it file #1.  Previously, with
the old version of excel(Excel 2002), I was able to use the VLOOKUP function
in excel to look up information in a different excel file (let’s call it
excel file #2) and have the output show up in excel ...

Is it possible to show formulas on a worksheet in Excel x for mac?  I know
how to do this on a pc, but I can not seem to find a way on this mac.  I am a
teacher in middle school and I want to give a problem that the students can
solve and then print their answers in both values ...

I'm trying to convert a text file with multiple rows (10) of repeated data.
The "Text to Columns" function in Excel can only sort one row. Is there a way
in Excel where I can format it to convert these data into just one row?

I have an Excel spreadsheet with 8000 rows.  I would like to know how many
cells in a particular column have value or text entered.  When I use the
formula =countA(e5:e8003), the number returned is 7998 (the number of rows in
the column).  As I eyeball the document, obviously not ...

I use Excel formulas in the Truss manufacturing industry. (We use a format to
enter Feet, Inches, Sixteenths. 112 equals 1 In., 12 Sxth. [1-3/4"] 10907
equals 1 Ft, 9 In., 7 Sxth. [1' 9-7/16"] )
How can I convert this into a decimal number for calculations? Or how can

The CONCATENATE function is fantastic for joining text from 3 cells to one.
But is there a function that will seperate 1 cell's information to 3 or more
cells?

Hi this is my first time working with formulas from scratch so I need some
assistance.
I just need to create a formula that will provide a message in a different
cell (not in a popup message) if a range of cells (ie: A3:A30) are all

I am making a model in Excel which is takes data updates from an outside
source and then processes the information to develop charts on the data.  
There are a lot of charts so I have developed the model to process the data
automatically as the data comes (down the sheet).  This ...

I need some help referencing certain cells from one worksheet in
another. Here is an example of what I am trying to accomplish:
Worksheet 1:
Item #    Name     Value

I have grouped columns and rows, but I cannot see the +/- buttons in the
margins of the excel program to expand or collapse my groupings.  How do I
get the +/- buttons to show?

How can I count  amount of  Days I worked per year on Excel ?

I'm not looking for volumes of info on this one.  (Um, that doesn't mean I
wouldn't appreciate it, though!  LOL)  I just need a jump start so I can
figure out what to do to get started.
I have a workbook with about 50 sheets.  4 of the sheets get data, dumped