I have a file with a detailed script that gets messed up if anything
but A1  in Worksheet 1 is selected then saved.
Can this become the default selection everything the file is closed?
How?

My problem would seem to be very basic. I have a table that has values
with dollars in columns and then a rate (i.e. one cell less another
and then divide) in percentage format. When I copy an existing tab
either into the same workbook or into a new workbook, many of my

I would like to press key strokes-instead of using mouse- to:
insert new worksheet,
bring up "Open" dialogbox,
Print Preview, etc.

I work in an environment where passing workbooks to and from other
people is a common occurence. Sometimes when opening up a workbook
from someone else, my "reviewing" toolbar gets set to visible. I don't
want that to happen, I'll turn on the toolbar when *I* want it on,

When I print up a spreadsheet that has a lot of text in the cell, The end
character of each line in a cell of text is clipped off. This even happens in
cells with less than 80 chracters.

I have an array of times in format 00:00 (hh:mm).  then, in a separate
cell i have the total sum of all the times,
Eg: 580:23 (hh:mm).  I would like to get the results like this: 24
"days" 4 "hours" 23 "minutes"

Hi
I need some help! I have a column with results from a survey. The results
are in text but do have a ranking, e.g. the results can be A,B,C,D or E. I
now want to create an option button or similar where I can let the user

I want to calculate two cells, and when the outcom is positive then just
show the calculation. On the other hand when the calculation is negative it
must give 0 as a result.
So it's never a <0 figure

Every time I start a word search, the default searches for fomulas instead
of value.   So everytime I have to open up the option button and change it
to value instead of formula.
How do I change that default setting?

I have a macro to print a certain range of cells.
I need VB code for Header:
left header "text 1"
center header (a picture) Logo.jpg

Any ideas why a combined cell crossing several columns should wrap text fine
for several lines, and then go off the side for the rest?  The text is all
wrapped when actually editing within the 'cell', but when one leaves it only
the top few lines are wrapped and readable.

I have text definitions on sheet 2, I have the text words on sheet 1, How can
I create a formula to insert the definitions to the corresponding text with
the words on sheet 1? I am new to excel so please help me step by step. thank
you

In David McRitchies (http://www.mvps.org/dmcritchie/excel/
buildtoc.htm ) TOC page there is a great macro for building TOC.
But this table sorts the sheets in alphabetic order. Is there a way to
change the macro, so it will sort the sheets according to the way they

I have a  form that contains NAME in cell A:1, and GENDER in cell B:2.
I want to build a library of generic statements along the lines of:
NAME tries hard, but if HE/SHE tried harder HIS/HER results would be much
better.

Hola
Quisiera saber si existe alguna función que pueda utilizar para
impedir que cuando escriba algún dato en alguna celda en la siguiente
no se pueda escribir nada o me dé algún tipo de meseja. Por ejemplo: