LinkBack URL
About LinkBacks
Hello, is there a hotkey which simulates doublclicking on cell, selecting all text within cell and copying the selection?
Thank you.
Hello, is there a hotkey which simulates doublclicking on cell, selecting all text within cell and copying the selection?
Thank you.
Here is a list of keyboard shortcuts
http://www.asap-utilities.com/excel-tips-shortcuts.php
Perhaps Control + C
Last edited by alansidman; 01-07-2016 at 10:16 AM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
No ctrl+c makes copy of cell with formatting. Perhaps a hotkey for paste special 'values only' would do the trick.
The only combination I know of is a series of "hotkeys". F2 function key --> Shift + home --> Ctrl + C. Is this what you are looking for?
Dave
here is code I use for copy-->paste special in the same cell.
Please Login or Register to view this content.
Alt + h + v + v will paste values. That is about it for a keyboard shortcut to paste values.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Sadly it doesn't work for me. I often have to copy contetnts of cell and paste it to formula which is in another cell. Doing with mouse is rather tedious. I can't link the cell which contains the string I need to paste, because the string and formula are in areas which filters independently. So both relative and absolute possitions are dynamic.Originally Posted by newdoverman
Make use of the Clipboard. On the Home tab, Clipboard, click on the little Dialogue Launcher (lower right corner) and click on options and select Show Office Clipboard when Ctrl +C Pressed Twice.
This will allow you to copy up to 24 separate items and then you can select what you want to paste as required.
Perhaps if you told us a full story, we might be able to supply a workable solution instead of guessing at what you need.
Exuse me please. Full story short I'm lazy as ****. Full story is not needed. I will use the macro and assign it to hotkey. Sadly there is very limited amount of assigned hotkeys to macros that are working.
Thank you all very much for trying to help me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks