• Skip to main content
  • Skip to primary sidebar

Excel Tips and Tricks

  • About
  • Privacy Policy

Always Keep headings visible in Google Spreadsheet

August 24, 2011 by Ravi 1 Comment

When you are working with lot of data in a Spreadsheet, the headings would disappear when you start scrolling down the rows. Google Docs Spreadsheet provides users with the option for keeping the headings always visible even when you scroll down the Sheet. This can be done by using the menu option available as part of the View menu. To explain, let us take the take following sample data

Now when the users scroll down below Row no 26, the heading rows would disappear as shown below.

And it will be difficult for the users to find out the column under which the values fall. This problem can be addressed using the Freeze rows feature. Navigate to View menu then Freeze rows and select Freeze 1 row menu option.

This would always Keep the heading rows always visible in a Google Docs Spreadsheet.

Filed Under: Excel, Technical Tagged With: Freeze rows, Google Docs, Headings, Rows, spreadsheet, Visible

Reader Interactions

Comments

  1. Jean says

    October 17, 2014 at 3:30 pm

    Thank you. That helped!

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • How to increase number of worksheets Excel
  • A trick to flip a column upside down in Excel
  • Prevent users from adding new worksheet in Excel
  • Repeat action keyboard shortcut in Microsoft Office
  • How to import text file in Excel

Copyright 2020 © getexceltips.com