20 Useful Tips and Tricks For Mac Numbers

[@suecaronia3076]

Finally a video that explains the simple functions I needed to know about numbers! Thank you so much!!!

[@weldo1948]

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

[@Coruptshun]

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.

[@MaquinasDePalomitas]

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.

[@alexugw9512]

I love you man ❤ Literally all I know about numbers I have learn from you there is too many people teaching about numbers in KZbin but no one explain how you do thank you so much

[@JBullerwell]

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!

[@carlisletalbot6520]

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!

[@davidrosemond9012]

Once again a gold mine of hidden gems! Thanks Gary.

[@ianmeechan2040]

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.

[@carpenterhillstudios8327]

This is a valauble list of great timesavers and powerful functions. Thank you!

[@Practice_Kindness-1st]

You are priceless! Thank you for helping so many of us!

[@delislac]

Gary you're the best. Thank you for all you show!

[@SrujanRaghavendra-y9h]

It was superbly helpful. In just 15 mins, i could grasp so many tricks. Thank you big brother..!

[@keliblum6591]

WOW thank you soooo much! You just made my life much easier. Liked & Subscribed!!

[@dmedilicious8488]

Switching from Windows to Mac. Super grateful

[@QuangNguyen-ey6zf]

I can watch this all day. You've got a new subscriber 👍🏼👍🏼👍🏼

[@ninaoppa9642]

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👍💯

[@sujankhanal5680]

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

[@florbisagno]

Thank you so much! What you are sharing is so useful! 🙏🙏🙏

[@stevensmall1]

Excellent tips and hints. I'm trying to move from Excel and this is very very helpful. Thanks.

[@Eagles.Fan.Since.Super.Bowl.52]

I came hoping to find a simple answer (and I did), but I subscribed before leaving. Great job! 👍🏼

[@JyraAnnyeong]

this video helps a lot for new mac users like me. You've explained things very well. Thank you so much!

[@28fizzle]

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?

[@macmost]

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.

[@TheFredismShow]

You are just downright awesome! Thank you for these instructions videos.

[@richvanatte3947]

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.

[@MotoFinances]

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 :)

[@mysticsunonline]

Great Tutorial thanks for your Numbers wisdom

[@lobzangchamba8197]

You’re amazing,Friend. I couldn’t thank you more! Your jobs are inspiring.

[@SuperJoSouthgate]

Thank you Gary for you wonderful videos. You are amazingly good at teaching these things

[@loo231]

thank you very much! Clear and concise 👍🏽

[@andrewforshaw7846]

Awesome,.. great pace, just right for me. Thank you.

[@maikaimakena9424]

As always you do incredible videos and the community is lucky 🍀 to have you.

[@GastonVicioso]

Thanks a lot. I use numbers in a daily basis and I didn’t know many of the tips in this video.

[@andrefouche8725]

Thanks so much Gary. Just what I needed.

[@paullaughlin4503]

Great video!! When I print out something from numbers the grid lines (columns and rows) are not there. Can I rectify this?

[@pnamajck]

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

[@davidseibert5268]

Amazing. Yet another very useful video. Thanks so much for educating us.

[@davemilnes1147]

Super useful, thank you!

[@Time7ord]

Man I wish I had a teacher like you in school.

[@alciferblack]

I enjoyed this very much! Thank you for your productions. How would I sort columns by the filled color?

[@junecrisfrye]

This is very helpful and I noticed some additional tricks along the way. I made some notes about it !

[@mva134]

Can't thank you enough - that was lovely session!

[@cheikhelwely-sm1ld]

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.

[@gregorynelson4216]

Thanks Gary, were is the video on the perpetual spending numbers spreadsheet?

[@jonahjin]

Very useful!!! Big THANK YOU!

[@visual-independence]

Best channel to learn all things Mac !

[@danielre988]

Hi Gary, we love your tips. I was wondering how you move from top to bottom of a column rapidly rather than scrolling?

[@macmost]

Lots of ways. Command+Up and Command+Down for instance.

[@The_BrighterSide]

