I have a standard report that I receive every day from IT and it can't be
altered by IT. So once I have it opened in Excel I can manipulate it but on
column has data in Column B where some of it is Aligned Left and some is
Aligned Right. What I want to do is write a statement in ...

I'm as new to Excel as can be, so be gentle.  
When making reference to a certain cell (say, Cell J60, containing a total),
what's the difference between using =J60 and $J$60.  I've read about this in
the Microsoft KB but I don't have enough experience to understand it.  Can

I know that formatting a date with ddd shows the first three letters
of the day, but is there a way to show only the first letter of the
day (Mon = M, Tue = T)?
TIA,

Just recently (today) I started having problems opening my excel spreadsheets
from every location (desktop, folders, etc.) unless I open them inside the
Excel program from the open menu.  I am running Office 2007, Home and Student
Edition on my laptop operating Windows Vista.  ...

Excel 2003
This is a weird problem that I've never seen before.  We have a user who is
unable to view the contents of a specific Excel workbook.  When the user
opens the file it looks as if there are no files open--all he gets is a gray

I want to write a statement to check a series of rows in a column to see if
it has data. If it has data then I want to return a statement that says Not
Null and if the statement is blank... well you guessed it I want it to say
Null.

After I set the print area of my document, it prints as I want it to, but
onscreen the gridlines outside the print area still show.  
If my columns go from A to K, how do I make everything to the right of the
print area show no lines for columns or rows when viewed onscreen?

I take about 40 seconds for the document to come up on screen
This also happens in Word

Is there a way to set a "global" cell format such that when I enter a
date, it's automatically set to the format I like to have, without
having to re-format every cell?

I have a workbook with about 50 worksheets.
If I scroll along the bottom tabs my first worksheet (which is the menu)
disappears off the screen.
Is there a way to freeze a worksheet or worksheets so that their tabs are

A restriction in my documents will be of a great help. For example, all
numbers in column D should be <10. This will surely help drastically in my
employees Data Entry work and also save time and effort.
Thanks.

Hi, I'm trying to get this formula to work, but it just keeps returning
"FALSE" into the cell.  What am i doing wrong?  Can anybody help me? Please???
I use excel 2003.
=IF(C11=Sheet2!A2:A410,(VLOOKUP(Sheet2!B2:B410,2,0)))

A database query program outputs everything as a text string.  One of
the fields is a date, formatted as yyyymmdd.  I need this as at least
a number, and preferably a real date that I can Autofilter.
Using a tip from JE McGimpsey, I select the column, choose Data/Text

I have a large spreadsheet that lists  numerous customers. Each
custtomer has a code for the service that we provide them and then has
a price negotiated at the time of service. We are have set up a price
list that gives the service code, in a vertical column and then has a

Hi everyone,
I have 15 worksheets in my workbook, but i just want to print specific
worksheets. Is it possible to specify which worksheets you want to print to
save me having to print the whole workbook?