CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
user1592380
user1592380

Reputation: 36205

Adding header name to row columns with google sheets

enter image description here

Is it possible to change the column headers from A, B to lets say name , email ?Then you could take advantage of the native sorting capability of the spreadsheet.

Upvotes: 1

Views: 1284

Answers (1)

Josh
Josh

Reputation: 4322

Changing the letters assigned to the columns is not supported in Google Sheets (or Excel for that matter).

However, the behavior that you're describing can be easily achieved by using the "Freeze" functionality.

Simply add the column names that you want in the top row, then select the entire row (by clicking on the number 1 on the left side of the screen), and then click View > Freeze > 1 row.

You should now be able to sort the data in the columns without the header labels moving around.

Upvotes: 5

Related Questions