Working page Set up

%3CLINGO-SUB%20id%3D%22lingo-sub-1849356%22%20slang%3D%22en-US%22%3EWorking%20page%20Set%20up%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1849356%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI've%20a%20question%20about%20a%20basic%20page%20set%20up.%20Let's%20see%20if%20i%20can%20explain%20me%20clearly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20build%20a%20page%20layout%20model%20right%20to%20fast%20paste%20and%20clip%20personal%20%22standard%22%20data%20from%20other%20files%20and%20i%20can%20easy%20have%20my%20data%20in%20excel%20with%20a%20simple%20paste.%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EA%20problem%20arrive%20when%20i%20have%20to%20work%20with%20tables%20with%20long%20texts%20or%20with%20different%20dimension%20from%20my%20%22standard%22.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20layout%20have%20a%20dimensioned%20header%20and%20footer%20tables%26nbsp%3B%20build%20in%20the%20working%20page%20and%20is%20not%20allowed%20to%20stretch.%3C%2FP%3E%3CP%3ENow%20I%20manually%20rebuild%20column%20and%20string%20with%20merge%2C%20add%2C%20delete%20button%20(but%20it%20required%20time%20to%20calibrate%20the%20new%20table%20with%20the%20layout%20std%20configuration%20)%20or%20simply%26nbsp%3B%20import%20a%20jpg%20(but%20for%20professial%20tasking%20is%20not%20a%20good%20choiche).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%20is%20if%20is%20possible%20to%20select%20a%20certain%20area%20in%20the%20work%20page%20and%20tell%20to%20excel%20to%20make%20that%20area%20indipendent%20right%20to%20have%20a%20space%20where%20i%20can%20work%20cells%20without%20modify%20the%20external%20cells%20dimensions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20for%20my%20bad%20english%2C%20I%20hope%20someone%20can%20understand%20the%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20attention%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1849356%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1849643%22%20slang%3D%22en-US%22%3ERe%3A%20Working%20page%20Set%20up%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1849643%22%20slang%3D%22en-US%22%3ECan%20you%20perhaps%20post%20screen-shots%20of%20(for%20example)%20the%20result%20before%20and%20after%20pasting%20and%20how%20you%20want%20it%20to%20look%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1849817%22%20slang%3D%22en-US%22%3ERe%3A%20Working%20page%20Set%20up%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1849817%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOk%20lets%20try%3C%2FP%3E%3CP%3EIn%20yellow%20You%20have%20what%20i%20want%20to%20keep%20safety%3C%2FP%3E%3CP%3EIn%20green%20You%20have%20the%20result%20i%20want%20to%20reach%3C%2FP%3E%3CP%3Ei%20put%20in%20grey%20what%20i%20ask%20if%20is%20possible%20to%20do%3C%2FP%3E%3CP%3EI%20try%20to%20ask%20if%20is%20possible%20to%20make%20an%20area(green)%20an%20obtain%20an%20indipendent%20column%20and%20string%20layout%20right%20to%20no%20modify%20the%20yellow%20zone%20if%20I%20stretch%20column%20add%20or%20delete%2C%20ecc...%3C%2FP%3E%3CP%3EI%20hope%20to%20be%20more%20clear%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again%20for%20the%20attention%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1849881%22%20slang%3D%22en-US%22%3ERe%3A%20Working%20page%20Set%20up%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1849881%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20I%20make%20a%20mistake%20in%20the%20number%20of%20strings%20here%20is%20the%20right%20screen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1849979%22%20slang%3D%22en-US%22%3ERe%3A%20Working%20page%20Set%20up%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1849979%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F855983%22%20target%3D%22_blank%22%3E%40Trim1234%3C%2FA%3E%26nbsp%3BExcel%20has%20a%20limitation%20that%20gets%20in%20your%20way%20here%3A%20Each%20column%20can%20have%20only%20one%20width%20and%20each%20row%20can%20only%20have%20one%20height.%20The%20trick%20to%20have%20different%20column%20widths%20above%20each%20other%20is%20by%20NOT%20placing%20them%20above%20each%20other%20but%20next%20to%20each%20other.%20So%20you%20design%20TWO%20tables%2C%20each%20on%20their%20own%20worksheet.%20Then%20you%20select%20the%20worksheet%20which%20you%20want%20to%20display%20below%20the%20other%20one.%20Select%20all%20cells%20you%20want%20to%20%22copy%22%20and%20then%20click%20the%20little%20drop-down%20next%20to%20the%20copy%20button%20on%20the%20Home%20tab%20of%20the%20ribbon%20and%20choose%20%22Copy%20As%20Picture%22.%20Now%20go%20to%20the%20other%20worksheet%20and%20Paste.%20Now%20comes%20the%20important%20step%3A%20Click%20in%20the%20formula%20bar%20and%20press%20the%20equal%20sign.%20Click%20on%20the%20other%20worksheet%20and%20select%20those%20same%20cells%20again%20and%20click%20Enter.%20The%20picture%20is%20now%20dynamic!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi,

I've a question about a basic page set up. Let's see if i can explain me clearly.

 

I've build a page layout model right to fast paste and clip personal "standard" data from other files and i can easy have my data in excel with a simple paste.

  

A problem arrive when i have to work with tables with long texts or with different dimension from my "standard". 

The layout have a dimensioned header and footer tables  build in the working page and is not allowed to stretch.

Now I manually rebuild column and string with merge, add, delete button (but it required time to calibrate the new table with the layout std configuration ) or simply  import a jpg (but for professial tasking is not a good choiche).

 

My question is if is possible to select a certain area in the work page and tell to excel to make that area indipendent right to have a space where i can work cells without modify the external cells dimensions.

 

Sorry for my bad english, I hope someone can understand the question.

 

Thanks for the attention

 

7 Replies
Highlighted
Can you perhaps post screen-shots of (for example) the result before and after pasting and how you want it to look?
Highlighted

@Jan Karel Pieterse 

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 

Highlighted

@Jan Karel Pieterse 

Sorry I make a mistake in the number of strings here is the right screen

Highlighted

@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!

Highlighted

@Jan Karel Pieterse 

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

Highlighted
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)
Highlighted

@Jan Karel Pieterse 

 

Awesome! I understimated the power of IF Function

 

Thanks a lot for the help!

 

Have a Nice day!