When I click on a cell, it selects 8 cells. How do I reset it to only pick a
column to work with?
Thanks in advance.
Bob

When performing a "Save as" a "Tab (delimited)" file in Excel 2000, cells
contents that contain a comma are automatically surrounded by double quotes
(").
Is there a way to save a file in tab delimited format without Excel

my problem is that I have to do a number of vlookups (exact matches)
on customer codes (which are numeric values). Most of the times, Excel
returns an N/A error, even when it shouldn't, because the code is in
both tables. My understanding is that this happens when Excel treats

I accidently added a "send this sheet" section to a file toolbar--how do I
remove this section?

Without using VBA - If cell A1=red, A2=white and A3=blue, can I set C1
to be the value of the selected cell so that if A1 is selected, C1
will equal red, if A2 is selected, C1 will equal white, etc.?
Thanks, Sheldon Potolsky

Anyone have any idea why I wouldn't be able to delete rows in a worksheet?
It doesn't seem to be protected for row deletion.
I am selecting the whole row (from the left side of the sheet) & then going
to the end of the sheet to grab the bottom.

I'm using Excel 2003, and I've tried to allow only sorting on a protected
sheet.  I've tried by choosing Tools, Protection, Protect Sheet.  Next, I've
checked the sort check box in the "Allow all users of this worksheet to:"
area.  The only other check boxes that are checked are ...

This should be so simple but I cant figure out how to get a Grand Total cell
B16 without naming each sub total cell.  I used 'auto sum' icon to get a
subtotal on b5, b10, b14.  Help lost me on paste functions, math, sum because
I got a sum that included the sub totals as another ...

We are using Excel 2002.  I have a pivot table with an OLAP cube data
source.  I have added a new member to the cube and would like to be able to
add the member to the pivot table as a data field, but the member does not
appear in the PivotTable Field List.  Using Refresh Data ...

I am receiving the following error for the code listed below:
   'Run-time error 1004'
   'Application-defined or object-defined error'
'Sub filter()

I have a data in this format
Date    Day    Time    Confirmed    Home Page UV's    Search Page UV's    Ratio of H.S & H.P
    conversion this hour UV's
1-Feb    Fri    9:30 AM    424    8456    4047    0.481    0.1088

I have a VLOOKUP in calculation =VLOOKUP(D14,'[Week 2.xls]Daily Lines'!
$A$4:$Y$18,23,0)/1000.
Basically When looking up the value in D14 if it is not in the [Week
2.xls]Daily Lines' sheet I am getting the #n/a error. Basically I

I have a rather large worksheet that will have hundreds of cells with
conditional formatting. Most of them are the same (only the cells and value
ranges change).
Here is an example of a conditional format I need:

We are being asked to keep track of our daily work load. We need to
record start and stop times as well as total time spent working on
each job. It seems Excel would be perfect for this task because of
it's Current Date and Time functions. Does anyone know whether this

p 151 tells us to enter a url for importing data from web.  But which URL?  
I'm connected to web and have installed cd to my pc.
I found the correct errata in mspress for this book but it doesn't list the
missing url as an error.