Paste Link function

D

Dave Peterson

Pasting a link creates a formula to retrieve a value from a different cell.

Formulas don't bring back formatting--they bring back values.
 
P

pshepard

Hi Al,

You can copy the format from one cell and paste the format to another cell
using paste special, format. However, if the formating changes from the
source cell - the updated formatting won't update.

If you want to maintain a cohesive style in your workbook, you should look
at using style in Excel
 

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

Paste to excel from word - auto format problem 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Paste options button disappears 0
Embed the same Excel multiple times 0
Auto match destination formatting for Mac 0
How to make repeating drop-down lists? 2
Create a dynamic master file 1
Insert name and adress from a list in a word document 1

Top