[Solved] Lost 500 rows

Discuss the spreadsheet application
Locked
THEBookMan
Posts: 122
Joined: Wed Sep 30, 2015 10:03 pm
Location: Houston, TX area

[Solved] Lost 500 rows

Post by THEBookMan »

Formatting CALC. sheet
Deleting duplicate E-Mails
Delete column with duplicating formula

Suddenly top 500 rows dont' appear !
CALC sheet begins with row 507.

I suspect that rows 1 - 506 are there, but I can't seem to get tem to display !

Thanks for all the help,


⌡im [THE BookMan]
Last edited by MrProgrammer on Mon Jul 14, 2025 3:07 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Open Office 4.1.3 Win 10
User avatar
Zizi64
Volunteer
Posts: 11494
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Lost 500 rows

Post by Zizi64 »

CALC sheet begins with row 507.
Select all of the cells on the sheet, and then - on a viewable row - use the context menu: Show
ShowRows.png
ShowRows.png (24.08 KiB) Viewed 862 times
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
THEBookMan
Posts: 122
Joined: Wed Sep 30, 2015 10:03 pm
Location: Houston, TX area

Re: Lost 500 rows

Post by THEBookMan »

Thank you.

I knew it had to be a simple solution.

⌡im [THE BookMan]
Open Office 4.1.3 Win 10
Locked