If I go into excel 2007, select Open and then Other file types I can see the
'.wks' spreadsheet I want, but double clicking on it only opens up another
blank spreadsheet not the file I was expecting to see! The version of Excel I
have comes with Home & Student 2007 version and is ...

I am trying to create vba that will create a querytable (URL) and then run
the specified query (future use: loop through an array of url's).   However,
the url is extremely long and excel keeps giving me an error.  Is there any
way around this besides using tinyurl.com <-- I ...

Hello, I have Excel 2003 and an InFocus projector. The combination works
fine until I start the Excel program and it automatically zooms up to 400
per cent resolution. I am unable to get it back down from this resolution.
Clicking on the zoom box brings it down and then it goes ...

I received a spreadsheet with a pivot table.  If I double click a results
filed I see the data that rolls into the results.  I do not see visibly see
any of the data any where in the spreadsheet to support the results unless I
double click it.

I'm using the @ sign and Excel insists on treating it as an email address,
when I don't want it to. How can I turn this off?

Hi,
Does anyone knows how can I use CountIf with two criteria conditions. For
example if I want to Count numbers with the following criteria: >=40 and <45.
What shall I write in the criteria field

I'm looking for a way to calculate the difference in time in minutes for the
following format. Taking the date into consideration. Can you help? I
apologize if this is a 2nd posting but I can 't find the first so I don't
think it took.

I am struggling with an IF statement...here's my situation:
I need the default value of a cell (C64) to be 8 as long as cells F24 and
F25 contain text "n".  If F24 text is "y" (F25 will remain "n"), then I need
the value of C64 to be (8-I24).  If the F25 text is "y" (F24 will ...

This venue is the finest source of information and assistance that I have
ever encountered, and I would like to thank, those that take the time to
help, those of us that are in need of assistance.  It's truly appreciated.
I have a spread sheet that is a list of issues. In column "A" ...

i dont know the password i have used to protect the worksheet, workbook. how
can i unprotect those without my password???

I'm trying to import business addresses from a web page (in typical mailing
label format) into Excel in a typical database (column) format, i.e., name in
column A, Street in column B, etc.
Transpose will only do 1 address at a time, but I have hundreds of addresses.

I need to be able to copy and paste text from e.g. word or emails, into my
spreadsheet but when I do, it changes the fill colour back to white - how to
I lock the fill colour, or is there soemthing else I can do without changing
the theme?

I have imported a report from an accounting program using Import External
Data.  When setting up the columns, it messes up the alignment of the titles
at the top and number totals at the bottom.  When I select the cells to merge
them it will only keep the info in the far left ...

Using Excel 2000, I posted here and John Bundy told us how to select
only the Rows that have a certain character (@), by using a "Helper"
column with
=IF(ISERROR(FIND("@",A1)),"","1")

I have a very large spreadsheet with the first column showing dates of all
weekdays from 1/2/1900 through the present.  the rest of the columns (about
500 of them are different categories.  Each date may have one or more of
those categories.  Eacch row consists of a date, ...