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
- One thing you should know: a cell with a formula is never really empty, but you can make it look like it is empty. Suppose your cell must refer to Sheet2, cell B2, then this formula makes the cell look empty if Sheet2 cell B2 is empty:
=IF(Sheet2!B2="","",Sheet2!B2)Awesome! I understimated the power of IF Function
Thanks a lot for the help!
Have a Nice day!