Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Limiting number of columns/rows on a sheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tarvi - 06 Jul 2006 12:30 GMT
Hi
How to limit the number of columns on a sheet? I'd like to have a
columns on a sheet and afterwards coming the "gray area" (Like it i
coming after 256 columns or 65536 rows)

Thanks in advance
Tarv
R..VENKATARAMAN - 06 Jul 2006 12:47 GMT
hide unwanted rows and columns

> Hi
> How to limit the number of columns on a sheet? I'd like to have a 5
[quoted text clipped - 3 lines]
> Thanks in advance
> Tarvi
Dave Peterson - 06 Jul 2006 12:55 GMT
Maybe you could just hide the columns you don't want to see.

But xl2003 (and below) have 256 columns--this can't be reduced or increased.

> Hi
> How to limit the number of columns on a sheet? I'd like to have a 5
[quoted text clipped - 9 lines]
> tarvi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36109
> View this thread: http://www.excelforum.com/showthread.php?threadid=558833

Signature

Dave Peterson

Mark Ivey - 07 Jul 2006 04:58 GMT
Give this a go...

Set your print area, go to a print preview and select the Print Break Preview.

Maybe this will give you the aesthetics you are looking for. The columns and rows are still there, but not shown as a normal input area.

Signature

Mark Ivey


 Hi
 How to limit the number of columns on a sheet? I'd like to have a 5
 columns on a sheet and afterwards coming the "gray area" (Like it is
 coming after 256 columns or 65536 rows)

 Thanks in advance
 Tarvi

 --
 tarvi
 ------------------------------------------------------------------------
 tarvi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36109
 View this thread: http://www.excelforum.com/showthread.php?threadid=558833
Bill Sharpe - 07 Jul 2006 16:27 GMT
> Hi
> How to limit the number of columns on a sheet? I'd like to have a 5
[quoted text clipped - 3 lines]
> Thanks in advance
> Tarvi

If not happy with the other solutions offered, switch to Quattro Pro,
where you can go as small as a one-by-one worksheet, if you like.

Bill
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.