Thank you so much this was SUPER helpful!!!

[@f.christensen39]

I like the video, thank you. I still am looking for a way to adjust ALL the columns and rows simultaneously. I know how to adjust a row or a column, but not the whole table. Please help

[@macmost]

Adjust in what way?

[@vimukthaariyasinghe8041]

This is the one i was searching for..thanks a lot man

[@RahulSharma-lh1ug]

You are genius man ...its very helpful ... thanks a lot ...God bless you

[@plantificationpodcast]

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

[@StephaneMaurin]

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

[@stephenselby4252]

Thank you. Great video! Is there a command to display all the formulas in a spreadsheet?

[@HarmoniaAAxyridis]

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.

[@artemdoroshenko515]

Thank you so much. Really helped. No WAR!

[@dannyjenkins7569]

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.

[@marietagonzalez4356]

Thank you so much, could you please make a video for numbers in Ipad????

[@mga83]

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.

[@tiagomaqz]

Hi. Great video. How to see the data sum by selecting cells in Numbers on iPad? Could not find this option.

[@macmost]

I don't think there is an automatic sum like on a Mac. But play around and see if you can find it. Otherwise, just create your own SUM function to do it.

[@tiagomaqz]

@@macmost thank you so much for taking the time to reply. Will do it! 🙏🏼

[@elaineortiz940]

Holy crap you just changed my life!

[@mr.mittal07]

@macmostvideo thanks for the amazing content on numbers, In addition to what you taught, just wanted to know if I have four items in column A(pop menu is great) and if all four items have different sub menus in column B, is there a provision for it? Like for eg, if I select Fiction Books in column A, in column B I should get all the sub pop menu of fiction books feeded and so on... Looking forward to your response.

[@macmost]

No real way to do that.

[@xLoganWong]

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.

[@yemifalaee4701]

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

[@Patrick76399]

Instead of using Trello could we turn a spreadsheet into a Kanban board? Do you have a video discussing and showcasing this idea?

[@tstroope1]

very informative - is there a way to lock (only) certain cells. We are using the table for ‘notes to file’ and want to prevent previous notes from accidentally being erased (yes, it has happened) by other users

[@macmost]

No. So design your document to use unlocked data in unlocked tables and locked data in locked tables.

[@ahmedmujadad]

Keyboard shortcuts for numbers tutorial needed, also more videos needed on pages & numbers

[@nicksmith4137]

Just starting watching So informative Thank you

[@AlbinGlasell]

This is great, thank you!

[@charlesanthonyclarke5690]

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.

[@DavidAusman]

Fantastic. Thank you!

[@JennyJardin]

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

[@CharlesMrdbCFrancis]

Great stuff! Your the man!

[@ch1tHappensSchool]

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 ?

[@ovyarad]

I am new to apple ,slow down a little bit, to fast but i learn from you ,so tanks man and keep going...

[@macmost]

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!

[@ovyarad]

macmostvideo ,thanks anyway i now,but I don’t like to pause every second,but I watch your videos anyway...

[@WITHINOHBOAT]

@@ovyarad I would recommend reducing the playback speed to 0.75.

[@Greg-fg1rd]

Awesome tutorial! Thank you!

[@julietaylormtc8636]

Helpful - it's a couple of decades since I learned excel... I have a problem though... Can I ask you it here? I have copy pasted a simple spreadsheet of names and dates and I set the date column to a certain format. Now the program has copied the date but to format the dates so they are all the same, it won't? And it doesn't blend them and put them in ascending order. I wonder what I can do?

[@iahmadux]

Thanks for sharing, can you help me to extract the string/text from "1.1.2 title" or "2.3 another title"

[@macmost]

Do you mean extract "title" and "another title"? You could use FIND to find the first space and then MID to get the characters from that point on. Or, if you know how to use REGEX you could use the REGEX.EXTRACT function to do it.

[@Jason-yo8nk]

