aik hi cell main

[faizan374]

agar excel main aik hi cell main 2 ya 3 words likhne hon to enter karta hun to wo dusrey cell pe chala jata hai jabke mujhey 1 ke neechey aik word likhna hai please tell me.

excel main ctlr+z lock hai kaise kholun?

pehle se baney huey table main jab bhi koi naye cheez jaise students ke numbers etc add karta hun to formula ur jata hai wo kaise hoga ke formula baqi rahe or main entry karlun?

regards

[faizan374]

plz help

[syar]

agar excel main aik hi cell main 2 ya 3 words likhne hon to enter karta hun to wo dusrey cell pe chala jata hai jabke mujhey 1 ke neechey aik word likhna hai please tell me.

excel main ctlr+z lock hai kaise kholun?

pehle se baney huey table main jab bhi koi naye cheez jaise students ke numbers etc add karta hun to formula ur jata hai wo kaise hoga ke formula baqi rahe or main entry karlun?

regards

1. jab pahly name likhain tu is k bad ALT+Enter press krain aur is k bad dosra name likhain aur phr sa ALT+ENTER krain. tu name ya koi bhe text ise cell m new line sa start ho ga. dosri cell m nahee jai ga jese k normally neter krne p hota ha.

2. CTRL+Z lock nahee ho ga. ya file protected ho tu aap ko file unprotect krne ho gi ya VBA ka code ho ga use delete kr k file dobra save kr lain. Ya agar aap cell m EIDT kr rahe hon tu bhe ya function baz auqat kam nahee krta. Please zara aur explain kar dian.

3. aap dobara explain krain ya ho sakte tu apna sample data attach kr daink smjhne m asani ho.

regards