Xcel - selecting non-contiguous column

T

tigason

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How do i select 2 or more non-contiguous column? I understand how to select non-contiguous cells using the Command button. But i want to select 2 whole columns. How do i do that?
 
C

CyberTaz

Do you really mean the entirety of both columns?

If so, click the Column Heading of the one column then Command-Click the
Column Heading for the other.

If you actually mean a range of cells in each column, select the first range
then hold the Command key while you drag to select the 2nd range. Repeat for
as many additional ranges as needed.

Other selection options are described in Excel Help & you can expand on
those by experimenting with different key/mouse combinations.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Accessibilty - how to open doc with keyboard? 0
format painter 7
De-Selecting in Excel 3
Document rows and columns 1
Column letters 2
How to stop Excel from rounding up 2
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
Selecting multiple non-contiguous cells 2

Top