Thank you so much for such a video. I just gone through your channel all the videos are very useful and well explained. Expecting a video for advanced level pivot table..... Once again thank you......
Glad to hear that. Click on the small Triangle in the Top left corner of the worksheet to select the Entire sheet > Right-click on any Column header (A, B, C etc.) and select Unhide. Every hidden column will become visible. To unhide Rows, Select the entire sheet, Right-click on any Row header (1, 2, 3 etc.) and select Unhide.
Sir, As you said last in the video for 200 Short cuts explanation video, could I have please that link? Or still pending? Your videos are quite appreciable!! Regards
I am still working on that video and it will take time for the final cut. But you can check these videos on my another UA-cam channel ua-cam.com/video/ynk01mkeK7Y/v-deo.html ua-cam.com/video/mRpKwsnydM4/v-deo.html ua-cam.com/video/kOmPcBY6ap8/v-deo.html
I have done a video on the technique to highlight the Active Cell in a worksheet. Please go through the videos section of this channel to find it. Highlighting cursor is related to settings of the Operating System.
Sir, Could you explain to calculate Over time from Monday to Sunday. Because Monday to Friday after 8 hrs only over time. But week days if any time is over time. How we can calculate over time from Monday to Sunday in single XL sheet
You can use the Freeze pane option for the same. For example your headings are in Row number 3 and you want the headers to stay visible when you scroll down. Select Row number 3 > Go to the View tab in the Excel ribbon > Free Panes > Freeze Panes Another option is using Excel Tables. Please refer to my video on Advantages of using Excel Tables.
Go to the Page Layout tab > Print Titles> in the Page setup dialog, go to the Sheet tab > Rows to Repeat at top > select the rows containing Headers to repeat in every page and click OK
സ്കാൻ ചെയ്യുമ്പോൾ ഓരോ പേജിനു ശേഷവും exit/finish ചെയ്യാതെ പുതിയ പേജ് വെച്ചു scan ചെയ്യുക. എല്ലാ പേജും കഴിഞ്ഞ ശേഷം finish ചെയ്യുക. അപ്പോൾ ഒറ്റ ഫയലായി കിട്ടും. ഇനി അഥവാ പല പേജ് ആയിട്ടാണെങ്കിലും ശരിയാക്കാം. ADOBE PDF ൽ ഒരു file OPEN ചെയ്താൽ മുകളിൽ ഒരു പച്ച + കാണും. ഇല്ലെങ്കിൽ combine files എന്ന tab കാണും. അതിനു ശേഷം ചേർക്കേണ്ട file ചോദിക്കും. അപ്പോൾ ആവശ്യമുള്ള പേജ് എല്ലാം സെലക്ട് ചെയ്യുക. വേണമെങ്കിൽ പേജുകളുടെ ഓർഡർ മാറ്റാം. എന്നിട്ട് combine ക്ലിക്ക് ചെയ്യുക. ഒറ്റ ഫയലായി വരും. Default ആയി Binder എന്ന പേരായിരിക്കും. അതു ആവശ്യം പോലെ തിരുത്തി save ചെയ്യുക.
You can adjust the number of sheets and more using the Page Setup option. CTRL + P > Page Setup > in the Page Setup dialog, select the option 'Fit to *1* Page wide by *1* tall'
Thank you so much for such a video. I just gone through your channel all the videos are very useful and well explained. Expecting a video for advanced level pivot table..... Once again thank you......
You are most welcome
Daily use cheyyan ullath correct kitty Thanks sir 🙏
Extremely useful video.
Looking forward to more such educational videos.
Thank you and best wishes.
For Filter Alt+D+F+F and Paste special alt+ctrl+v also can use
Excel class very useful and interesting, please give more functions, formula based and text base class
Please xheck the Playlists section for more videos. Playlist of 50+ functions are given below.
ua-cam.com/video/sh4IKt5Wi5U/v-deo.html
You are really stupendous!!! Appreciate for your great efforts Sir👏👏👏👏👌👌👌👌👌👍👍👍👍🙏🙏🙏🙏🙏✌
So nice of you
25 th can be done using control+alt+v
To copy the content frome the above cell to the down cell control+d also can be used
Thank you for sharing the Tip!😀
@@XLnCADMalayalam The content from left sell to right sell/ CTRL+r
Alt+ Enter key ( long time finding this options)👍👍
വളരെ നല്ല അവതരണം, very very informative
Thank you :)
ഒരുപാട് ഒരുപാട് ഒരുപാട് ഉപകാരം ചേട്ടാ..... താങ്ക്യൂ സോ മച്ച്...... 🥰👍🏻
😀
Thanks for another good information 👍🏻👍🏻👍🏻
Very useful and informative. Thanks
Glad it was helpful!
Very helpful short cuts... 👍👍👍 thanks bro....
Very useful video🌹simple presentation...
Thank you :)
Very useful very nice we hope more videos frm your side
Glad to hear that.
You are Dr Ajay Anand or Prof Ajay Anand. I feel knowing nothing about Excel the more I listen to you. Thanks a lot.
My pleasure 😀
Thanks .It is very good presentation .
You are most welcome
As always great lessons in a very professional manner.keep it up sir
Finally found the perfect video 😭❤..Thank you sir 🙌🏻
Appreciate and thank you so much Sir 👍🙏 for the valuable information 👌
Glad to hear that. There is one more video on Excel shortcuts. I recommend to refer that too.
@@XLnCADMalayalam thanks and noted Sir 👍🙏
Useful video..thnku.. thnku so much sir🙏
Most welcome
you reveal a magic world in XL. Very useful..
Glad you think so! :)
Very good method
Thank u very much
Very useful tips tips, can I get this short cuts in excel as you show in video 0:19 please
All these shortcuts are listed in my website
xlncad.com
Thank you you're great
😀🙏
Very useful video 👌 thank you sir
It's my pleasure and thank you for your kind words.
Useful episode, thank you 😊 Appreciate
So nice of you
Useful video…Thanks
Super very helpful appreciate your effort
Glad to hear that
Sir, very usefull video, thnq💓
Most welcome
Sir , well presentation. Its very easy to understand. And we can use alt+ctrl+v shortcut key for paste as value instead of Alt+E+S+V.
Thank you for sharing the Tip.
I must say. Realy nice. One doubt how visible again hidden rows or hidden column
Glad to hear that.
Click on the small Triangle in the Top left corner of the worksheet to select the Entire sheet > Right-click on any Column header (A, B, C etc.) and select Unhide. Every hidden column will become visible.
To unhide Rows, Select the entire sheet, Right-click on any Row header (1, 2, 3 etc.) and select Unhide.
@@XLnCADMalayalam thank u so much for ur concern
How to change case as Capitalise Each Word (First letter of all words in a sentence) ?
Sir njn examinte Annu morning aanu ee video kande Enikku upakaarapettu Thak you sir😍😍😍😍😍
Glad to hear that :)
Very good presentation.
Glad you liked it!
🌟🤩 Ithilum nannayi vere aar paranj tharum... 🌟
Splendid Presentation👍
Thank you! Cheers!
Very simple n excellent
Thank you! Cheers!😀👍
Nice way of presentation 🤝
Thank you 🤝
Excel SHORTCUTS explained excellently
Thank you :)
Please let me know that,Is ther anyway to directly copy a file description(eg.Title,Date) and paste it to excel. Thank you.
Please refer my video on 'How to create list of files in a folder'
Very informative..
Glad you think so!
XL n CAD ന്റെ WORD Help videos ഉണ്ടോ
Excellent instruction, thanks.
Glad it was helpful!
Thangalude video kandanu njan padikunnath,thnk u
Thank u sir you're my teacher
It's my pleasure
ഒരു excel ഷീറ്റിലേക്ക് ഉള്ള ലിങ്ക് track ചെയ്യാൻ ഏത് കീ കോമ്പോ ആണ് ഉപയോഗിക്കേണ്ടത്
Ctrl + [
Really useful.... Thank you..
My pleasure. I have one more video on Excel shortcuts for beginners. Check that too.
Super video very helpful✌️
Thank you 👍
Thank you sir, good class
Always welcome
Good class... Thanks
Glad you liked it
Thanku sir valare help aayi
😀✌️
Concise & clear ...
Thank you :)
Adipoli Video !! Really useful
Excellent work
Thank you
Powli vedio class🥰🤟🤟
Glad to hear that :)
Very useful sir.
Thank you :)
Helpful video... Thanks...
My pleasure :)
very good presentation
Thanks a lot
Sir, organisation chart ഉണ്ടാക്കുന്ന വിധം വീഡിയോ ചെയ്യാമോ
It’s nice 👍🏻
Good information good luck
So nice of you
Good One 🥇
Thank you.
I have more video on Excel Shortcuts. Please check that too.
very useful shortcuts thanks
You are welcome
Please add a contents page showing time to navigate to particular topic
Thank u,,super
Welcome 😊
Sir,PDF file MB kurakkan pattumo, vera oru application use cheyyathai.
You should try a PDF Compression software for that. Google for the term 'Compress PDF'
Very help ful👍
Good presentation ❤👍
Thank you 😀
Sir, As you said last in the video for 200 Short cuts explanation video, could I have please that link? Or still pending?
Your videos are quite appreciable!!
Regards
I am still working on that video and it will take time for the final cut. But you can check these videos on my another UA-cam channel
ua-cam.com/video/ynk01mkeK7Y/v-deo.html
ua-cam.com/video/mRpKwsnydM4/v-deo.html
ua-cam.com/video/kOmPcBY6ap8/v-deo.html
XL n CAD Malayalam 👍🏻
I have added these shortcuts to my website. Pls check.
xlncad.com/excel-shortcuts/
Very useful.
Glad it was helpful!
thank a lot for this video
You are welcome
Great work
Thank you so much 😀
Well explained 👍🏻
Thank you :)
Cursor move aakunna sthalathu highlight cheyyan ulla reethi onnu parayaamo ?
I have done a video on the technique to highlight the Active Cell in a worksheet. Please go through the videos section of this channel to find it.
Highlighting cursor is related to settings of the Operating System.
Very interesting..
Glad you think so!
Than you so much
Very useful ❤️
Thank you. I have one more video on Excel Shortcuts. Pls check that too.
Thank you...
You're welcome!
Excellent explanation! Can we adjust height of wordlines in a cell ? I tried but failed Pls clarify
Alt+E+S+V kidu👍
alt+e+s+f = formula
Hai its very use full thank u so much,, and to create new chart alt+f1 its not working,
Ma kayinja oralk Dca, ms office ' data entry ivayil yethaanu bettr.pls reply
Very Useful 👍
Sir, Could you explain to calculate Over time from Monday to Sunday. Because Monday to Friday after 8 hrs only over time. But week days if any time is over time. How we can calculate over time from Monday to Sunday in single XL sheet
Nammal Oru pad sheetulla Oru documentil sheet 20 kittanamenkil aroo key allatha shortcut enthenkilum undoo
Please refer my video on Excel Name Box
Nammal data enter cheyyumbol thazhoot kure aay kazhiyumbol mukalilathe heading or serial no.kanaan vendi enth cheyyanam
You can use the Freeze pane option for the same.
For example your headings are in Row number 3 and you want the headers to stay visible when you scroll down.
Select Row number 3 > Go to the View tab in the Excel ribbon > Free Panes > Freeze Panes
Another option is using Excel Tables. Please refer to my video on Advantages of using Excel Tables.
Valiya page print cheyyumbo 2 or 3 pagilayitaan print varunnat. Aa varunna paginellam 1st pagile athe heading nganeya varuka......?
Go to the Page Layout tab > Print Titles> in the Page setup dialog, go to the Sheet tab > Rows to Repeat at top > select the rows containing Headers to repeat in every page and click OK
To Insert a Row we can use Alt+I+R
To insert a Column we can use Alt+I+C
Excellent
Thank you :)
very helpfull videos
Glad you think so!
excellent
Thank you
very very helpful
Glad to hear that
How to ലെറ്റർഹെഡ് in എക്സൽ sheet
I will recommend MS Word for this purpose.
I have one doubt. While using "IF" function, can we select a cell in which a date is showing as a result of a formula?
Yes.
@@XLnCADMalayalam it was not working for me, when I used it. May be some error in the format I used. If possible, kindly guide me.
Thank you 😌 sir
My pleasure
Super class sir
Thanks you :)
Thanks🙏🏼
You’re welcome 😊
Oru figure automatic aayi in words mattoru cellil varanulla xl command undo
I have two videos on that Topic (Convert Numbers into Words). Please go through the videos section of this channel to find that videos.
സർ ഡൗട്ട് ചോദിക്കാൻ നമ്മളെ പാസ്പോർട്ട് സ്കാൻ ചെയ്യുമ്പോൾ ഒരുമിച്ച് ഒരു പിഡിഎഫ് ഫയൽ ആക്കാൻ എന്താ മാർഗം
സ്കാൻ ചെയ്യുമ്പോൾ ഓരോ പേജിനു ശേഷവും exit/finish ചെയ്യാതെ പുതിയ പേജ് വെച്ചു scan ചെയ്യുക. എല്ലാ പേജും കഴിഞ്ഞ ശേഷം finish ചെയ്യുക. അപ്പോൾ ഒറ്റ ഫയലായി കിട്ടും.
ഇനി അഥവാ പല പേജ് ആയിട്ടാണെങ്കിലും ശരിയാക്കാം. ADOBE PDF ൽ ഒരു file OPEN ചെയ്താൽ മുകളിൽ ഒരു പച്ച + കാണും. ഇല്ലെങ്കിൽ combine files എന്ന tab കാണും. അതിനു ശേഷം ചേർക്കേണ്ട file ചോദിക്കും. അപ്പോൾ ആവശ്യമുള്ള പേജ് എല്ലാം സെലക്ട് ചെയ്യുക. വേണമെങ്കിൽ പേജുകളുടെ ഓർഡർ മാറ്റാം. എന്നിട്ട് combine ക്ലിക്ക് ചെയ്യുക. ഒറ്റ ഫയലായി വരും. Default ആയി Binder എന്ന പേരായിരിക്കും. അതു ആവശ്യം പോലെ തിരുത്തി save ചെയ്യുക.
Adobe scan play store
word ൽ ഉള്ളത് പോലെ , type ചെയ്യുമ്പോൾ ആദ്യാക്ഷരം capital letter ആയി വരാൻ വല്ല മാർഗ്ഗവും ഉണ്ടോ ?
Proper formula use cheyta madi
=Proper ( select the cell containing text)
Use the formula - Proper
Proper or Flash will key
സർ , ഒരു വലിയ സ്പ്രെഡ് ഷീറ്റ് എങ്ങിനെയാണ് ഒരു A4 പേജിൽ ചുരുക്കി പ്രിൻറ് എടുക്കുന്നത് .. ഒന്ന് വിശദമാക്കാമോ?
You can adjust the number of sheets and more using the Page Setup option.
CTRL + P > Page Setup > in the Page Setup dialog, select the option 'Fit to *1* Page wide by *1* tall'
Njn agarahicha chodhiyam thanks man