hard referencing ($F$4)

T

Todd

Hi. I am working with liked worksheets. I want to insert
a blank line in the base worksheet and have the linked
worksheets show the blank line. Do I have to manually
insert the line on each worksheet? Or is there a better
way.


Thanks,


Todd
 
B

Biff

Hi Todd,

Just select both sheets. Select the first sheet, hold CTRL
and select the second sheet. Insert the 'line' and it will
appear in both sheets. Make sure that immediately after
you select any other sheet to ungroup the two sheets.
People tend not to do this and really mess things up!

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Embed the same Excel multiple times 0
Hide columns based on row values 2
Converting URLs in comments to Markdown-formatted links 2
Grow/Shrink Text gradually from slide to slide 0
Macro to change referenced column to the next one 1
attempting complicated IF comparison with end goal easy for future users 1
Trying to create custom labels from an csv file + Need items numerically counted out 0

Top