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

[@malkeetsinghacademy]

How to use functions in Google sheets mobile app || How to use google sheet functions in mobile app kzbin.info/www/bejne/jYHJq35-md-grKs

[@willart1735]

Amazing content, very helpful saved me loads of messing around

[@malkeetsinghacademy]

Thanks 😊 hope it helped you

[@miraclejackson6709]

The best Video In KZbin on Google sheet.

[@malkeetsinghacademy]

Thank you so much 😊

[@gregchristie2763]

... yes thank you.. first comprehensive beginner's guide..perfect 👌

[@malkeetsinghacademy]

Thank you much Greg ☺️🙏

[@brannzo6147]

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

[@malkeetsinghacademy]

Thank you so much brother 😊😊🙏

[@Srinivasan.Ganesan.]

Excellent presentation. Thank you so much. Awaiting more.

[@malkeetsinghacademy]

Thank you so much brother 😊. Hope it helped you 🙏🙏

[@saisridhiya2135]

This one is very very useful for us. Thank you very much sir.

[@malkeetsinghacademy]

Thanks for watching. Hope it helps you 🙏

[@limahowlader2869]

Onk sundor kore bujhaucen vaia......thank u so so much... Apni ekta app nia joto sundor kore kosto kore bujhaicen emn keo bujhai na

[@malkeetsinghacademy]

Thank you ☺️ Hope it helped you 🙏

[@deeptiagrawal1848]

Really good video....very helpful to me

[@malkeetsinghacademy]

Thank you ☺️

[@atwiinedickson8745]

Thank you so much, surely i have picked alot.

[@malkeetsinghacademy]

Thank you bro 😊

[@ksskss8804]

Very thankful sir I will double thanks

[@malkeetsinghacademy]

Hope it helps you

[@nsmmjoy]

This is very helpful to me. Thanks a lots

[@malkeetsinghacademy]

My pleasure 😊

[@millionairesclub00]

Great content. 👍 Thank you sir

[@malkeetsinghacademy]

Thank you so much ❤️

[@anusthakumari5616]

Thank u so much reallly really really helpful for students like us😊😊

[@malkeetsinghacademy]

Thanks ma'am for watching. Hope this video helped you

[@deelippal4954]

Very very helpful video for beginners

[@malkeetsinghacademy]

Thank you brother 😊

[@khalidgucci1933]

Wow thank 5hat useful

[@malkeetsinghacademy]

Thank you for watching 😊

[@relatenature6996]

I love u dost mai bahut pareshan tha isi ki vajh se tq

[@malkeetsinghacademy]

Thank you so much.

