Тёмный

How to use Google Sheets Mobile app | How to use Sheets in mobile app | Complete tutorial 

Malkeet Singh Academy
Подписаться 4,7 тыс.
Просмотров 56 тыс.
50% 1

Video description-
This is video tutorial is a complete step by step tutorial how to use Google sheets in mobile application. How to use Google sheets on mobile app. In this video I have covered all the major topics that everyone going to need beginners to advanced topics covered how to use google sheet mobile application.
This video is divided into different time stamps so you can go to any particular topic that you want.
I hope this video help you in some way.
Timestamps:
0:00 - Introduction to Google Sheets
1:30 - How to use Email ID in Google Sheets
03:41- How to create a Google Sheet in mobile app
05:00 - How to Name Google Sheet in mobile app
06:02 - Basics of Google Sheets in mobile app
09:27 - How to format cells and columns in Google Sheets in mobile app
9:59- How to add dates in Google Sheets using mobile app
11:18- How to add currency format in Google Sheets using mobile app
13:04 - How to use autofill in Google Sheets using mobile app
15:02 - How to delete text in Google Sheets in mobile app
15:49 - How to share Google Sheet through mobile app
16:45 - How to share Google sheet as View only or Commentor or Editor using mobile app
18:04 - How to share Google Sheet as a link to someone through mobile app
19:44 - How customize colors of a Google Sheet in mobile app
22:08 - How to add borders in Google Sheet using mobile app
23:25 - How to rename, duplicate, delete and edit tabs in Google sheets using mobile app
25:20 - How to use find and replace in Google sheets using mobile app
26:11- How to freeze columns and rows in Google sheets using mobile app
28:44 - How to clear all the formatting in Google Sheets using mobile app
30:08 - How to wrap text in Google Sheets using mobile app
32:00 - How to use conditional formatting in Google Sheets in mobile app
34:41 - How to perform data validation in Google Sheets using mobile app
37:02 - How to rotate text in Google sheets using mobile app
38:10 - How to hide column in Google Sheets using mobile app
38:47 - How to multiple rows and columns in Google sheets using mobile app
40:42 - How to use comments in Google sheets in mobile app
42:49 How to add images in Google sheets using mobile app
44:20 - How to add a chart in Google Sheets using mobile app
45:59 - How to use functions and formulas in Google Sheets using mobile app
49:49 - How to use paste special in Google Sheets using mobile app
52:33 - How to use join function in Google Sheets using mobile app
54:36 - How to remove access of your Google sheets using mobile app
55:10 - How to convert Google sheets into excel using mobile app
56:20 - How to star your Google sheet using mobile app
56:50 - How to make offline files in Google sheets using mobile app
57:16 - How to restore or delete Google sheets using mobile app
57:26 - How to apply filter in google sheet mobile app
Subscribe to my channel
Malkeet Singh Academy
Like share and subscribe
#google #sheets #mobile

Опубликовано:

 

