Ask Your Question
2

how to make a scrolling spreadsheet with a set title row?? [closed]

asked 2012-09-25 14:25:42 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi, excuse my lack of technical vocabulary, I am quite new to spreadsheets and don't even know what terms to use...

Basically I would like to make a spreadsheet with a top row (indicating titles for information in each column) which does not vanish when I scroll down along the document.

For example:

Let's say the top row consists of titles at the top of each column indicating types of expenses: food, lodging, transport. And each row below the top row has a different figure for each corresponding column.

I'd like to make it so when i scroll down the spreadsheet the topmost row, the one with the titles FOOD LODGING TRANSPORT remains at the top of the screen, in view, so I can enter new data without having to continually scroll to the top in order to remember what each column represents.

Make sense? I hope so! Any advice appreciated!!!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 03:16:13.620344

3 Answers

Sort by » oldest newest most voted
3

answered 2012-09-25 14:59:59 +0100

JohnSUN gravatar image

Usually causes difficulties selection of cell about which the frozen region. In fact, it's simple: you need to specify the cell below and right of assigned titles.

Animated gif from <a href=http://myooo.ru/content/view/201/112/">

edit flag offensive delete link more
1

answered 2012-09-25 14:41:45 +0100

Timon gravatar image

http://wiki.documentfoundation.org/images/6/6d/0300CG3-CalcGuideLibO3.pdf See page 34 Freezing rows and columns. Choose Window - Freeze.

edit flag offensive delete link more
0

answered 2012-09-26 22:55:03 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

thanks! i figured it was something obvious ;)

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-09-25 14:25:42 +0100

Seen: 22,707 times

Last updated: Sep 26 '12