Select the cells or range of which you want a picture taken.With the Camera tool in place, follow these steps to use it: It is near the bottom of the list of commands and looks-oddly enough-like a small camera. When you are doing your customizing, the Camera tool is available on the Commands tab in the Tools section. To use the Camera tool, you must customize your toolbar so that the tool is available it is not available by default.
![copy formatting shortcut not content copy formatting shortcut not content](http://tothepc.com/img/2010/04/copy-without-formatting.png)
Since the graphic is dynamic, whenever the source cells are changed (including formatting), the image is also updated to reflect the change. It is the image of the source cells that is shown, and it is shown as a graphic, not as the contents of any target cells. This has been covered in other issues of ExcelTips, but essentially the camera is a way to copy a dynamic image of a range of cells from one place to another. (There is no way to trigger an automatic event whenever formatting is changed.)Īn alternative to the macro approach is to use the Camera tool in Excel. In addition, the macro only runs if the contents of cell C7 are actually changed, not if the formatting alone of C7 is changed. First, it can be slow, particularly if you have quite a few cells that you want to copy in this manner. There are some downsides to this approach. If Not Intersect(Target, Range("C7")) Is Nothing Then Private Sub Worksheet_Change(ByVal Target As Excel.Range) When the change is in cell C7, then the contents of C7 are copied to cell E3 on Sheet1. For instance, the following macro will run every time there are changes in the worksheet.
![copy formatting shortcut not content copy formatting shortcut not content](https://spreadsheetpoint.com/wp-content/uploads/2020/05/Copy-conditional-formatting-by-using-Paint-Format.png)
First, you can create a macro that will find out whenever cell C7 changes, and if it does, the macro copies the contents of the cell (including formatting) to the target cell. There are two workarounds you can try, however. Unfortunately, there is no intrinsic way to do this in Excel. What if you are not just interested in copying cell values, but also want to copy formatting from one cell to another? This copies the contents from cell C7 to the current cell, and updates whenever the contents of cell C7 change. For instance, you could use the most simple of formulas in a cell: One of the foundational features of Excel is to allow one cell to be equal to another cell.