B2B (business-to-business) On the Internet, B2B (business-to-business), also known as e-biz, is the exchange of products, services or information (aka e-commerce) between businesses, rather than between businesses and consumers. Download this free guide.
You can freeze rows and columns in your spreadsheet. To do so, select the cell above which and to the left of which you want to freeze the columns and rows. Click the View tab.Click Freeze Panes in the Window section of the View tab and select Freeze Panes from the drop-down menu.OTE: Frozen rows and/or columns are indicated by a thin black border. To allow the frozen rows and columns to move again, click Freeze Panes in the Window section of the View tab and select Unfreeze Panes. You can also just freeze rows or columns.
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.