View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How can I delete all colums to the right of a specific column?

Select the column to the right of last one you want to see.

SHIFT + End + Right Arrow.

FormatColumnHide.


Gord Dibben MS Excel MVP

On Tue, 6 May 2008 06:42:02 -0700, ManhattanRebel
wrote:

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.

"David Biddulph" wrote:

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.
--
David Biddulph

"ManhattanRebel" wrote in message
...
In other words, I want to have my spreadsheet end on at certain column..
Right now, I can scroll into infinity.