Author Topic: A row with no number in Excel  (Read 2870 times)

0 Members and 1 Guest are viewing this topic.

Offline Highlander

  • Lord of the Rings
  • Prolific Member
  • *****
  • Posts: 21645
  • Age: 72
  • Location: Dingwall, Ross-shire (God's Own Country)
A row with no number in Excel
« on: May 23, 2016, 18:32:47 PM »
How do I get rid of the un-numbered row between row 636 and row 637 in Excel




It's driving me insane >:( >:( >:( >:( >:(



Offline KKOB

  • Prolific Member
  • *****
  • Posts: 13570
  • I'm hearing the word.... Nonce !
Re: A row with no number in Excel
« Reply #1 on: May 23, 2016, 20:16:01 PM »
Your screenprint isn't very clear, but have you tried "Unhide" and then "Hide" again ?

Offline Highlander

  • Lord of the Rings
  • Prolific Member
  • *****
  • Posts: 21645
  • Age: 72
  • Location: Dingwall, Ross-shire (God's Own Country)
Re: A row with no number in Excel
« Reply #2 on: May 23, 2016, 21:03:44 PM »
I have now - didn't work.

Thanks anyway.

Offline KKOB

  • Prolific Member
  • *****
  • Posts: 13570
  • I'm hearing the word.... Nonce !
Re: A row with no number in Excel
« Reply #3 on: May 23, 2016, 21:29:36 PM »
Reduce the Row Height to 0 ?

Offline SteveJ

  • Full Member
  • ***
  • Posts: 1162
  • Age: 70
  • Location: United Kingdom
Re: A row with no number in Excel
« Reply #4 on: May 23, 2016, 23:40:42 PM »
Hi H - what is convincing you that there is a row between 636 and 637?

As KKOB say, your screenshot is very unclear but have you looked at the header or footer? Go to Page Layout then sheet options and see if that's where the extra row is hiding.

Offline Scunner

  • Chairman of the Bored
  • Administrator
  • Prolific Member
  • *****
  • Posts: 45714
  • Age: 57
  • Location: Perthchester
Re: A row with no number in Excel
« Reply #5 on: May 24, 2016, 00:12:33 AM »
I think SteveJ is right - you have 6 lines unnumbered on page two not one - the blank line will probably be found in the header details.

Offline Highlander

  • Lord of the Rings
  • Prolific Member
  • *****
  • Posts: 21645
  • Age: 72
  • Location: Dingwall, Ross-shire (God's Own Country)
Re: A row with no number in Excel
« Reply #6 on: May 24, 2016, 10:28:16 AM »
Thanks steveJ and scunner.

It has something to do with Rows to repeat at top: but I don't know why it only appeared to affect the one page.

Thanks KKOB - I could click on the row to reduce it.

Anyway it appears sorted now.




Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf