how to select entire row and column in a sigle cell selection
i want to select the entire row and entire column on selecting a single cell.
is it possible |
how to select entire row and column in a sigle cell selection
Shift+space to select entire row
Ctrl+space to select entire column -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sabu varoor" wrote: i want to select the entire row and entire column on selecting a single cell. is it possible |
how to select entire row and column in a sigle cell selection
You can do that with event code. Right click the tab on the worksheet you
want this functionality for and then copy/paste this code into the code window that appeared... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target, Range("D:F")) Is Nothing Then Exit Sub Application.EnableEvents = False Union(Target.EntireColumn, Target.EntireRow).Select Application.EnableEvents = True End Sub You didn't say for what range of cells you want this functionality, so I set it up for columns D, E and F as an example... just change the range to suit your needs. If, on the other hand, you want this functionality for the entire sheet and not just a range of cells on that sheet, use this code instead... Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.EnableEvents = False Union(Target.EntireColumn, Target.EntireRow).Select Application.EnableEvents = True End Sub -- Rick (MVP - Excel) "sabu varoor" <sabu wrote in message ... i want to select the entire row and entire column on selecting a single cell. is it possible |
how to select entire row and column in a sigle cell selection
On Dec 22, 6:54*am, sabu varoor <sabu
wrote: i want to select the entire row and entire column on selecting a single cell. is it possible If you want to select both the row and column, but not the whole sheet, you'll have to use the mouse. CTRL-Click on the row and column headers. And then you'll have to use Tab to get the proper cell active if that is what you want. |
All times are GMT +1. The time now is 01:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com