View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default Removing Columns

Wed, 30 Jan 2008 05:06:01 -0800 from Maurice
:
Working with Excel 2003. I have a spreadsheet with a large numbe of empty
rows. Have tried to delete them but more appear. I have also tried the hide
command with no success. Seeking guidance on how to display just the columns
that have data. Advice sought


Excel worksheets always contain rows through 65536 and columns
through IV (more in Excel 2007); there's nothing you can do about
that.

You can adjust the View | Zoom so that only the rows and columns
you're interested in fit on the screen.

You can use File | Print Area | Set Print Area to control how much of
the worksheet prints.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/