word-excel-access-help.com logo
Excel Tips
Word 2007
Excel 2007
Access 2007
Word xp
Excel xp
Access xp

Excel Tips
Additional Resources

Excel Tips | Microsoft Excel XP | Page 3

Microsoft Excel XP logo
Learn some Excel tips on how to select a cell, range, non-neighboring ranges, columns, rows and the entire worksheet's cells.

Excel Office Helper What's on this page...
Selecting A Cell
Selecting A Range
Selecting Non-Neighboring Ranges
Selecting Entire Columns

Selecting Entire Rows
Selecting the Entire Worksheet's Cells

Selecting Entire Rows

You can select entire rows as part of your selecting operations.

To select entire rows, use any one of the following methods:

Click the Row Heading (A, B, C...) to select a single row.
  Excel Tips: Row Select example
To select multiple neighboring rows,
click-and-drag the Row Headings to select.
  Excel Tips: Neighboring Row Select example
To select multiple non-neighboring rows,
hold down the CTRL key and click the Row Headings to select.
  Excel Tips: Non-Neighboring Row Select example
Press SHIFT+ SPACEBAR to select the row of the active cell or the rows of the selected cells.

Selecting The Entire Worksheet's Cells

You can decide that you want to select all the cells, rows and columns on a worksheet. In other words, you want to select all.

Some Excel Tips on how to select all the cells of a worksheet, use any one of the following methods:

Click the Select All button at the top-right corner where Column A and Row 1 starts.
  Excel Tips: Select All button
Press CTRL + A on the keyboard.
Press CTRL + SHIFT + SPACEBAR on the keyboard.
Back to Top
See also... Select a Cell | Select a Range
Select non-Neighboring Cells | Select entire Columns
Return to Excel XP from Excel Tips
Excel XP Topics
- Tips
- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Print
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter