How can i lock the cells in a row across columns so i can sort by product without mixing up price in excel? - retail product number
I have a 5-column Excel spreadsheet with the cell phone manufacturer, model number, the entire sale price, sale price and quantity in stock.
Should one or another model, the price for retail or manufacturer, with information in all cells of each line to travel to solve together. Is it possible to do this?
Monday, February 1, 2010
Retail Product Number How Can I Lock The Cells In A Row Across Columns So I Can Sort By Product Without Mixing Up Price In Excel?
Subscribe to:
Post Comments (Atom)
2 comments:
Sure. Select the entire data block, the five pillars. Then select "Data" | "Tri" in the menu bar.
Study carefully the options and select the column you for your kind of key. Note you say that Excel is that the first row contains column headings, you can (if not).
Try the first response to print! In fact, always make a backup before starting this kind of manipulation.
Sure. Select the entire data block, the five pillars. Then select "Data" | "Tri" in the menu bar.
Study carefully the options and select the column you for your kind of key. Note you say that Excel is that the first row contains column headings, you can (if not).
Try the first response to print! In fact, always make a backup before starting this kind of manipulation.
Post a Comment