ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   When I click on a column, that column and one to its right is sele (https://www.excelbanter.com/new-users-excel/225727-when-i-click-column-column-one-its-right-sele.html)

Larry6295

When I click on a column, that column and one to its right is sele
 
For some reason, on my first spreadsheet, when I click on a column, the one
to its right is also selected. It doesn;t happen on all the columns. What did
I do to cause that? Thank you for any assistance.

Dave Peterson

When I click on a column, that column and one to its right is sele
 
I bet you merged some cells.

Select those two columns and then
Rightclick on any of the selected cells
Format cells|Alignment tab
Look for merged cells.

You'll see that it's a mixture of merged cells (either a green square or a grey
checkbox -- depends on the version).

You can remove the merged cells by clearing that checkbox.

But you may want to look to see if you removed some of the "prettiness" from
your worksheet. Merged cells are used to make things look pretty--like headers
that span multiple columns.

Larry6295 wrote:

For some reason, on my first spreadsheet, when I click on a column, the one
to its right is also selected. It doesn;t happen on all the columns. What did
I do to cause that? Thank you for any assistance.


--

Dave Peterson


All times are GMT +1. The time now is 12:29 PM.

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