[libreoffice-users] Highlight & Delete Column Data to End of Calc Sheet

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: users+unsubscribe@global.libreoffice.org
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