Skip to Content
Office 2007 Bible
book

Office 2007 Bible

by John Walkenbach, Herb Tyson, Faithe Wempen, Cary N. Prague, Michael R. Groh, Peter G. Aitken, Michael R. Irwin, Gavin Powell, Lisa A. Bucki
June 2007
Intermediate to advanced
1224 pages
35h 32m
English
Wiley
Content preview from Office 2007 Bible

Selecting Rows, Columns, and Cells

If you want to apply formatting to one or more cells, or issue a command that acts upon them such as Copy or Delete, you must first select the cells to be affected:

  • A single cell: Move the insertion point by clicking inside the desired cell. At this point, any command acts on that individual cell and its contents, not the whole table, row, or column. Drag across multiple cells to select them.

  • An entire row or column: Click any cell in that row or column and then open the Select button’s menu on the Layout tab and choose Select Column or Select Row (Figure 23-5). Alternatively, position the mouse pointer above the column or to the left of the row, so that the mouse pointer turns into a black arrow, and then click to select the column or row. (You can drag to extend the selection to additional columns or rows when you see the black arrow.)

Figure 23-5. Select a row or column with the Select button’s menu, or click above or to the left of the column or row.

There are two ways to select the entire table—or rather, two senses in which the entire table can be “selected.”

  • Select all table cells: When you select all of the cells, they all appear with shaded backgrounds, and any text formatting command that you apply at that point affects all of the text in the table. To select all cells, do any of the following:

    • Choose Select Table ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

PowerPoint® 2007 Bible

PowerPoint® 2007 Bible

Faithe Wempen
Easy Office 2013

Easy Office 2013

Patrice-Anne Rutledge, Sherry Gunter
Office 2010: The Missing Manual

Office 2010: The Missing Manual

Nancy Conner, Matthew MacDonald
Microsoft® Office 2010 Inside Out

Microsoft® Office 2010 Inside Out

Ed Bott and Carl Siechert

Publisher Resources

ISBN: 9780470046913Purchase book