[@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.

[@malkeetsinghacademy]

It's called a filter and you can apply a filter for that

[@GRANDCHILDRENofNANABAWA]

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.

[@malkeetsinghacademy]

Thank you so much Ashraf please go through this video I have explained how to add stars in sheets kzbin.info/www/bejne/bpvMfq2cqNmqm7M

[@sarahclark8554]

Very helpful, thank you! I am also curious how to change the sizes of complete rows and columns.

[@malkeetsinghacademy]

Thank you Sarah. For that select the whole sheet and first change the size of rows and then columns

[@skkhairuzzamam1175]

Thank you so much brother

[@malkeetsinghacademy]

Thanks bro 😊

[@ishfaqahmad9272]

Very much useful video , greatly explained. Thankyou sir.

[@malkeetsinghacademy]

Thank you so much Ishfaq 😊.

[@rajenderbabu9559]

Useful information thanks

[@malkeetsinghacademy]

Thanks sir, hope it helps you 🙏

[@petergarcia4957]

Thanks very much impormative, I want to know how to make signatures in google sheets

[@malkeetsinghacademy]

Thanks 😊. Signatures how like an image

[@hariharan_ashok_kumar]

Thank you very much for your video!

[@malkeetsinghacademy]

Thank you so much 🥰. Hope it helped you 🙏

[@hariharan_ashok_kumar]

Definitely 😊

[@rajenderbabu9559]

good explanation sir

[@malkeetsinghacademy]

Thank you so much Sir ❤️🙏

[@geographyclassroom1794]

Please upload a video about formula...How to understand Syntax?I want a detailed video.

[@malkeetsinghacademy]

Sure sir actually I have made a video on how to use functions in Google sheets mobile app. This is the link kzbin.info/www/bejne/jYHJq35-md-grKs. Hope it helps you 🙏

[@encyclopedia9.6]

Great video... Just tell me how to delete extra column and rows?

[@malkeetsinghacademy]

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

[@rifatsarker03]

Helpful ✌️

[@malkeetsinghacademy]

Thanks ☺️

[@noushadchola6633]

Very good thank you How to send one sheet and how to adjust preview size

[@malkeetsinghacademy]

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

[@Oldies4eva]

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??

[@malkeetsinghacademy]

Thanks for watching you can use Import function in Google sheets to import data from different Google sheets

[@masudakhatun7926]

Oha.... Nice video... But how do use together Google sheet and online any pages.........

[@malkeetsinghacademy]

Share the link to anyone with editing rights

[@msrocksport6482]

Outstanding sir

[@malkeetsinghacademy]

Thanks a lot ❤️🙏

[@sudheeshaalur6412]

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.

[@malkeetsinghacademy]

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

[@anilshingade7212]

Thank you, sir

[@malkeetsinghacademy]

Thank you Anil 🙏

[@mahammadsamsuddin7606]

Sir,please give a video on how to create a salary sheet using Google Sheets on mobile . Thanks.

[@malkeetsinghacademy]

Sure I definitely will make

[@vivekannigeri1495]

Please let us know how to use named range in Google sheets for mobile

[@malkeetsinghacademy]

Sure sir I will explain 👍

[@Olayinkahakeemishola]

Please do for macro and vba. Thanks.

[@malkeetsinghacademy]

Surely I will do 🙏

[@motivationpower1418]

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

[@malkeetsinghacademy]

Thanks for watching 🙏. That is called wrap text. I have made a separate video on that. Here is the link kzbin.info/www/bejne/fIuQdIOEi9F-q6M please check.

[@motivationpower1418]

@@malkeetsinghacademy Thank you very much for valuable information thanks a lot

[@malkeetsinghacademy]

@@motivationpower1418 pleasure is mine. thanks for watching

[@suyakisaneeshwar8506]

Hi sir i have a question how to go spread sheet settings.. refresh one minute in mobile sir

[@malkeetsinghacademy]

Click on settings. You can access it through 3 dotted button on top right corner

[@suyakisaneeshwar8506]

@@malkeetsinghacademy i dont understand pls explain me propper way

[@kamalkant9471]

As tab on laptop to jump into cells what's on mobile for tab option

[@malkeetsinghacademy]

Sorry to say there is no such option for sheets mobile app. You have to manually click on each cell

[@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]

if possible please upload very soon about lock cell, and rows

[@kungkuli4276]

and botton create

[@malkeetsinghacademy]

Thank you bro. Surely I will make the video in that

[@dawn7496]

Thank you!!!!

[@malkeetsinghacademy]

Thank you Dawn 😊

[@aimran006]

How to change page orientation in Google sheets in iPhone

[@malkeetsinghacademy]

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

[@aaliyahhayden3804]

How to create a pivot table in google sheets when using a cell phone?

[@malkeetsinghacademy]

Sure I will definitely help you will post a video on that soon 🙏

[@aaliyahhayden3804]

@@malkeetsinghacademy ok, thanks much🥰

[@malkeetsinghacademy]

@@aaliyahhayden3804 Actually pivot tables could be only added through web browser. Mobile app doesn't have the feature to add Pivot tables

[@AamnaIdrisi]

Have u made a vedio on Google docs?

[@malkeetsinghacademy]

Soon I will make thanks

[@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

[@malkeetsinghacademy]

To protect the sheet you have to use the desktop version of the sheets app. In the mobile version it is not possible

[@alexandermiller1631]

Very helpful, thanks! Background music too loud!

[@malkeetsinghacademy]

Sorry for that I will not add any background music in my future videos 😂

[@kjkiran7760]

How to add numbers in different sheets in mobile application? Thank you bro 😊

[@malkeetsinghacademy]

Numbers like how? In serial order starting from 1 to 100 . I don't understand your question bro

[@kjkiran7760]

@@malkeetsinghacademy 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

[@malkeetsinghacademy]

@@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]

@@malkeetsinghacademy I'm sorry to inform you that this was not my quation. Anyhow thank you soo much

[@kjkiran7760]

@@malkeetsinghacademy I'm sorry to inform you that this was not my quation. Anyhow thank you soo much

[@Shahyan008]

How do I subtract sir horizontal ? From total line 1B my electric billz,rents,food

[@malkeetsinghacademy]

You have to select the cells horizontally

[@Shahyan008]

@@malkeetsinghacademy thank you, now I figure it out

[@MukeshKumar-qg3vs]

Sir how can i selection print in google sheet mobile app.

[@malkeetsinghacademy]

Hello bro Currently selection print is not possible in mobile app. For that you have to use the desktop app

[@anuragpal3303]

Can we see edited history at google sheet with android ?

[@malkeetsinghacademy]

On mobile I don't think there is such an option to see edited history

[@janetcalupasandion2160]

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?

[@malkeetsinghacademy]

Hey there you are talking about the dashboard. You can search on KZbin

[@kristentheologus-KTechnogal]

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.

[@malkeetsinghacademy]

It works the same as on desktop app

[@VivekHegdevj]

How to use add-ons in google sheet by moble app.

[@malkeetsinghacademy]

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

[@rasmeetkour5512]

sometimes in apple send as pdf option doesnt appear ,,whats the reason fr that and how to do that...??

[@malkeetsinghacademy]

Actually it is not suppose to happen but you can check for any updates in sheets application

[@amuworld3948]

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😰

[@malkeetsinghacademy]

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

[@Kiki-oj2uj]

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!

[@malkeetsinghacademy]

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.

[@rameswarhigh8956]

Sir Sir how to select some specific cells, it may not be adjacent cells in an Android mobile in a Google sheet

[@malkeetsinghacademy]

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]

