Google Sheets for iPad Tutorial 2019

Подписаться 36 тыс.

Просмотров 192 тыс.

50% 1

Learn how to use Google Sheets for the iPad. This detailed tutorial explores all the features currently available in Google Sheets, although there are some differences between this and the version available through the browser.
If this video was useful, please buy me a coffee!
www.buymeacoffee.com/buzzkeil
Support Bit By Byte and follow:
Facebook: / bitbytehd
Instagram: / bitbytehd
Twitter: / bitbytehd
VIDEO CONTENTS:
0:00-1:02 Intro
1:02-3:14 Adding/Switching Accounts/Accessing Starred Files/Shared Files/Offline/Trash/App Settings/Offline Toggle/Default Apps
3:14-3:30 Searching for a Document
3:30-4:08 Templates/Creating a Blank Document
4:08-4:23 Navigating a Spreadsheet/Zoom
4:23-4:57 Adding/Renaming/Duplicating Sheets
4:57-5:28 Freeze Rows/Columns (Panes)
5:28-6:01 Inputting Text/Data
6:01-7:15 Editing Text/Data
7:15-7:32 Cut/Copy/Comment/Clear/Note
7:32-9:12 Selecting Multiple Cells/Columns/Rows/Resizing
9:12-9:47 Insert Column or Row Before/After
9:47-11:45 Editing Cells (Fill/Borders/Text Wrapping/Merge/Number Format/Decimal Places)
11:45-12:24 Quick Formula and Enter Formula
12:24-13:07 Insert Functions
13:07-14:47 Creating/Editing a chart
14:47-15:24 Adding and Editing Images
15:24-15:39 Undo/Redo/View Comments/Share
15:39-16:11 View Comments/Find and Replace
16:11-16:44 Explore (Quick Actions)
16:44-18:20 Sort and Filter (and removing filters)
18:20-18:27 View File Details
18:27-19:23 Sharing, Printing, Convert to Excel, Make a Copy/Make Available Offline
19:23-20:33 Document Selection Screen/Quick Actions
My Gear
Main Camera (Panasonic GH5)
US: amzn.to/2DmyEMw - UK: amzn.to/2BLjvEi
Second Camera (Leica D-Lux Typ 109)
US: amzn.to/2zDJtrq - UK: amzn.to/2l9MzyX
Tripod (Manfrotto 190 GO!)
US: amzn.to/2DmM23d - UK: amzn.to/2l9bceY
Fluid Head (Manfrotto Pro Video Head)
US: amzn.to/2zEw2au - UK: amzn.to/2zDPjcn
Lighting (Neewer Bi-color 480 LED)
US: amzn.to/2CeuwPr - UK: amzn.to/2E2AoMc
Outdoor Mic (Rode VideoMicro)
US: amzn.to/2E4XC4s - UK: amzn.to/2zEQ1G4
Audio Recorder (Zoom H5)
US: amzn.to/2zEhtnq - UK: amzn.to/2zEEIhf
Main Mic (Zoom Stereo Shotgun)
US: amzn.to/2BKjsIV - UK: amzn.to/2Cf2JhX
Mobile Gimbal (DJI Osmo Mobile)
US: amzn.to/2DoEAVn - UK: amzn.to/2CeuF5C
Get 20GB of FREE cloud storage: copy.com?r=luz428
Get $30 off your first year of hosting at DreamHost: goo.gl/Q1597p
Use the Promo Code: TECHTECH30

Наука

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

8 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 172

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

@howaboutno2614 4 года назад

thank you!! needed this for a project:)

@DarrenBroadhead 4 года назад

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.

@jacquelinegross9037 3 года назад

Very informative. Thank you!

@obayev 5 лет назад

Thank you so much 🙏 Your video really helped me! And, as a bonus, I quite enjoyed its beauty and simplicity 👍👍👍

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

@sampool2011 2 года назад

Brilliant video. Very well spoken and easy to follow and understand 👍

@Eww_itsalessia 3 года назад

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!

@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

@rogersledz6793 3 года назад

Thank you so much for uploading this video. It is helping me get through the pandemic!

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

@rameenmalik6996 3 года назад

Very helpful! Thank you.

@karingzaugun505 5 лет назад

Thank you for this video. It is useful.

@carlosmontgomery1820 4 года назад

Thanks for the help with google sheets

@farmantahiracademy7118 3 года назад

Thank you so much, it is Really useful...

@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 🙏🏾

@thelivingword6930 Год назад

This was very helpful. Thanks.

@MsTBrown60 2 года назад

Thank you for putting this together. Very helpful!

@MKMTG 2 года назад

Thanks! Glad it was useful!

@follc1991 3 года назад

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

@parebalo2000 9 месяцев назад

Thank You!!! This was so clear. It answered so many of my questions/frustrations that I could not find anywhere else!!! 😊😊😊

@Dgsmnt 4 года назад

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

@NicoleandStevie Год назад

Well you addressed what I came here for within the first minute. Thank you for saving me from hours more of frustration.

@katylowe3504 Год назад

Excellent. Need to search further for potential for choosing page edits; i.e., landscape vs portrait.

@lakwatsierra3014 2 года назад

Thank you. It helps me a lot

@imopn 4 года назад

How good is it at Pivot Tables? I use them heaps and wondering if sheets on iPad does this well

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

