Showing only rows with data

G

Guest

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 "grey" 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 "highlights" 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
"range" of data as it were......

I am not sure if that makes sense.

Look forward to any input on this one.

Thanks
Shaz
 
G

Guest

How simple was that!!!

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

Thanks Dave

Shaz
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Fill Color When Data is Entered 1
Adding rows once data is entered 1
Conditional Formatting Applied when Statement Not True 6
Deleting 63,886 Blank Rows Under My Data 15
Lookup Column Headings and Sum the Rows 3
Excel Equation Blank cells until input is added 1
Having an entire row highlighted as I move from cell to cell 8
Series fill only copying and fill series greyed out 1

Top