If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Deleting columns
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? |
#2
|
|||
|
|||
Deleting columns
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? |
#3
|
|||
|
|||
Deleting columns
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 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? |
#4
|
|||
|
|||
Deleting columns
"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¤t=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¤t=help.jpg" target="_blank" |
#5
|
|||
|
|||
Deleting columns
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) |
Thread Tools | |
Display Modes | |
|
|