Hi Gary, I am new in numbers, how could I sum the same cell with the previous sheet for a formula, so when I add duplicate sheet that formula could carry on "C1(sheet 2)=A1(sheet 2)+A1(sheet 1), C1(sheet 3)=A1(sheet 3)+A1(sheet 2), C1(sheet 4)=A1(sheet 4)+A1(sheet 3)?, thanks

[@macmost]

Not quite sure what you are trying to do, but look into the INDEX and INDIRECT functions.

[@asefsyal]

I'm looking for age formula in Apple Numbers, but I can't find. As in Excel (datedif..) So, is there any formula in Numbers to calculate ages in a column? Thanks

[@jamesmason8259]

Under the personal section in Numbers there is a calendar. How do you change the month and year and get the dates to auto-populate, so that the first falls on the correct day?

[@stingray9905]

Very helpful videos, thank you but i hope next time you will start briefly from the start what we click before we can go to that page. Just for the sake of beginners like me. Thanks.

[@macmost]

I usually do. But this is a list of 20 tips. See some of my other Numbers videos or my course on Numbers.

[@kylei.3590]

Thanks so much for these videos. I have been watching a few different ones but can't seem to get my question answered so I will ask you directly. If I have a large table of data that is often being re-sorted but different columns. While at the same time have a separate tab with formulas that pull data from the initial large table. What happens is every time a different column is sorted all my formulas become useless because they are now pulling data from the wrong cells. They will still pull from B,7 rather then from the cell I initially selected. How is it I can lock onto a particular cell in a row and have it stay locked on that cell even when the table is re-arranged or sorted by a different column? Thank you so much in advance and keep up the good work!

[@macmost]

So usually a table is a collection of similar data, like records in a database. What is special about those cells, like B7, that you want that row specifically? Maybe if I understood what you were actually doing I could suggest something.

[@kylei.3590]

@@macmost Okay so I am doing large compilations of data on companies for reference and investment reasons. There will be approximately 30 data points and at the end a final score in 4 different categories. I sometimes like to adjust different columns of data to see how results would change in different hypothetical situations such as an interest rate hike etc. When I make these adjustments it slightly effects the scores of these companies and they become sorted slightly differently. At the same time I have a second tab that pulls data on these companies stock price changes. This second tab pulls the stock price changes from selected stocks and compares it to the overall averages of the market. Therefore when i make subtle changes to the data and re-sort the data my second tab pulls data from the wrong stocks now. This is because it is still pulling from cell (d,4) instead of sticking to company 'abc'. Basically the cell I am pulling data from is not locked to that particular row that company 'abc' is in but rather from which next company occupies that row in position 4. Does this make sense to you? I want to be able to create a formula from a different tab that pulls particularly from the data in the row for company 'abc' no matter how I decided to sort my data by any given column.

[@macmost]

@@kylei.3590 Ah, I see. Use LOOKUP then. It will grab the data from the row that matches (the stock symbol, I assume) and it won't rely on the actual row number to do it. kzbin.info/www/bejne/gH68eX5re7-IoLc

[@thegoatdamn]

Hi!! This was such an awesome video! Do you know how to access Quick Analysis in Excel for Mac? I want to click TOTALS -Sum. But I can’t find Quick Analysis when I highlight the range of cells. :(

[@macmost]

Sorry, I'm a Numbers expert, not really an Excel one.

[@ykk113]

Thanx for your effort.

[@rahbrt]

attempting to add photos to a cell, which I successfully managed to do, but now I want to view the photo in the cell in larger scale & when I double click to open it nothing is selected and photo won't respond. the image is to small to view. without having to zoom in...... is there a way to "view only" photos that were entered in a single cell? thanks in advance!

[@richquesty8371]

I am a new Mac numbers user. I came from HP Excel, where one sort rows and columns by colors. I you help me do this with Mac numbers?

[@michaelmccullough9668]

Is there a way to add a date format like this in Numbers? I want to setup a date format like this Date/Month/Year. So it looks like this "25 Jan 2021".

[@GracelynHedrick]

Is there a way to change the color of specific cells? Please help!!

[@magiciansniece]

Very helpful. Thank you so much!

[@debbiepersaud2169]

Do you have a video/tutorial for the basics of Numbers. Can you share a link ? My Mac is 2009.......yes it’s old so I use Numbers on the iCloud. My iPhone however is 10XS fairly up to date so I have no trouble to view the most recent version. Thanks 😊

[@macmost]

I have a lot of videos on Numbers. See kzbin.info/aero/PL1bsBsPtN-9RMox2tdiIsJ14URKMCkwSn

[@debbiepersaud2169]

@@macmost Thanks so much.

[@luiseEllen]

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 :)

[@BarnabY07]

Very great video. Is it possible to have 2 tables in the same document with 2 different languages formats ?

[@macmost]

You can format tables any way you want. As for languages, you can type any text you want, but the spellcheck won't be very useful I would assume. Why not just try what you want to do and see?

[@sajidullah4661]

Good evening sir. Can we get cell value from one sheet to another sheet in numbers on iPhone not on the computer?

[@mohammedyasmeen]

thanks for you video, how can I add 1 for blank cell and 0 for filled cell?

[@macmost]

What are you trying to do here? If a blank cell has a "1" shown, it really isn't blank. Explain what you are trying to do and maybe I can suggest something.

[@mohammedyasmeen]

@@macmost Thank you for your reply and help, what I wanted to say was I have a list of names (as an example) when all the cells filled with names then I need to have Zero amount in a different cells (to use it as a report), when some name is deleted I need to see a value 1 in some other cell. I am using this formula in excel to have what I want =IF(AB29="",A64,0), but now I am switching into numbers and I want the same thing. Again thank you so much

[@macmost]

@@mohammedyasmeen Just do it that same way in Numbers. That very same formula will produce the same result.

[@mohammedyasmeen]

@@macmost Highly appreciated, it works. you're awesome

[@chinmayeekreddy1832]

Hi can v extract Data from pictures ... Like on excel in numbers app too ?

[@shamcharanjitsinghsatia4782]

do you have video on how to send text messages from numbers ? like we can do with windows Excel

[@macmost]

I suppose you could adapt something like this to do it: kzbin.info/www/bejne/baPMgKt4rcx2isU

[@i2iwithhorses]

Have you, or will you, do a video on setting up a apreadsheet for accounting (double entry)? It may be necessary to copy information from a General Transaction Journal to a specific Ledger Account (a different sheet?)

[@macmost]

I've never done that. Not sure what aspect of double-entry you are trying to do, but you wouldn't want to have your data in more than one table. So a large table where you have two rows for each item, one recording the debit and the other the credit. Usually you would use accounting software for this, but I guess you can simulate parts of it in a spreadsheet if you really wanted to.

[@i2iwithhorses]

@@macmost The current accounting programs want to charge monthly or other fees and store info on the cloud. For my small business the cost is prohibitive. I am looking for a low-cost, one-and-done purchase of a program. It is easy to create a general journal (transaction register) on a spread sheet. I am wondering if a new sheet in the same file can be set up with categories which can pull information from the transaction sheet. The categories sheet would be the General Ledger of accounts. Is this possible?

[@Noyiq]

Hi Gary, could you please advice how to change the text alignment position to degree 180 ?

[@Mheprai]

This cannot be done in Numbers. The only answer is to go to INSERT > and create a text box. You can lock the text box in place but it will not move with a dynamic chart. It's crazy that apple has not solved this as yet when in fact it used to be a function in early versions of this app.

[@Noyiq]

@@Mheprai thank you.

[@edielott1901]

Thx. so much useful info on this video.

[@nounix]

Why can you not right-click on a cell in Numbers and just add a hyperlink to a file on your hard disk, just like you can do in Excel?? In Excel (even in a very old 2011 version..) I can just right click on a cell, and add a hyperlink to a file anywhere on my disk (and if it's a video, for example, the video files is opened with VLC player which is the default player I have selected to open videos. Simple.). Is it possible that in the year 2020 Numbers is still so far behind Excel?? Or is this function "hidden" somewhere Numbers and I just can't find it??