We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

skipping columns when frozen area [closed]

asked 2012-09-14 06:05:42 +0200

anonymous user


updated 2020-07-13 19:55:16 +0200

Alex Kemp gravatar image

I have a spread sheet A B C D E F G H I J 1 2 3 4 5 6 7 8 9 10 I freeze columns A, B, C now I scroll the information so I get A B C G H I J 1 2 3 7 8 9 10

This is what I would like to print but a print preview results in the first form (all columns.) Is there way the view of A B C G H I J and not showing D F G

Thank you

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 02:19:51.172920

1 Answer

Sort by » oldest newest most voted

answered 2012-09-14 09:05:49 +0200

m.a.riosv gravatar image

Menu/Format/Print ranges is where to define the range to print, rows and columns to repeat.

image description

edit flag offensive delete link more

Question Tools


Asked: 2012-09-14 06:05:42 +0200

Seen: 472 times

Last updated: Sep 14 '12