Professor Excel

Comments 4

  1. Sorujsiri

    I have a problem to “paste link” in excel (office 2019). The same file can use paste link in office 2013.

    • Henrik Schiffner

      Hi Sorujsiri,
      Not sure if I understand your question. Can you describe your problem?

  2. ExcelPro

    Thanks for your tip! I appreciate your post. A note on deleting zeroes: I, too, like zeroes to be deleted but some cells were already zero before I copied and pasted the link (zero growth for certain rows) and by deleting zeroes you also may be deleting what you may need to show to your colleagues. So my recommendation is to go line-by-line to delete what you do not need.

    • Henrik Schiffner

      Thanks, ExcelPro, for the comment. Yes, fully agree – often selecting zeroes manually line by line is not only the safest way but also the fastest way.

Leave a comment

%d bloggers like this: