How to Indent Text With Bullets in Excel. Microsoft Excel 2010 does not include a bullet button on the command ribbon. However, you can still create an indented, bulleted list using shortcut. Indentation consists of 'pushing' text to the left or the right without centering it. To visually indent the contents of a cell or of a group of cells, after making the selecting, on the Ribbon, click Home. Excel for the web doesn’t have the font orientation option for you to apply vertical text or rotate text in an angle. To express your interest in having this feature in Excel for the web, please go to the Visio Suggestion Box and click the Vote button. If your indent column actually has those dots in it, then your formula would have to be =REPT(' ',LEN(A2)-1)&B2 Of course, this formula would go in your first blank row.

Excel Indent Text Shortcut

• Points

  8

  Trophies

  1

  Posts

  2

  For those of you that know what an indented BOM is this will make perfect sense.

  
  

  Below is what I have tried and failed at, so it may not be possible to do what I want but I'm sure someone can come up with Plan B.

  
  

  e.g. C2 will have the formula: =IF(A2=2,F2,').....D2 will have the formula: =IF(A2=3,F3,')
  etc.
  So the issue is that the formulas keep the adjoining cells from displaying all of the F column info and will display only what fits into the cell.

  
  

  1. Is there a way for all of the information to display across cells with formulas...OR
  2. Using Example 2, below, is there a way to indent the information in the same column (B) by reading column A?

  1. Navigation
  2. OzGrid
  3. Forum
  4. Members
  5. Options
  6. Current Location
  This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.

  Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.

Excel Vba Indent Text

Excel Indent Vertical Text

How To Search For Text In Excel