@@malkeetsinghacademy 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?

[@malkeetsinghacademy]

@@donarighi1803 Yes you have to use import range function. It will serve your purpose

[@jaspr144]

Sr how to put start time, end time, hour time in goole sheets app in mobile

[@malkeetsinghacademy]

For that you have to use time function

[@ritaconstanciaf.delacruz1811]

how to page set up in google sheets?thankk you

[@malkeetsinghacademy]

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.

[@MukeshKumar-qg3vs]

How can i print only selection in Android mobile if possible please help me.

[@malkeetsinghacademy]

Sorry bro this feature is not available in sheets mobile app. You have to use desktop app for selecting certain portion of sheet

[@user-Preshylove]

Thanks

[@malkeetsinghacademy]

😊

[@thankuish]

I did not understand how to freeze volume, i repeated the video,but where to select that options.🤔

[@malkeetsinghacademy]

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👍

[@SandyBoone]

I appreciated the video. Next time would you please not put music in the background?

[@malkeetsinghacademy]

Already done ✅

[@moulaali7313]

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.

[@malkeetsinghacademy]

Hello Ali, you can use import range function for using different formulas in different tabs kzbin.info/www/bejne/mHW5aHyYhZKqaKc

[@mohammedabdulkareem1834]

How to use paint format option in g sheet mobile app

[@malkeetsinghacademy]

Actually paint format doesn't work in mobile app. It is currently available in desktop app

[@33bbb]

sir can i make checkboxes on mobile

[@malkeetsinghacademy]

you can make Check boxes in desktop app

[@snippetsofpam184]

How can I insert multiple rows in together on the app?

[@malkeetsinghacademy]

First select multiple rows and then click on arrow icon to add multiple rows

[@malkeetsinghacademy]

Select the rows and then click on insert rows

[@GRANDCHILDRENofNANABAWA]

How to get STAR or tick symbols in GSheets while using mobile or tab??

[@malkeetsinghacademy]

You can use the char function for adding different emojis

[@pm7421]

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? 🙏

[@malkeetsinghacademy]

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

