Forum Discussion

Trim1234's avatar
Trim1234
Copper Contributor
Nov 03, 2020

Working page Set up

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

 

excel

7 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Nov 03, 2020
    Can you perhaps post screen-shots of (for example) the result before and after pasting and how you want it to look?
    • Trim1234's avatar
      Trim1234
      Copper Contributor
      Nov 03, 2020

      JKPieterse 

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

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Nov 03, 2020

        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!

    • Trim1234's avatar
      Trim1234
      Copper Contributor
      Nov 03, 2020

      JKPieterse 

      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 

Resources