How do I delete extraneous EXCEL columns?

[Robert Judge]

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.

 

[Bernard Liengme]

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

 

[Joel]

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.

 

[Mike Rogers]

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

 

[Gene Augustin]

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