Insert additional columnsĬlick the column heading (A, B, C, and so on) for the column to the right of where you want to add a column. Solution: Insert more columns, and then try pasting again. On the Home tab, click the Number Format menu.Ĭlick the cell format that matches the information that you are trying to paste into the column.Ĭause: There are not enough columns to accept the information that you're trying to paste. Change the cell format for a columnĬlick the column heading (A, B, C, and so on) for the column that you want to change. Solution: If you're trying to paste a large amount of information, make sure that the cell format for the cells in the column matches the format of the information that you want to paste, and then paste the information one column at a time. Less Cause: The information that you are trying to paste does not match the cell format (Date, Currency, Text, or other format) for the cells in the column. Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac Excel for Mac 2011 More.
