Calis Beach and Fethiye Turkey Discussion Forum

General Topics => Computer Problems & Questions, Virus/Scam Warnings => Topic started by: Highlander on May 23, 2016, 18:32:47 PM

Title: A row with no number in Excel
Post by: Highlander 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

(http://s33.postimg.org/ezcjxiux7/excel.jpg) (http://postimg.org/image/ezcjxiux7/)


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

Title: Re: A row with no number in Excel
Post by: KKOB on May 23, 2016, 20:16:01 PM

Your screenprint isn't very clear, but have you tried "Unhide" and then "Hide" again ?

Title: Re: A row with no number in Excel
Post by: Highlander on May 23, 2016, 21:03:44 PM

I have now - didn't work.

Thanks anyway.

Title: Re: A row with no number in Excel
Post by: KKOB on May 23, 2016, 21:29:36 PM

Reduce the Row Height to 0 ?

Title: Re: A row with no number in Excel
Post by: SteveJ 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.

Title: Re: A row with no number in Excel
Post by: Scunner 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.

Title: Re: A row with no number in Excel
Post by: Highlander 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.