Hi: LibreOffice 7.3.2.2 on Win10 build 19043 on desktop PC.
How should I highlight all rows above row 600 so I could then remove the unwanted _<Division 2 Category>_ entries from my spreadsheet?
When working on a Calc sheet, I copied a drop down list, i.e, _<Division 2 Category>_, to the end of column [AC]. Still not sure how to correctly do that! The way I did it was to first highlight the column's heading/label_,_ _[_AC_]_; doing that highlighted the entire column. Then, I de-selected the heading/label... I think there is a shortcut key combination to accomplish this, but unsure.
(There is no data within columns above row 600 other than within column [AC].)
Now, I want to remove all entries that are located above row 600. I used Ctrl-End, which got me /there/, but I need to highlight all rows above row 600 - to the very last row, and then "Clear All" the data contained within cells that are above row 600, somehow????
Please help. <snipped> TNX. VinceB. -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
