By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

 


Formatting

Formatting introduction

Some Formatting:
  • Bullets like in this list
  • Color - Fill, Font
  • Size
  • Table/Borders - Striped tables
  • Alignment
  • Wrap Text
  • Orientation
  • Shrink to fit
  • Merged cells
  • Hidden/Visible
  • Number formats ($1,009.25 ; 2329 ; 09928; ...
  • Date Value
  • Formatting Ribbon/menu
  • Bold/Italic/Underline
  • Font
  • Pictures
  • HTML or CSS
  • Background
  • Header verses details
  • Sorting or filters
  • Convert #N/A to a space

    Display certain columns




    Add borders




    Format New Columns

    I've added new columns to a sheet and now want to do something with the formatting
  • Fix the widths
  • Wrap the text
  • Add Borders




    Hide Columns

    Typically recorded code.

    Columns("A:A").Select
    Selection.EntireColumn.Hidden = True
    Columns("AO:AO").ColumnWidth = 26.86
    ' Borders

    MergeCells



    FixWidthWhenMergedCell

    • blog comments powered by Disqus