Formatting Linked Info

  • Thread starter Thread starter PMach
  • Start date Start date
P

PMach

I just figured out how to link different sheet and files. I'm using a
summary page to keep track of totals from different workbooks. However, once
it goes into the summary sheet, the formatting is gone. I can't figure out
how to format the linked information. Can you help me out with that? Thank
you.
 
Well, if you just want to match the format of the source information,
highlight it on your source page, then Copy. Now on your summary sheet, do a
Paste Special: Formats. The Paste Special option is on the right-click menu
or the Edit menu.
 

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

Excel 2007 - Linking 1
PLEASE HELP - Link Data from Different Sheets to Summary Page 3
linking cells 1
Can I have Paste Link copy formating? 3
Excel Macro to Modify Multiple Worksheets in the Same Manner 1
Linking Formula 2
Excel Count If Formula Question 1
filtering data for analysis 6

Back
Top