Merge - Unmerge

I have received a large treasures report that i have to plough through, but
there are merged cells. is there s quick way to unmerge these cells instead
of trawling through the whole file?

Yes
Just select all the cells (Ctrl A)

then format cells alignment untick the merge cells box which will probably be gray

Regards

Dav