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. How to freeze a row in excel ? This can be done easily in Google Docs Spreadsheet.

Login to Google Docs.

Open any spreadsheet/excel sheet.

Go to View Menu. Here you can find freeze option in excel.

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. Once you freeze header in excel, you can easily navigate rest of the sheet without losing track of headers. Its very easy to freeze panes in excel.


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