software

This is a hard thing to explain, but I have been sent an excel document,
where the cells with data in come up as white and all other cells are grey.
I am not wanting to hide rows, but find out how this works.

What happens is if you type anything in the quot;greyquot; area, as soon as you
press enter, it incorporates your new data into the white area, so the grey
row that you entered data into automatically becomes white. From what I can
see, some how it quot;highlightsquot; the first and last column with data in and then
the first and last row with data it. If you leave 5 rows blank and then
enter data, the 5 blank rows also become white, as it forms part of the
quot;rangequot; of data as it were......

I am not sure if that makes sense.

Look forward to any input on this one.

Thanks
Shaz

Maybe...
View|Normal

I think you may be in View|Page break Preview mode.

Shaz wrote:
gt;
gt; This is a hard thing to explain, but I have been sent an excel document,
gt; where the cells with data in come up as white and all other cells are grey.
gt; I am not wanting to hide rows, but find out how this works.
gt;
gt; What happens is if you type anything in the quot;greyquot; area, as soon as you
gt; press enter, it incorporates your new data into the white area, so the grey
gt; row that you entered data into automatically becomes white. From what I can
gt; see, some how it quot;highlightsquot; the first and last column with data in and then
gt; the first and last row with data it. If you leave 5 rows blank and then
gt; enter data, the 5 blank rows also become white, as it forms part of the
gt; quot;rangequot; of data as it were......
gt;
gt; I am not sure if that makes sense.
gt;
gt; Look forward to any input on this one.
gt;
gt; Thanks
gt; Shaz

--

Dave Peterson

How simple was that!!!

That is right...thanks so much for that, it was really bugging me!

Thanks Dave

Shaz

quot;Dave Petersonquot; wrote:

gt; Maybe...
gt; View|Normal
gt;
gt; I think you may be in View|Page break Preview mode.
gt;
gt; Shaz wrote:
gt; gt;
gt; gt; This is a hard thing to explain, but I have been sent an excel document,
gt; gt; where the cells with data in come up as white and all other cells are grey.
gt; gt; I am not wanting to hide rows, but find out how this works.
gt; gt;
gt; gt; What happens is if you type anything in the quot;greyquot; area, as soon as you
gt; gt; press enter, it incorporates your new data into the white area, so the grey
gt; gt; row that you entered data into automatically becomes white. From what I can
gt; gt; see, some how it quot;highlightsquot; the first and last column with data in and then
gt; gt; the first and last row with data it. If you leave 5 rows blank and then
gt; gt; enter data, the 5 blank rows also become white, as it forms part of the
gt; gt; quot;rangequot; of data as it were......
gt; gt;
gt; gt; I am not sure if that makes sense.
gt; gt;
gt; gt; Look forward to any input on this one.
gt; gt;
gt; gt; Thanks
gt; gt; Shaz
gt;
gt; --
gt;
gt; Dave Peterson
gt;