On the “Go To Special” dialog box, select “Blanks” and click “OK.”Īll the cells in the selection that are not blank are de-selected, leaving only the blank cells selected. In the “Cells” section of the “Home” tab, click “Delete” and then select “Delete Sheet Rows” from the drop-down menu.Īll the blank rows are removed, and the remaining rows are now contiguous. Be sure to include the row just above the first blank row and the row just below the last blank row.Ĭlick “Find & Select” in the “Editing” section of the “Home” tab and select “Go To Special…” on the drop-down menu. Highlight the area of your spreadsheet in which you want to delete the blank rows. Deleting blank columns is a similar process that we’ll show you later in this article.
Paste the width of one column or range of columns to another column or range of columns.Ĭombine conditional formatting from the copied cells with conditional formatting present in the paste area. When you paste a link to the data that you copied, Excel enters an absolute reference to the copied cell or range of cells in the new location.Ī copy of the image with a link to the original cells (if you make any changes to the original cells those changes are reflected in the pasted image). Link the pasted data to the original data. Only the values and number color and font size formatting.Īll cell formatting, including number and source formatting. Only the values as displayed in the cells. Data in rows is pasted into columns and vice versa.
Reorients the content of copied cells when pasting. Only formulas and number formatting options.Īll cell contents and formatting except cell borders. The options on the Paste menu will depend on the type of data in the selected cells:Īll cell contents and formatting, including linked data. On the Home tab, click the arrow next to Paste, and then do any of the following. Select the cells that contain the data or other attributes that you want to copy.Ĭlick the first cell in the area where you want to paste what you copied.