ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How can I insert the small letter a inside any excel cell without using keyboard or screen keyboard?

user-image
تم إضافة السؤال من قبل Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL
تاريخ النشر: 2015/05/30
Mohammad Basheer abu ahmad
من قبل Mohammad Basheer abu ahmad , مشرف كمبيوتر ، الإشراف على الموظفين , قطاع عام

I think by option - pick from list - after you copy any character

Muhammad Moeen Bhatti
من قبل Muhammad Moeen Bhatti , Cluster Incharge , Premier DLC - A project of Beaconhouse Group

if you don't want to use any keyboard you can enter the small letter with mouse with copy / paste option

Michael Lagunday
من قبل Michael Lagunday , Accountant , Dubai Camel Racing Club

 It can be done using a copy and paste.

 

 

Ahmed Maher allam
من قبل Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL

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

Donna Angeli Benitez
من قبل Donna Angeli Benitez , Accounting Assistant , Extreme Piling Tech-Doha Qatar

copy the text using the mouse then paste in the excel cell.

ASHOK KUMAR M P
من قبل ASHOK KUMAR M P , Data Entry Operator , District TB Cente, Govt. Health Services, Kerala

Select the letter what you want to enter and paste it to ever you want

Said Ibrahim Abdelsalam Rizk
من قبل Said Ibrahim Abdelsalam Rizk , Financial Manager , Modern Power Systems - MPS

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

 

 

 

 

هاشم المشارقة
من قبل هاشم المشارقة , Key Account Manager , Advanced United Systems Ltd. ( A member of Taj Holding Group)

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 ?

Abhilash Koturwar
من قبل Abhilash Koturwar , Development Manager , Sobha Realty

copy text from other cell i gues

المزيد من الأسئلة المماثلة