Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allow Sheets to be Connected by Rows or by Columns
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. Thats 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/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allow Sheets to be Connected by Rows or by Columns
You can "group" two or more sheets together temporarily - any action
carried out on one sheet will be reflected on all the grouped sheets. So, if you have two tables of, say, 15 rows by 6 columns on Sheets 1 and 2, then with Sheet1 selected, hold down the CTRL key and click on the tab for Sheet2 - this "groups" them. Then if you insert two new rows at 10 and 11 and one new column C on Sheet1, this will also happen to Sheet2 at the same time. Ungroup the sheets by right-clicking on one of the sheet tabs and clicking on Ungroup sheets. Hope this helps. Pete On Dec 6, 10:10 pm, miroslj wrote: 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/comm....mspx?mid=3335... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
How do I have excel setup so formulas is connected between sheets | Excel Worksheet Functions | |||
How do I repeat rows that are not connected? | Excel Worksheet Functions | |||
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) |