Edsa Mae [Working with Tables] - SHIFT+SPACEBAR to select a...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
WORKING WITH TABLES Navigating in a tables Selecting parts of a table Adding new rows or columns TIP
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Selecting cells in a table works just like selecting cells in a normal range. One difference is when you use the TAB key. Pressing TAB moves to the cell to the right, and when you reach the last column, pressing TAB again moves to the first cell in the next row.
Background image of page 2
To select an entire column -Move the mouse to the top of the cell in the header row, and the mouse changes to a down pointer arrow. Click a second time to select the entire table column(including the Header Row and the Total Row, if it has one.) You can also press CTRL+ SPACEBAR ( once or twice) to select a column. To select an entire row - Move the mouse to the left of a cell in the first column, and the mouse pointer changes to a right-pointing arrow. Click to select the entire table row. You can also press
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: SHIFT+SPACEBAR to select a table row. To select an entire table-Move the mouse to the upper-left part of the upper left cell . When the mouse pointer turns into diagonal arrow, Click to select the data area of the table . Click a second time to select the entire table(including the header row and the total row). You can also press CTRL+A (once or twice) to select the entire table. To add a new column to the end of a table, select a cell in the column to the right of the table and start entering the data. Excel automatically extends the table horizontally. Similarly, if you enter data in the row below a table, excel extends the table vertically to include the new row. Right-clicking a cell in a table displays several selection options in the shortcut menu....
View Full Document

This note was uploaded on 12/16/2011 for the course ACCOUNTANC 506 taught by Professor Mr.reyes during the Spring '11 term at University of the Philippines Diliman.

Page1 / 6

Edsa Mae [Working with Tables] - SHIFT+SPACEBAR to select a...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online