@medicalstudent9838 2 года назад

thank you

@treccobay5621 7 месяцев назад

Thank you, found the tutorial very helpful. Using Google Sheets App

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

@murka4669 3 года назад

Thank you, i am from Russia, I understood all information! There’s no on Russian language tutorial like that.❤️

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

@antoinejean-baptiste3591 4 года назад

This was really helpful but is there anyway to edit your axes?

@gavindoescoffee 4 года назад

Thanks for showing how to you Google Slides 🤛🏾👌

@gavindoescoffee 4 года назад

Thanks

@renaldkeithbriones7890 3 года назад

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.

@messnomoreorganizing 4 месяца назад

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.

@wirabinabdollah3074 Месяц назад

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.

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

@penguinbingintiew9394 4 года назад

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

@uchihaitachi6810 3 года назад

Thanks

@samratspeaks 4 года назад

How to change the size of column in the ipad?

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

@cheungchakhong5b034 3 года назад

@ziadabbas1365 3 года назад

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

@uchihaitachi6810 3 года назад

You are best

@jnolasco24 Год назад

Hi! How do you delete rows/columns? How do you delete a cell?

@shaunsart 6 месяцев назад

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

@alireinhold3125 4 года назад

How can I copy a formula for the entire column

@queen.azizah 11 месяцев назад

Yeeaah this my problem too

@poppydwip6560 2 года назад

Hello, can we enter text in a same column? I've been looking for this but haven't found how to

@Demy1970 6 месяцев назад

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

@heey_panda 3 года назад

How I can pin a column for always see it on the sheet?

@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 3 года назад

Sara De Franco hey! May i know if you figured it out?

@cami8892 3 года назад

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

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

@fanuelfebrianosanto8011 4 года назад

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?

@atypicalelectronics 3 года назад

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.

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

@fermicarus Год назад

is there any way to use paste special in mobile version of spreadsheet?

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

@leandrolopes7317 4 года назад

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 4 года назад

I ALSO NEED THIS ANSWER

@persadsanjay 4 года назад

How do I copy a bar graph from google sheets to docs on my iPad?

@Reinald.n 2 года назад

How do you add a line break (new line) inside a cell with physical keyboard?

@TheArid92 3 года назад

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

@GoldChopper 11 месяцев назад

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.

@Aptix-yt 5 лет назад

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?

@ballafasho332 3 года назад

How do you hide grid lines when printing on google sheets??! Frustrating with my 12.9 pro. Please help

@Flowersandshotguns 3 года назад

How can I print the sheet in a horizontal landscape from iPad?

@rondameyers2936 6 месяцев назад

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.

@natemargolin4360 2 года назад

How do you move one specific cell either up or across? iPad google sheets

@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

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

@radenprayudi2712 3 года назад

How can we protect/unprotect sheet ? Or is it only applicable using laptops? I’ve googled it but nothing comes up

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

@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

@louisewells3891 Год назад

How to change the individual colour of the bar in your graph?

@curtiscruise1298 3 года назад

How can you select two non adjacent columns?

@jujube0410 Год назад

Can we access the brush paint on Ipad? I do not see it on your screen nor mine

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

@JuliusSDeLaCruz Год назад

Hi! How do I move just one cell or a group of cells?

@imanali4743 4 года назад

can i add data validation on Ipad_

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

@zaosh24 3 года назад

I’m having trouble with the fonts. I need Cambria font. I know it sounds stupid but my class assignments need Cambria font so if you know how to add fonts please tell me. Thank you!

@MKMTG 3 года назад

You would need to use Google Sheets in Safari instead of the app for this.

@CiprianFx59 2 года назад

is there any way to get rid of pressing that annoying check mark all the time? on android a swipe back ia enough.

@putridusak6712 2 года назад

Can we add checkbox through iPad?

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

@abrols Год назад

How do one insert a cell value from another worksheet?

@mobiarena4038 2 года назад

can i draw in a specific cell with ipad in a google sheets?

@missionaeyfs5016 3 года назад

How do I add checkboxes?

@catmurat73 2 года назад

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 2 года назад

I do not have a printer home as well… I can’t change the setting in the print section

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

@Nirrrr 2 года назад

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?

@venusalexa9668 3 года назад

How to do or make signature in this apps?

@palomadelrosario3812 3 года назад

And what if the chart doesn't get formed even if you del t the information and it says you ha no data selected?

@sharonmiller591 2 года назад

Do you have a hard copy of these instructions?

@AdreyThe 4 года назад

where is the alternative color menu?

@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

@jasonjudiputra Год назад

Bang kalau spreadsheet di ipad bisa ftur pivot ga ya?

@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

@whitneyheim3129 4 года назад

Very helpful. Thank you.

@aracelymondragon7263 3 года назад

How do I copy a graph?

@sweetmace8574 3 года назад

Hi! How do we delete a row, please? I accidentally added 5 rows and can’t figure out how to delete them! Thanks in advance :)

@TheBuusbaarn 2 года назад

Hi! Maybe you’ve already gotten the answer to your question. I’ve been going absolutely crazy about the fact that I didn’t find any information regarding how to delete rows. Tap the row number and then tap it again. You get the ”copy”/”paste” options as well as a few others, for exampel ”delete row”.