30 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 252   
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
How to use functions in Google sheets mobile app || How to use google sheet functions in mobile app ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WPfzKHdzmvI.html
@willart1735
@willart1735 4 месяца назад
Amazing content, very helpful saved me loads of messing around
@malkeetsinghacademy6322
@malkeetsinghacademy6322 4 месяца назад
Thanks 😊 hope it helped you
@miraclejackson6709
@miraclejackson6709 8 месяцев назад
The best Video In RU-vid on Google sheet.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 8 месяцев назад
Thank you so much 😊
@gregchristie2763
@gregchristie2763 2 года назад
... yes thank you.. first comprehensive beginner's guide..perfect 👌
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thank you much Greg ☺️🙏
@Srinivasan.Ganesan.
@Srinivasan.Ganesan. 2 года назад
Excellent presentation. Thank you so much. Awaiting more.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thank you so much brother 😊. Hope it helped you 🙏🙏
@brannzo6147
@brannzo6147 5 месяцев назад
Oh man, this is great. Thank you for the introduction ❤. Til now I thought, that the app is just good for viewing sheets and not for creating and editing. Greetings from Germany
@malkeetsinghacademy6322
@malkeetsinghacademy6322 5 месяцев назад
Thank you so much brother 😊😊🙏
@nsmmjoy
@nsmmjoy 2 месяца назад
This is very helpful to me. Thanks a lots
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 месяца назад
My pleasure 😊
@saisridhiya2135
@saisridhiya2135 3 года назад
This one is very very useful for us. Thank you very much sir.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Thanks for watching. Hope it helps you 🙏
@atwiinedickson8745
@atwiinedickson8745 6 месяцев назад
Thank you so much, surely i have picked alot.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 6 месяцев назад
Thank you bro 😊
@sciwiz55
@sciwiz55 Месяц назад
How do you apply a filter to the first name column to sort it alphabetically but keep all the other rows lined up with the correct first name? When I do what you said only the selected column gets sorted and then it dose not match with what it was originally next to in the next rows.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 6 дней назад
It's called a filter and you can apply a filter for that
@limahowlader2869
@limahowlader2869 2 года назад
Onk sundor kore bujhaucen vaia......thank u so so much... Apni ekta app nia joto sundor kore kosto kore bujhaicen emn keo bujhai na
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thank you ☺️ Hope it helped you 🙏
@ishfaqahmad9272
@ishfaqahmad9272 2 года назад
Very much useful video , greatly explained. Thankyou sir.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thank you so much Ishfaq 😊.
@millionairesclub00
@millionairesclub00 Год назад
Great content. 👍 Thank you sir
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Thank you so much ❤️
@anusthakumari5616
@anusthakumari5616 2 года назад
Thank u so much reallly really really helpful for students like us😊😊
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thanks ma'am for watching. Hope this video helped you
@msrocksport6482
@msrocksport6482 3 года назад
Outstanding sir
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Thanks a lot ❤️🙏
@rifatsarker7432
@rifatsarker7432 Год назад
Helpful ✌️
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Thanks ☺️
@rajenderbabu9559
@rajenderbabu9559 2 года назад
Useful information thanks
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thanks sir, hope it helps you 🙏
@deeptiagrawal1848
@deeptiagrawal1848 Год назад
Really good video....very helpful to me
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Thank you ☺️
@relatenature6996
@relatenature6996 2 года назад
I love u dost mai bahut pareshan tha isi ki vajh se tq
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thank you so much.
@deelippal4954
@deelippal4954 Год назад
Very very helpful video for beginners
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Thank you brother 😊
@hariharan_ashok_kumar
@hariharan_ashok_kumar 2 года назад
Thank you very much for your video!
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thank you so much 🥰. Hope it helped you 🙏
@hariharan_ashok_kumar
@hariharan_ashok_kumar 2 года назад
Definitely 😊
@skkhairuzzamam1175
@skkhairuzzamam1175 Год назад
Thank you so much brother
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Thanks bro 😊
@sarahclark8554
@sarahclark8554 2 года назад
Very helpful, thank you! I am also curious how to change the sizes of complete rows and columns.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thank you Sarah. For that select the whole sheet and first change the size of rows and then columns
@LiveSuperRichLife
@LiveSuperRichLife Год назад
Thank you very much for the holistic coverage sir 🙏👑🏆helps me fully for my inventions documentation!
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Thank you so much 🥰🙏
@LiveSuperRichLife
@LiveSuperRichLife Год назад
@@malkeetsinghacademy6322 welcome Sir 🏆
@dawn7496
@dawn7496 2 года назад
Thank you!!!!
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thank you Dawn 😊
@rajenderbabu9559
@rajenderbabu9559 2 года назад
good explanation sir
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thank you so much Sir ❤️🙏
@GRANDCHILDRENofNANABAWA
@GRANDCHILDRENofNANABAWA 2 года назад
Thank you vary much bro Malkeet Singh..it was beneficial..my query was about Adding STAR 🌟 symbole and tick Mark in G.sheet's column next to a names.. Thank you. Ashraf N.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thank you so much Ashraf please go through this video I have explained how to add stars in sheets ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-8jiMzfstweQ.html
@anilshingade7212
@anilshingade7212 2 года назад
Thank you, sir
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thank you Anil 🙏
@kristentheologus-KTechnogal
@kristentheologus-KTechnogal 9 месяцев назад
Sheets on iPad does not have the data validation option. Some of the other options are in different locations but I can't find any way to make a drop down list.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 9 месяцев назад
It works the same as on desktop app
@petergarcia4957
@petergarcia4957 11 месяцев назад
Thanks very much impormative, I want to know how to make signatures in google sheets
@malkeetsinghacademy6322
@malkeetsinghacademy6322 11 месяцев назад
Thanks 😊. Signatures how like an image
@sudheeshaalur6412
@sudheeshaalur6412 2 года назад
Thank you so much for your work. I need to know one more thing why formula bar is dissappearing when I'm selecting texts in mobile Google sheets. Or is there any option to know the count of texts if I filter any particular column.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thank you Sir for watching 🙏. Well formula bar automatically disappear whenever we select multiple columns or rows. You can apply formula and filter them, there are so many methods to find the count from a given column
@Oldies4eva
@Oldies4eva 2 года назад
Thank you so much, it helped alot however I need more assistance. How can I embed a single tab with info from Google sheets to Google docs??
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Thanks for watching you can use Import function in Google sheets to import data from different Google sheets
@Kiki-oj2uj
@Kiki-oj2uj 2 года назад
Hello sir I have a question about the "Find and Replace" feature in the mobile version. How do I search a word over several sheets, I pressed ctrl+H in my tablet but the find and replace box doesn't show up. Please help sir, thank you kindly!
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Actually there is a find and replace option in the mobile app. You have to click on the 3 dotted button on the top right corner.
@ahmeddin2021
@ahmeddin2021 Год назад
Sir most option are clear but very importAm option is not discuss how protect sheet and formula cells pl explain it thanks best regards ahmed
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
To protect the sheet you have to use the desktop version of the sheets app. In the mobile version it is not possible
@geographyclassroom1794
@geographyclassroom1794 3 года назад
Please upload a video about formula...How to understand Syntax?I want a detailed video.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Sure sir actually I have made a video on how to use functions in Google sheets mobile app. This is the link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WPfzKHdzmvI.html. Hope it helps you 🙏
@mahammadsamsuddin7606
@mahammadsamsuddin7606 6 месяцев назад
Sir,please give a video on how to create a salary sheet using Google Sheets on mobile . Thanks.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 5 месяцев назад
Sure I definitely will make
@kamalkant9471
@kamalkant9471 2 года назад
As tab on laptop to jump into cells what's on mobile for tab option
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Sorry to say there is no such option for sheets mobile app. You have to manually click on each cell
@manojkumarverma3852
@manojkumarverma3852 2 года назад
My enter key is not working properly in google sheet.when i use enter key the certain cell does not change.curser remains in the same cell.i want to next cell by enter key in mobile.please reply
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Manoj try with updating the application
@rasmeetkour5512
@rasmeetkour5512 2 года назад
sometimes in apple send as pdf option doesnt appear ,,whats the reason fr that and how to do that...??
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Actually it is not suppose to happen but you can check for any updates in sheets application
@MUKESHKUMARSHARMA-qg3vs
@MUKESHKUMARSHARMA-qg3vs 2 года назад
How can i print only selection in Android mobile if possible please help me.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Sorry bro this feature is not available in sheets mobile app. You have to use desktop app for selecting certain portion of sheet
@aimran006
@aimran006 3 года назад
How to change page orientation in Google sheets in iPhone
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Actually you have take a print preview of Google sheet. Print option you will find by clicking on the three dotted button on right top corner. When you click on print option you will find to change the orientation of Google sheet
@vivekannigeri1495
@vivekannigeri1495 2 года назад
Please let us know how to use named range in Google sheets for mobile
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Sure sir I will explain 👍
@noushadchola6633
@noushadchola6633 2 года назад
Very good thank you How to send one sheet and how to adjust preview size
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
You can't send a single sheet to someone but you can share the sheet. And print preview is not applicable in mobile app for that you have to use the desktop app
@motivationpower1418
@motivationpower1418 3 года назад
This is awesome ,my question is how to arrange text in single cell like F1. When write a sentence some word show but some word hide .how to correct it within cell. Please reply
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Thanks for watching 🙏. That is called wrap text. I have made a separate video on that. Here is the link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-FZ-CPNVlKuA.html please check.
@motivationpower1418
@motivationpower1418 3 года назад
@@malkeetsinghacademy6322 Thank you very much for valuable information thanks a lot
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
@@motivationpower1418 pleasure is mine. thanks for watching
@aaliyahhayden3804
@aaliyahhayden3804 3 года назад
How to create a pivot table in google sheets when using a cell phone?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Sure I will definitely help you will post a video on that soon 🙏
@aaliyahhayden3804
@aaliyahhayden3804 3 года назад
@@malkeetsinghacademy6322 ok, thanks much🥰
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
@@aaliyahhayden3804 Actually pivot tables could be only added through web browser. Mobile app doesn't have the feature to add Pivot tables
@VivekHegdevj
@VivekHegdevj 3 года назад
How to use add-ons in google sheet by moble app.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
1)You have to click on three dotted at the extreme right top button 2) after that more settings will open up 3) choose add ons option 4) select from the list In mobile app you will not get much options for add-on. There are only few add-on are available
@GRANDCHILDRENofNANABAWA
@GRANDCHILDRENofNANABAWA 2 года назад
How to get STAR or tick symbols in GSheets while using mobile or tab??
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
You can use the char function for adding different emojis
@amuworld3948
@amuworld3948 3 года назад
Bhaiyya..how to go to next line inside the cell..in laptop we use alt+enter..but in phone how to do that..please help i am working from home need this badly😰
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
You have to long press anywhere on the row or column. Then you will be able to add the row or column. To move to next row simply click on the next row or column. It will do
@janetcalupasandion2160
@janetcalupasandion2160 4 месяца назад
Hi, can you a video for daily report for a clothing brand? How to create a daily report for a month. Example, i create a report this day then i want to save it after that i want tp create another report the next day but and so on. But i want to check how many sales or pcs sold in other day, i just dont want to scroll again or go back, can you give some tip to make a day filter?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 4 месяца назад
Hey there you are talking about the dashboard. You can search on RU-vid
@masudakhatun7926
@masudakhatun7926 Год назад
Oha.... Nice video... But how do use together Google sheet and online any pages.........
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Share the link to anyone with editing rights
@suyakisaneeshwar8506
@suyakisaneeshwar8506 Год назад
Hi sir i have a question how to go spread sheet settings.. refresh one minute in mobile sir
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Click on settings. You can access it through 3 dotted button on top right corner
@suyakisaneeshwar8506
@suyakisaneeshwar8506 Год назад
@@malkeetsinghacademy6322 i dont understand pls explain me propper way
@snippetsofpam184
@snippetsofpam184 2 года назад
How can I insert multiple rows in together on the app?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
First select multiple rows and then click on arrow icon to add multiple rows
@Shahyan008
@Shahyan008 2 года назад
How do I subtract sir horizontal ? From total line 1B my electric billz,rents,food
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
You have to select the cells horizontally
@Shahyan008
@Shahyan008 2 года назад
@@malkeetsinghacademy6322 thank you, now I figure it out
@MUKESHKUMARSHARMA-qg3vs
@MUKESHKUMARSHARMA-qg3vs 2 года назад
Sir how can i selection print in google sheet mobile app.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Hello bro Currently selection print is not possible in mobile app. For that you have to use the desktop app
@jaspr144
@jaspr144 2 года назад
Sr how to put start time, end time, hour time in goole sheets app in mobile
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
For that you have to use time function
@thankuish
@thankuish 2 года назад
I did not understand how to freeze volume, i repeated the video,but where to select that options.🤔
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
That option is can selected by clicking non the plus icon at below or long pressing on the sheet. Try with that I have done the same👍
@encyclopedia9.6
@encyclopedia9.6 Год назад
Great video... Just tell me how to delete extra column and rows?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Just select the row or column you want to delete and then long press on your screen. You will find the option to delete row or column
@nikhiltak6360
@nikhiltak6360 2 года назад
How to download a "selected cells" Pdf through the google sheet mobile app?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
That is only possible in desktop app. This feature is not available in mobile app.
@deeptiagrawal1848
@deeptiagrawal1848 Год назад
How can we translate english names into hindi .....please reply ..... By using googale sheets in mob.....it is very necessary for me ......as i m a teacher .....i have to convert 100 students names into hindi......if you can hel p....please make a video .......your video is appreciable
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Yes you can I have explained in this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WPfzKHdzmvI.html you can skip and watch how to use the translate function in sheets
@sundayvictor4367
@sundayvictor4367 2 года назад
Please sir how can i paste different mobile contacts that i have copied elsewhere into the column???
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Paste them as plate text if there is any + sign before the mobile number remove that also
@ritaconstanciaf.delacruz1811
@ritaconstanciaf.delacruz1811 3 года назад
how to page set up in google sheets?thankk you
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Actually you will not get much options for page setup in Google sheets but you can try save or export Google sheet into pdf and from there you can have the option for page orientation and changing page type while you are saving the Google sheet.
@anuragpal3303
@anuragpal3303 2 года назад
Can we see edited history at google sheet with android ?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
On mobile I don't think there is such an option to see edited history
@mohammedabdulkareem1834
@mohammedabdulkareem1834 2 года назад
How to use paint format option in g sheet mobile app
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Actually paint format doesn't work in mobile app. It is currently available in desktop app
@Olayinkahakeemishola
@Olayinkahakeemishola 2 года назад
Please do for macro and vba. Thanks.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Surely I will do 🙏
@pm7421
@pm7421 3 года назад
1. How to add signature on sheet? 2. When file saved on drive it has insert image option but when saved on device it hasn't the option insert image. Is it mandatory to save file on drive for getting that insert image option? 🙏
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Hello there. Insert image works in both either to select from mobile memory or from drive. Actually you have click on ok ( Tick ) button so that you sheets changes could be saved. And similarly you can add your signature in sheet
@kamleshram5314
@kamleshram5314 3 года назад
😀
@snehthakker1709
@snehthakker1709 3 года назад
How to export to pdf but only the selected cells not all
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Actually there is no option for if you want to print the selected cells or range. This feature is only available in desktop app
@moulaali7313
@moulaali7313 2 года назад
Hi bro Please let me know how to apply formulas in different tabs. In a single sheet we can apply the formulas What to do when we need to get the data in different tabs in the same sheet.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Hello Ali, you can use import range function for using different formulas in different tabs ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bDV7IbP-w2E.html
@rameswarhigh8956
@rameswarhigh8956 3 года назад
Sir Sir how to select some specific cells, it may not be adjacent cells in an Android mobile in a Google sheet
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
For that you have to click on the right top corner and there you can go to any cell just type in the name or number of the cell
@donarighi1803
@donarighi1803 2 года назад
@@malkeetsinghacademy6322 sir, is it possible to link a cell from a different sheet while entering a formula? On desktop version, it is just click at the different sheet, then select the desired range.. But on mobile version, everytime I type =, the sheet bar disappear instantly.. so I cannot refer a cell from different sheet, unless I type the name of the sheet manually, and typing the range of cells manually😥 which is not time efficient can you please tell me how?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
@@donarighi1803 Yes you have to use import range function. It will serve your purpose
@kungkuli4276
@kungkuli4276 Год назад
hi sir your video is great 👍 but missing an important topic that is how to lock rows and sheets it is very important to know how to lock so I'm waiting for your next video
@kungkuli4276
@kungkuli4276 Год назад
if possible please upload very soon about lock cell, and rows
@kungkuli4276
@kungkuli4276 Год назад
and botton create
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Thank you bro. Surely I will make the video in that
@Artcell3288
@Artcell3288 2 года назад
Sir please tell how to make Google forms and send it to anyone
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Hello there I have made a complete video on how to make Google Form in mobile ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1W9yZePlEh8.html
@atwiinedickson8745
@atwiinedickson8745 6 месяцев назад
How do i calculate percentages on different amounts of money.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 5 месяцев назад
You can use currency function
@SandyBoone
@SandyBoone 2 года назад
I appreciated the video. Next time would you please not put music in the background?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Already done ✅
@AamnaIdrisi
@AamnaIdrisi Год назад
Have u made a vedio on Google docs?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Soon I will make thanks
@sumitbhowmik7465
@sumitbhowmik7465 3 года назад
How to use IMPORTRANGE function of Google sheets on mobile phones
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Hello sir thanks a lot for watching my video. I have made a video on your request. How to use IMPORTRANGE function in Google sheets mobile app. Here is the video link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bDV7IbP-w2E.html
@soumyabandyopadhyay1375
@soumyabandyopadhyay1375 2 года назад
How can use protect sheet option by android?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
For that you have to use the desktop app
@satyanarayana5784
@satyanarayana5784 Год назад
How put automatically serial number (in Google sheet) with responses of Google form quiz , by using formula in mobile
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Simple autofill in your sheet it's very simple
@roshandangi246
@roshandangi246 2 года назад
Sir how can i lock cell and row
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Hello sir actually you can't do that in mobile app
@hariomsuman25
@hariomsuman25 Год назад
how to eneble find in all sheets in google sheet in mobile
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Find something from all sheets only work in desktop app
@hariomsuman25
@hariomsuman25 Год назад
@@malkeetsinghacademy6322 thanks
@alinamorjuri6883
@alinamorjuri6883 2 года назад
How to print page satup thank for you
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Actually page set up can't be done in mobile application you have to use the desktop app for that
@33bbb
@33bbb 3 года назад
sir can i make checkboxes on mobile
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
you can make Check boxes in desktop app
@alexandermiller1631
@alexandermiller1631 Год назад
Very helpful, thanks! Background music too loud!
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Sorry for that I will not add any background music in my future videos 😂
@vonchen2744
@vonchen2744 4 месяца назад
Where data validation why I did not see on ios?
@alokeshize
@alokeshize 10 месяцев назад
How to create macro in Google sheet in mobile
@malkeetsinghacademy6322
@malkeetsinghacademy6322 9 месяцев назад
In mobile macros doesn't work for that you have to use desktop app
@shreenivaspotnis4680
@shreenivaspotnis4680 5 месяцев назад
How to format numbers?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 месяца назад
hello sir i dont understand your question
@bharatsingh-mg7ls
@bharatsingh-mg7ls Год назад
My mobile not show paste special option in the 50:34 app
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
You can use long press or try updating the sheets app
@bhadrabrahma5460
@bhadrabrahma5460 Год назад
How to line break in a single cell without using wrap text. Please show.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 Год назад
Just add multiple spaces in formula bar it will serve your purpose
@jaspr144
@jaspr144 2 года назад
Sr How lock cell and range.
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Locking cell range is only possible in desktop in mobile there is only freeze option
@dilipbhandari1
@dilipbhandari1 3 года назад
How can we delete extra columns and rows in google sheets android mobile app , if possible give reply in hindi language
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
आप मल्टीपल कॉलमन्स को सलेक्ट करके उनको डिलीट कर सकते हो।
@dilipbhandari1
@dilipbhandari1 3 года назад
@@malkeetsinghacademy6322 हमने करके देखा है लेकिन वह हो नही रहा है कृपया आप एखाद व्हिडिओ डाल के इस का खुलासा करेंगे तो बहुत अच्छा रहेगा धन्यवाद
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
@@dilipbhandari1 आप मुझे whatsaap कर दीजिये 9915230132
@tracyvo7140
@tracyvo7140 3 года назад
How to freeze the table?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Select from the freeze multiple rows from the bottom or select the table rows or columns and then long press on the screen. Then select freeze option
@avatarsingh6736
@avatarsingh6736 2 года назад
How to go to specific cell ?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Well you can select a particular cell through formula bar. But there is no right option for going to a particular cell
@javinpatel
@javinpatel 3 года назад
How to lock specific cell in this sheet
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
To protect a sheet or range, use Google Sheets on a computer. This feature is not available in sheets mobile app yet
@marcjonas7590
@marcjonas7590 3 года назад
How to put shapes?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Actually there is no such option to add shapes but shapes can be added as images.
@kjkiran7760
@kjkiran7760 2 года назад
How to add numbers in different sheets in mobile application? Thank you bro 😊
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Numbers like how? In serial order starting from 1 to 100 . I don't understand your question bro
@kjkiran7760
@kjkiran7760 2 года назад
@@malkeetsinghacademy6322 example: In sheet1 'X' cell is having some value , In Sheet2 'Y' cell is having some value, In Sheet3 'Z' cell is having some value and so on then I want to add all these X,Y,Z.....so on cells values in Mobile Google sheet app...... Thank you bro
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
@@kjkiran7760 oh just type 1 in first cell and then type 2 in second cell which is immediately below it and then select the whole cells either below or right just long press then select the option autofill. Then it will fill all the cells with the values.
@kjkiran7760
@kjkiran7760 2 года назад
@@malkeetsinghacademy6322 I'm sorry to inform you that this was not my quation. Anyhow thank you soo much
@kjkiran7760
@kjkiran7760 2 года назад
@@malkeetsinghacademy6322 I'm sorry to inform you that this was not my quation. Anyhow thank you soo much
@shivanisoni5122
@shivanisoni5122 2 года назад
Sir is there no insert tab in google sheet?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
You have to long press on the cell then you are able to add new tab
@godspeedalbay2814
@godspeedalbay2814 3 года назад
How to protect the data on android?
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Actually to protect a sheet or range, you have to use Google Sheets on a computer. Currently this feature doesn't come in mobile app
@noushadchola6633
@noushadchola6633 3 года назад
How to send the selected area in google sheets
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Actually you can't send certain part of the Google sheet but you can send the image of the sheet
@yourrecommend525
@yourrecommend525 2 года назад
how to lock certain cell? so it cant be editable
@malkeetsinghacademy6322
@malkeetsinghacademy6322 2 года назад
Locking cells can't be done in a mobile app. You have to use the desktop version for that
@ShahidKhan-bx1sx
@ShahidKhan-bx1sx 3 года назад
How to add multiple pictures in rows
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Actually you have do it one by one. Just click on the plus icon and add one picture at a time inside a cell or over a cell. Google sheets doesn't have option to select multiple pictures at once
@ShahidKhan-bx1sx
@ShahidKhan-bx1sx 3 года назад
@@malkeetsinghacademy6322 is there any formula for this
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
@@ShahidKhan-bx1sx To insert images, all you can do is insert the url of the image on the =IMAGE(url) function, which transforms this url in their graphic representation, so if the function only lets you add a single image, that is all you can do.
@p.stutorial3134
@p.stutorial3134 3 года назад
How to print out from Google sheets
@malkeetsinghacademy6322
@malkeetsinghacademy6322 3 года назад
Click on the three dotted button on the right top corner and then select share and export. Here you will find the print option
Далее
Create a Button that works in mobile in Google Sheets
13:38
Make Your Google Sheets Look PRO in Under 10 Minutes!
9:25
Google Sheets - 5 Reason To Use Google Sheets
10:19
Просмотров 620 тыс.
10 Google Sheets Tips You DON'T Want to Miss
13:51
Просмотров 561 тыс.
How To Use Google Sheets
7:34
Просмотров 487 тыс.
15 Functions in Google Sheets You NEED to know!
17:30
Просмотров 424 тыс.