[Solved] Cannot delete duplicate line of spreadsheet

Discuss the spreadsheet application

[Solved] Cannot delete duplicate line of spreadsheet

Postby SharonAnne » Tue Feb 04, 2020 9:29 am

In Open Office Calc, pressed an unknown key by accident which resulted in first line of data on spreadsheet,i.e. "Line 1", being duplicated with a bold underline. There is no underline in the original line of data. This duplicate line with its bold underline now appears as "Line 1" of the spreadsheet, and the original "Line 1" continues also to appear as "Line 1" but now actually in the next line down the page. How can I delete this unwanted line of data? I have used Open Office Calc for 10 plus years but do not consider myself a sophisticated user.
Last edited by MrProgrammer on Sun Feb 09, 2020 7:24 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
OPERATING SYSTEM = WINDOWS 10
OPEN OFFICE VERSION = 4.1.7
SharonAnne
 
Posts: 1
Joined: Tue Feb 04, 2020 8:38 am

Re: CANNOT DELETE DUPLICATE LINE OF SPREADSHEET DATA

Postby robleyd » Tue Feb 04, 2020 10:43 am

If you want to delete a complete row in Calc, simply right click on the row number at the left of the sheet and select Delete Rows.

At the time, you could have used Ctrl-Z or the Undo icon (see the red arrow in the image) to undo whatever keystroke you accidentally pressed.
Attachments
oo_delete_row.png
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3467
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: CANNOT DELETE DUPLICATE LINE OF SPREADSHEET DATA

Postby Villeroy » Tue Feb 04, 2020 11:11 am

menu:Window>Split = Off
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28573
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: RPG and 34 guests