ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Deleting unused columns (https://www.excelbanter.com/excel-discussion-misc-queries/93272-deleting-unused-columns.html)

dramajuana

Deleting unused columns
 
Is there a way to get rid of unused columns? It automatically gives me
columns A-L, and I really only need up to H usually. Deleting these columns
makes them appear again (it's MAGIC!), and making them hidden just makes it
look like letters are skipped.

Biff

Deleting unused columns
 
What you've already done is all that can be done.

You can't delete columns/rows in the sense that they are removed from the
sheet.

You can hide from column I to IV and those columns will just appear as an
empty gray space.

Biff

"dramajuana" wrote in message
...
Is there a way to get rid of unused columns? It automatically gives me
columns A-L, and I really only need up to H usually. Deleting these
columns
makes them appear again (it's MAGIC!), and making them hidden just makes
it
look like letters are skipped.




Gord Dibben

Deleting unused columns
 
An Excel worksheet has 256 columns(more in 2007 version)

You can cannot delete these columns. You can hide them or give them a
background color so it appears they are not there.


Gord Dibben MS Excel MVP

On Sat, 10 Jun 2006 13:39:01 -0700, dramajuana
wrote:

Is there a way to get rid of unused columns? It automatically gives me
columns A-L, and I really only need up to H usually. Deleting these columns
makes them appear again (it's MAGIC!), and making them hidden just makes it
look like letters are skipped.




All times are GMT +1. The time now is 01:54 PM.

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