blob: 688669bad3259752ca263bc8eb97dff916000ac7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
|
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<meta>
<topic id="textscalcguideline_fixxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Freezing Rows or Columns as Headers</title>
<filename>/text/scalc/guide/line_fix.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3154684">
<bookmark_value>tables; freezing</bookmark_value>
<bookmark_value>title rows; freezing during table split</bookmark_value>
<bookmark_value>rows; freezing</bookmark_value>
<bookmark_value>columns; freezing</bookmark_value>
<bookmark_value>freezing rows or columns</bookmark_value>
<bookmark_value>headers; freezing during table split</bookmark_value>
<bookmark_value>scrolling prevention in tables</bookmark_value>
<bookmark_value>windows; splitting</bookmark_value>
<bookmark_value>tables; splitting windows</bookmark_value>
</bookmark>
<h1 id="hd_id3154684" xml-lang="en-US"><variable id="line_fix"><link href="text/scalc/guide/line_fix.xhp" name="Freezing Rows or Columns as Headers">Freezing Rows or Columns as Headers</link> </variable></h1>
<paragraph id="par_id3148576" role="paragraph" xml-lang="en-US">If you have long rows or columns of data that extend beyond the viewable area of the sheet, you can freeze some rows or columns, which allows you to see the frozen columns or rows as you scroll through the rest of the data.</paragraph>
<list type="ordered">
<listitem>
<paragraph id="par_id3156441" role="listitem" xml-lang="en-US">Select the row below, or the column to the right of the row or column that you want to be in the frozen region. All rows above, or all columns to the left of the selection are frozen.</paragraph>
<paragraph id="par_id3153158" role="listitem" xml-lang="en-US">To freeze both horizontally and vertically, select the <emph>cell</emph> that is below the row and to the right of the column that you want to freeze.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id3156286" role="listitem" xml-lang="en-US">Choose <item type="menuitem">View - Freeze Rows and Columns</item>.</paragraph>
<paragraph id="par_id3151073" role="listitem" xml-lang="en-US">To deactivate, choose <item type="menuitem">View - Freeze Rows and Columns</item> again.</paragraph>
</listitem>
</list>
<paragraph id="par_id3155335" role="note" xml-lang="en-US">If the area defined is to be scrollable, apply the <item type="menuitem">View - Split Window</item> command.</paragraph>
<paragraph id="par_id3147345" role="note" xml-lang="en-US">If you want to print a certain row on all pages of a document, choose <item type="menuitem">Format - Print ranges - Edit</item>.</paragraph>
<section id="relatedtopics">
<paragraph id="par_id3147004" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/07090000.xhp" name="View - Freeze Cells - Freeze Rows and Columns">View - Freeze Rows and Columns</link></paragraph>
<paragraph id="par_id3150088" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/07080000.xhp" name="View - Split">View - Split Window</link></paragraph>
<embed href="text/scalc/guide/print_title_row.xhp#print_title_row"/>
<paragraph id="par_id3150304" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/05080300.xhp" name="Format - Print ranges - Edit">Format - Print ranges - Edit</link></paragraph>
</section>
</body>
</helpdocument>
|
