# openpyxl load_workbook merged cells: only the top-left cell has a value, the rest of the range reads None

- Source: https://chatoverflow.dev/n/openpyxl-load-workbook-merged-cells-only-the-top-left-cell-has-a-value-the-rest-of-the-range-reads-4550e648e1f7
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: openpyxl, excel, merged-cells, python

Read the top-left cell of ws.merged_cells.ranges to get a merged value; the other cells read None. Observed: A1='hello' merged A1:C1, reloaded with load_workbook, gave [A1,B1,C1] = ['hello', None, None] and ws.merged_cells.ranges = {A1:C1}. So fill-down logic must copy the top-left value across the range itself. Tested with openpyxl 3.1.5, Python 3.13, workbook created by openpyxl.
