Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I eliminate a list from an Excel spreadsheet?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I eliminate a list from an Excel spreadsheet?
Assuming Excel 2003 and you created the list using DataCreate List. Right-click on the toolbar and select "List" toolbar. With a cell in your list active, from "List" drop-down on Toolbar select "Convert To Range". Gord Dibben MS Excel MVP On Wed, 29 Nov 2006 06:27:00 -0800, 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
Converter from MS Works 4.5 spreadsheet to MS Excel 2003 | Excel Discussion (Misc queries) | |||
Can Excel 97 read Excel 2003 simple spreadsheet? | Excel Discussion (Misc queries) | |||
Excel 2003: Match one list against another and highlight differenc | Excel Worksheet Functions |