I’m entering a bunch of data into an Excell spreadsheet, and I have two questions:
-
I want the data within each row of the spreadsheet to remain constant, even if, by accident, I select a single column and then hit the “sort” button. I want to be able to move and sort whole rows, and I may want to move or insert whole columns. But I want to prevent any rearrangement of values within a single column or a single row. How do I do this?
-
I want to replace the letters at the top of each row with column titles. I’ve found out how to name columns, but those names appear only in the “names” box, and they only appear if I select the whole column. How do I replace the heading “A”, for example, of the first row, with a descriptive title, like “Date of sample collection,” or some such thing? I want to be able to see this title every time I look at the spreadsheet, so I can minimize my risk of entering the wrong data in the wrong cell.
I’ve already consulted the Excell Office Assistant help thingie, and it’s been very little help at all. I’d appreciate any tips or info you could give me. Thanks.