I created a list in a worksheet that I have spent hours putting together. It
has been working perfectly for weeks, until now! For some reason the INSERT
ROW at the bottom of the list doesn't appear any more. I have tried several
ways to get around this, including unsorting all of my data in the list so
that every line appears, then converting the list to range then back to list.
This doesn't help. The nearest I came to fixing it was to copy the list and
its contents to a new worksheet and messing about with it there for a bit.
This kind of got it working (on the new worksheet) but there is a lot of
conditional formatting in some of the rows which won't copy into the new rows
as it did before. The data that is entered into this list populates about 5
more sheets with vital data for the buiness so this is a big problem. At the
moment I'm having to manually insert a row each time a new sale needs
recording. This is fine when I'm doing it but the other staff can't seem to
cope with it as they are useless with technology.

Any help would be greatly appreciated.

Thanks

Jon

Hi,

I may be asking the obvious but if 'Insert Row' wasn't missing from your
list then what would it do and more importantly, how would it do it.

Mike

"offanon" wrote:

I created a list in a worksheet that I have spent hours putting together. It
has been working perfectly for weeks, until now! For some reason the INSERT
ROW at the bottom of the list doesn't appear any more. I have tried several
ways to get around this, including unsorting all of my data in the list so
that every line appears, then converting the list to range then back to list.
This doesn't help. The nearest I came to fixing it was to copy the list and
its contents to a new worksheet and messing about with it there for a bit.
This kind of got it working (on the new worksheet) but there is a lot of
conditional formatting in some of the rows which won't copy into the new rows
as it did before. The data that is entered into this list populates about 5
more sheets with vital data for the buiness so this is a big problem. At the
moment I'm having to manually insert a row each time a new sale needs
recording. This is fine when I'm doing it but the other staff can't seem to
cope with it as they are useless with technology.

Any help would be greatly appreciated.

Thanks

Jon

In short, the list is a sales record containing info such as Salesman,
Customer, Product, Profit etc. Each new line is a new sale. In order to enter
a new sale to the list, I have been clicking into the Insert Row at the
bottom of the list and entering the new data. This row no longer appears and
my list is surrounded by a blue border which doesn't move whether I click
inside the list or not. Nor does it allow me to drag the dimensions of the
list like I can with others.

Hope this makes sense.

Jon

"Mike H" wrote:

Hi,

I may be asking the obvious but if 'Insert Row' wasn't missing from your
list then what would it do and more importantly, how would it do it.

Mike

"offanon" wrote:

I created a list in a worksheet that I have spent hours putting together. It
has been working perfectly for weeks, until now! For some reason the INSERT
ROW at the bottom of the list doesn't appear any more. I have tried several
ways to get around this, including unsorting all of my data in the list so
that every line appears, then converting the list to range then back to list.
This doesn't help. The nearest I came to fixing it was to copy the list and
its contents to a new worksheet and messing about with it there for a bit.
This kind of got it working (on the new worksheet) but there is a lot of
conditional formatting in some of the rows which won't copy into the new rows
as it did before. The data that is entered into this list populates about 5
more sheets with vital data for the buiness so this is a big problem. At the
moment I'm having to manually insert a row each time a new sale needs
recording. This is fine when I'm doing it but the other staff can't seem to
cope with it as they are useless with technology.

Any help would be greatly appreciated.

Thanks

Jon

It sound like you are in Page Break Preview. Try selecting:

View Normal

or if you want to stay inPage Break Preview, hover the cursor over the
bottom blue border and it should turn into a double headed arrow, left-click
and drag the border down.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"offanon" wrote in message
...
In short, the list is a sales record containing info such as Salesman,
Customer, Product, Profit etc. Each new line is a new sale. In order to
enter
a new sale to the list, I have been clicking into the Insert Row at the
bottom of the list and entering the new data. This row no longer appears
and
my list is surrounded by a blue border which doesn't move whether I click
inside the list or not. Nor does it allow me to drag the dimensions of the
list like I can with others.

Hope this makes sense.

Jon

"Mike H" wrote:

Hi,

I may be asking the obvious but if 'Insert Row' wasn't missing from your
list then what would it do and more importantly, how would it do it.

Mike

"offanon" wrote:

I created a list in a worksheet that I have spent hours putting
together. It
has been working perfectly for weeks, until now! For some reason the
INSERT
ROW at the bottom of the list doesn't appear any more. I have tried
several
ways to get around this, including unsorting all of my data in the list
so
that every line appears, then converting the list to range then back to
list.
This doesn't help. The nearest I came to fixing it was to copy the list
and
its contents to a new worksheet and messing about with it there for a
bit.
This kind of got it working (on the new worksheet) but there is a lot
of
conditional formatting in some of the rows which won't copy into the
new rows
as it did before. The data that is entered into this list populates
about 5
more sheets with vital data for the buiness so this is a big problem.
At the
moment I'm having to manually insert a row each time a new sale needs
recording. This is fine when I'm doing it but the other staff can't
seem to
cope with it as they are useless with technology.

Any help would be greatly appreciated.

Thanks

Jon

