Upper and lower case versions of the same letter are treated as equal. By clicking the arrow at the end of the formula bar. The formula bar comes very handy when you are dealing with a pretty long formula and you want to view it entirely without overlaying the contents of the neighbor cells.
Enter data into any cell.
Move your cursor on the Highlight Cell Rules Option. Drag and drop the formula to the remaining cells to get the results. Kutools for Excel - Includes more than 300 handy tools for Excel. If you have Kutools for Excel installed its Work Area utility can help you quickly hide Status Bar Formula Bar or Ribbon easily in Excel and also enables you to restore the default Excel view immediately.