Shopko (formerly ShopKo until June 2007) is a chain of retail stores based in Ashwaubenon, Wisconsin. Shopko was founded in 1962 by James Ruben, and its first store opened in Green Bay. From 1991 to 2005, the company was publicly held, with stock traded on the New York Stock Exchange under the symbol SKO.
I can freeze either the top row or the first column but not both. Tried selecting both, etc. to no avail. Instead of selecting the entire row and column you need only to select the cell, so for example select B2 and select freeze panes and row 2 will be frozen and column A will be frozen.
Click the row number located just under the last row you want to lock. Excel only allows you to lock the top rows of a spreadsheet, so everything above your selected row will become locked in place. Click the View tab at the top of the screen. Click the Freeze Panes button in the Window area of the ribbon. Click the Freeze Panes button that then appears in a pop-up menu. Select the column letter or row number that corresponds to the information you want to alphabetize. Click the Data tab at the top of the screen, then click the Sort button. Click OK on the sort window and your information will be sorted.