How do I delete extraneous EXCEL columns?
 

I have an EXCEL 2003 worksheet with data only in columns A through M.
However, when I print it, columns N,O,P, and Q also print, with no data in
them.

When I try to delete or hide those columns, EXCEL just create four new
columns R, S,T, and U.

How can I edit the worksheet so that only columns that contain data will show?

I will appreciate advice.

How do I delete extraneous EXCEL columns?
 

You cannot alter the numbers of columns in a worksheet
You CAN change the range covered by Print Area:
Select what you want printed and use File | Print Area | Set
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Robert Judge" wrote in message
...
I have an EXCEL 2003 worksheet with data only in columns A through M.
However, when I print it, columns N,O,P, and Q also print, with no data in
them.

When I try to delete or hide those columns, EXCEL just create four new
columns R, S,T, and U.

How can I edit the worksheet so that only columns that contain data will
show?

I will appreciate advice.

How do I delete extraneous EXCEL columns?
 

You need to either Set your Print Area or clear You r Print area

Menu : File - Page Setup - Sheet - Print Area

With no print area set excel will use the Used Area of the worksheet. If a
cell contained data a one time this will be part of the used area. to
resolve the problem you can delete unused rows and columns which should
reduce the used area back to the actually area where your data is located.
To be safe, it is a good idea to set the print area.

"Robert Judge" wrote:

I have an EXCEL 2003 worksheet with data only in columns A through M.
However, when I print it, columns N,O,P, and Q also print, with no data in
them.

When I try to delete or hide those columns, EXCEL just create four new
columns R, S,T, and U.

How can I edit the worksheet so that only columns that contain data will show?

I will appreciate advice.

How do I delete extraneous EXCEL columns?
 

Robert Judge

If it is a case where your don't want to see the extra columns when you use
or show your worksheet on the computor just hide them. Select all the
columns you dont want, (select the first one and drag left until you get to
the end of the worksheet). Right click and select "Hide". The same thing can
be done with rows.

Mike Rogers

"Robert Judge" wrote:

I have an EXCEL 2003 worksheet with data only in columns A through M.
However, when I print it, columns N,O,P, and Q also print, with no data in
them.

When I try to delete or hide those columns, EXCEL just create four new
columns R, S,T, and U.

How can I edit the worksheet so that only columns that contain data will show?

I will appreciate advice.

How do I delete extraneous EXCEL columns?
 

1. Select the area of cells you want to print.
2. MENU FILE PRINT AREA SET PRINT AREA
3. You should then do MENU FILE PAGE SETUP review the options,
especially MARGINS


Gene Augustin

On 2/12/09 10:13 AM, in article
, "Mike Rogers"
<Mike060349@NoxSpamxAOLDOTcom wrote:

Robert Judge

If it is a case where your don't want to see the extra columns when you use
or show your worksheet on the computor just hide them. Select all the
columns you dont want, (select the first one and drag left until you get to
the end of the worksheet). Right click and select "Hide". The same thing can
be done with rows.

Mike Rogers

"Robert Judge" wrote:

I have an EXCEL 2003 worksheet with data only in columns A through M.
However, when I print it, columns N,O,P, and Q also print, with no data in
them.

When I try to delete or hide those columns, EXCEL just create four new
columns R, S,T, and U.

How can I edit the worksheet so that only columns that contain data will
show?

I will appreciate advice.