

Easy deploying in your enterprise or organization. Combine Workbooks and WorkSheets Merge Tables based on key columns Split Data into Multiple Sheets Batch Convert xls, xlsx and PDF.Super Filter (save and apply filter schemes to other sheets) Advanced Sort by month/week/day, frequency and more Special Filter by bold, italic.Extract Text, Add Text, Remove by Position, Remove Space Create and Print Paging Subtotals Convert Between Cells Content and Comments.


The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Kutools for Excel, with more than 300 handy functions, makes your jobs more easier.

If you have Kutools for Excel installed, you can enable its Reading Layout to across highlight the active cell for sticking out. Outstanding active cell with Kutools for Excel Tip: it will remove all border format of the sheet if you apply this macro code. Save the code, and now when you select a range, the range’s border color will be change to red. VBA: Change background color of active cell Private Sub Worksheet_SelectionChange(ByVal Target As Range)ģ. Double click at the sheet you want to use the code in the Project Explore pane, and paste below code to the Module script. Press Alt + F11 keys to open Microsoft Visual Basic for Applications window.Ģ. To change the filled color of active cell is a good choice to make it outstanding, but there is no built-in function to help you except macro code.ġ. Outstanding active cell with Kutools for Excel Change border color of active cell with VBA In this article, I will give you some tricks on changing border of the active cells for making it differ from others in Excel.Ĭhange border color of active cell with VBA But in some times, you want to change the border color of the active cell for more outstanding from others. In Excel, the border color of active cell or range are different from others as below screenshot shown.
