When you press CTRL+D in Excel 2007 or 2010 (and probably older versions), it makes an exact copy of the cell above it (modifying cell references, of course). In doing so, it copies everything else like font formatting, fills, and even borders (ugh). If I could just copy the value/forumula and just inherit the current cell's formatting, that'd be awesome.
An answerer has recommended I use a macro. Using their idea presented in their answer, I came up with this macro:
Unfortunately, I cannot use this. If I have anything stored in my clipboard, this macro will cause that data to be lost. I will still keep this here for anyone who's not bothered by that.
Sub ctrld() Dim scrup As Boolean scrup = Application.ScreenUpdating Application.ScreenUpdating = False Selection.Offset(-1, 0).Copy Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Application.ScreenUpdating = scrup End Sub
Unless anyone knows of a more native approach to this then that answerer will get the mark.