I have some worksheets where some, but not all of the gridlines are
missing. Using Tools/Options/View and unchecking and then checking
makes no difference. Any solution? I'd like to have them.

I made the mistake of getting up from the computer without saving and my son
closed my workbook.  Can I recover the workbook with the new items as I was
working on the document long enough for the auto recovery to save a few times?
There is about an hours worth of work i lost.

If you select a range of cells and COPY, then cancel the copy by pressing
ESC, there is a long (10+ second) delay while it clears the copy selection.
I'm aware this isn't a major issue, but it is very annoying.  I'm interested
if anyone else is seeing it.

I am working on a Validation List
In cell D13, I want user to key in only letters A, B, C, D, or E and all
should be in CAPITAL LETTERS.
I use the formula below in

hi community
is it possible to print data from different location example: i want to
print colum B and data from colum H
when I used ctrl+select and do a Print Preview, I can see both columns

I work for a pretty small company, and I am the so called Excel " expert " (
which means I know about 1% of most of you)...my problem is...we are doing a
piece rate time sheet, It is from an ancient Lotus 123 that I converted into
excel, and it works fine...all the info works.

We use a system of monitoring duties using excel, with spreadsheets that
are protected with passwords to modify by certain personnel.  
The worksheets within are password protected to prevent deletion of
formula in certain locked cells/columns.  Other cells are not locked

I wish to be able to import stock data as in the pre-defined import, except
that I would like to import the data from a defined date in the past rather
than today's close.  Has anyone devised an import querry to do this?  If so,
I would appreciate it if you could post it.  Thanks ...

I have two sheets in a workbook. One is a Summary sheet, and the next is
titled "Bldg 5".
What I am trying to make sure is that the range A1:K20 on the Bldg 5 sheet
has had data entered to them (ie, they are not blank).

I wish to update one worksheet (containing an XML export 'list') with
values from various distilled other worksheets.
Its quite a simple operation, on click of a macro button take all
'completed' rows from one work sheet and append onto the bottom of the

i've been reading up on all the sumproduct related posts, but can't figure
out what's wrong with mine...
this is my formula:
=SUMPRODUCT(Détail!B2:B151=1;Détail!AB2:AB151=1;Détail!T2:T151)

i have text data like this
1-58/a
i want to convert thease colum like
1

Hi, I would like to check (on Exit) a value entered in a textbox with a
certain cell. That's not the problem, but I would like to find a method how
to move the cursor to the wrong entered value (so: back to that textbox).
Thanks in advance!

How to repeat a code for selected sheets (or a contiguous range of sheets)
in a Workbook?
The code is:
Range("J16").Select

Hi how would I write a formula to calculate the following
cell b2 contains 0.02169 cell B3 contains 0.01590 cell D2 contains 5860 and
column G contains numbers from 1 to 20845
Units Rate 1  0.02169 (first 5,860 units) 5860 £127.10