Ok, weird question...a co-worker has been teaching me a lot about
Excel but his computer is set up in Spanish (he's from Mexico). There
is a 2-part command that is:
Shift + Ctrl. + down arrow (to fill all cells down that have values)

When you have a range selected and there are not values in all columns
of the top row, the default behavior of Sort will be to not include a
column header.  However, I have a data range that DOES have column
headers across the range, and yet, whenever I go to sort, it does not

I'm trying to copy data from Office Suite to Works but the data won't paste
the same way and I can't figure out to format it to match the original
document.  Is there a way?  Any suggestions?

Here's the situation.  In Sheet1 I have a list of about 1200 items in
following format:
T0000
----

Why can't I access all of my tools in the Data tab?  I have access to them in
another document but not a second document.

I find that if I create a conditional format at one cell and then copy that
to a multitude of others, the variable references within the conditional
format will not adjust accordingly. For example:
At cell A1, I have the conditional format of "=IF(A1>0,1,0)".  If I copy

Can someone tell me the links where i can learn how to write macros - i
would prefer to do simple things with my macro such as copy information from
several sheets to one sheet, find the average,sum..etc of cell values from
different worksheets

How do I unhide 200 sheets in a workbook ?

Someone sent me an Excel spreadsheet with two photographs in it. I would like
to remove those photographs, save them as standalone JPG files (or whatever
format they are in) How do I save/extract photographs from an Excel
Spreadsheet? It's Excel 2002 and Windows XP.

I'd like information that I input into a cell to be automatically output into
another cell. So, for example, In one cell I input the following information:
HWC65917 P Science / Health & Medical Sciences / Human Anatomy & Physiology
/ Human Systems / Immune/Lymphatic System / ...

Not sure if it can be done:
Property management spreadsheet with general ledger. I wish to separately
track expenses for each property automatically by extracting from the general
ledger. So, my thought is that each row would start with a property code, say

I have in cells A1 -A12  words (eg wages, electricity etc)
In cells D1-D12 I have values (numbers)
I am trying to get a bar chart where the number is displayed by the vertical
bar and at the bottom of each bar it gives the name (eg electricity,wages

I want to keep a running total of inventory as follows:
            On Hand      This Shipment       Quan Updated
Part # 1      10                   5                  update this column on
each new shipment

I KNOW THAT THIS IS EXTREMELY BASIS, BUT I'M NEW SO PLEASE FORGIVE ME.  
BUT....I NEED TO SET UP A COMMAND BUTTON TO MOVE TO A DIFFERENT TAB.  HOW DO
I DO THAT?  I HAVE THE BUTTON, BUT NOT SURE WHAT TO DO AFTER THAT.

I have posted the file DB Practice.xls, at https://mediafire.com, I beleive
that this is a file sharing site unlike the previous site.
I think the questions contained in the file explain the problem I am having
with the index function. I am trying to retreive the intersecting cell ...