| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete extraneous EXCEL columns?
I have an EXCEL 2003 worksheet with data in columns A-D. However, there are
four other columns in the worksheet with no data, E, F, G, and H. When I try to delete or hide columns E-H, EXCEL just makes four new blank columns, I, J, K, and L. How do I delete the extra blank columns so that only the four columns that contain data will appear? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I delete extraneous EXCEL columns?
You could use the Page Break Preview and then only the columns with data will
show. "Robert Judge" wrote: I have an EXCEL 2003 worksheet with data in columns A-D. However, there are four other columns in the worksheet with no data, E, F, G, and H. When I try to delete or hide columns E-H, EXCEL just makes four new blank columns, I, J, K, and L. How do I delete the extra blank columns so that only the four columns that contain data will appear? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I delete extraneous EXCEL columns?
Select all the columns from E on and right-click a selected column letter and
choose Hide. Excel always has 256 columns, all you can do is not display them. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Robert Judge" wrote: I have an EXCEL 2003 worksheet with data in columns A-D. However, there are four other columns in the worksheet with no data, E, F, G, and H. When I try to delete or hide columns E-H, EXCEL just makes four new blank columns, I, J, K, and L. How do I delete the extra blank columns so that only the four columns that contain data will appear? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete extraneous EXCEL columns? | Excel Discussion (Misc queries) | |||
| Extraneous character | Excel Discussion (Misc queries) | |||
| Excel crashes when I try to Delete Columns | Excel Discussion (Misc queries) | |||
| How do I delete columns and rows in Excel, not just hide them | Excel Discussion (Misc queries) | |||
| How to delete extraneous rows and columns | Excel Discussion (Misc queries) | |||
Linear Mode
