Methods and systems for providing selective multi-way replication and atomization of cell blocks and other elements in spreadsheets and presentations

A non-transitory computer readable medium loaded with instructions, that when executed on a processor, cause the processor to implement actions of copying a grid layout of multiple cells in a spreadsheet to cells onto a page or slide, collectively page, in a document or deck, collectively document, then separating and rearranging individual copied cells, the actions including:

• copying the grid layout of positions and content of multiple spreadsheet cells from the spreadsheet to an initial layout of cells on the page in the document, wherein at least some of the cells hold formulas,
• including linking individual cells in the initial layout to the spreadsheet cells in the grid layout and separating cells in the initial layout to allow rearrangement and reformatting of the individual cells into different positions and sizes on the page than in the grid layout, without changing the grid layout of the linked cells in the spreadsheet;
• and
• responsive to user commands to rearrange and reformat selected individual cells that are a proper subset of the initial layout of cells on the page, rearranging and reformatting the selected individual cells to positions and sizes on the page moved away and separated from non-selected cells remaining in the initial layout in a grid, while maintaining the linking of content of the rearranged individual cells to non-rearranged cells in the spreadsheet.