Walgreens began in 1901, with a drug store on the corner of Bowen Ave and Cottage Grove in Chicago, owned by Galesburg native Charles R. Walgreen, Sr. By 1913, Walgreens had grown to four stores on Chicago's South Side. It opened its fifth in 1915, and four more in 1916.
How to apply formula to entire column or row. Select D2 cell by using mouse. You will see rectangular black thick box. Place cursor right bottom corner of rectangular box. You will see cursor symbol changing to â+â symbol shown in below screenshot. Hold left click of mouse, drag mouse down to end of page. Now you have applied formula to every cell in the column. You need to drag towards right, to apply formula to entire row. Type any value in B3 and c3 cells, you will see answer in D3 cell. If you select D3 cell, you will see â=B3-C3â near fx.
5. Press Enter. Voila! Excel automatically fills all blank cells down your column with the same formula. If you want to switch back from a table to a simple range for some reason (I don't know any :)), select any cell in your table, then press the  Convert to range  button on the Design tab.. Select all the blank cells in a column. 2. Press F2 to edit the last selected cell and type some data: it can be text, a number, or a formula (e.g.  _unknown_ ). 3. Press Ctrl+Enter instead of Enter. All the selected cells will be filled with the data that you typed.