[@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

[@malkeetsinghacademy]

Yes you can I have explained in this video kzbin.info/www/bejne/jYHJq35-md-grKs you can skip and watch how to use the translate function in sheets

[@sundayvictor4367]

Please sir how can i paste different mobile contacts that i have copied elsewhere into the column???

[@malkeetsinghacademy]

Paste them as plate text if there is any + sign before the mobile number remove that also

[@Artcell3288]

Sir please tell how to make Google forms and send it to anyone

[@malkeetsinghacademy]

Hello there I have made a complete video on how to make Google Form in mobile kzbin.info/www/bejne/Z4icqo2bhdF4npo

[@manojkumarverma3852]

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

[@malkeetsinghacademy]

Manoj try with updating the application

[@roshandangi246]

Sir how can i lock cell and row

[@malkeetsinghacademy]

Hello sir actually you can't do that in mobile app

[@hariomsuman25]

how to eneble find in all sheets in google sheet in mobile

[@malkeetsinghacademy]

Find something from all sheets only work in desktop app

[@hariomsuman25]

@@malkeetsinghacademy thanks

[@soumyabandyopadhyay1375]

How can use protect sheet option by android?

[@malkeetsinghacademy]

For that you have to use the desktop app

[@sumitbhowmik7465]

How to use IMPORTRANGE function of Google sheets on mobile phones

[@malkeetsinghacademy]

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 kzbin.info/www/bejne/mHW5aHyYhZKqaKc

[@bharatsingh-mg7ls]

My mobile not show paste special option in the 50:34 app

[@malkeetsinghacademy]

You can use long press or try updating the sheets app

[@nikhiltak6360]

How to download a "selected cells" Pdf through the google sheet mobile app?

[@malkeetsinghacademy]

That is only possible in desktop app. This feature is not available in mobile app.

[@vonchen2744]

Where data validation why I did not see on ios?

[@snehthakker1709]

How to export to pdf but only the selected cells not all

[@malkeetsinghacademy]

Actually there is no option for if you want to print the selected cells or range. This feature is only available in desktop app

[@dilipbhandari1]

How can we delete extra columns and rows in google sheets android mobile app , if possible give reply in hindi language

[@malkeetsinghacademy]

आप मल्टीपल कॉलमन्स को सलेक्ट करके उनको डिलीट कर सकते हो।

[@dilipbhandari1]

@@malkeetsinghacademy हमने करके देखा है लेकिन वह हो नही रहा है कृपया आप एखाद व्हिडिओ डाल के इस का खुलासा करेंगे तो बहुत अच्छा रहेगा धन्यवाद

[@malkeetsinghacademy]

@@dilipbhandari1 आप मुझे whatsaap कर दीजिये 9915230132

[@alokeshize]

How to create macro in Google sheet in mobile

[@malkeetsinghacademy]

In mobile macros doesn't work for that you have to use desktop app

[@meetpatel7205]

How to Marge two google sheet in one sheet with mobile

[@malkeetsinghacademy]

You can use import function to merge two different sheets or use manual method to merge sheets

[@meetpatel7205]

@@malkeetsinghacademy oky

[@meetpatel7205]

@@malkeetsinghacademy But the warn show Please use a desktop Web browser to connect this sheet

[@jaspr144]

Sr How lock cell and range.

[@malkeetsinghacademy]

Locking cell range is only possible in desktop in mobile there is only freeze option

[@alinamorjuri6883]

How to print page satup thank for you

[@malkeetsinghacademy]

Actually page set up can't be done in mobile application you have to use the desktop app for that

[@satyanarayana5784]

How put automatically serial number (in Google sheet) with responses of Google form quiz , by using formula in mobile

[@malkeetsinghacademy]

Simple autofill in your sheet it's very simple

[@shivanisoni5122]

Sir is there no insert tab in google sheet?

[@malkeetsinghacademy]

You have to long press on the cell then you are able to add new tab

[@bhadrabrahma5460]

How to line break in a single cell without using wrap text. Please show.

[@malkeetsinghacademy]

Just add multiple spaces in formula bar it will serve your purpose

[@ShahidKhan-bx1sx]

How to add multiple pictures in rows

[@malkeetsinghacademy]

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]

@@malkeetsinghacademy is there any formula for this

[@malkeetsinghacademy]

@@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.

[@marcjonas7590]

How to put shapes?

[@malkeetsinghacademy]

Actually there is no such option to add shapes but shapes can be added as images.

[@godspeedalbay2814]

How to protect the data on android?

[@malkeetsinghacademy]

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

[@tracyvo7140]

How to freeze the table?

[@malkeetsinghacademy]

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

[@noushadchola6633]

How to send the selected area in google sheets

[@malkeetsinghacademy]

Actually you can't send certain part of the Google sheet but you can send the image of the sheet

[@p.stutorial3134]

How to print out from Google sheets

[@malkeetsinghacademy]

Click on the three dotted button on the right top corner and then select share and export. Here you will find the print option

[@javinpatel]

How to lock specific cell in this sheet

[@malkeetsinghacademy]

To protect a sheet or range, use Google Sheets on a computer. This feature is not available in sheets mobile app yet

[@yourrecommend525]

how to lock certain cell? so it cant be editable

[@malkeetsinghacademy]

Locking cells can't be done in a mobile app. You have to use the desktop version for that

[@zaheermohd2269]

Data validation is not available for me

[@malkeetsinghacademy]

It will be there you can check

[@zaheermohd2269]

@@malkeetsinghacademy no its not