Skip to main content

TIP - 47 : Insert shapes and linking cell contents in excel


Insert shapes and linking cell contents in excel

Wow great!!!  we can link a cell information to a shape. So that when we change the cell data it will be auto updated in the shape as well.

Step 1: Please create or draw a shape of your choice

Step 2: Select the shape, then click on the formula bar

Step 3: Now type = and then select the cell which you want to link, press enter

Now when we change cell data, Shape data updated automatically.

Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more