LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
 
Posts: n/a
Default Excel should have an unlimited number of columns available.

Hi

For my taste, it's extremly cumbersome to work with tables with more
columns, than you can place on single A4 landscape sheet.

Btw. I designed a yearly calendar, which occupies a single A4 sheet. User
enters year number, and according calendar (months columnwise, weekends and
state holidays coloured differently) is displayed.

Of-course it will be different, when you need a calendar-agenda, where you
can enter various information for every day. But then my advice is to use
some database (p.e. Access), or to design the calendar as database in
Excel - on one sheet you enter all information into events table like
Date, Event
, and design one or several additional sheets as reports, where you select
p.e. some time interval (month, week, or day), and according info is
retrieved from events table. And you are free to design this report sheet as
you like am best.
Or simply use Outlook :-)


Arvi Laanemets


<JSA - Plano; "TX" <JSA - Plano, TX @discussions.microsoft.com wrote in
message ...
The main reason I'd like to see more than 256 columns: Creating a

Calendar.
As is stands now, to create a 1 year calendar in Excel, you need to split

it
into at least two tabs: Jan-Jun and Jul-Dec; or 4 quarerly tabs or 12

monthly
tabs. It makes managing dates a pain. In the past three years, I've had

to
create about ten applications in Excel that have been hobbled because of

the
column limitation.

"Duke Carey" wrote:

I would guess that the VAST majority of spreadsheets use nothing near

the
current limit of 256 columns. In other words, I'd guess this is one of

those
things that would benefit so few users that it'd be a really low

priority in
my book (or should that be workbook?)

If MS could simply increase the max # without in any way affecting
performance, or without causing other, more needed features to be

omitted,
then I'd be in favor of more columns. Otherwise - NO WAY.

"jkp" wrote:

I am building a worksheet that needs 262 columns. It will have 259

worksheets
linked to this main worksheet. Just wondering why the number of

columns is
limited to 256.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto number columns in excel Laura Excel Discussion (Misc queries) 4 March 29th 05 02:39 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
Add more lines and more columns in Excel Marc Charbonneau Excel Worksheet Functions 3 January 20th 05 03:44 AM
Can the number of times undo is used in Excel 2002 be increased? Austrian Hannes Setting up and Configuration of Excel 2 December 6th 04 05:54 PM
I have Excel columns with different statements (yes, no; numbers). David Verlander Excel Worksheet Functions 2 November 26th 04 10:27 PM


All times are GMT +1. The time now is 06:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"