Click on the cell with the text/formula to copy Shift+Click on the last cell to copy to Ctrl + Enter (or CMD + Enter on Mac.)