ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Cell Selection (https://www.excelbanter.com/new-users-excel/174250-cell-selection.html)

Paul

Cell Selection
 
In Excel 2007 I am trying to select a number of adjacent columns. As cells in
a number of rows crossing these columns are merged across more cloumns than I
would like to select, Excel is selecting all the columns which are cut across
by the merged cells. This did not happen in Excel 2003, I used to select
whatever rows or columns I needed.

How can I do so in 2007? Excel Help does not seem to be so helpful in this
respect.







Paul

Cell Selection
 
I have found the solution:

Double click the first column header
Shift
Double click the last column header




"Paul" wrote:

In Excel 2007 I am trying to select a number of adjacent columns. As cells in
a number of rows crossing these columns are merged across more cloumns than I
would like to select, Excel is selecting all the columns which are cut across
by the merged cells. This did not happen in Excel 2003, I used to select
whatever rows or columns I needed.

How can I do so in 2007? Excel Help does not seem to be so helpful in this
respect.








All times are GMT +1. The time now is 09:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com