I need help setting up conditional formatting in an Excel Spreadsheet.  I am
getting ready to review numbers from several vendors regarding office
supplies.  After inputting the cost per item from each vendor (I have 3
bidders) I would like Excel to identify the lowest price of ...

A colleague of mine has been using excel fine and when inputting numbers
they have used the general number format so type "1" and you see "1". He is
not aware he has changed anything but even when opening a new file/worksheet
if he types in "1" it now defaults to 0.01.

I am doing a excel project for my Computing and Productivity Software class.
I am setting up my Loan Payment Calculator and it tells me to position the
mouse pointer on the bottom boundary of row heading 1, then drag down until
the Screen Tip indicates Height: 21.75 (29 pixels). ...

After upgrading to 2007 and getting a new PC, the shortcut Ctrl and + (on the
numeric part of the keyboard to the right) doesn't work anymore. To add a new
row in Excel.
It works if I use the '+' on top of the keyboard.

How do I get averages over non-existing numbers? e.g. I have the
following (Best viewed in a fixed font)
Week        Average    1    2    3    4
Average 1     25    10    20    20

Got a complicated situation here that I think I'd be better of using a macro
to achieve. However if someone knows a slightly easier method (because I'm
not that good with Macros atm) that would be great!
I have a "data" sheet that has a list of current projects. I've used the

Dear Super Excel Expert,
I am working in a company in Dubai where I am trying to monitor the lead
time of order preparation. I have in column A the order date and time in
DD:MM:YY HH:MM and in column B the packed date and time (same format). I

Dear Excel Experts,
I would like to select a full sheet and only delete datas from it without
touching the formulas.
Please help.

I may be missing the obvious, but here goes. I have a spread sheet that I
need to enter times into. What I would like to do is use just the 10 key to
enter 3 or 4 digit numbers tha will be display as 8:00 or 11:45. Any
suggestions?

I am looking for a shortcut to delete multiple blank rows (rows alternate as
follows: data, blank, data, blank, etc.) Is there a way to delete the blank
rows between the data rows without having to select each row individually
using CNTRL-C?

How can I change a VLOOKUP formula to provide a set response if the item
being searched for in the VLOOKUP is not in the table?
I have a formula that looks up a part number entered into column B and fills
in column F with data if the part number entered in column B is in my table ...

I have this problem:
Book1 is my source and Book2 is my target. I have pasted the following link
in Book2 which returns the cell value of C10 in Book1. This works fine for me.
'[Book1.xls]Sheet1'!$C$10

hi community
can community assist me on this matter...
when i do a sum or average on cell range, and is it possible to have the
function example, =sum(value+value) display on the excel status bar (the

I have used the following table in my survey:
Frequency of use - check which on is applicable:
                 every few hours                      every few
mins                    every few secs

I have a program in which I can create pivot tables to get data.  The problem
is that I want the data so I can merge it with some other data.  Is there a
way to export pivot table data?
Thanks