M
ManhattanRebel
In other words, I want to have my spreadsheet end on at certain column..
Right now, I can scroll into infinity.
Right now, I can scroll into infinity.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How can I delete all colums to the right of a specific column?
D
David Biddulph
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.
which version of Excel you are using).
You can't delete them, but you can hide them.
M
ManhattanRebel
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.
to scroll to the right my spreadsheet never ends .. I was up to 3,000
columns and still going.
T
Tim879
depending on how many columns you are actually using.... try freezing
the panes and then you won't see the other columns.
the panes and then you won't see the other columns.
D
David Biddulph
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).]
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).]
G
Gord Dibben
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
SHIFT + End + Right Arrow.
Format>Column>Hide.
Gord Dibben MS Excel MVP