This excel tutorial reviews how to freeze rows in excel and freeze columns in excel using the python excel library OpenPyXL. I use Anaconda's Jupyter Lab interface to demonstrate this openpyxl tutorial. This technique is useful for improving data presentation in your spreadsheets.
😄 Please consider supporting this channel and making this content possible:
☕ https://www.buymeacoffee.com/DataAutomation
🅿 https://www.patreon.com/DataAutomation
00:00 :: Intro and workbook review
00:40 :: Accessing and reviewing freeze_panes
01:00 :: Freeze rows
01:42 :: Freeze columns
02:20 :: Freeze rows and columns
02:58 :: Overview
#PythonExcelTutorial #openpyxl #DataAutomation #python #pythontutorial #excel #pythonautomation #pythonprogramming #data #jupyterlab
