Skip to main content

Excel Tips: Edit > Copy and Paste

Copy with Criteria

How to copy cells if column contains specific value/text in Excel?

How to copy column based on cell value to another sheet?

How to copy row to another sheet based on cell value in Google sheet?

How to copy rows and paste to another sheet based on date in Excel?

How to copy rows if column contains specific text/value in Excel?

How to copy rows to new sheet based on column criteria in Excel?

How to duplicate rows based on cell value in a column?

Copy with Formulas

How to copy cell as text value not formula in Excel?

How to copy cell formula only not formatting in Excel?

How to copy formulas and paste to other worksheet as text in Excel?

How to copy formulas from one workbook to another without link?

How to copy numbers or values without formulas in Excel?

How to keep formula and formatting when copying and pasting in Excel?

How to paste all except formulas in Excel?

Others

How to auto copy and paste cell in current sheet or from one sheet to another in Excel?

How to copy a selected range to a new workbook in Excel?

How to copy and paste merged cells to single cells in Excel?

How to copy and paste only non-blank cells in Excel?

How to copy and paste skip blank cells in Excel?

How to copy and paste without borders in Excel?

How to copy cell without new line break in Excel?

How to copy current cell address to other location in Excel?

How to copy Excel page setup to other worksheets in Excel?

How to copy hyperlink only from one cell to another in Excel?

How to copy one chart format to others in Excel?

How to copy only visible cells in Excel?

How to copy row and column headings in Excel?

How to copy subtotals only in Excel?

How to copy sum of selected cells only in Excel?

How to copy text from message box in Excel?

How to disable cut, copy and paste functions in Excel?

How to loop through files in a directory and copy data into a master sheet in Excel?

How to paste data in alternate blank rows in Excel?

How to paste excel table to word and make table content fit to page?

How to paste external content to Excel always match destination formatting?

How to paste range into one cell in Excel?

How to prevent copy and paste over cell with drop down list in Excel?

How to quickly swap contents of two cells in Excel?

How to reorder position of columns in table in Excel?

How to restrict to paste values only (prevent formatting) in Excel?

How to set paste values as default paste when using Ctrl + V in Excel?

How to shift down cells and paste copied values in Excel?

How to swap rows or columns in Excel?