How to use functions in Google sheets mobile app || How to use google sheet functions in mobile app kzread.info/dash/bejne/iYSa3K2BlN3Tpqw.html

Amazing content, very helpful saved me loads of messing around

@malkeetsinghacademy6322

4 ай бұрын

Thanks 😊 hope it helped you

The best Video In KZread on Google sheet.

@malkeetsinghacademy6322

8 ай бұрын

Thank you so much 😊

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

@malkeetsinghacademy6322

2 жыл бұрын

Thank you much Greg ☺️🙏

Excellent presentation. Thank you so much. Awaiting more.

@malkeetsinghacademy6322

2 жыл бұрын

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

This is very helpful to me. Thanks a lots

@malkeetsinghacademy6322

2 ай бұрын

My pleasure 😊

Very much useful video , greatly explained. Thankyou sir.

@malkeetsinghacademy6322

2 жыл бұрын

Thank you so much Ishfaq 😊.

Thank you so much, surely i have picked alot.

@malkeetsinghacademy6322

6 ай бұрын

Thank you bro 😊

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

@malkeetsinghacademy6322

3 жыл бұрын

Thanks for watching. Hope it helps you 🙏

Great content. 👍 Thank you sir

@malkeetsinghacademy6322

Жыл бұрын

Thank you so much ❤️

Useful information thanks

@malkeetsinghacademy6322

2 жыл бұрын

Thanks sir, hope it helps you 🙏

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

5 ай бұрын

Thank you so much brother 😊😊🙏

Thank you!!!!

@malkeetsinghacademy6322

2 жыл бұрын

Thank you Dawn 😊

Thank you so much brother

@malkeetsinghacademy6322

Жыл бұрын

Thanks bro 😊

Thank you very much for your video!

@malkeetsinghacademy6322

2 жыл бұрын

Thank you so much 🥰. Hope it helped you 🙏

@hariharan_ashok_kumar

2 жыл бұрын

Definitely 😊

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

@malkeetsinghacademy6322

2 жыл бұрын

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

Very very helpful video for beginners

@malkeetsinghacademy6322

Жыл бұрын

Thank you brother 😊

Helpful ✌️

@malkeetsinghacademy6322

Жыл бұрын

Thanks ☺️

Really good video....very helpful to me

@malkeetsinghacademy6322

Жыл бұрын

Thank you ☺️

Thank you, sir

@malkeetsinghacademy6322

2 жыл бұрын

Thank you Anil 🙏

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

@malkeetsinghacademy6322

2 жыл бұрын

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

Outstanding sir

@malkeetsinghacademy6322

3 жыл бұрын

Thanks a lot ❤️🙏

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

4 күн бұрын

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

Thank you very much for the holistic coverage sir 🙏👑🏆helps me fully for my inventions documentation!

@malkeetsinghacademy6322

Жыл бұрын

Thank you so much 🥰🙏

@LiveSuperRichLife

Жыл бұрын

@@malkeetsinghacademy6322 welcome Sir 🏆

good explanation sir

@malkeetsinghacademy6322

2 жыл бұрын

Thank you so much Sir ❤️🙏

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

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

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

@malkeetsinghacademy6322

2 жыл бұрын

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

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

2 жыл бұрын

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

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

2 жыл бұрын

Thank you ☺️ Hope it helped you 🙏

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

2 жыл бұрын

Thank you so much Ashraf please go through this video I have explained how to add stars in sheets kzread.info/dash/bejne/ap6dr9yfo9fdlbQ.html

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

@malkeetsinghacademy6322

11 ай бұрын

Thanks 😊. Signatures how like an image

How to change page orientation in Google sheets in iPhone

@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

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

@malkeetsinghacademy6322

2 жыл бұрын

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

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

9 ай бұрын

It works the same as on desktop app

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

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.

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

@malkeetsinghacademy6322

2 жыл бұрын

Thank you so much.

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

@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

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

@malkeetsinghacademy6322

2 жыл бұрын

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

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

@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

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

@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

Can we see edited history at google sheet with android ?

@malkeetsinghacademy6322

2 жыл бұрын

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

how to page set up in google sheets?thankk you

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

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

@malkeetsinghacademy6322

2 жыл бұрын

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

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

3 жыл бұрын

Thanks for watching 🙏. That is called wrap text. I have made a separate video on that. Here is the link kzread.info/dash/bejne/eI5hpbKHhs-xpaQ.html please check.

@motivationpower1418

3 жыл бұрын

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

@malkeetsinghacademy6322

3 жыл бұрын

@@motivationpower1418 pleasure is mine. thanks for watching

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

4 ай бұрын

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

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

@malkeetsinghacademy6322

3 жыл бұрын

Sure sir actually I have made a video on how to use functions in Google sheets mobile app. This is the link kzread.info/dash/bejne/iYSa3K2BlN3Tpqw.html. Hope it helps you 🙏

How can use protect sheet option by android?

@malkeetsinghacademy6322

2 жыл бұрын

For that you have to use the desktop app

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

@malkeetsinghacademy6322

2 жыл бұрын

Sure sir I will explain 👍

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

@malkeetsinghacademy6322

2 жыл бұрын

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

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

@malkeetsinghacademy6322

3 жыл бұрын

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

