Did you know that the copy and paste feature in Excel has multiple options? For example, you can copy just formulas or formatting.
Let’s say you have a column of dates and you have it formatted just the way you want. You want to copy this formatting over to another column. Highlight the column that contains the correct formatting and right click and select copy. Highlight the column that has the dates you want to mirror the first column. Right click and select paste special. Select the radio button next to Formats. This will copy over the column width, the date formats, and any other formatting.
What if you want to copy cell values? Let’s say you have a column of data that contains formulas. You can perform the same steps, but when you select paste special, select values.
Note: I highly recommend using this function to copy values over formulas in large documents, especially if there will be a lot of movement of data back and forth. Sometimes formulas can get lost in the shuffle.
We love feedback from our customers and implement suggestions often. What shortcut do you use the most? If you have a question or idea for a Microsoft Windows or Excel tip that you would like to see, let me know and I might write about it!