ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I eliminate a list from an Excel spreadsheet? (https://www.excelbanter.com/excel-discussion-misc-queries/120813-re-how-do-i-eliminate-list-excel-spreadsheet.html)

Mike Rogers

How do I eliminate a list from an Excel spreadsheet?
 
Pete

Not sure I understand everything, but to remove a named range (is this how
you made your list?) goto insertnamedefineselect the name and click remove.

Mike Rogers

"Pete" wrote:

I unintentionaly created a list in a spreadsheet I have which has over 4,000
rows of data in 10 columns. The list I created was the first 5 columns of
the entire spreadsheet, and due to creating the list, it added a row in those
5 coilmns, and now my spreadsheet has the info for a row for last 5 columns
being shown one row up from the other data for that row.



All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com