Difference between revisions of "Documentation/AOO4 User Guides/Getting Started/Getting Started with Calc/Selecting Items in a Sheet or Spreadsheet/Selecting Columns and Rows"
From Apache OpenOffice Wiki
< Documentation | AOO4 User Guides/Getting Started | Getting Started with Calc | Selecting Items in a Sheet or Spreadsheet
(→Selecting Columns and Rows) |
m (→Selecting Columns and Rows) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 12: | Line 12: | ||
'''Single column or row''' | '''Single column or row''' | ||
| − | To select a single column, click on the column identifier letter (see Figure 62). | + | To select a single column, click on the column identifier letter (see [[Media:AOO41GS05 001.png|Figure 62]]). |
To select a single row, click on the row identifier number. | To select a single row, click on the row identifier number. | ||
| Line 34: | Line 34: | ||
To select the entire sheet, click on the small box between the A column header and the 1 row header. You can also press {{key|Ctrl|A}} to select the entire sheet. | To select the entire sheet, click on the small box between the A column header and the 1 row header. You can also press {{key|Ctrl|A}} to select the entire sheet. | ||
| − | [[Image:AOO41GS05_018.png| | + | [[Image:AOO41GS05_018.png|200px|center]] |
| − | + | <center>''Figure 73: Select All box''</center> | |
{{CCBY}} | {{CCBY}} | ||
[[Category:Getting Started (Documentation)]] | [[Category:Getting Started (Documentation)]] | ||
Latest revision as of 11:58, 30 September 2023
- What is Calc
- Parts of the main Calc window
- Open and Save CSV files
- Navigating within spreadsheets
- Selecting items in a sheet or a spreadsheet
- Selecting Cells
- Selecting Columns and Rows
- Selecting Sheets
- Working with Columns and Rows
- Working with Sheets
- Viewing Calc
- Entering data using the keyboard
- Speeding up data entry
- Validating cell contents
- Editing data
- Formatting data
- Auto-formatting cells and sheets
- Formatting spreadsheets using themes
- Using conditional formatting
- Hiding and showing data
- Sorting records
- Using formulas and functions
- Analyzing data
- Printing from Calc
Selecting Columns and Rows
Entire columns and rows can be selected very quickly in Apache OpenOffice.
Single column or row
To select a single column, click on the column identifier letter (see Figure 62).
To select a single row, click on the row identifier number.
Multiple columns or rows
To select multiple columns or rows that are contiguous:
- Click on the first column or row in the group.
- Hold down the ⇧ Shift key.
- Click the last column or row in the group.
To select multiple columns or rows that are not contiguous:
- Click on the first column or row in the group.
- Hold down the Ctrl key.
- Click on all the subsequent columns or rows while holding down the Ctrl key.
Entire sheet
To select the entire sheet, click on the small box between the A column header and the 1 row header. You can also press Ctrl + A to select the entire sheet.
| Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |
