The dot operator is a versatile addition to Excel’s formula toolkit, allowing you to dynamically trim unused cells—whether at the beginning, end, or both—within your data ranges.

How to create data bars in Excel 1. Select the cells you want to apply the data bars to. You can select a single cell, a range of cells, a table, or the entire sheet. 2.