How to Deselect a Specific Column After Selecting the Entire Worksheet in Excel 2010?

[happydz]

Hi everyone,

I'm working in Excel 2010 and have selected the entire worksheet (by clicking the box at the top-left corner where the row numbers and column letters meet). Now, I want to deselect a specific column from the selection — for example, column B — without unselecting the entire worksheet.

I've tried holding down the Ctrl key and clicking on the column header (e.g., column B), but it only deselects the B1 cell and doesn't affect the whole column.

I’m looking for a built-in solution or Excel trick that allows me to deselect a specific column (or range of columns) from a full worksheet selection without using VBA, macros, or any scripting.

Is there any way to do this in Excel 2010 using just the standard Excel interface?

Any tips, tricks, or suggestions would be greatly appreciated!

 

[NoSparks]

Post #5 works for me with my Excel 2010

Hide column B
Select everything
Alt key and semicolon key at same time
column B width indicates 0.00
grab and drag wider

 

[happydz]

Post #5 works for me with my Excel 2010

Hide column B
Select everything
Alt key and semicolon key at same time
column B width indicates 0.00
grab and drag wider

Thank you so much guys, it works now, I really appreciate it.