This is something that has bothered me for years. When I am using SQL Server 2005 Management Studio and I am in the table designer and I'm editing the column definitions It is almost possible to do this entirely without using the mouse. However, if I'm navigating around the cells in this designer using the arrow keys, when I move to a new cell all the text is selected. Say I want to change a decimal(6,2) to decimal(6,3), so I move over there with arrow keys and the whole decimal(6,2) phrase is selected. I have been completely unsuccessful in finding a way to move the cursor to the beginning or end of the line. Instead any combination of ctrl, shift, alt and arrow keys blithely select the adjacent cell in that arrow's direction. So inevitably, I have to take my hands from the keyboard and use the mouse to click within the cell I want to edit and then I can edit the value without having to retype the entire thing.
GRRR!
Can anyone help me out with this one?
I will be eternally grateful (or at least as long as I use Sql server management studio)!
Thanks,
Uh... F2, right? That's always worked for me, in just about any program where you edit a grid
While playing around with @Damien's answer I found out an even better answer that I basically accept as the answer.
If you move to a cell and all the text is selected you can hit the escape key. All the text will still be selected but at this point you can use the navigation keys like arrows and Home and End and they will work as expected.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With