Which key is pressed to copy cell contents using drag and drop?

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel for iPad Excel for iPhone Excel for Android tablets Excel 2010 Excel 2007 Excel for Mac 2011 Excel for Android phones Excel Mobile Notes: • The shortcuts in this topic refer to the US keyboard layout. Keys for other layouts might not correspond exactly to the keys on a US keyboard. • A plus sign (+) in a shortcut means that you need to press multiple keys at the same time. • A comma sign (,) in a shortcut means that you need to press multiple keys in order. Notes: • To quickly find a shortcut in this article, you can use the Search. Press Ctrl+F, and then type your search words. • If an action that you use often does not have a shortcut key, you can record a macro to create one. For instructions, go to • Download our • Get the Excel 2016 keyboard shortcuts in a Word document: In this topic • • • • • • • • • • • • • Frequently used shortcuts This table lists the most frequently used shortcuts in Excel. To do this Press Close a workbook. Ctrl+W Open a workbook. Ctrl+O Go to the Home tab. Alt+H Save a workbook. Ctrl+S Copy selection. Ctrl+C Paste selection. Ctrl+V Undo recent action. Ctrl+Z Remove cell contents. Delete Choose a fill color. Alt+H, H Cut selection. Ctrl+X Go to the Insert tab. Alt+N Apply bold formatting. Ctrl+B Center align cell contents. Alt+H, A, C Go to the Page Layout tab. Alt+P...

You copy the entire cell when you Ctrl+Click on the cell, so it becomes a highlighted range selection. Then you can grab it anywhere (in Excel it has to be the border) and drag it to the destination. Drop moves the cell over the destination. Ctrl+Drop copies the cell over the destination. Alt+Drop moves the cell between two destination ranges, indicated by the mouse pointer. Ctrl+Alt+Drop copies the cell between two destination ranges, indicated by the mouse pointer. Villeroy wrote:You copy the entire cell when you Ctrl+Click on the cell, so it becomes a highlighted range selection.... Hi Villeroy, That doesn't work on the Mac because Ctrl click selects the right mouse button, so it just gives me the contextual menu for right click. Cmd click doesn't work either. Chris. Villeroy wrote:You can highlight a single cell with Shift+Arrow (select 2 cells) and then Shift+Opposite-Arrow (back to the one cell) or likewise with the mouse. But highlighting a cell isn't the problem - I can do that just by clicking on it. The problem is not being able to copy a cell by dragging with the mouse. Hi Keme, What you describe is the usual 'fill-down', but I want to copy a cell's contents from one location to another, and often between separated cells. In Windows Excel, you select the cell, hold down Ctrl, then drag and drop with the mouse to copy. But it doesn't work on the Mac, because Ctrl invokes right-click. Using Cmnd instead of Ctrl doesn't work, although I think that is what you have ...