Register now or log in to join your professional community.
I think by option - pick from list - after you copy any character
if you don't want to use any keyboard you can enter the small letter with mouse with copy / paste option
It can be done using a copy and paste.
The answer is : =char(97)
because a small has decimal number97 and the capital A has decimal number65
and the formula char changes the decimal and convert it to binary then to ascii
copy the text using the mouse then paste in the excel cell.
Select the letter what you want to enter and paste it to ever you want
Advanced Answer : To write "a" in any cell in any sheet - Just with Mouse Click
1- "Right-Click" on any sheet in excel Workbook
2- From popup menu select "View Code"
3- From left panel named "VBAProject" select "ThisWorkbook"
4- past the following code in the withe space
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)Target.Cells.Value = "a"End Sub
It is very advanced tricky, Actually I don't know.
But what about put the pointer at the bottom-left corner and drag to the cell down ?
copy text from other cell i gues