Share via

How to add "Center Across Section" to Quick Access or Ribbon for adequate key strokes (Financial Modeling)

Anonymous
2023-07-17T15:24:55+00:00

As most in the financial modeling/investment banking/pe understand it is best practice to never use Merge & Center but rather "Center Across Section" which causes frustration provided you can't add Center Across Section to the ribbon or quick access toolbar and the keystroke "Alt FA tab tab down down down down down enter" is obnoxious. Can anyone tell me a work around to add this somewhere to have it get added to Quick Access? Or have Microsoft make the enhancement? Thanks!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-07-17T16:03:22+00:00

    That is exactly what the modeling industry is trying to avoid. We do not want to Merge cells. That is why it has to be "Center Across Section"

    6 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-07-17T15:56:42+00:00

    Thanks for the note, but that seems like a more complicated solution when there is an entire industry waiting for there to be a more applicable solution. If it's the only option I would definitely consider.

    5 people found this answer helpful.
    0 comments
  3. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-07-17T15:46:59+00:00

    You might create the following macro in your Personal Macro Workbook PERSONAL.XLSB:

    Sub CAS()
    On Error Resume Next
    Selection.HorizontalAlignment = xlHAlignCenterAcrossSelection
End Sub

    You can assign it to a Quick Access Toolbar button and/or a convenient keyboard shortcut.

    See Excel Personal Macro Workbook | Save & Use Macros in All Workbooks

    4 people found this answer helpful.
    0 comments
  4. Anonymous
    2023-07-17T16:16:34+00:00

    2 people found this answer helpful.
    0 comments
  5. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more