Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a workbook with a "master worksheet" and 4 worksheets that reference all the information in the master. The purpose of the master sheet requires resorting on a quarterly basis. My issue is the format of the referenced cells on the other 4 worksheets. The resort changes the position of the referenced information but it does not pick up all the formats which leaves me with miss matched formats between the master and the other sheets. Can I use a function to reference a cells value and its formats?

share|improve this question

To specifically answer your last question on whether you can reference a cell's format, the answer is yes, by using the CELL function in your formula.

 =CELL("format", A1)

The values that this function returns are listed on this page:

share|improve this answer

You could try putting together a hack macro that resets your cell references. If the position changes you'll need to get Excel to locate whatever column/row that you are interested in using some sort of search.

Another way is to leave the master spreadsheet alone and recreate the 4 other guys each time you get an updated master, all with VBA.

share|improve this answer

I think I have found a way around it --

  1. Copy source cell
  2. right click, paste special, use "Linked Picture"

the catch is:

the result will only show the area within the source cell. i.e if your source cell's text exceeds the width, it will only show the parts that's in the area of the source cell. just ensure that your source column is wide enough and it'll be ok

I'm using MS 2010 :) hope this will be helpful!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.