The Formula bar displays data and formulas for the current cell in Microsoft Excel. You can expand the formula editor if the data or formula does not fit and hide the formula bar if you need more screen space.
Column letters and Row numbers are principal features of Excel spreadsheets. Using Column letter and Row number, you can address any cell - the main element in Excel.
Excel for Microsoft 365 has changed the way to work with comments. Now you have two different features for commenting: comments and notes.
When you import data into Excel spreadsheets from Internet pages or CSV files, Excel fails to
recognize some numbers and converts them to the default text type. Temporarily changing Excel
settings helps to reduce the amount of manual work and the number of errors on replacing comma
to point, dot to comma, semicolon to comma, etc. Also, you need to change decimal delimiter
settings for printing or exporting data for international users.
Excel automatically creates hyperlinks if you type or insert some text that Excel sees like a hyperlink
such as URL or e-mail. You can quickly turn off and turn on the automatic creation of
hyperlinks for more comfortable work in Excel ☺.
When you work in Excel, by default, it automatically identifies all issues, such as incorrect data in the cell, problems with formulas, etc. So, you see green triangles (by default) shown in the top left corner of these cells.
Gridlines help you align shapes and create consistent dimensions for each object. In Excel, gridlines are
simulated by column borders, and changing column widths and heights essentially controls your gridlines.