Is there a keyboard shortcut to center data in a cell?

Record a macro to do the cnte and assign it a shortcut key.

Start recording (Tools, Macros, Record New Macro)
Give it a meaningful name (e.g. CentreText)
Select your letter of choice (I use "e") and put that in the Shortcut Key field.
Ensure macro is being recoprded in your "Personal Wookbook" to make it available in all workbooks.
Click OK to start recording.

Click the toolbar button to cente text.

Stop recording (Tools, Macro, Stop Recording)

Now you need to edit the recorded macro to remove any reference to the cell you centred during the recording.

You may need to "unhide" the personal wookbook (Window, Unhide) first.

To edit the macro ...
Tools, Macro, Macros.
Select your macro and click Edit.

Make your macro look something like this ...

With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.ShrinkToFit = False
.MergeCells = False
End With

... and then quit (File, Quit).

Re-hide your Personal workbook (Windows, Hide)

Close Excel and you will be prompted to save your Personal Workbook - do so.


Now to centre text, just press CTRL and whatever letter you chose above (I used "e").