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

Additional Resources







Excel Tips | Microsoft Excel XP | Page 2

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 Non-Neighboring Ranges

Most of the time, the ranges that you select will be a single rectangle of neighboring cells. Excel also let's you work with non-neighboring ranges, which consist of two or more ranges (or single cells), not necessarily next to each other (also known as a multiple selection).

If you want to apply the same formatting to cells in different areas of your worksheet, one approach is to make a multiple selection.

As Excel Tips, after you select the appropriate cells or ranges, Excel applies the formatting that you choose to all the selected cells.

Use any one of the following methods to select non-neighboring cells (or ranges):

First click the starting cell of the selection.
Hold down the CTRL key while you click the mouse and drag to highlight the individual cells or ranges.
   
  OR
   
From the keyboard, select a range by pressing F8 and then use the arrow keys.
After selecting the first range, press Shift+ F8, move the cell pointer, and press F8 to start selecting another range.

Excel Tips: Non-neighboring selected cells example

Excel Office Helper Excel Tips:

Remember to click the first starting cell of the selection.

The last selected cell is not highlighted in transparent, but shows a thick border around the cell.


Selecting Entire Columns

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

As Excel tips on how to select entire columns, use any one of the following methods:

Click the Column Heading (A, B, C...) to select a single column.
   
  Excel Tips: Column Select example 1
   
  OR
   
To select multiple neighboring columns,
click-and-drag the Column Headings to select.
   
  Excel Tips: Neighboring Column Select example
   
  OR
   
To select multiple non-neighboring columns,
hold down the CTRL key and click the Column Headings to select.
   
  Excel Tips: Non-Neighboring Column Select example
   
  OR
   
Press CTRL+ SPACEBAR to select the column of the active cell or the columns of the selected cells.
Back to Top
 
See also... Select a Cell | Select a Range
 
Select entire Rows | Select entire Worksheet
 
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