Hi Sandy,

Thanks for trying but unfortunately neither of those suggestions fixed the
problem. I'm already in Normal view and the double headed arrow doesn't
appear at all. I know its supposed to as I've used that function before, it
just isn't doing it now.

Thanks

Jon

"Sandy Mann" wrote:

It sound like you are in Page Break Preview. Try selecting:

View Normal

or if you want to stay inPage Break Preview, hover the cursor over the
bottom blue border and it should turn into a double headed arrow, left-click
and drag the border down.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"offanon" wrote in message
...
In short, the list is a sales record containing info such as Salesman,
Customer, Product, Profit etc. Each new line is a new sale. In order to
enter
a new sale to the list, I have been clicking into the Insert Row at the
bottom of the list and entering the new data. This row no longer appears
and
my list is surrounded by a blue border which doesn't move whether I click
inside the list or not. Nor does it allow me to drag the dimensions of the
list like I can with others.

Hope this makes sense.

Jon

"Mike H" wrote:

Hi,

I may be asking the obvious but if 'Insert Row' wasn't missing from your
list then what would it do and more importantly, how would it do it.

Mike

"offanon" wrote:

I created a list in a worksheet that I have spent hours putting
together. It
has been working perfectly for weeks, until now! For some reason the
INSERT
ROW at the bottom of the list doesn't appear any more. I have tried
several
ways to get around this, including unsorting all of my data in the list
so
that every line appears, then converting the list to range then back to
list.
This doesn't help. The nearest I came to fixing it was to copy the list
and
its contents to a new worksheet and messing about with it there for a
bit.
This kind of got it working (on the new worksheet) but there is a lot
of
conditional formatting in some of the rows which won't copy into the
new rows
as it did before. The data that is entered into this list populates
about 5
more sheets with vital data for the buiness so this is a big problem.
At the
moment I'm having to manually insert a row each time a new sale needs
recording. This is fine when I'm doing it but the other staff can't
seem to
cope with it as they are useless with technology.

Any help would be greatly appreciated.

Thanks

Jon

Well, my next guess would be that you have an event macro which runs when
you click into the last row. Is there an code to be see when you
right-click on the sheet tab and select View code?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"offanon" wrote in message
...
In short, the list is a sales record containing info such as Salesman,
Customer, Product, Profit etc. Each new line is a new sale. In order to
enter
a new sale to the list, I have been clicking into the Insert Row at the
bottom of the list and entering the new data. This row no longer appears
and
my list is surrounded by a blue border which doesn't move whether I click
inside the list or not. Nor does it allow me to drag the dimensions of the
list like I can with others.

Hope this makes sense.

Jon

"Mike H" wrote:

Hi,

I may be asking the obvious but if 'Insert Row' wasn't missing from your
list then what would it do and more importantly, how would it do it.

Mike

"offanon" wrote:

I created a list in a worksheet that I have spent hours putting
together. It
has been working perfectly for weeks, until now! For some reason the
INSERT
ROW at the bottom of the list doesn't appear any more. I have tried
several
ways to get around this, including unsorting all of my data in the list
so
that every line appears, then converting the list to range then back to
list.
This doesn't help. The nearest I came to fixing it was to copy the list
and
its contents to a new worksheet and messing about with it there for a
bit.
This kind of got it working (on the new worksheet) but there is a lot
of
conditional formatting in some of the rows which won't copy into the
new rows
as it did before. The data that is entered into this list populates
about 5
more sheets with vital data for the buiness so this is a big problem.
At the
moment I'm having to manually insert a row each time a new sale needs
recording. This is fine when I'm doing it but the other staff can't
seem to
cope with it as they are useless with technology.

Any help would be greatly appreciated.

Thanks

Jon

Hi Sandy,

Thanks for your persistance with this. No, there is no code to be seen, I
haven't created any macros in this workbook at all. It's just gone "Faulty"
all of a sudden. Can't figure it out.

Is there anyone at Microsoft you can ring?

"Sandy Mann" wrote:

Well, my next guess would be that you have an event macro which runs when
you click into the last row. Is there an code to be see when you
right-click on the sheet tab and select View code?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"offanon" wrote in message
...
In short, the list is a sales record containing info such as Salesman,
Customer, Product, Profit etc. Each new line is a new sale. In order to
enter
a new sale to the list, I have been clicking into the Insert Row at the
bottom of the list and entering the new data. This row no longer appears
and
my list is surrounded by a blue border which doesn't move whether I click
inside the list or not. Nor does it allow me to drag the dimensions of the
list like I can with others.

Hope this makes sense.

Jon

"Mike H" wrote:

Hi,

I may be asking the obvious but if 'Insert Row' wasn't missing from your
list then what would it do and more importantly, how would it do it.

Mike

"offanon" wrote:

