How can I delete all colums to the right of a specific column?

  • Thread starter Thread starter ManhattanRebel
  • Start date Start date
M

ManhattanRebel

In other words, I want to have my spreadsheet end on at certain column..
Right now, I can scroll into infinity.
 
You can't go to infinity, as the number of columns has a limit (depending on
which version of Excel you are using).
You can't delete them, but you can hide them.
 
I have excel 2007.. I'd like to hide them then. How do I do that? When I try
to scroll to the right my spreadsheet never ends .. I was up to 3,000
columns and still going.
 
depending on how many columns you are actually using.... try freezing
the panes and then you won't see the other columns.
 
If you don't believe me when I tell you that there is a limit, either look
up specification limits in Excel 2007 help, or try to go to column 16,385
(XFE?). [With Excel 2003, the limit was 256 (column IV).]
 
Select the column to the right of last one you want to see.

SHIFT + End + Right Arrow.

Format>Column>Hide.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Viewable columns 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Sum If question 9
delete extra columns and rows 1
Limit the size of the spreadsheet 3
Freeze columns 2
How can I update macro to delete zero amount columns? 2
how do I sort data excluidng headings? 2

Back
Top