Skip to main content

Excel Tips: Format > Format Cells

Alignment

How to align column of numbers by decimal point in Excel?

How to align dollar sign left in Excel?

How to align duplicates or matching values in two columns in Excel?

How to auto-center checkbox in cell in Excel?

How to center a picture in an Excel cell?

How to center text across cellls without merging in Excel?

How to center text across multiple cells in Excel?

How to force or auto line break within an Excel cell?

How to keep merged cells while inserting a new row in Excel sheet?

How to merge cells in a range formatted as table in Excel?

How to merge cells without centering the contents in Excel?

How to pad cells to a fixed length in Excel?

How to pad IP address with zero in Excel?

How to prevent cell content overflow in Excel?

How to prevent text from spilling over to next cell in Excel?

How to put multiple lines of text in one cell in Excel?

How to remove indents within cells in Excel?

How to rotate text and cell border to 45 degrees in Excel?

How to shrink text to fit a cell in Excel?

How to unmerge cells and fill with duplicate values in Excel?

How to wrap text by inserting carriage/hard return in cells in Excel?

Border

How to add all borders to cells with shortcuts in Excel?

How to add border line below when value changes in an Excel column?

How to add border to cells by using If statement in Excel?

How to add borders automatically to cells in Excel?

How to add horizontal borders only in specific range in Excel?

How to automatically create borders if a cell has contents in Excel?

How to border cells based on cell values in Excel?

How to border every 5/n rows in Excel?

How to change border color of active cell in Excel?

How to change border color of multiple cells in Excel?

How to design custom border style (thickness/width/diagonal) in Excel?

How to keep borders while sorting in Excel?

How to preserve grid lines while filling color in Excel?

How to quickly insert diagonal line in a cell?

How to rotate text and cell border to 45 degrees in Excel?