Forum Discussion
=UPPER(A1)
OK, I'm really bad at excel, so excuse me please, but I've created a cell that uses the =UPPER(A1) formula. Worked great, but now I want to copy that text to A1. but it breaks the reference. Is ther...
Hello NEDNARB,
SergeiBaklan and Subodh_Tiwari_sktneer both offered great solutions.
Here is the shortcut I like to use when pasting as values:
1. Ctrl+C - (Copy cell)
2. Ctrl+V - (Paste cell)
3. Ctrl - (Paste options)
4. V - (Values)
I have found that this method is quick and easy to remember.
Approximately the same, but I never can find C and V without moving focus on keyboard.
Thus
Ctrl+Ins
Shift+Ins
Ctrl
Down
Down
Enter
Above buttons are pressed practically automatically with some help of peripheral vision since they are practically isolated. If we speak about full scale keyboard.