|keyboard shortcut to copy format in excel||1.5||1||4746||66|
Copy and Paste Data in Excel With Shortcut Keys Click a cell or multiple cells to highlight them. Press and hold down the Ctrl key on the keyboard. Press and release the C key without releasing the Ctrl key. A moving border (sometimes called marching ants) will surround the selected cell (s). More items...How do you copy only formatting in Excel?
In Excel, you can copy cells' formatting only with the Format Painter tool. 1. Select a range which contains the cells' format you want to copy. See screenshot: 2. Applying Format Painter by clicking it under the Home tab, see screenshot: 3. Select a blank cell and click it, only the cells' formatting is pasted.