When I create simple spreadsheets like this - I try to print it and get a gadzillion pages. How do I define the beginning and ending of the spreadsheet?
You can select the cells you'd like printed, including the rows and cells adn when printing selected 'selection' rather than the entire spreadsheet. This will help you print what you need.
Q, is there a way to validate email address in sheets? without addons? great videos please keep them coming I like the method of delivery it stays in my head!! p.s I might post this question on a couple of your videos.
I learned how to create a crossword puzzle for my students' distance learning in Google Sheets. I inserted a text box for the clues for Across/Down. I want to edit the clue numbers in the puzzle but I cannot get the numbers to change. I click on the beginning of row/column and went to "insert note". In the note I see the updated number but not when I click the print option. The old numbers are still showing. Any help would be fantastic. I'm not sure if I need the notes and the text box clues.
I have a few criticisms. If you could speak louder, and zoom in on the area you're working on, that would be most helpful. I turned the volume all the way up on my device, but the audio was still too soft to hear. It is difficult to see the words you type because the screen is zoomed all the way out. THANK YOU!
I agree with all the comments you have made and as you might have seen from exploring the rest of my channel this was one of my first videos from about 3 years ago, I have since drastically changed my video format. I encourage you to have a look at some of my more recent videos and hope you find those helpful! Thank you for your feedback I appreciate each and every comment and it is through feedback we can all improve. ;-)
When you are putting in the names and ages, how do you move so quickly down the column? If I hit the TAB key, it sends me to the next column (horizontally), instead of down the column. Thanks!
hi buddy, have a question lets say i made an order and i want to increase or decrease the order lets say by 10-15% how can i do so? (so i can drug down in a new cell and then copy past if i want it to i want to see the numbers change rather the percentage to appir ) thanks
hey great fun here...i wnat to ask something,i am working with google sheet and when i copy values that are for example 7.6 google sheet tranform this value like 7,6,some time these valuse can be use with function sum,sometime no google sheets see this number 7,6 as value equal 0,can u help me ?
You would set a custom format. More formats > Custom number format and then in the input box you entered the format of the number.. "+"#"("###")"###"-"#### Will turn the number 12345678900 into +1(234)567-8900 Find the format that works for you. ...and press "Apply".
Thanks, I appreciate this tutorial. I am trying to figure out how to have the cells input information in a block (multiple lines vs one long line). I have a table with a column for the date, what is blooming, and then I need to write a note, which might be one word or a long sentence. I want the long sentence to push the cell to a block and not just a long line. Is this possible? Thank you!
Hi, Thank you for your comment! Am I correct in understanding that you are trying to adjust the way your cells interact with text? You can set different text wrapping settings by clicking on Format -> Text Wrapping and selecting what you would like to use. Does that work for your purposes? If not let me know and I will see if I can figure out hat you're trying to do.
sometimes i can click a cell and correct a spelling error and sometimes i click and it deletes everything in the cell. why? how do i make it always allow me to edit a cell
Donald Toomey I'm not sure what you mean? When you click on a cell you should be able to edit this cell in the box above the spreadsheet. I hope that helps. If not let me know.
Thanks for the video. I would like to learn more about Pivot tables in Google Sheets, maybe this could be the subject for an additional video. I find google sheets increasingly competitive to Microsoft excel however, the one thing it still lacks is the speed of the UX, what is your mind on this? BTW we are testing a beta software pdfextractoronline.com/bar-charts-to-excel/#! that allows you to extract charts to google sheets in editable format. Please take a look and write some feedback on applications and possible improvements.
+Pioneer Ventures Thank you for your feedback! As soon as this Holiday period is over I will get back into exploring, recording and evaluating software and videos. Let me get back to you on the Software ;-) I will definitely be doing a video on pivot tables in the near future!
Depending on the type of papers you are trying to make, I have many videos on my channel that could help you get that done. Do let me know what you are trying to create.
Not sure what you mean? I have never come across a limitation of 53 lines? The official limitations are: a limit of 400,000 cells, with a maximum of 256 columns per sheet. There are also some other limitations: Number of Formulas: 40,000 cells containing formulas Number of Tabs: 200 sheets per workbook GoogleFinance formulas: 1,000 GoogleFinance formulas GoogleLookup formulas: 1,000 GoogleLookup formulas ImportRange formulas: 50 cross-workbook reference formulas ImportData, ImportHtml, ImportFeed, or ImportXml formulas: 50 functions for external data
hello very good video , Actually I am working in pulling some data from SCOPUS web and It works fine, but some of the info that I importing them does not display of appear in the cell of spreadsheet even it showing , Can you help ? Thanks
+Lance Dwight you would have to make sure the +1 is set as text or a string rather than numeral. You can select the cells and under format set it to text if you need the plus one to show up. Hope I understood you question. If not let me know and I'll see what I can do;-)
Iv gotta a major problem if anyone could help me that would be awesome! Google sheets, when i create/open a new sheet i do not get the options like File / Edit / Vew etc. why is that?
volume is very low i can barely hear the instruction my desktop's volume as well as the video's volume is already on its maximum level but still i can barely hear you
Agree. My first couple of video had poor audio and I have since(some year ago now) made some significant changes to the quality of the videos. Looking at redoing the old sheets videos into a slightly longer and better quality video. All the recent videos should have much better sound.
Not at all. Some of my older videos had poor Audio quality and I have since made changes to this. I'm convinced you will find my more recent videos easier to hear.
Favorite and favourite are different spellings of the same word. Favorite is the preferred spelling in the U.S., while favourite is preferred in all the other main varieties of English.
Huge update to GMail! Check the video Here: ruclips.net/video/ExFpgmxbDHQ/видео.html
Join Cheelism
Please raise your volume, I had max volume on both RUclips and my speakers and I could barely hear you over a desk fan.
I agree that the volume in this one is low. I have since improved my audio quality and hope you fin the newer tutorials helpful.
turn off the desk fan
Eight Trix 🤣😂
WOW! You have a very nice teaching style! Thanks for sharing
+kev bra Thank you for your kind Comment. Really appreciate it!
Google Help couldn't tell me how to merge cells, but you did! Thanks!!!
Thats great to hear. Glad it helped!
Great Tutorial. Very well presented. I've learned a lot. Thank you very much!
+Ben Philias thank you! Appreciate the feedback!
+Ben Philias thank you for taking the time to leave a comment. Its most appreciated.
I swore to myself never to enjoy a video for ICT homework but too bad I broke that promise
Thank you. Hope you find the other videos on the channel helpful or somewhat enjoyable 😉
Thanks Bro! Really Helpful - for a beginner like like me, Appreciated!
Thanks for this video! straight to the point and easy to follow. I do agree speaking a little louder will help for next time.
This was a very old video. I have made some big changes to audio since then and hope the more recent videos are clearer. Thank you for the feedback.
Thank you so much! You make learning Google Sheets look so simple :)
You're welcome! Appreciate your comment!
Very clear and simple, thnx.
Thank you for your time in creating this. The vol is a little low. Thank you for your help!
+angela brown thank you for you comment. I am aware of the volume and have since adjusted this. Hopefully you find the newer videos equally helpful.
Great video because I was clueless. Thanks
Hello, Ive been watching your videos and I am wondering if you are willing to do an updated video on Google Forms?
I'll add it onto my list
Great product...I use it a ton.
+James Pharris I agree! The more I work with it the more functionalities I find and use.
When I create simple spreadsheets like this - I try to print it and get a gadzillion pages. How do I define the beginning and ending of the spreadsheet?
You can select the cells you'd like printed, including the rows and cells adn when printing selected 'selection' rather than the entire spreadsheet. This will help you print what you need.
Very clear, thanks.
+goodmusic4eva Thank you!
Nice video. Thanks!
+Joseph Conrey Thank You!
Life saver.
Thank you
Q, is there a way to validate email address in sheets? without addons? great videos please keep them coming I like the method of delivery it stays in my head!! p.s I might post this question on a couple of your videos.
OMGGGGGGGGGGGGG THIS IS SOOOO COOLL
I learned how to create a crossword puzzle for my students' distance learning in Google Sheets. I inserted a text box for the clues for Across/Down. I want to edit the clue numbers in the puzzle but I cannot get the numbers to change. I click on the beginning of row/column and went to "insert note". In the note I see the updated number but not when I click the print option. The old numbers are still showing. Any help would be fantastic. I'm not sure if I need the notes and the text box clues.
I have a few criticisms. If you could speak louder, and zoom in on the area you're working on, that would be most helpful.
I turned the volume all the way up on my device, but the audio was still too soft to hear.
It is difficult to see the words you type because the screen is zoomed all the way out.
THANK YOU!
I agree with all the comments you have made and as you might have seen from exploring the rest of my channel this was one of my first videos from about 3 years ago, I have since drastically changed my video format. I encourage you to have a look at some of my more recent videos and hope you find those helpful! Thank you for your feedback I appreciate each and every comment and it is through feedback we can all improve. ;-)
Thank you
When you are putting in the names and ages, how do you move so quickly down the column? If I hit the TAB key, it sends me to the next column (horizontally), instead of down the column. Thanks!
I always move around using the arrow keys. Hope this helps.
try CTRL and the arrow key... hope it helps!
hi buddy, have a question lets say i made an order and i want to increase or decrease the order lets say by 10-15% how can i do so? (so i can drug down in a new cell and then copy past if i want it to i want to see the numbers change rather the percentage to appir ) thanks
Can you resize columns you created on an android tablet? If so, how?
hey great fun here...i wnat to ask something,i am working with google sheet and when i copy values that are for example 7.6 google sheet tranform this value like 7,6,some time these valuse can be use with function sum,sometime no google sheets see this number 7,6 as value equal 0,can u help me ?
How can I write phone code in google spread sheet like +61. Please...
You would set a custom format. More formats > Custom number format and then in the input box you entered the format of the number..
"+"#"("###")"###"-"####
Will turn the number 12345678900 into +1(234)567-8900
Find the format that works for you.
...and press "Apply".
Thanks, I appreciate this tutorial. I am trying to figure out how to have the cells input information in a block (multiple lines vs one long line). I have a table with a column for the date, what is blooming, and then I need to write a note, which might be one word or a long sentence. I want the long sentence to push the cell to a block and not just a long line. Is this possible? Thank you!
Hi, Thank you for your comment! Am I correct in understanding that you are trying to adjust the way your cells interact with text? You can set different text wrapping settings by clicking on Format -> Text Wrapping and selecting what you would like to use. Does that work for your purposes? If not let me know and I will see if I can figure out hat you're trying to do.
THANK YOU SO MUCH!!! That was just what I needed to learn. I really appreciate your help.
No problem. If there is anything else do visit this channel or my website and I'll see what I can do!
Hello! How do you add an image on Google Sheets using the Google Sheets app on my iphone?
Some of the functionality of g suite is limited to the full web version. Mobile versions come with limitations and not everything is supported.
6 years late but is there a way to change the column titles?
like the ones that says A B C D E F..
Nice!
sometimes i can click a cell and correct a spelling error and sometimes i click and it deletes everything in the cell. why? how do i make it always allow me to edit a cell
Donald Toomey I'm not sure what you mean? When you click on a cell you should be able to edit this cell in the box above the spreadsheet. I hope that helps. If not let me know.
Thank You. !
You're welcome.
Thanks for the video. I would like to learn more about Pivot tables in Google Sheets, maybe this could be the subject for an additional video. I find google sheets increasingly competitive to Microsoft excel however, the one thing it still lacks is the speed of the UX, what is your mind on this? BTW we are testing a beta software pdfextractoronline.com/bar-charts-to-excel/#! that allows you to extract charts to google sheets in editable format. Please take a look and write some feedback on applications and possible improvements.
+Pioneer Ventures Thank you for your feedback! As soon as this Holiday period is over I will get back into exploring, recording and evaluating software and videos. Let me get back to you on the Software ;-) I will definitely be doing a video on pivot tables in the near future!
I want to make papers for students how can I do this???
Depending on the type of papers you are trying to make, I have many videos on my channel that could help you get that done. Do let me know what you are trying to create.
How do I extend a column all the way down the page? it stops at line 53 & I can't make it longer...
Not sure what you mean? I have never come across a limitation of 53 lines? The official limitations are: a limit of 400,000 cells, with a maximum of 256 columns per sheet.
There are also some other limitations:
Number of Formulas: 40,000 cells containing formulas
Number of Tabs: 200 sheets per workbook
GoogleFinance formulas: 1,000 GoogleFinance formulas
GoogleLookup formulas: 1,000 GoogleLookup formulas
ImportRange formulas: 50 cross-workbook reference formulas
ImportData, ImportHtml, ImportFeed, or ImportXml formulas: 50 functions for external data
thank you that helped me a lot....
You're welcome!
dope!
Your sound was a little low, I had to turn my volume all the way up. But overall, excellent video
hello very good video , Actually I am working in pulling some data from SCOPUS web and It works fine, but some of the info that I importing them does not display of appear in the cell of spreadsheet even it showing , Can you help ? Thanks
How do I format "+1" in a google sheet? I'm making flashcards and want the "+" to show up.
+Lance Dwight you would have to make sure the +1 is set as text or a string rather than numeral. You can select the cells and under format set it to text if you need the plus one to show up. Hope I understood you question. If not let me know and I'll see what I can do;-)
+Lance Dwight seeing as you are looking at creating flashcards have a look at the add in flippity. It is Brilliant!
Hello sir, what is the use of Google excel sheet
+Siva Google sheets has many different uses. But at it's core it's a data handler(spreadsheets) similar to excel in the cloud.
Thanks a lot for Allison John...
Iv gotta a major problem if anyone could help me that would be awesome!
Google sheets, when i create/open a new sheet i do not get the options like File / Edit / Vew etc. why is that?
+Imo Verum have you tried ctr+shift+f it could be that your menu structure is hidden.
YES that was the missing little hidden thing that was missing. thanks mate
+Imo Verum No problem! Glad it helped!
how do i change decimal points to commas in a currency column anybody ?
I think it depends on your Locale. Assign a different Locale in your settings, I suggest.
Hi. Your volume is too low!
Lorenzo Vaccaro Hi, thanks for the feedback. Working on it ;-)
volume is very low i can barely hear the instruction my desktop's volume as well as the video's volume is already on its maximum level but still i can barely hear you
Agree. My first couple of video had poor audio and I have since(some year ago now) made some significant changes to the quality of the videos. Looking at redoing the old sheets videos into a slightly longer and better quality video. All the recent videos should have much better sound.
man you need a better cpu if you want to screen cap. from what I see, your computer is really slow when clicking on things.
Thanq
You're welcome
Thank you but for me it does not work to MERGE CELLS
Oh,,, now is working. Thank you for the video
Great to hear That!
I could not hear you! found was too soft -- maybe my computer.
Not at all. Some of my older videos had poor Audio quality and I have since made changes to this. I'm convinced you will find my more recent videos easier to hear.
Not hearing
Your volume is too low we cannot hear you
hello every one
Thank you. God Jesus bless you.
i like how you didnt really explain anything
Want to learn to format a Google Sheets table in the 2017 version?
I show you here: ruclips.net/video/zBFt7Yt9djE/видео.html
1:36 you spelled favorite wrong!
+Waddles nope... favourite UK spelling. Favorite US spelling .
Can't hear narrator. Increase volume please.
Hi, I agree. My earliest videos had poor audio. Hopefully you find my more recent videos easier to follow.
I'm coming from 2020 lol
So am I ;-)
my name is jack and im 12 years old:)
Please,raise your voice
Grasse bondieu
s
You spelled favorite wrong
Favorite and favourite are different spellings of the same word. Favorite is the preferred spelling in the U.S., while favourite is preferred in all the other main varieties of English.
I'm having a hard time hearing this tutorial.
+Davida Tyson I agree that some of my older tutorials had very poor audio. I've since upgraded and am planning do redo some older ones.
lol
comment :)
Reply to comment 😉
Had to dislike, don't want school videos in my recommended on my personal account.
Are you signed into multiple accounts? Could help to keep the content viewed separate for your accounts.
bru im late
W