![]() ![]() This will clear the clipboard and the range will no longer be highlighted with a dotted border around it. When you are done copying and pasting the range, you can press the Escape key. Notice that your selected range (B1:C6) still has a dotted border which means that the range is still in your clipboard and you can paste it again to another location in your spreadsheet. In this example, F1:G6 now contains a copy of the data and formatting from the range B1:C6. Now you should see the pasted range in the new location in your spreadsheet. To paste the range of cells, press CONTROL + V. You can also select the entire column by using Ctrl + Space shortcut. In this example, we have selected cell F1. To do this, select the starting cell where you would like to paste the range. Now you will need to select your destination. To select more than one column at a time, hold down Ctrl and. You will see a dotted border appear around the range of cells indicating that the cells are in the clipboard and ready to be pasted to another location in your spreadsheet. Click on the letter associated with the appropriate column to highlight all cells in the column. Now to copy the cells, press CONTROL + C. If you want to select an entire row, click on the row number. ![]() TIP: If you want to select an entire column, click on the column letter. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |