Hi all,
I know that this could be a stupid question, but was wondering if it could be possible.
I would like to select a column by a keyboard shortcut. If I would press a key combination adding the letter of a column as example F, it would select the whole column.
I was trying to search for this in google, but no luck.
Any one knows how to get this done?
Greetings.
Hi,
Press Ctrl + Spacebar to select entire column.
For more excel shortcuts, refer the below link:
http://chandoo.org/wp/2010/02/22/com...cel-shortcuts/
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
Hi Pareshj,
Thanks for the link.
I went trough it, but no keyboard shortcut to select a column by letter. With Ctrl + Spacebar, I can only select the column where the current cell is selected.
Greetings.
Hi,
You want to select a column by letter? Can you explain it in brief with example.
Regards,
Paresh J
One way around this is ......
Press Alt+F11 to open VBA Editor --> Insert --> Module --> Paste the code given below in the code window --> Close the VBA Editor --> Save your workbook as Excel Macro-Enabled Workbook.
Now press Alt+F8 --> Select the macro "SelectColumn" from the macro list --> Options --> Set the shortcut key like Ctrl+Shift+F --> OK
Please Login or Register to view this content.
Now on the sheet press the shortcut key Ctrl+Shift+F, you will be prompted to input the column letter, type the column letter in the input box and press OK.
Is that something you can work with?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Press F5
A go to Box will open
Enter: F:F in The Reference and Press Enter Button
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi Sktneer,
Thanks for the macro. It works nice, but it is not that convinient as I can only use it in one workbook and does not on others.
Hi Pareshj,
The idea of selecting the column by letter is that if I would like to select column F, I would press some keyboard combination in the way I would select the whole column the way I would select it by pressing Ctrl + Spacebar (but this only selects the column where the cell is active).
Greetings.
Hi Megatronics,
From my knowledge, That would not be possible to create. You can have Macro with keyboard shortcut but again if you use other workbook then the shortcut will not work.
Regards,
Paresh J
i think this would be the closest your going to get without a macroOriginally Posted by nflsales
if you dont want the pop up you can type directly into name box on the top left of the sheet
http://www.guidesandtutorials.com/im...3_name_box.png
Last edited by humdingaling; 07-24-2014 at 03:28 AM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi all,
Thank you all for your time :-)
I guess the answer from Humdingaling is the most logical one. But looks like that with the mouse is faster, but not handier.
a macro can be written to request via inputbox i guess but then that would not be very different to what nflsales has proposed
maybe some a few keystrokes at most
is that really worth the effort? if yes the code itself isn't very hard
assign macro to custom shortcut key and there you goPlease Login or Register to view this content.
ps put macro into your "Personal.xls" macro book in order to transfer between workbooks
Last edited by humdingaling; 07-24-2014 at 04:35 AM. Reason: sorry sktneer just noticed your code already posted
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks