Navigating within worksheet
Each sheet in spreadsheet is called as worksheet. Worksheet is made up of cells arranged in rows and columns. It is possible to select a single or a range of cell/row/column, add/ remove row/column, move from one place to another within the worksheets, etc
Selecting cell/ row/ column
Cell:
To select a single cell use arrow key or directly click mouse over the particular cell. When a cell is selected or in focus, the cell borders are emphasized. Multiple cells or a range of cells can also be selected.
To select range of continuous cells
A range of cells can be selected using the keyboard or the mouse.
To select a range of cells by dragging the mouse cursor:
Click in a cell.
Press and hold down the left mouse button.
Move the mouse around the screen.
Once the desired block of cells is highlighted, release the left mouse button.
To select a range of cells without dragging the mouse:
Click in the cell which is to be one corner of the range of cells.
Move the mouse to the opposite corner of the range of cells.
Hold down the Shift key and click.
You can also directly select a range of cells using the Name Box. Click into the Name Box on the Formula Bar. To select a range of cells, enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. For example, to select the range that would go from A3 to C6, you would enter A3:C6.
To select range of non-continuous cells
Select the cell or range of cells using one of the methods above.
Move the mouse pointer to the start of the next range or single cell.
Hold down the Ctrl key and click or click-and-drag to select another range of cells to add to the first range.
Repeat as necessary.
When a group of cells is selected, the cell area is colored. The color of the cell border emphasis and the color of a group of selected cells depends on the operating system being used and how you have set up LibreOffice .
Row/Column:
To select a single row, click on the row header.
To select a single column, click on the column header.
To select multiple columns or rows that are continuous:
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 continuous:
Click on the first column or row in the group.
Hold down the Ctrl key.
Click on all of the subsequent columns or rows while holding down the Ctrl key.
Moving within worksheet
Navigation within a worksheet can be done in various ways:
Using the mouse – place the mouse pointer over the cell and click the left mouse button. To move the focus to another cell using the mouse, simply move the mouse pointer to the cell where you want the focus to be and click the left mouse button.
Using a cell reference – highlight or delete the existing cell reference in the Name Box on the Formula Bar. Type the new cell reference of the cell you want to move to and press Enter key. Cell references are case insensitive: for example, typing a3 or A3 will move the focus to cell A3.
Using the Enter key – pressing Enter moves the cell focus down in a column to the next row. Pressing Shift+Enter moves the focus up in a column to the next row.
Using the Tab key – pressing Tab moves the cell focus right in a row to the next column. Pressing Shift+Tab moves the focus to the left in a row to the next column.
Using the arrow keys – pressing the arrow keys on the keyboard moves the cell focus in the direction of the arrow pressed.
Using Home, End, Pageup and Pagedown
– Home moves the cell focus to the start of a row.
– End moves the cell focus to the last cell on the right in the row that contains data.
– Page Down moves the cell focus down one complete screen display.
– Page Up moves the cell focus up one complete screen display.
Inserting row/column
Row/column can be inserted in two ways i,e., by using insert menu or by using mouse.
Insert menu:
Select a cell, column, or row where you want the new column or row inserted.
Go to Insert on the main menu bar and select either Insert > Columns or Insert > Rows.
Mouse:
Select a column or row header where you want the new column or row inserted.
Right-click the column or row header.
Select Insert Columns Left/right or Insert Rows Above/below from the context menu.
Multiple columns/ rows can also be inserted at once rather than inserting them one at a time. Highlight the required number of columns or rows by holding down the left mouse button on the first one and then dragging across the required number of row/column headers. Then follow any one of the inserting single column or row method.
Deleting row/ column
To delete a single column or row:
Select a cell in the column or row you want to delete,.
Go to Edit on the main menu bar and select Delete Cells or right-click the mouse and select Delete from the context menu.
In the Delete Cells dialog box, choose the option as per the need
To delete multiple columns or rows:
Select the columns or rows
Go to Edit on the main menu bar and select Delete Cells, or right-click and select Delete from the context menu, or right-click in the column or row header and select Delete Selected Columns or Delete Selected Rows from the context menu.
Each sheet in spreadsheet is called as worksheet. Worksheet is made up of cells arranged in rows and columns. It is possible to select a single or a range of cell/row/column, add/ remove row/column, move from one place to another within the worksheets, etc
Selecting cell/ row/ column
Cell:
To select a single cell use arrow key or directly click mouse over the particular cell. When a cell is selected or in focus, the cell borders are emphasized. Multiple cells or a range of cells can also be selected.
To select range of continuous cells
A range of cells can be selected using the keyboard or the mouse.
To select a range of cells by dragging the mouse cursor:
Click in a cell.
Press and hold down the left mouse button.
Move the mouse around the screen.
Once the desired block of cells is highlighted, release the left mouse button.
To select a range of cells without dragging the mouse:
Click in the cell which is to be one corner of the range of cells.
Move the mouse to the opposite corner of the range of cells.
Hold down the Shift key and click.
You can also directly select a range of cells using the Name Box. Click into the Name Box on the Formula Bar. To select a range of cells, enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. For example, to select the range that would go from A3 to C6, you would enter A3:C6.
To select range of non-continuous cells
Select the cell or range of cells using one of the methods above.
Move the mouse pointer to the start of the next range or single cell.
Hold down the Ctrl key and click or click-and-drag to select another range of cells to add to the first range.
Repeat as necessary.
When a group of cells is selected, the cell area is colored. The color of the cell border emphasis and the color of a group of selected cells depends on the operating system being used and how you have set up LibreOffice .
Row/Column:
To select a single row, click on the row header.
To select a single column, click on the column header.
To select multiple columns or rows that are continuous:
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 continuous:
Click on the first column or row in the group.
Hold down the Ctrl key.
Click on all of the subsequent columns or rows while holding down the Ctrl key.
Moving within worksheet
Navigation within a worksheet can be done in various ways:
Using the mouse – place the mouse pointer over the cell and click the left mouse button. To move the focus to another cell using the mouse, simply move the mouse pointer to the cell where you want the focus to be and click the left mouse button.
Using a cell reference – highlight or delete the existing cell reference in the Name Box on the Formula Bar. Type the new cell reference of the cell you want to move to and press Enter key. Cell references are case insensitive: for example, typing a3 or A3 will move the focus to cell A3.
Using the Enter key – pressing Enter moves the cell focus down in a column to the next row. Pressing Shift+Enter moves the focus up in a column to the next row.
Using the Tab key – pressing Tab moves the cell focus right in a row to the next column. Pressing Shift+Tab moves the focus to the left in a row to the next column.
Using the arrow keys – pressing the arrow keys on the keyboard moves the cell focus in the direction of the arrow pressed.
Using Home, End, Pageup and Pagedown
– Home moves the cell focus to the start of a row.
– End moves the cell focus to the last cell on the right in the row that contains data.
– Page Down moves the cell focus down one complete screen display.
– Page Up moves the cell focus up one complete screen display.
Inserting row/column
Row/column can be inserted in two ways i,e., by using insert menu or by using mouse.
Insert menu:
Select a cell, column, or row where you want the new column or row inserted.
Go to Insert on the main menu bar and select either Insert > Columns or Insert > Rows.
Mouse:
Select a column or row header where you want the new column or row inserted.
Right-click the column or row header.
Select Insert Columns Left/right or Insert Rows Above/below from the context menu.
Multiple columns/ rows can also be inserted at once rather than inserting them one at a time. Highlight the required number of columns or rows by holding down the left mouse button on the first one and then dragging across the required number of row/column headers. Then follow any one of the inserting single column or row method.
Deleting row/ column
To delete a single column or row:
Select a cell in the column or row you want to delete,.
Go to Edit on the main menu bar and select Delete Cells or right-click the mouse and select Delete from the context menu.
In the Delete Cells dialog box, choose the option as per the need
To delete multiple columns or rows:
Select the columns or rows
Go to Edit on the main menu bar and select Delete Cells, or right-click and select Delete from the context menu, or right-click in the column or row header and select Delete Selected Columns or Delete Selected Rows from the context menu.
No comments:
Post a Comment