Improve Your Excel.com Everything you need to improve your Excel in one place! Home Categories Tips By Email Search Contact Us Other Links Your Questions Answered

Adding Borders to Cells Automatic Lines for Dividing Lists Automatic Row Height For Merged Cells with Text Wrap Changing the Color of a Cell Border Drawing Borders Hiding and Unhiding Rows Hiding Rows Based on Two Values Removing Borders Setting Row Height Add a fancy line for Presentation Add special symbols to the number format Adding Euro format to the number format in Microsoft Excel Adding special symbols to the number format in Microsoft Excel Alternate row shading using Conditional Formatting Applying Colors to Maximum/Minimum Values in a List Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel Automatically Copying Formatting Bitwise Logical Functions Calculating using significant digits Change the cell formatted from date format to number format in Microsoft Excel Change the color of worksheet tabs Changing the Cell Formatting from Date to Number Changing the default cell comment formatting Changing the Default Style Color numbers based on the value result in Microsoft Excel Coloring Even Numbered Rows in a List Coloring Numbers Based on Specific Criteria Coloring Rows Based on Text Criteria Converting UNIX timestamps to XL date/times Copying Formatting Copying Styles from One Workbook to Another Create styles directly from cells in Microsoft Excel Creating and Saving Custom Styles Customizing Date Formatting Display text in multiple lines Displaying Figures in Financial Reports Rounded to Thousands Duplicate repeated entries in a list Fix incorrect decimal places during data entry Format even numbers Format number in joining text with linked number in Microsoft Excel Formatting a Negative Number with Parentheses Hiding the Display of Zero Values Increase the number of rows or columns? Inserting Special Symbols into Custom Formats Number of Pages, using XL4M commands Removing or avoiding automatic hyperlinks Replacing Zeros with Dashes in Number Formatting Rounding Numbers to Millions Rounding Numbers to Millions with Thousands as a Decimal Rounding Numbers to Thousands Rounding Numbers to Thousands with Hundreds as a Decimal Sampling from a range Save time formatting in Excel with custom styles Summing every Nth column or row Symbols Used to Create Custom Formatting Three-dimensional SUMIF()s Use the format painter to copy column widths and row heights in Microsoft Excel Using conditional formatting Using Copy and Paste for Formatting Using SUMPRODUCT() to calculate variable rates and commissions Using the Round Function to Round Numbers to Thousands Working with fractions Worksheet and Workbook names using the CELL() function

Want more tips? Subscribe to our Free Newsletter today and we will send them to you.

Most Popular Categories |Bar_Charts |Charts |Pie_Charts |Excel Counting |Excel Filters |Pivot_Tables |Excel_Keyboard_Shortcuts |Conditional_Formating |VLookup |Games |Names_and_ranges |VBA_Examples |Macros

website stats online web site counter