Excel Guides

Inserting Different Dashes in Excel

There are four different dashes that can be inserted into an Excel document:

  1. En Dash: Used to indicate a range of values, such as numbers or dates. For example, "January 1–February 28" or "Pages 12–42." To insert an en dash, press Ctrl+- (minus sign).
  2. Em Dash: Can be used in place of commas, parentheses, or colons for added emphasis or to join independent clauses. For example, "I'm not going—you can't make me!" To insert an em dash, press Ctrl+Alt+- (minus sign).
  3. Hyphen: Used to join words or parts of words. For example, "left-handed" or "e-mail." To insert a hyphen, press Ctrl+[hyphen]
  4. .
  5. Horizontal Bar / Pipe / Broken Bar: A vertical bar used in place of the em dash for added emphasis or to join independent clauses. For example, "I'm not going | you can't make me!" To insert a horizontal bar, press Ctrl+]bar]
  6. .

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.