Ask Your Question
0

Is there a way to freeze columns?

asked 2016-12-27 17:20:28 +0200

pirate russell gravatar image

updated 2016-12-27 17:21:16 +0200

I want to have two sets of figures on the same sheet. I only want to scroll up/down on one set, or the other, at a time. Can Calc do this?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2018-05-08 20:53:57 +0200

nobody_special gravatar image

Freeze rows and columns is not the same as split screen. To Freeze a column, click the column to the right of the columns you want frozen, Then "Window - Freeze Rows and Columns" does the trick.

edit flag offensive delete link more
0

answered 2016-12-27 18:57:48 +0200

oldgoatroper gravatar image

updated 2016-12-27 18:59:48 +0200

In my own testing just now, this will work using split screen, if your two sets of figures are above and below each other and not beside each other.

Navigate to the row where you want to split the screen and click on the left-most cell, then click the Split Screen button on the button bar OR click Window on the menu bar at the top and select Split Screen.

Now your work area will be split horizontally and you will be able to scroll each section (upper and lower) independently.

I know that doesn't quite do what you are asking for, but might do the trick if repositioning your figures is not a big deal.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-12-27 17:20:28 +0200

Seen: 470 times

Last updated: May 08 '18