Excel Pro Tips
How to Add a Column to a Table in Excel (6 Easy Ways)
Learn step-by-step methods to add a column to a table in Excel using the ribbon, context menu, shortcuts, or Power Query.
Read article
Excel Pro Tips
555 articles
Excel Pro Tips
How to Convert a Table to a Range in Excel (5 Easy Ways)
Learn how to convert a table to a range in Excel using Table Design, context menu, VBA, or by removing filters and formatting.
Read article
Excel Pro Tips
How to Sort Rows by Column in Excel (5 Effective Ways)
Learn how to sort rows by column in Excel using Sort & Filter, Sort dialog box, custom sorts, and the SORT function easily.
Read article
Excel Pro Tips
How to Create a Floating Text Box in Excel (6 Easy Methods)
Learn step-by-step methods to create a floating text box in Excel using the Insert tab, Shapes, VBA, ActiveX, and more.
Read article
Excel Pro Tips
How to Reverse a Text String in Excel (4 Suitable Ways)
Learn how to reverse a text string in Excel using formulas, VBA, and Power Query with step-by-step methods for all skill levels.
Read article
Excel Pro Tips
How to Auto Sort in Excel When Data Changes
Learn how to auto sort data in Excel using SORT, SORTBY, FILTER, INDEX, and VBA to keep your sheets organized automatically.
Read article
Excel Pro Tips
How to Do a Random Sort in Excel (7 Different Ways)
Learn how to do a random sort in Excel using RAND, RANDBETWEEN, SORTBY, RANDARRAY, and VBA for quick and easy data shuffling.
Read article
Excel Pro Tips
How to Do Advanced Sorting in Excel (4 Different Examples)
Learn how to use advanced sorting in Excel, including sorting by multiple columns, colors, custom lists, and custom value rules.
Read article
Excel Pro Tips
How to Translate Arabic to English in Excel (2 Easy Ways)
Learn how to translate Arabic to English in Excel using the TRANSLATE function and Microsoft Translator for quick, accurate results.
Read article
Excel Pro Tips
How to Set Permissions for a Shared Excel File
Learn how to set permissions for shared Excel files—limit edits, encrypt with passwords, and manage access in OneDrive easily.
Read article
![[Fixed] Excel Not Highlighting Cells in Formula](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-excel-not-highlighting-cells-in-formula-ce84ffe8.webp)
Excel Pro Tips
[Fixed] Excel Not Highlighting Cells in Formula
Fix Excel not highlighting cells in formulas with easy methods—enable editing in cells, use VBA, repair Office, or check F2 settings.
Read article
Excel Pro Tips
Conditional Formatting for Dates Older Than Today in Excel
Learn how to highlight dates older than today in Excel using the TODAY function or a VBA macro for automatic formatting.
Read article