Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions

  




 

 

OpenOffice Calc User Guide
Previous Page Home Next Page

Using Home, End, Page Up and Page Down

  • Home moves the focus to the start of a row.

  • End moves the focus to the column furthest to the right that contains data.

  • Page Down moves the display down one complete screen and Page Up moves the display up one complete screen.

  • Combinations of Control and Alt with Home, End, Page Down, Page Up, and the cursor keys move the focus of the current cell in other ways. Table 1 describes all the keyboard shortcuts for moving about a spreadsheet.

TIP

Holding down Alt+Cursor key resizes a cell.

Table 1. Moving from cell to cell using the keyboard

Key Combination

Movement

→

Right one cell

â†

Left one cell

↑

Up one cell

↓

Down one cell

Control+→

To last column containing data in that row or to Column IV

Control+â†

To first column containing data in that row or to Column A

Control+↑

To first row containing data in that column or to Row 1

Control+↓

To last row containing data in that column or to Row 32000

Control+Home

To Cell A1

Control+End

To lower right hand corner of the square area containing data

Alt+PgDn

One screen to the right (if possible)

Alt+PgUp

One screen to the left (if possible)

Control+PgDn

One sheet to the right (in Sheet Tabs)

Control+PgUp

One sheet to the left (in Sheet Tabs)

Tab

To the cell on the right

Shift+Tab

To the cell on the left

Enter

Down one cells

Shift+Enter

Up one cell

OpenOffice Calc User Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire