Thank you. I have been using Google Sheets for years and for the first time tried with the IPad. The UI does not have all of the icons and it looked like the functionality had been paired down. I thought Google had gotten into trouble from Excel. I can see it’s all their because of the video. Many thanks.
@parebalo2000
11 ай бұрын
Thank You!!! This was so clear. It answered so many of my questions/frustrations that I could not find anywhere else!!! 😊😊😊
@rogersledz6793
3 жыл бұрын
Thank you so much for uploading this video. It is helping me get through the pandemic!
@alireinhold3125
4 жыл бұрын
How can I copy a formula for the entire column
@queen.azizah
Жыл бұрын
Yeeaah this my problem too
@Spoons0810
4 жыл бұрын
How do you select multiple cells at the same time that are not next to eachother, so for example: a cell from row one and a cell from row 4
@messnomoreorganizing
7 ай бұрын
Thank you, I was having a problem figuring out how to use the freeze feature on I-pad since I am a windows user but was helping someone on an I-pad. Problem solved :-) thanks a bunch.
@jdrobins0832
5 жыл бұрын
Is there a way to manually enter the cells height and width? When I press down on them, it only tries to move the entire column
@jacquelinegross9037
4 жыл бұрын
Very informative. Thank you!
@thelivingword6930
Жыл бұрын
This was very helpful. Thanks.
@gismaker1015
3 жыл бұрын
Hi Bit by Bye thanks for your helpful Video. I am currently uses a Logitech Folio Keyboard and have a difficult time navigating around the spreadsheet, I only can press the command and arrow key to move sideway but not up and down, and also my touchpad doesn't work when I try to slide the sheet up and down with two fingers. Is that happen to you as well ?? I hope to have your assist, thank you very much.
@GoldChopper
Жыл бұрын
have a question ? Any way to modify text or values in multiple cells within a column? Don’t want to type like 50 times of the same number per cell.
@shrougabdullah5708
4 жыл бұрын
Is there any way that I can write in a cell as the following order: 1- 2- 3- It seems impossible at the moment! It shows in one line like 1-2-3- , I wish anyone can help. Thanks
@jonmui40
3 жыл бұрын
No u cant
@Demy1970
9 ай бұрын
Excellent video question, I use this for one of my boxing board games and the template is established. I enter the information, fight is done and I have results, how do I go back with a clean slate of a template? Do I need to copy the blank template before using? 2. How do I save it as a final copy. Thanks
@Rg1989.
3 ай бұрын
I have a problem I have several pages on a cell I have to enter a formula fx = and go find another cell on another page to copy and paste it but when I want to go to another page I have to click on the 'check on the left above to see the other pages and that cancels my fx= and it puts an error I cannot go to another page select a cell to add it in my fx = formula because the = does not remain activated. whereas on Microsoft I see all my pages I click and paste the formula. iPad I don't know how to do it
@sampool2011
2 жыл бұрын
Brilliant video. Very well spoken and easy to follow and understand 👍
@toneranger
2 жыл бұрын
Thank you, how can I drag copy a cell so the text or formula in the cell is copyied to the rows below AUTOFILL as far down as I select ? How can you add a new line in a cell ?
@JuliusSDeLaCruz
2 жыл бұрын
Hi! How do I move just one cell or a group of cells?
@xBabyDassWassup
2 жыл бұрын
How do you activate a cell selection option for sharing as a pdf? On the desktop version you just print to pdf and it gives you the option of saving a page range, tabs, cell selection etc. I can't find that option on the iPad 😩
@samratspeaks
4 жыл бұрын
How to change the size of column in the ipad?
@Empe-kl1cj
4 жыл бұрын
How do I insert a checkbox?? I’ve looked everywhere and normally it would be in the insert menu but it’s not...
@tulasirakesh007
2 жыл бұрын
Thank you. So everyone else showing desktop version of Google sheets.
@heey_panda
3 жыл бұрын
How I can pin a column for always see it on the sheet?
@carmeltaylor2719
Жыл бұрын
When I send the schedule in email, it doesn’t send. 😢
@blesss1271
Жыл бұрын
How to make a cell an absolute value?
@greggnelson5665
2 жыл бұрын
My google sheets on ipad does not have the format cell capabilities any comment?
@persadsanjay
4 жыл бұрын
How do I copy a bar graph from google sheets to docs on my iPad?
@Flowersandshotguns
3 жыл бұрын
How can I print the sheet in a horizontal landscape from iPad?
@catmurat73
3 жыл бұрын
Can you help me to setup my page to landscape instead of portrait in the app? When I send a copy there is a 137 pages (all blank) and not only my only page to send, THX
@catmurat73
3 жыл бұрын
I do not have a printer home as well… I can’t change the setting in the print section
@dalecaldwell8382
3 жыл бұрын
There appears to be no way to print a spreadsheet from Google Sheets on IPad in Landscape; under “more” the chose to change orientation we find in Google Docs does not exist. Do you have a work around?
@dalecaldwell8382
3 жыл бұрын
My plan is to edit on the bigger I Pad and Print from my Android Cell Sheets App which has the needed option to change orientation; will comment on the outcome
@seapark1792
4 жыл бұрын
Great beginner tutorial, thank you. I found it very helpful as I am making the transition from excel to google sheet. I just got a new iPad and found out my existing excel subscription on the old iPad does not apply to the new iPad). Goodbye excel, hello google sheet!
@curtiscruise1298
4 жыл бұрын
How can you select two non adjacent columns?
@anandvijay6234
3 жыл бұрын
CAN YOU COPY AND PASTE MULTIPLE CELLS IN PAD ....??
@MKMTG
3 жыл бұрын
If they are adjacent cells, yes.
@uchihaitachi6810
3 жыл бұрын
Thanks
@imanali4743
4 жыл бұрын
can i add data validation on Ipad_
@AdreyThe
4 жыл бұрын
where is the alternative color menu?
@dmurphy6151
Жыл бұрын
As far as I can see, everything in this video can also be applied to Android Tablets
@Columbiana212
Жыл бұрын
@17:01 How to create a filter.
@eijereichero
3 жыл бұрын
Been a user of MS Excel for over a decade and just a few months ago started using Google Sheets on my iPad. Anybody knows how to disable the auto-hide option of tabs whenever we start working on the cells? I am trying to add some numbers from different tabs and unable to successfully do so coz of the formula bar at the bottom that keeps on popping up. Thanks much! UPDATE: Figured out the annoying way to add them by manually typing the formula, but if there’s a quicker way, please let me know. :-)
@rico2898
3 жыл бұрын
is it free to use google sheets on ipad?
@eijereichero
3 жыл бұрын
@@rico2898 Yes. Just need a Google account.
@rico2898
3 жыл бұрын
@@eijereichero okay 😉
@mewtwo3291
3 жыл бұрын
How do you add checkboxes on your XL sheet?
@o0Yusuke0o
Жыл бұрын
you have to open the google sheet on you computer the click Insert and add the checkbox, and use it on your ipad and iphone.
@mewtwo3291
Жыл бұрын
@@o0Yusuke0o thanks
@mylifestyle.mywholefamily6887
3 жыл бұрын
Teach me sir
@williamtay741
4 жыл бұрын
Okay correct me if I am wrong but the mobile version app crap. I had 2 cells for some god damn reason google round off my 2 decimal paces to whole number. I had to go into a desktop to fix their cock up as nothing worked on mobile. Why the fuck would google round off my decimal place without me asking to do it and why can you not fix it on mobile?
@MKMTG
4 жыл бұрын
You can. 11:40
@williamtay741
4 жыл бұрын
Okay I saw it thanks, I was too pissed off with the app that I did not look properly. My bad I Guess. Honestly though if I am trying to make it work with an ipad for College/Uni will it work? I am business major, I will be working a lot with sheets and docs
@MKMTG
4 жыл бұрын
What iPad do you have? I strongly suggest using a keyboard and mouse/trackpad as part of your setup. To be honest the Google apps are very underdeveloped and only good for light editing. I use Google Docs/Sheets/Slides very often but I use Safari for this on the iPad instead of the Google apps. I’ve been pretty much iPad only for this (I’m a teacher) since March and it’s been fine.
@williamtay741
4 жыл бұрын
Bit By Byte I am planning to buy the base model ipad 7th gen 10.2 with 128 GB. I plan to pair it with a Bluetooth keyboard as Apple keyboards are over priced. Can you use Safira version of Google doc or sheets on the ipad 7th gen, 10.2 inch version?
@MKMTG
4 жыл бұрын
Yes this will work fine. I’d recommend getting a mouse/trackpad though. The buttons and menu items in Safari will be smaller than on the app, so it’ll be easier to use with a mouse.
@santawansanpha-asa3408
4 жыл бұрын
9:12
@saradefranco5831
4 жыл бұрын
How do I add a new line in one cell, I want to make a list in one cell! On my MacBook Air it was just ALT + Enter/Return, but I can’t figure it out on my iPad Pro. Thanks so much!
@nrzztk
4 жыл бұрын
Sara De Franco hey! May i know if you figured it out?
@cami8892
4 жыл бұрын
Sara De Franco ugh same!!! 😩😩😩 i've been looking everywhere and i didn't find anything i'm so pissed
@selmaisabelsaravialuna
3 жыл бұрын
Same here¡
@BingL211
3 жыл бұрын
Hi, Has this been resolved? Would like to know the solution if you know 😀
@shaimaahmad9837
3 жыл бұрын
Have you figured it out yet
@rameenmalik6996
3 жыл бұрын
Very helpful! Thank you.
@vinehtanwar2734
Жыл бұрын
How do i use a line break inside a cell
@roxiemullinix6551
3 жыл бұрын
Excellent. Everything was taught clearly and slowly. You made it easy to understand. But now I got it! I just wanted a simple spreadsheet to track store purchases. You’re a very good teacher. Many of these KZitem videos explain things so quickly that’s it’s hard to follow. Thank you. Now if I could just find a good Affinity Photo for iPad video.
@bo.slo7h815
7 ай бұрын
How to search inside sheet, like ctrl + f on pc
@abrols
2 жыл бұрын
How do one insert a cell value from another worksheet?
@howaboutno2614
4 жыл бұрын
thank you!! needed this for a project:)
@jenefairfernando4628
3 жыл бұрын
Thank you for the info! Can I use the apple pencil to check a box or something rather than to write on the sheet itself?
@fermicarus
Жыл бұрын
is there any way to use paste special in mobile version of spreadsheet?
@obayev
5 жыл бұрын
Thank you so much 🙏 Your video really helped me! And, as a bonus, I quite enjoyed its beauty and simplicity 👍👍👍
@Dgsmnt
5 жыл бұрын
Thank you for this tutorial I’ve been so lost on how to use this app lol!
@stachu5006
4 жыл бұрын
Charlotte R yh it makes no sense
@MKMTG
3 жыл бұрын
If you liked this video, I would be *incredibly* grateful if you subscribed! Let me know if you did in the comments below, always good to chat to new people! :) If this video was useful, you can leave a tip on my Buy Me a Coffee page: www.buymeacoffee.com/buzzkeil
@shaunsart
9 ай бұрын
On my iPad , my A symbol top right of header I don’t have lines beside it like you do. Mine is a plain A. I don’t have the options you do on that A
@diniramdhaniar9354
4 жыл бұрын
Can you insert line break in google sheets for ipad without any formula? If you using PC just click alt+enter, or in Mac using option+return. But I can’t insert line break in iPad.
@imopn
4 жыл бұрын
Googles apps on iPad are starting to fall behind fast. They are still treating iPad like a large mobile. Hope they get all their apps on feature parity with desktop versions but sadly looks like Microsoft will beat them to it. iPadOS and iPadPro 12.9 especially make a iPad a very capable laptop replacement
@farmantahiracademy7118
4 жыл бұрын
Thank you so much, it is Really useful...
@renaldkeithbriones7890
4 жыл бұрын
Bit By Byte does the ipad pro replace a laptop? I am a college student and I planned to buy a tablet as my primary device for school.
@leandrolopes7317
5 жыл бұрын
Hi, can i use Scripts like in computer, in developers sheet in Google sheets for iPad? I want edit "macros" ir Scripts in case to auto some tasks (;
@richardlongrus880
5 жыл бұрын
I ALSO NEED THIS ANSWER
@gavindoescoffee
4 жыл бұрын
Thanks for showing how to you Google Slides 🤛🏾👌
@gavindoescoffee
4 жыл бұрын
Thanks
@murka4669
3 жыл бұрын
Thank you, i am from Russia, I understood all information! There’s no on Russian language tutorial like that.❤️
@NicoleandStevie
2 жыл бұрын
Well you addressed what I came here for within the first minute. Thank you for saving me from hours more of frustration.
@yartomasankolo4727
Жыл бұрын
This was awesome, what a great way to learn. Thank you so much for being so good at explaining this to us, what a great teacher you are. Once again thanks 🙏🏾
@raceboii1339
3 жыл бұрын
So basically the app version is garbage lmaoo. Use safari version instead for drop down menus.
@wirabinabdollah3074
4 ай бұрын
Thank forcthe tutorial video. How about if we are creating a form with data validation / dropdown list on ipad. Thank you in advance for your reply.
@antoinejean-baptiste3591
4 жыл бұрын
This was really helpful but is there anyway to edit your axes?
@generector8583
4 ай бұрын
Google sheets will not work with safari, unless Settings/Safari/Request Desktop Website is turned on.
@rb8058
5 жыл бұрын
Very helpful! Saw your Reddit post and this is a big help for those of use who use the desktop app and want to make the jump to iPad.
@manniegrant6745
Жыл бұрын
Hello. I have templates that my company uses, that I need workers in the field to be able to access. Is there a way to accomplish this feat?
@farhanmuhammad793
2 жыл бұрын
How to insert formula/data from another tab, because when i press = the bottom tab is gone. I cant do like when using laptop
@johnpazzia9158
4 жыл бұрын
Thank you great tutorial!!! However I am trying to find “landscape” (to print my spread sheet ) on iPad google sheets ...nowhere to be found .... please help anyone
@yusniedaym2149
4 жыл бұрын
me too...i still hard to find how to set the paper size and the rotation paper..😩
@jasonjudiputra
Жыл бұрын
Bang kalau spreadsheet di ipad bisa ftur pivot ga ya?
@girishkuvalekar3965
Жыл бұрын
I was expecting iPad version to include Google scripts, but this one looks like kids mode of Google sheets
@CiprianFx59
3 жыл бұрын
is there any way to get rid of pressing that annoying check mark all the time? on android a swipe back ia enough.
@JazminDeLaCruz-b1l
Жыл бұрын
how can I insert a scribble using the drawing on the ipad? it doesn't seem to appear
@jujube0410
Жыл бұрын
Can we access the brush paint on Ipad? I do not see it on your screen nor mine
@kawskelvin7884
4 жыл бұрын
Why isn’t my chart working when I highlight everything.
@magnoliahabaths3331
4 жыл бұрын
Yeah same
@magnoliahabaths3331
4 жыл бұрын
Use excel it is easier
@carlosmontgomery1820
4 жыл бұрын
Thanks for the help with google sheets
@mobiarena4038
2 жыл бұрын
can i draw in a specific cell with ipad in a google sheets?
@Axis.Mundis.
2 жыл бұрын
“ipad not compatible”. I bought this iPad today for this specific reason, using Google sheets and I can’t even do it. I have done much data on Google sheets I don’t really wake change platforms having spent so much time learning this one. Is there something I can do? Softwares up to date it says 9. Whatever. This sucks
@MKMTG
2 жыл бұрын
Did you buy the iPad new or secondhand? When you say the software is up to date and it says ‘9’ do you mean iOS9? (Go to Settings, General, About, then see what software version it says, then let me know).
@putridusak6712
2 жыл бұрын
Can we add checkbox through iPad?
@rubenfranco5491
Ай бұрын
Can I copy format on an iPad?
@venusalexa9668
3 жыл бұрын
How to do or make signature in this apps?
@populationproblems7095
2 жыл бұрын
Hi… how to delete a line from the sheet?
@moonlightfitz
3 жыл бұрын
Can you see a “comment” on ipad?
@deannaedgecomb2541
2 жыл бұрын
When using a pivot table…. You can double click a cell. Google provides a separate tab/sheet with the detail for that specific cell. Then you can down loan that specific data into another format as needed. How can you perform this task with pivot tables on the IPad?
@MsTBrown60
2 жыл бұрын
Thank you for putting this together. Very helpful!
@MKMTG
2 жыл бұрын
Thanks! Glad it was useful!
@glinlargosa5809
2 жыл бұрын
Can you use 2 safari's but without using split screen? Like when youre on computer/laptop and youre using 2 windows of Google Chrome, you could just simple press Alt + Tab when you want to use the first Window and another Alt + Tab for other Window. Thats just how I work on a computer What I am asking, If dont want to use Computer, is there any work around for Ipad Pro? Can I just press Alt Tab to switch another window or Google Chrome/Safari? Thank you, please help.
@rondameyers2936
9 ай бұрын
Great video and clear speech and instructions. The only thing I don't get, is that it says it is for iPad, yet I see you with a cursor and likely a mouse. I was watching to learn how to create a document without those items, since iPad doesn't have that...were you using a keyboard? I would like more instruction on moving data around into different areas, portrait and landscape mode. And no info on numbers, as I want to learn how to set up documents at this stage. Numbers, charts, formulas should be on a separate video please.
@shantiintanlestari3520
2 жыл бұрын
How to copy Cell and row
@awanberkabut681
2 жыл бұрын
how to enter in one cell?
@yasminshafeek9300
2 жыл бұрын
Hello, thanks for sharing your knowledge with us. I have a quick question here, how do you modify links in sheets? In desktop and android I’ve pasted the link and press on top of it and modify the name, how can i do it in ipadOS? Is it possible?
@asiaguy
Жыл бұрын
Can I create a drop down calendar date list in the app? Like clicking on the cell allow me to select a date.
@MKMTG
Жыл бұрын
You would need to use Google Sheets in Safari instead of the app for this. The app is very limited.
@medicalstudent9838
2 жыл бұрын
thank you
@Hscottmartin
3 жыл бұрын
Does anyone know how I get my spreadsheet to fill the page? It’s so small at the top of the page. Let dosen’t seem to be anything in the ‘printing options’ on an iPad x
@TheArid92
4 жыл бұрын
Bro, how to use calendar in sheet. Coz when i use android its just appear at below right. But at iphone there is no calendar icon appear. Can u explain why
@ziadabbas1365
4 жыл бұрын
How would I edit the series on the iPad Pro like I would on my mac? I just made the switch and I can’t seem to get the graph correct...
@coreyle
2 жыл бұрын
Does anyone know how to select multiple rows or columns so I can copy and paste in another sheet? Might have to return the iPad and go back to a laptop if this can’t be done…
@Nirrrr
3 жыл бұрын
When i open google sheet with drop down on ipad, the drop down menu is i muddle of the sheet instead of right on the drop down. So when I click on drop down it opens it on middle of sheet. How can i fix this on ipad?
Пікірлер: 173