@aaliyahhayden3804

3 жыл бұрын

@@malkeetsinghacademy6322 ok, thanks much🥰

@malkeetsinghacademy6322

3 жыл бұрын

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

How to print page satup thank for you

@malkeetsinghacademy6322

2 жыл бұрын

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

How do i calculate percentages on different amounts of money.

@malkeetsinghacademy6322

5 ай бұрын

You can use currency function

How to use paint format option in g sheet mobile app

@malkeetsinghacademy6322

2 жыл бұрын

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

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

@malkeetsinghacademy6322

Жыл бұрын

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

@suyakisaneeshwar8506

Жыл бұрын

@@malkeetsinghacademy6322 i dont understand pls explain me propper way

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

@malkeetsinghacademy6322

2 жыл бұрын

For that you have to use time function

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

2 жыл бұрын

Manoj try with updating the application

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

@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

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

@malkeetsinghacademy6322

2 жыл бұрын

You can use the char function for adding different emojis

Have u made a vedio on Google docs?

@malkeetsinghacademy6322

Жыл бұрын

Soon I will make thanks

Sir how can i lock cell and row

@malkeetsinghacademy6322

2 жыл бұрын

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

Please do for macro and vba. Thanks.

@malkeetsinghacademy6322

2 жыл бұрын

Surely I will do 🙏

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

@malkeetsinghacademy6322

2 жыл бұрын

You have to select the cells horizontally

@Shahyan008

2 жыл бұрын

@@malkeetsinghacademy6322 thank you, now I figure it out

sir can i make checkboxes on mobile

@malkeetsinghacademy6322

2 жыл бұрын

you can make Check boxes in desktop app

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

@malkeetsinghacademy6322

2 жыл бұрын

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

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

2 жыл бұрын

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

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

@malkeetsinghacademy6322

5 ай бұрын

Sure I definitely will make

Sr How lock cell and range.

@malkeetsinghacademy6322

2 жыл бұрын

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

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

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

How to create macro in Google sheet in mobile

@malkeetsinghacademy6322

9 ай бұрын

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

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

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

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

Жыл бұрын

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

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

@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

How to use IMPORTRANGE function of Google sheets on mobile phones

@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 kzread.info/dash/bejne/lHiKmaubgJDdYqg.html

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

@malkeetsinghacademy6322

Жыл бұрын

Find something from all sheets only work in desktop app

@hariomsuman25

Жыл бұрын

@@malkeetsinghacademy6322 thanks

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

@malkeetsinghacademy6322

Жыл бұрын

Simple autofill in your sheet it's very simple

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

@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

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

2 жыл бұрын

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

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

@malkeetsinghacademy6322

Жыл бұрын

Share the link to anyone with editing rights

How to format numbers?

@malkeetsinghacademy6322

3 ай бұрын

hello sir i dont understand your question

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

2 жыл бұрын

Hello Ali, you can use import range function for using different formulas in different tabs kzread.info/dash/bejne/lHiKmaubgJDdYqg.html

Sir is there no insert tab in google sheet?

@malkeetsinghacademy6322

2 жыл бұрын

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

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

@malkeetsinghacademy6322

Жыл бұрын

You can use long press or try updating the sheets app

How to put shapes?

@malkeetsinghacademy6322

3 жыл бұрын

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

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

@malkeetsinghacademy6322

2 жыл бұрын

Hello there I have made a complete video on how to make Google Form in mobile kzread.info/dash/bejne/Y4tt27yegM-rmJs.html

How to lock specific cell in this sheet

@malkeetsinghacademy6322

3 жыл бұрын

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

Where data validation why I did not see on ios?

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

Жыл бұрын

Yes you can I have explained in this video kzread.info/dash/bejne/iYSa3K2BlN3Tpqw.html you can skip and watch how to use the translate function in sheets

How to freeze the table?

@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

how to lock certain cell? so it cant be editable

@malkeetsinghacademy6322

2 жыл бұрын

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

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

@malkeetsinghacademy6322

Жыл бұрын

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

How to send the selected area in google sheets

@malkeetsinghacademy6322

3 жыл бұрын

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

How to protect the data on android?

@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

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

@malkeetsinghacademy6322

2 жыл бұрын

Already done ✅

How to go to specific cell ?

@malkeetsinghacademy6322

2 жыл бұрын

Well you can select a particular cell through formula bar. But there is no right option for going to a particular cell

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

@malkeetsinghacademy6322

3 жыл бұрын

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

@dilipbhandari1

3 жыл бұрын

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

@malkeetsinghacademy6322

3 жыл бұрын

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

How to Marge two google sheet in one sheet with mobile

@malkeetsinghacademy6322

2 жыл бұрын

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

@meetpatel7205

2 жыл бұрын

@@malkeetsinghacademy6322 oky

@meetpatel7205

2 жыл бұрын

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

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

@malkeetsinghacademy6322

Жыл бұрын

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

How to print out from Google sheets

@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

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

@malkeetsinghacademy6322

2 жыл бұрын

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

@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

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

2 жыл бұрын

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

@kjkiran7760

2 жыл бұрын

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

😀

How to add multiple pictures in rows

@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

3 жыл бұрын

@@malkeetsinghacademy6322 is there any formula for this

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