Techniques to present a dynamic formula bar in a spreadsheet

A computer-implemented method, comprising:

• presenting on a display, by a processor circuit, a grid comprising cells arranged in rows and columns;
• receiving a control directive selecting a first cell in a row from the presented grid;
• displaying in response to the received control directive, a formula bar user interface (UI) element in a row other than the row of the first cell and within the presented grid, wherein the formula bar UI element further performs at least one of displaying content of the first cell or accepts input to the first cell;
• displaying a visual indicator forming a connection between the formula bar UI element and the row of the first cell to indicate the formula bar UI element is to display the content for the first cell;
• and
• accepting input to the first cell from the formula bar UI element.

Computer-readable storage hardware comprising a tangible medium to store instructions that, when executed, cause a system to:

• present, on a display, a grid comprising cells arranged in rows and columns;
• receive a control directive selecting a first cell from the grid;
• insert a row into the grid and display a formula bar user interface (UI) element within the inserted row of the grid in response to receiving the control directive selecting the first cell, wherein the formula bar UI element further performs at least one of displaying content of the first cell or accepts input to the first cell;
• accept input to the first cell from an entry field in the formula bar UI element;
• and
• move the formula bar UI element upon commitment of the input to the first cell such that the formula bar UI element remains within the grid.