It can be useful to inspect a cell’s formula visually without having to click in it to display the formula in the formula bar. Excel’s FORMULATEXT function enables you to see the formula in another cell.
Excel General Tips
How to add, move, group and copy worksheets within and between Excel workbooks, and how to navigate between sheets in large multi-worksheet file, and how to hide and unhide worksheets.
How to add a data label to just one data point on a chart in Excel.
How to remove blank cells from a set of data so that a plotted line is continuous. Example shows blank cells being replaced by ‘N/A’ values using an IF statement.
Create a list of items which can be selected from a dropdown selector in a cell in Excel, using data validation
How to use Excel’s group and summarize data functions.
How to create a chart with multi-level categories and sub-categories.
How to add multiple rows or columns into an Excel spreadsheet
To equalise column widths or row heights in Excel, by selecting a range of columns/rows, and dragging a column/row divider.
To apply conditional formatting in Excel to non-adjacent, non-sequential cells.