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
@roxiemullinix65513 жыл бұрын
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 KZbin 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.
@saradefranco58314 жыл бұрын
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!
@nrzztk4 жыл бұрын
Sara De Franco hey! May i know if you figured it out?
@cami88923 жыл бұрын
Sara De Franco ugh same!!! 😩😩😩 i've been looking everywhere and i didn't find anything i'm so pissed
@selmaisabelsaravialuna3 жыл бұрын
Same here¡
@BingL2113 жыл бұрын
Hi, Has this been resolved? Would like to know the solution if you know 😀
@shaimaahmad98373 жыл бұрын
Have you figured it out yet
@alireinhold31254 жыл бұрын
How can I copy a formula for the entire column
@queen.azizah Жыл бұрын
Yeeaah this my problem too
@DarrenBroadhead4 жыл бұрын
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.
@thelivingword6930 Жыл бұрын
This was very helpful. Thanks.
@howaboutno26144 жыл бұрын
thank you!! needed this for a project:)
@follc19914 жыл бұрын
I can't tell you how many times I come back to this video for references you have helped me out so much thank you again anybody reading this I highly recommend you save it never know what you're going to need down the road and this man delivers
@NicoleandStevie2 жыл бұрын
Well you addressed what I came here for within the first minute. Thank you for saving me from hours more of frustration.
@jacquelinegross90374 жыл бұрын
Very informative. Thank you!
@rogersledz67933 жыл бұрын
Thank you so much for uploading this video. It is helping me get through the pandemic!
@parebalo200010 ай бұрын
Thank You!!! This was so clear. It answered so many of my questions/frustrations that I could not find anywhere else!!! 😊😊😊
@murka46693 жыл бұрын
Thank you, i am from Russia, I understood all information! There’s no on Russian language tutorial like that.❤️
@Dgsmnt5 жыл бұрын
Thank you for this tutorial I’ve been so lost on how to use this app lol!
@stachu50064 жыл бұрын
Charlotte R yh it makes no sense
@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 🙏🏾
@treccobay56219 ай бұрын
Thank you, found the tutorial very helpful. Using Google Sheets App
@rb80585 жыл бұрын
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.
@MsTBrown602 жыл бұрын
Thank you for putting this together. Very helpful!
@MKMTG2 жыл бұрын
Thanks! Glad it was useful!
@jenefairfernando46283 жыл бұрын
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?
@messnomoreorganizing5 ай бұрын
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.
@gavindoescoffee4 жыл бұрын
Thanks for showing how to you Google Slides 🤛🏾👌
@gavindoescoffee4 жыл бұрын
Thanks
@obayev5 жыл бұрын
Thank you so much 🙏 Your video really helped me! And, as a bonus, I quite enjoyed its beauty and simplicity 👍👍👍
@farmantahiracademy71184 жыл бұрын
Thank you so much, it is Really useful...
@carlosmontgomery18204 жыл бұрын
Thanks for the help with google sheets
@lakwatsierra30142 жыл бұрын
Thank you. It helps me a lot
@sampool20112 жыл бұрын
Brilliant video. Very well spoken and easy to follow and understand 👍
@rameenmalik69963 жыл бұрын
Very helpful! Thank you.
@jdrobins08325 жыл бұрын
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
@dimitryvanmaris50594 жыл бұрын
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
@katylowe3504 Жыл бұрын
Excellent. Need to search further for potential for choosing page edits; i.e., landscape vs portrait.
@rondameyers29368 ай бұрын
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.
@medicalstudent98382 жыл бұрын
thank you
@karingzaugun5055 жыл бұрын
Thank you for this video. It is useful.
@diniramdhaniar93544 жыл бұрын
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.
@tulasirakesh0072 жыл бұрын
Thank you. So everyone else showing desktop version of Google sheets.
@renaldkeithbriones78903 жыл бұрын
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.
@shrougabdullah57084 жыл бұрын
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
@jonmui403 жыл бұрын
No u cant
@uchihaitachi68103 жыл бұрын
You are best
@gismaker10153 жыл бұрын
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.
@antoinejean-baptiste35914 жыл бұрын
This was really helpful but is there anyway to edit your axes?
@wirabinabdollah30743 ай бұрын
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.
@atypicalelectronics3 жыл бұрын
Hey this video was extremely helpful! I want to get a tablet, and once I saw that you can't add conditional formatting on the iPad app, I decided not to get one.
@shaunsart8 ай бұрын
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
@uchihaitachi68103 жыл бұрын
Thanks
@cheungchakhong5b0343 жыл бұрын
ty
@Eww_itsalessia3 жыл бұрын
Thanks so much for this! It is super helpful. But is there a way to add not just info for the left axis but also on the right? I think it might only be a desktop thing but I'm not very good with the app so decided to ask you. Thanks for the video!
@deannaedgecomb25412 жыл бұрын
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?
@fermicarus Жыл бұрын
is there any way to use paste special in mobile version of spreadsheet?
@whitneyheim31294 жыл бұрын
Very helpful. Thank you.
@johnpazzia91584 жыл бұрын
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
@yusniedaym21494 жыл бұрын
me too...i still hard to find how to set the paper size and the rotation paper..😩
@samratspeaks4 жыл бұрын
How to change the size of column in the ipad?
@Rg1989.2 ай бұрын
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
@kawskelvin78844 жыл бұрын
Why isn’t my chart working when I highlight everything.
@magnoliahabaths33313 жыл бұрын
Yeah same
@magnoliahabaths33313 жыл бұрын
Use excel it is easier
@follc19914 жыл бұрын
NICE JOB MY MAN HELPED ME WITH ALOT OF SHIT
@farhanmuhammad793 Жыл бұрын
How to insert formula/data from another tab, because when i press = the bottom tab is gone. I cant do like when using laptop
@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.
@dmurphy6151 Жыл бұрын
As far as I can see, everything in this video can also be applied to Android Tablets
@leandrolopes73175 жыл бұрын
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 (;
@richardlongrus8805 жыл бұрын
I ALSO NEED THIS ANSWER
@Demy19707 ай бұрын
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
@penguinbingintiew93944 жыл бұрын
I’ve tried to resize the column but can not do, when I’ve tried to resize it became select column. Could you explain more? Thank you
@toneranger2 жыл бұрын
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 ?
@yasminshafeek93002 жыл бұрын
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?
@glinlargosa58092 жыл бұрын
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.
@fanuelfebrianosanto80114 жыл бұрын
It’s quite hard to do VLOOKUP between 2 different sheets. If I want to select table range at another sheet, the formula will suddenly disappear. Any idea?
@Nirrrr3 жыл бұрын
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?
@coreyle2 жыл бұрын
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…
@xBabyDassWassup2 жыл бұрын
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 😩
@seapark17924 жыл бұрын
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!
@palomadelrosario38123 жыл бұрын
And what if the chart doesn't get formed even if you del t the information and it says you ha no data selected?
@Empe-kl1cj4 жыл бұрын
How do I insert a checkbox?? I’ve looked everywhere and normally it would be in the insert menu but it’s not...
@girishkuvalekar3965 Жыл бұрын
I was expecting iPad version to include Google scripts, but this one looks like kids mode of Google sheets
@radenprayudi27123 жыл бұрын
How can we protect/unprotect sheet ? Or is it only applicable using laptops? I’ve googled it but nothing comes up
@generector85832 ай бұрын
Google sheets will not work with safari, unless Settings/Safari/Request Desktop Website is turned on.
@TheArid924 жыл бұрын
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
@blesss1271 Жыл бұрын
How to make a cell an absolute value?
@jnolasco24 Жыл бұрын
Hi! How do you delete rows/columns? How do you delete a cell?
@ziadabbas13653 жыл бұрын
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...
@Aptix-yt5 жыл бұрын
Hey there, I have a column with only links and want to hide the in front of all links but still want them to be clickable. How can I do that?
@poppydwip65602 жыл бұрын
Hello, can we enter text in a same column? I've been looking for this but haven't found how to
@user-hl6pt5wh3n11 ай бұрын
how can I insert a scribble using the drawing on the ipad? it doesn't seem to appear
@CiprianFx593 жыл бұрын
is there any way to get rid of pressing that annoying check mark all the time? on android a swipe back ia enough.
@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?
@ballafasho3323 жыл бұрын
How do you hide grid lines when printing on google sheets??! Frustrating with my 12.9 pro. Please help
@louisewells3891 Жыл бұрын
How to change the individual colour of the bar in your graph?
@bo.slo7h8156 ай бұрын
How to search inside sheet, like ctrl + f on pc
@Reinald.n2 жыл бұрын
How do you add a line break (new line) inside a cell with physical keyboard?
@heey_panda3 жыл бұрын
How I can pin a column for always see it on the sheet?
@jujube0410 Жыл бұрын
Can we access the brush paint on Ipad? I do not see it on your screen nor mine
@greggnelson56652 жыл бұрын
My google sheets on ipad does not have the format cell capabilities any comment?
@vinehtanwar273411 ай бұрын
How do i use a line break inside a cell
@sharonmiller5912 жыл бұрын
Do you have a hard copy of these instructions?
@putridusak67122 жыл бұрын
Can we add checkbox through iPad?
@imopn4 жыл бұрын
How good is it at Pivot Tables? I use them heaps and wondering if sheets on iPad does this well
@natemargolin43603 жыл бұрын
How do you move one specific cell either up or across? iPad 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
@MKMTG2 жыл бұрын
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).
@carmeltaylor2719 Жыл бұрын
When I send the schedule in email, it doesn’t send. 😢
@Hscottmartin3 жыл бұрын
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
@JuliusSDeLaCruz2 жыл бұрын
Hi! How do I move just one cell or a group of cells?
@populationproblems70952 жыл бұрын
Hi… how to delete a line from the sheet?
@abrols Жыл бұрын
How do one insert a cell value from another worksheet?