Deleting columns

Heather · External Since: Mar 04, 2006 Posts: 68

I want the columns to be completely gone- and the rows- I only want to be
able to see the column in which I have data and then for only those rows of
cells. How do I delete them?

Kassie · External Since: Feb 01, 2009 Posts: 19

The long and the short - you cannot!

A workaround is to work in page break preview.

--
HTH

Kassie

Replace xxx with hotmail

"Heather" wrote:

> I want the columns to be completely gone- and the rows- I only want to be
> able to see the column in which I have data and then for only those rows of
> cells. How do I delete them?

Gord Dibben · External Since: Feb 23, 2004 Posts: 9178

You cannot delete.

Hide what you don't want to see.

Gord Dibben MS Excel MVP

On Thu, 9 Jul 2009 09:26:04 -0700, Heather
<Heather.TakeThisOut@discussions.microsoft.com> wrote:

>I want the columns to be completely gone- and the rows- I only want to be
>able to see the column in which I have data and then for only those rows of
>cells. How do I delete them?

Melvin · External Since: Jul 30, 2009 Posts: 2

"Heather" wrote:

> I want the columns to be completely gone- and the rows- I only want to be
> able to see the column in which I have data and then for only those rows of
> cells. How do I delete them?

You should be able to do it. I've done it before in the previous version of
Excel and now for the life of me, I cannot figure out where those menus are.

Check out the blue area to the right of column L.
<img src="http://img.photobucket.com/albums/v401/eonmuon/help.jpg"
border="0" alt="Photobucket"></a>

<a
href="http://smg.photobucket.com/albums/v401/eonmuon/?action=view&current=help.jpg"
target="_blank"><img
src="http://img.photobucket.com/albums/v401/eonmuon/help.jpg" border="0"
alt="Photobucket"></a>
<a
href="http://smg.photobucket.com/albums/v401/eonmuon/?action=view&current=help.jpg" target="_blank">

Melvin · External Since: Jul 30, 2009 Posts: 2

This is the answer, hide the unused columns:
- Click on the F to select column F
- While holding Shift, hit the End key, and then the Right Arrow key
this will select all columns from F to the end
- Format - Column - Hide (or right-click on the column headings and pick Hide)