L
LM
Hi all,
I've been using excel of various vintages for a very long time, but
recently something happened in the normal view that I have never seen
before, and cannot get rid of it. Not sure if this is a bug, or my
toddler son has pressed some weird key/mousing combination to get
this.. I was hoping someone can help me get rid of it.
usually, you have a column header at the top of the worksheet, A, B,
C.. etc. and that is the top-most row in the worksheet window.
however, recently one of my worksheet is now showing two rows with no
heading showing up ABOVE the column header (the A, B, C, etc)
this "blank" row above the column header has row numbered "1" and "2",
and nothing else. no cells, no line, no input area.. sort of greyed
out completely. clicking around it produces no effect. I've tried
moving the split screen cursors, etc trying to see if that is the
problem, but no go. I cannot get my input cursor move beyond the normal
cell ranges, and it will not go above the cell headers. sort of a
phantom rows above the column headers that I can't do anything, but
it's there..
when I do a "select all" and copy the content of the worksheet to
another worksheet, the weird rows above the column header also gets cut
and pasted. If I selec only the real rows (the rows under the column
headers where you usually input database), and then do copy and paste
into another worksheet, it will not show up in the other worksheet. if
I do select all and then do delete content, all the information in the
cells disappear, but the weird row still stays.
so.. what the heck is this row that's showing up in my worksheet? how
do I get rid of it? I've tried everything I could think of. and this
particular worksheet is linked onto by many other worksheet, and I'd
rather not have to start over (cut-paste contents onto another
worksheet, and then re-do all the links in the other worksheet)
help!
I've been using excel of various vintages for a very long time, but
recently something happened in the normal view that I have never seen
before, and cannot get rid of it. Not sure if this is a bug, or my
toddler son has pressed some weird key/mousing combination to get
this.. I was hoping someone can help me get rid of it.
usually, you have a column header at the top of the worksheet, A, B,
C.. etc. and that is the top-most row in the worksheet window.
however, recently one of my worksheet is now showing two rows with no
heading showing up ABOVE the column header (the A, B, C, etc)
this "blank" row above the column header has row numbered "1" and "2",
and nothing else. no cells, no line, no input area.. sort of greyed
out completely. clicking around it produces no effect. I've tried
moving the split screen cursors, etc trying to see if that is the
problem, but no go. I cannot get my input cursor move beyond the normal
cell ranges, and it will not go above the cell headers. sort of a
phantom rows above the column headers that I can't do anything, but
it's there..
when I do a "select all" and copy the content of the worksheet to
another worksheet, the weird rows above the column header also gets cut
and pasted. If I selec only the real rows (the rows under the column
headers where you usually input database), and then do copy and paste
into another worksheet, it will not show up in the other worksheet. if
I do select all and then do delete content, all the information in the
cells disappear, but the weird row still stays.
so.. what the heck is this row that's showing up in my worksheet? how
do I get rid of it? I've tried everything I could think of. and this
particular worksheet is linked onto by many other worksheet, and I'd
rather not have to start over (cut-paste contents onto another
worksheet, and then re-do all the links in the other worksheet)
help!