I created a list in a worksheet that I have spent hours putting
together. It
has been working perfectly for weeks, until now! For some reason the
INSERT
ROW at the bottom of the list doesn't appear any more. I have tried
several
ways to get around this, including unsorting all of my data in the list
so
that every line appears, then converting the list to range then back to
list.
This doesn't help. The nearest I came to fixing it was to copy the list
and
its contents to a new worksheet and messing about with it there for a
bit.
This kind of got it working (on the new worksheet) but there is a lot
of
conditional formatting in some of the rows which won't copy into the
new rows
as it did before. The data that is entered into this list populates
about 5
more sheets with vital data for the buiness so this is a big problem.
At the
moment I'm having to manually insert a row each time a new sale needs
recording. This is fine when I'm doing it but the other staff can't
seem to
cope with it as they are useless with technology.

Any help would be greatly appreciated.

Thanks

Jon

What happens when you double-click on the last cell with the asterisk in column1
of the list?

That should put you into edit mode.

Type your data and ENTER.

Your list range will shift down one row.


Gord Dibben MS Excel MVP

On Sat, 7 Jul 2007 08:48:00 -0700, offanon
wrote:

Hi Sandy,

Thanks for your persistance with this. No, there is no code to be seen, I
haven't created any macros in this workbook at all. It's just gone "Faulty"
all of a sudden. Can't figure it out.

Is there anyone at Microsoft you can ring?

"Sandy Mann" wrote:

Well, my next guess would be that you have an event macro which runs when
you click into the last row. Is there an code to be see when you
right-click on the sheet tab and select View code?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"offanon" wrote in message
...
In short, the list is a sales record containing info such as Salesman,
Customer, Product, Profit etc. Each new line is a new sale. In order to
enter
a new sale to the list, I have been clicking into the Insert Row at the
bottom of the list and entering the new data. This row no longer appears
and
my list is surrounded by a blue border which doesn't move whether I click
inside the list or not. Nor does it allow me to drag the dimensions of the
list like I can with others.

Hope this makes sense.

Jon

"Mike H" wrote:

Hi,

I may be asking the obvious but if 'Insert Row' wasn't missing from your
list then what would it do and more importantly, how would it do it.

Mike

"offanon" wrote:

I created a list in a worksheet that I have spent hours putting
together. It
has been working perfectly for weeks, until now! For some reason the
INSERT
ROW at the bottom of the list doesn't appear any more. I have tried
several
ways to get around this, including unsorting all of my data in the list
so
that every line appears, then converting the list to range then back to
list.
This doesn't help. The nearest I came to fixing it was to copy the list
and
its contents to a new worksheet and messing about with it there for a
bit.
This kind of got it working (on the new worksheet) but there is a lot
of
conditional formatting in some of the rows which won't copy into the
new rows
as it did before. The data that is entered into this list populates
about 5
more sheets with vital data for the buiness so this is a big problem.
At the
moment I'm having to manually insert a row each time a new sale needs
recording. This is fine when I'm doing it but the other staff can't
seem to
cope with it as they are useless with technology.

Any help would be greatly appreciated.

Thanks

Jon

Is there anyone at Microsoft you can ring?

These Newsgroups are not Microsoft, they are a peer to peer help forum.

In your original post you said:

"For some reason the INSERT ROW at the bottom of the list doesn't appear any
more. "

What INSET ROW are you talking about?

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"offanon" wrote in message
...
Hi Sandy,

Thanks for your persistance with this. No, there is no code to be seen, I
haven't created any macros in this workbook at all. It's just gone
"Faulty"
all of a sudden. Can't figure it out.

Is there anyone at Microsoft you can ring?

"Sandy Mann" wrote:

Well, my next guess would be that you have an event macro which runs when
you click into the last row. Is there an code to be see when you
right-click on the sheet tab and select View code?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"offanon" wrote in message
...
In short, the list is a sales record containing info such as Salesman,
Customer, Product, Profit etc. Each new line is a new sale. In order to
enter
a new sale to the list, I have been clicking into the Insert Row at the
bottom of the list and entering the new data. This row no longer
appears
and
my list is surrounded by a blue border which doesn't move whether I
click
inside the list or not. Nor does it allow me to drag the dimensions of
the
list like I can with others.

Hope this makes sense.

Jon

"Mike H" wrote:

Hi,

I may be asking the obvious but if 'Insert Row' wasn't missing from
your
list then what would it do and more importantly, how would it do it.

Mike

"offanon" wrote:

I created a list in a worksheet that I have spent hours putting
together. It
has been working perfectly for weeks, until now! For some reason the
INSERT
ROW at the bottom of the list doesn't appear any more. I have tried
several
ways to get around this, including unsorting all of my data in the
list
so
that every line appears, then converting the list to range then back
to
list.
This doesn't help. The nearest I came to fixing it was to copy the
list
and
its contents to a new worksheet and messing about with it there for
a
bit.
This kind of got it working (on the new worksheet) but there is a
lot
of
conditional formatting in some of the rows which won't copy into the
new rows
as it did before. The data that is entered into this list populates
about 5
more sheets with vital data for the buiness so this is a big
problem.
At the
moment I'm having to manually insert a row each time a new sale
needs
recording. This is fine when I'm doing it but the other staff can't
seem to
cope with it as they are useless with technology.

Any help would be greatly appreciated.

Thanks

Jon