M
miroslj
I had troubles in earlier versions of Excel when I was needed more columns,
than it was supplied in one sheet. Now that problem disappear for me because
Microsoft extend the number of columns in Excel 2007. But for somebody this
is maybe still not enough.
I suggest to allow some sheets that we chose to be connected.
One example of Two sheets connected by Rows:
When we insert, delete or copy the rows in one of this sheet the same rows
should follow the same action in other sheet. That’s it. Everything else
should work normally, as it worked till now.
Benefit 1 Extend number of columns:
On this way two sheets act like one. Like as that you extend the number of
columns. So on this way we can extend number of columns as we need, with just
simple connecting more sheets.
Benefit 2 Better Layout of Data:
If we have two Tables with the same number of rows, and we need when we
insert or delete rows in one table to insert the same rows at the same place
in another table. So now, we must put this tables to one sheet to have this
functionality. And go with slider from left to right to watch the data in
this two tables. It would be more easier to have this two tables on two
sheets. But then we have a problem, when we insert rows in one table we must
take care to insert rows (at the same place, the same number of rows) in
another table. This could be nightmare. Everybody will hold tables on one
sheet, and go left-right.
This simple example can also be used on Sheets connected by columns.
There are possible more extensions of this idea, I just gave here simply
example to make understanding of what I wanted to say easy.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
than it was supplied in one sheet. Now that problem disappear for me because
Microsoft extend the number of columns in Excel 2007. But for somebody this
is maybe still not enough.
I suggest to allow some sheets that we chose to be connected.
One example of Two sheets connected by Rows:
When we insert, delete or copy the rows in one of this sheet the same rows
should follow the same action in other sheet. That’s it. Everything else
should work normally, as it worked till now.
Benefit 1 Extend number of columns:
On this way two sheets act like one. Like as that you extend the number of
columns. So on this way we can extend number of columns as we need, with just
simple connecting more sheets.
Benefit 2 Better Layout of Data:
If we have two Tables with the same number of rows, and we need when we
insert or delete rows in one table to insert the same rows at the same place
in another table. So now, we must put this tables to one sheet to have this
functionality. And go with slider from left to right to watch the data in
this two tables. It would be more easier to have this two tables on two
sheets. But then we have a problem, when we insert rows in one table we must
take care to insert rows (at the same place, the same number of rows) in
another table. This could be nightmare. Everybody will hold tables on one
sheet, and go left-right.
This simple example can also be used on Sheets connected by columns.
There are possible more extensions of this idea, I just gave here simply
example to make understanding of what I wanted to say easy.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions