Is there any way I can allow users to use the Ctrl A (select all) short cut in a cell when they are using my spreadsheet? Right now it doesnt allow it...
I want them to be able to double click a cell, and press ctrl and A to be able to select all of the text in that cell..
It might help to know what they need to be able to do with the text they select. If they select a cell (but not double click) and click CTRL-C or Copy, it will copy all the text in the cell to the clipboard. Is there something else you want them to be able to do by selecting that text?
When they just select the cell and copy it in though it ruins my formatting that I have in excel. I am trying to avoid that
then why not just copy the cell normally?I want them to be able to double click a cell, and press ctrl and A to be able to select all of the text in that cell.
Or F2 shift Home
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The average user wont know to do that
So I guess theres no way to do this then?
What exactly are you trying to do?
Just be able to do ctrl + a so I can select text in a cell, I dont like the idea of people pasting info into the cell by just clicking the cell and pasting because that can ruin the formatting of the cell..
Without VBA I don't think you can prevent that.I dont like the idea of people pasting info into the cell by just clicking the cell and pasting because that can ruin the formatting of the cell..
Although it is not exactly clear what you want to achieve.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hmm. I have a cell that has a filler background green. The user can put any information they want in that cell. If they copy something from an outside source, click the cell and paste it, the formatting (filler green background ) goes away. I guess theres no way to prevent that, except for me actually telling everyone using the sheet to click inside the cell to paste?
[EDIT] Doing my own research I see that the only way is to use "Paste Values", so I cant really tell people they can use the keyboard shortcut ctrl v to paste as that could remove formatting in the cell....oh well.
Last edited by A108A108; 05-15-2016 at 03:06 PM.
Do you just want to force paste special as values?
If so check out this thread for one
http://www.mrexcel.com/forum/excel-q...al-values.html
or this one
http://www.siddharthrout.com/2011/08...-special-only/
or maybe try
Or you could do something like reinstating the format rules each time they save.
Please Login or Register to view this content.
Last edited by scottiex; 05-15-2016 at 05:47 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks