20 Useful Tips and Tricks For Mac Numbers
ฝัง
- เผยแพร่เมื่อ 7 ก.ค. 2024
- macmost.com/e-2103 Numbers is a huge app with tons of features. If you use it a lot, you can benefit from learning some tips, tricks and techniques. Learn how to autofill cells, re-apply sorts, get quick calculation results, automatically format cells, hidden keyboard shortcuts and much more.
FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY
▶︎ TH-cam - macmost.com/j-youtube (And hit the 🔔)
▶︎ Weekly Email Newsletter - macmost.com/newsletter ✉️
▶︎ Twitter - / rosenz and / macmost 🐦
▶︎ Facebook - / macmost 👍
SUPPORT MACMOST AT PATREON
▶︎ macmost.com/patreon ❤️
#macmost #numbers - วิทยาศาสตร์และเทคโนโลยี
![[Full Episode] MasterChef Junior Thailand มาสเตอร์เชฟ จูเนียร์ ประเทศไทย Season 3 Episode 5](http://i.ytimg.com/vi/g5wpgeAIzMs/mqdefault.jpg)
Finally a video that explains the simple functions I needed to know about numbers! Thank you so much!!!
This is awesome. It's exactly what I needed as someone totally new to numbers and spreadsheets. Thanks so much!! Going to watch the whole playlist.
I’ve been using it for a decade now and just occurred to me to look for a tutorial, mind blown, so many new things I’m just learning about. Glad you got to see it right from the start.
Once again a gold mine of hidden gems! Thanks Gary.
Your tips are the absolute best! Helpful, easy to follow and I always learn something I hadn't been able to figure out. You're my "Go To" when I'm having trouble figuring out how to do something. Thank you!
You’re amazing,Friend. I couldn’t thank you more! Your jobs are inspiring.
I have now watched several of you Numbers videos. I switched to a MacBook in 2014 but still feel like a rookie. I was proficient in Lotus, Symphony, Quattro Pro and Excel. Your videos are saving me lots of time and with less frustration!!! THANKS
It was superbly helpful. In just 15 mins, i could grasp so many tricks. Thank you big brother..!
wow, Thank you so much, I am so used to Excel and wanted to learn the Numbers from long time... this is exactly what I needed
As always you do incredible videos and the community is lucky 🍀 to have you.
this video helps a lot for new mac users like me. You've explained things very well. Thank you so much!
Can't thank you enough - that was lovely session!
Amazing. Yet another very useful video. Thanks so much for educating us.
Awesome tutorial! Thank you!
I can watch this all day. You've got a new subscriber 👍🏼👍🏼👍🏼
dang, *_sport_* … you fit a whole lot of t/t into this video … invaluable for newbie as well as the seasoned compiler … 'ppreciate it, *gary* !
Thank you so much this was SUPER helpful!!!
Do you have a video that shows beginners how to use colors, types of text, and other options in formatting in Numbers, such as highlighting, gradients, text colors, etc? If not, would you please make one that explains each step? (I haven't figured out how to get rid of a gradient in a text cell..) Thank you!
Very helpful. Thank you so much!
Thank you so much, I had a query about how to do a task in Numbers and within the first 20 secs you solved it. Love the channel and keep up the awesome work.
Gary you're the best. Thank you for all you show!
This is the one i was searching for..thanks a lot man
This is very helpful and I noticed some additional tricks along the way. I made some notes about it !
Thanks so much Gary. Just what I needed.
Thank you so much! What you are sharing is so useful! 🙏🙏🙏
That was fantastic. Thank you for moving so well through this useful material. Really need to learn this app quickly. Hope you're doing well. JV
You are priceless! Thank you for helping so many of us!
Fantastic. Thank you!
I enjoyed this very much! Thank you for your productions. How would I sort columns by the filled color?
PERFECT!!!!!! THANKS!!!!!
Thanks a lot. I use numbers in a daily basis and I didn’t know many of the tips in this video.
Dear Sir I have been breaking my head as to how to do this and almost all videos show me how to do it in Excel not Numbers. U have helped me soooo much!!! I am nearly in tears just thinking of all the time u have saved me. New sub for sure👍💯
very useful! thanks!
This is a valauble list of great timesavers and powerful functions. Thank you!
You are just downright awesome! Thank you for these instructions videos.
Awesome,.. great pace, just right for me. Thank you.
Great Tutorial thanks for your Numbers wisdom
Just found your channel! Great vids. I've been looking for a great tutorial on how to use numbers. You're the man!!! You just got yourself a new subscriber :)
Best channel to learn all things Mac !
Thank you Gary for you wonderful videos. You are amazingly good at teaching these things
thank you very much! Clear and concise 👍🏽
Great stuff! Your the man!
Very informative! Thank you!
Excellent tips and hints. I'm trying to move from Excel and this is very very helpful. Thanks.
Brilliant video! Many thanks.
Great tips! Very helpful!
really helpful, thanks a lot
This is great, thank you!
Very useful!!! Big THANK YOU!
Great video, thank you..
Super useful, thank you!
Just starting watching So informative Thank you
Amazing! I too am working through the playlist and will certainly be heading over to the patreon site at some point. Thank you for sharing your knowledge :)
Great information - Thanks
You are genius man ...its very helpful ... thanks a lot ...God bless you
WOW thank you soooo much! You just made my life much easier. Liked & Subscribed!!
Thanx for your effort.
Thank you so much. Really helped. No WAR!
Thanks a lot! It is very helpful!👍
Thx. so much useful info on this video.
Switching from Windows to Mac. Super grateful
Hi I run a picture frame business and have been working on building an inventory file on Numbers. I am stuck trying to figure out what kind of formula would let me enter individual cuts (moulding used each day categorized by item number) and keep track of the following things: daily average use of each moulding, weekly use, monthly use to keep track of what the most popular choices are & better regulate our ordering process. I hope you have some feedback as to how I can accomplish this. My first thought was to create a mirror sheet (using copying formulas) of the raw inventory numbers (what we have in stock) and connecting those to a sheet where I input the daily cuts and use formulas on another sheet to calculate weekly/monthly/ etc but the whole timeline aspect is throwing me for a loop.
Thank you!
super info
Thank you man
Awesome!
helpful thanks!
Excellent video
Keyboard shortcuts for numbers tutorial needed, also more videos needed on pages & numbers
So helpful
I came hoping to find a simple answer (and I did), but I subscribed before leaving. Great job! 👍🏼
Thank you so much
really good tutorial
Thanks Bunches
Thnaks for the video, very instructive!
Is there any way to freeze individual cells without freezing all the table? I created a table of calculus that I want to share but want to freeze the cells that shouldn't be changed giving only the option to have access where put the only input values. If someone has a trick for that. Thanks a lot.
Man I wish I had a teacher like you in school.
Nice.!!!!
Thank you. Great video! Is there a command to display all the formulas in a spreadsheet?
I am new to apple ,slow down a little bit, to fast but i learn from you ,so tanks man and keep going...
I don't like to filter my enthusiasm so I just speak as I normally would. You can always pause and rewind to review things. Thanks!
macmostvideo ,thanks anyway i now,but I don’t like to pause every second,but I watch your videos anyway...
@@ovyarad I would recommend reducing the playback speed to 0.75.
Gary is #THEMAN!! 🙌🏻⚡️💪🏻💻💥👏🏻
Thanks Gary, were is the video on the perpetual spending numbers spreadsheet?
Hey, thank you for your amazing videos, I have a question about Numbers and I hope you cold guide me. I want to be able to have a master data sheet that I can duplicate several times, make edits to the master that will automatically update on the other sheets. Is this possible? Thanks for your help.
Is it possible to reference one table from another sheet and create a scroll bar that will allow me to scroll through the data like a list? Basically, I am trying to create a one-page summary and I would like to have 1-3 tables referenced from a more detailed sheet that will show about 5 rows each.
Hi Gary, is there any chance you could show us how to insert a date picker (as in a mini calendar pop up) in a cell? I can't seem to find it anywhere.
Thanks in advance
Good evening sir.
Can we get cell value from one sheet to another sheet in numbers on iPhone not on the computer?
Do you have any advice for solver tables? Doing some practice work for school and input the formulas exactly and it defied my constraints and gave me the most bogus numbers ever
Holy crap you just changed my life!
Thank you, I was having a problem with the header not allowing me to see the top of my sheet. I unfroze it and now I can see my top row again! Not sure what happened there? But you helped me with a solution.
Hi Gary, we love your tips. I was wondering how you move from top to bottom of a column rapidly rather than scrolling?
Lots of ways. Command+Up and Command+Down for instance.
Great videos; I've looked through a few of them!! Trying to learn how I can create a table for food preparation/cooking so that if I add a 'finish time' and have each food an allocated 'cooking time' how it would deduct and show what time to go in? It does not seem to allow for 60min format and therefore setting at time of 17:00 (for example) and an 80min oven just offers 16:20 instead of 15:40. Make sense?
Durations would look like this: 60m
You can subtract a duration from a time. So if cell B2 held 16:00 and cell C2 held 50m and you calculated =B2-C2 you would get 15:10 as a result.
Hello Gary 👋,
How to copy a weekly spreadsheet functionality and entries for the next week to apply new data?
For example we have weekly sales that has nothing to do with the previous or next week.
How to avoid building it every time from scratch?
Thank you for your help.
THANK YOOU SOOOO MUCH, I WAS TRYING TO FIGURE OUT HOW TO ADD SALES TAX FOR THE LONGEST TIME HAHA
thank you so much, I am wondering why numbers is so difficult to use, now it fixed!
Is there a way to enter info in a separate window above the database as you can in Excel? (Instead of entering directly into a cell?)
This is really good advice. It is a bit fast, I have to pause the video and rewind over and over and over again to ty to understand how you apply the formula and copy and paste it to everything. It makes it quite hard to do.
I hope you can help ! I have for example
4x11 | 8x14 | 12x55 | 8x20 | 3x45 | TOTAL
is their a way to type in each cell the way I have it and in the total cell do all the math ?
(4x11) + (8x14)....+(3x45)
can I do that quickly and easily ?
God bless you!
Hey Gary. I love your channel, been a long time viewer. I got couple questions: 1. I’ve always used Excel, is Numbers worth switching from Excel? 2. Is 2019 MacBook Pro entry level worth buying now or wait for 2020?
Both are hard to answer because it depends on your situation, experience, budget, uses, etc. You have to decide for yourself as I don't have enough information to decide for you. Numbers is free, so why not play around with it and determine whether you want to use it for some things. I love Numbers, but if you have years of experience with Excel, you may want to stick with that. As for the MacBook, it depends how badly you need it right now.
dellhpfree : Gary is right at each point. Excel and Numbers are productivity tools more than they are performance-art tools: stick with whichever one you have mastered. Or invest the time to master whichever one feels more intuitive to you, if you're still a beginner. (If you were comparing PowerPoint and Keynote, I would suggest switching to Keynote: cf. Alex Lindsay's experiences in high-production-value webcasts etc.) And with the MacBook Pro, it really depends on what features you need for your business, what crap you're dealing with right now with your current laptop (and how long you can realistically hold on), and what your capital investment budget looks like. I seriously considered a 2019 MacBook Pro, decided I couldn't wait for the 2020 model... and ended up getting a pimped-out 2015 MacBook Pro instead. It has all the ports I use with the other gear I already own, and acceptable performance for what I need to do with it, and 3 TB of storage is plenty for me... but it isn't "entry level" for any MacBook Pro. Just get what you need!
Thank for your awesome tips! Can every other row be shaded?
Yes. Choose table, go to the table tab in the inspector, towards the bottom select Alternating Row Color.
Hi thanks a lot for the great video. Can you make a comparison video between Microsoft Excel and Mac numbers?
The main difference is that Numbers gives you blank sheets where you can add tables, charts and other elements. So you can design sheets of connected tables and graphics. Excel is more powerful in crunching numbers, but that usually only comes into play if you are doing pro scientific or massive business applications.
Great video!! When I print out something from numbers the grid lines (columns and rows) are not there. Can I rectify this?