Forum Discussion
Working page Set up
Sorry I make a mistake in the number of strings here is the right screen
Trim1234 Excel has a limitation that gets in your way here: Each column can have only one width and each row can only have one height. The trick to have different column widths above each other is by NOT placing them above each other but next to each other. So you design TWO tables, each on their own worksheet. Then you select the worksheet which you want to display below the other one. Select all cells you want to "copy" and then click the little drop-down next to the copy button on the Home tab of the ribbon and choose "Copy As Picture". Now go to the other worksheet and Paste. Now comes the important step: Click in the formula bar and press the equal sign. Click on the other worksheet and select those same cells again and click Enter. The picture is now dynamic!
Thanks a lot, that is awesome and hyper fast trick, easy to dimension and elegant to present.
If i can i will take advantage of your kindness and ask another thing.
I use a lot copy and paste link right to have same upgradeable data in different cells.
If i make that kind of link in an empty "mother" cell and paste link in another it always apper 0.
I try to go on format cells, number, custom and put the @ right to have a "neutral" cell property but still appear the 0.
I solved it by putting a - but if i want and empty linked cell, wich format should i take?
Sorry for bother You
Thanks
Ok lets try
In yellow You have what i want to keep safety
In green You have the result i want to reach
i put in grey what i ask if is possible to do
I try to ask if is possible to make an area(green) an obtain an indipendent column and string layout right to no modify the yellow zone if I stretch column add or delete, ecc...
I hope to be more clear
Thanks again for the attention
