Insert Row "Missing" from my list

O

offanon

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
 
M

Mike H

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
 
O

offanon

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
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
O

offanon

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
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
O

offanon

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?
 
G

Gord Dibben

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
 
S

Sandy Mann

Is there anyone at Microsoft you can ring?
Click to expand...

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top