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.
tip to copy data down all available cells in the column select the first cell press ctrl c click the column header to select the entire column and then press ctrl v however doing so forces excel to replicate a massive number of calculations so expect heavy delays when using complex formulaslick the first cell again to select it double click the cell s fill handle indicated by a small square at the lower right corner of the selected cell to automatically fill data down the entire column copying stops when excel reaches the end of the data column assuming no gaps in the data exist