ChemEng stuff followers

Monday, September 8, 2025

Key Excel features into Python add-in

 In this post, two very common features of Excel are tested within an add-in for Python from Anaconda. These features are:

  • cell fixing with $ and
  • repeated calculation by the drag and drop function of Excel.



For short, you should relax since YES, these two features are actually available in the Python add-in from Anaconda. In other words, you may use the $ to fix cells so that some data remains constant within a formula. See for reference the image below,



Also, if you inserted your code in a given cell, say B9, for example, you can drag and drop from that cell so that other cells fill in with the same formula while some cells remain fixed, just like B4, B5 and B8.



I hope you find this post helpful.

No comments:

Post a Comment

Most popular posts