I have a worksheet - many rows of completed data - I need to insert a blank
row between each of the rows with data  (a few hundred). How can this be done
quickly? I tried the insert row and paste function - does not work well. I
welcome the help to make this an easy thing to do.

Is there a way to insert horizontal and vertical lines to divide rows and
colomns on a worksheet without manually drawing in each line?

Sir,
I have a data in which Column A contains date B contains programmes. I am
trying to get in column C that if date starts with 1 a particular programme
from B and if start with 15 some other programme.  when i put the formulah

I need to count the number of cells in a range that are
less than 100 (some values may be negative)
Not empty (ie, exclude blanks)
Not zero

Define formula syntax-in relation to excel

Is there anything wrong with this code?
When I open the workbook, it should activate sheet "menu", but I keep
getting a run-time error 57121 with application and object defined error with
it.

I have some cells in a worksheet that are conditionally formatted. I need to
count the number of cells that have green text. How can this be done?

I need to UN-hide column A:
I had to Hide column A, and now I can't UN-hide it.  I tried the
normal way of clicking on the top of column B and moving the highlight
left to supposedly include column A, but without success.

I would like to know guys how to stop excel from automatically converting my
numbers into dates. I type "2-3" in a cell, and whenever I hit enter or next,
I found it changed to 2-3 February. How can I stop that?
Thanks for yoru help

As my subject line implies, I am trying to figure out how to change a
validation list based on a selection (or selections) from another validation
list. I found a resource that shows how to do it for 2 list, but I have 3
list and one of them is based on the selections from the ...

I am trying to find a way to generate a random number (used for an invoice
number) in a certain cell, each time a the workbook is opened. So far I have
only been able to generate a random number each time anything is input into
the spreadsheet. Any suggestions??

for some reason, the following enterred into custom format does not work
[>=10000000]#,###\,##\,##\,##0;[>=10000000]###\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0
whereas this works fine
[>=10000000]###\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0

I need to set up some Excel reports in a 11 x 17 wide format.  In Excel 2007,
the page layout tab has a "size" option, but no 11 x 17 listed.  How do I set
up my worksheet to be formated to 11 x 17?

when i push the file open button, i want to show the most currently used
folders first and after all the folders are listed, list the most recently
used file next
i tried to arrange by date and it lists them all backwards

I would like to export an adress list I have in excell to oulook contacts.
When I try the import feature in outlook, I have an error message, something
about name ranges. Can this be done and if so how?