HOW TO ADD BORDERS IN EXCEL 2011 MAC HOW TO

The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by Now borders are added to the cells in column C which are larger than 250000.įrom now on, borders will be moved with cells while sorting.

For example, to format the cells in column A contain apple, you can use this formula =$A1=”apple”ģ. You can change the formula to meet your own need. Then click Format to open the Format Cells dialog, under Border tab, select Outline choice. In the New Formatting Rule dialog, select Use a formula to determine which cells to format from Select a Rule Type section, then type this formula =$C1>250000to the Format values where this formula is true. Select the data range, then click Home > Conditional Formatting > New Rule.Ģ. To keep the borders or other formatting with cell contents when sort, you can add the formatting by using the Conditional Formatting function.ġ. Keep borders while sorting by using Conditional Formatting How can you keep the borders with cell contents while sorting in Excel? But when you sorting the data, the borders will stay on the same position instead of sorting with the cell contents as below screenshot shown. In some times, you may add borders around the cells which contains specific contents for outstanding them in Excel sheet.

HOW TO ADD BORDERS IN EXCEL 2011 MAC HOW TO

How to keep borders while sorting in Excel?

How to add borders in excel 2011 mac