For those who need their documents always online and accessible everywhere then “Google Docs” is the best solution for them.

And creating and using spreadsheets or excel files is very easy in Google Docs.

Sometimes we need a spreadsheet/excel sheet with fixed header row. This can be done easily in Google Docs Spreadsheet.

Login to Google Docs.

Open any spreadsheet/excel sheet.

Go to View Menu.

Then to Freeze Rows.

Then Select Freeze 1 Row.

Checkout following image for more details…

Google Docs Spreadsheet Freeze 1st Row, Fixed Row Header
Google Docs Spreadsheet Freeze 1st Row, Fixed Row Header

Hope your problem of how to make a fixed header in excel will be solved by above solution.


Get latest blog posts in your Mail ! Don't worry, I won't spam your Inbox, I hate spams too ! ! !