Solution: Select the upper-left cell instead of the whole range before you paste.Ĭlick the cell where you want the upper-left cell of the copied data to appear. Repeat step 2 until you have inserted the number of columns that you want.Ĭause: The Copy area and the Paste area are not the same size and shape. The column that you originally selected shifts to the right and the new column appears. 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |