How do I break a link between cells in the same workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
Convert to values?

edit|copy
edit|paste special|values

is one way.

LBogie wrote:
 
Thanks for the reply. Is there perhaps another wayto accomplish this? This
way may cause the formatting to change.
 
I don't think I've ever seen the formatting change when I do this. What changed
for you?

You could do it cell by cell.
Select a cell
hit F2
hit F9
hit enter
Select the next cell
 
You must log in or register to reply here.

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

Break a link between workbooks when there is no "break" option 2
break link to email workbook 1
Cells act as if they are linked-link does not display in entry bar 1
break links not working 39
How to create absolue path link to another workbook (Excel 2003) 1
break links to other workbooks 4
Linking workbooks together 1
How do I link cells between to sheets in MS Excel? 3

Back
Top