I regularly make reporting sheets and begin with a number of single rows.  
Under those rows I need to insert 2 more rows (1 at height 55 and one at
12.75) . Each of the two rows are merged into one column each.
Currently, I first go down the pages inserting two rows under each ...

my query is regarding Macros in Excelsheet! i have already an excel
report generated from a VB application. which is Protected.. i mean
it is
unedittable.i want to add few more columns in that report ..

my query is regarding Macros in Excelsheet! i have already an excel
report generated from a VB application. which is Protected.. i mean
it is
unedittable.i want to add few more columns in that report ..

i have a cloumn have many dates. i would like to know how many days repeated
in january, February and March for example

I have a column in which rows will contain the value of "1" when that row
meets a certain criteria.  I want to build an ascending list in another
location of the row numbers in that column that contain "1".  Any ideas?

Right I'll try and ask this as clearly as i can...
I have a worksheet where I have to work out what size pipe i need for a
specific room, so i have a selection of cells with formulas in it. I want to
keep one set of these cells on the worksheet but have the ablity to click a

Am trying to create a Excel template which user can download and fill in
In the first column i have defined data validations to show all the country
names.
In second column, i have to define the validation based on its adjacent

I am having trouble with the following, and wonder if someone can help me out.
We have a periodical dump of ledgerdata, which is divided in Budget and
Realisation info.
The format (i.e. the number of lines with Budget- or Realisation data)

I have a list of items that contain 3 rows for each item. Does anyone know of
a relatively easy way to sort the list by different 'fields' in each item?

My spreadsheet contains a row of hours worked by our team per day -- 31:06,
18:32, 43:44.  I also have a column of number of widgets produced that day.
How can I get Excel to calculate the number of widgets produced per hour?  
For example, row A is 7/1/07 and we had 40:00 labor ...

In one colon i have a lot of numbers in range from 1,03 to 16,00
and i need to have it in other colon provided to show as text like:
1,03-1,15
1,15-1,30

I M using excel since long but now I wanted to share my excel shee
with other user also. Now I wanted to lock some cells in which I mak
some formula's . So pl let me know how I will lock cell ? and if I wan
to change in lock cell how it will work ?

first sorry about my english (I'm Spanish native).
My question: I would like to use the function sum.if but in the criteria I
would like to use something like this: sum.if(B1:B5;"="f5:f10;c1:c5)
I know that I can use sum.if(b1:b5;"="&f1;c1:c5), but how to do it with a

I'm trying to do exactly that, and reference all the cells so when the
original update, so does the file I am trying to create.  Any help would be
fantastic.  Thanks!

I have an Excel document with four worksheets and need to send each one as an
email.  How do I make each worksheet into its own document?