Log in
x
or
x
x
Register
x

or

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?

Fill Color

How to alternate row color based on group in Excel?

How to apply color banded rows or columns in Excel?

How to apply color gradient across multiple cells?

How to apply shading to odd or even (alternative) rows/columns in Excel?

How to automatically color alternating rows/columns in Excel?

How to compare two columns and highlight the unmatched data in Excel?

How to compare two columns and highlight when found in another column?

How to compare two columns for (highlighting) missing values in Excel?

How to determine and identify the background color index of cells in Excel?

How to format cell to look like a 3D button in Excel?

How to half shade cell in Excel?

How to make cell flash red in Excel?

How to mark duplicate values with color in Excel?

How to randomly add background/fill color for cells in Excel?

How to remove fill color from cells in Excel?

How to select and highlight diagonal cells in Excel?

How to select and highlight row differences in Excel?

How to set cell color equal to another cell color in Excel?

Font

How to add or remove strikethrough in Excel?

How to auto strikethrough based on cell value in Excel?

How to bold all specific words in a range of cells?

How to bold only the first line or first word in cell in Excel?

How to bold part of text string in a cell in Excel?

How to bold part text when concatenate two columns in Excel?

How to bold text in checkbox in Excel?

How To Change Background Or Font Color Based On Cell Value In Excel?

How to change cell color when cell is clicked or selected in Excel?

How to change color if two cells are not equal in Excel?

How to change default font in Excel?

How to change font color based on cell value in Excel?

How to change font color for part of text in cell in Excel?

How to change the strikethrough color without changing the color of the text in Excel?

How to color duplicate values or duplicate rows in Excel?

How to color or highlight certain word in cells in Excel?

How to compare two strings for similarity or highlight differences in Excel?

How to format part text as superscript or subscript within a cell?

How to format single character in selected cell in Excel?

How to format text as subscript in Excel 2007/2010?

How to format text as superscripts in Excel 2007/2010?

How to increase or decrease the font size with shortcut key in Excel?

How to make cells bold if greater than certain number in Excel?

How to prevent hyperlinks from changing color in Excel?

How to subscript all numbers in chemical formulas in Excel?

How to use multiple font colors or fonts in one cell in Excel?

Number

Apply Date Formatting

How to change American date format in Excel?

How to change multiple dates to day of week in excel?

How to convert between date and Unix timestamp in Excel?

How to convert between Julian date and calendar date in Excel?

How to convert date from dot to slash format in Excel?

How to convert date to different or specific format in Excel?

How to convert date to number string or text format in Excel?

How to convert date to ordinal date format in Excel?

How to convert date to serial number in Excel?

How to convert date to weekday, month, quarter or year in Excel?

How to convert date to weekday, month, year name or number in Excel?

How to convert date to yyyy-mm-dd format in Excel?

How to convert date/time format cell to date only in Excel?

How to convert dD.MM.YYYY to date format (mM/DD/YYYY) in Excel?

How to convert dd/mm/yyyy to mm/dd/yyyy in Excel cells?

How to convert serial number to date in Excel?

How to convert various non-standard date formats to standard date in Excel?

How to display or show year of date only in Excel?

How to format date to show abbreviated day of week or month in Excel?

How to format dates to uppercase months in Excel?

How to quickly convert date format between European and US in Excel?

How to quickly convert Euro date format to US date in Excel?

How to quickly convert mm/dd/yyyy date format to yyyymmdd in Excel?

How to remove year from date in Excel?

How to return day of the week from date in Excel?

How to swap or reverse day and month of date in Excel?

Apply Time Formatting

How to convert dd hh mm time format to hours or minutes in Excel?

How to convert decimal hours/minutes to time format in Excel?

How to convert military time to standard time in Excel?

How to convert milliseconds to time in Excel?

How to convert time format from 12 hour to 24 hour and vice versa in Excel?

How to display time in minutes format only in Excel?

How to show time with milliseconds in Excel?

Custom Format

How to format axis labels as thousands/millions in Excel?

How to format cell so leading zeros don’t disappear in Excel?

How to format mac addresses in cells by adding colon symbol in Excel?

How to format number as ordinal (1st 2nd 3rd ) in Excel?

How To Format Numbers In Thousands, Million Or Billions In Excel?

How to format phone number with extension in Excel?

How to make all negative numbers in red in Excel?

How to move the decimal point to left in Excel?

How to remove leading zeros before decimal point in Excel?

How to save and apply custom number formats in Excel?

Percentage

How to add percentage symbol for multiple numbers in cells in Excel?

How to format a textbox as a percentage in Excel?

How to format chart axis to percentage in Excel?

Others

How to abbreviate numbers in Excel?

How to automatically insert a decimal point to number in Excel?

How to convert between fraction and decimal in Excel?

How to convert number format between European and US in Excel?

How to convert scientific notation to x10 format in Excel?

How to convert the phone number format to digits in Excel?

How to display negative numbers in brackets in Excel?

How to format a textbox as currency in Excel?

How to format data table numbers in chart in Excel?

How to move dollar sign closer number in Excel?

How to remove all zeros after decimal in Excel?

Others

How to keep cell formatting while referencing other sheet cells?

How to keep formatting when sorting data in Excel?

How to use shortcut to quickly format cells as number/text/general or other format in Excel?