Understanding Sheets and Tables In Mac Numbers
ฝัง
- เผยแพร่เมื่อ 7 ก.ค. 2024
- macmost.com/e-2515 Many Numbers users will try to fit everything into a single Sheet or even a single Table in a single Sheet. But the key to using Numbers effectively is to spead out the functins of your document across multiple sheets and multiple tables inside a sheet in a way that makes the most sense.
FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY
▶︎ TH-cam - macmost.com/j-youtube (And hit the 🔔)
▶︎ TH-cam Email Notifications - macmost.com/ytn ⭐️
▶︎ MacMost Weekly Email Newsletter - macmost.com/newsletter ✉️
SUPPORT MACMOST AT PATREON
▶︎ macmost.com/patreon ❤️
#macmost #mactutorial #macnumbers - วิทยาศาสตร์และเทคโนโลยี
Gary & Macmost are the VERY BEST. Period. Gary is my go-to-guy for learning ANYTHING on my Mac :)
Your videos are amazing. You have all of the information that we should get from apple but broken down and easy to understand. I'm a freelance artist and I don't think I could get through a day of accounting without your help. Thanks again!
Fantastic tutorial ~ awesome information 💯
After decades of using MS Office, I’m trying to move to Numbers for my personal life. These videos help. Thank you!
This is so so good. I can't tell you how much information you just handed to me. I am blown away!
Numbers is underestimated
Thanks Gary since i've discovered your channel i've learnt a lot about mac os & ios you are a great teacher!
Thanks you gave the only explanation I could follow. I am a novice with Numbers. What made it most helpful was cross referencing to Excel which I know reasonably well.
Just brilliant! After all these years I'm finally learning something useful. (i'm 74.)
This is a great tutorial on Numbers. I've always used Excel as the default spreadsheet handler, but this video really opened my eyes to the possibilities in my Mac Numbers application. Thanks a lot, Gary. You're great!
Very helpful to my immediate transition from Quick Pom’s to Numbers use.
I learned spreadsheets using Excel but a short time ago I decided to open Numbers and give it a try. I found it cleaner, neater and easier to use than Excel. I also found there were things Numbers could do that I don’t think Excel does!
God Gary - you just keep outdoing yourself ! Well done. I hope Apple is paying you ( as I know they aren’t ) because you keep us Mac users realising we don’t really need any other programs. IWorks does have it all.
Thanks! No, it is viewers like you that support me and I am grateful for that!
Very informative video tutorial today! Thanks for showing us how. Thank you, Gary! 👏👍🏻❤️
Your tutorials on Mac are excellent. Thank you for your output.
Perfect explanation, I just made a comment on another tut, and you have clarified it here Gary - you’re an amazing teacher
Thank you so much! I completely understand this now! I'm going to simplify my database forms to use multiple tables!
Clear and understandable explanation - thank you.
Thank you so much for sharing and teaching!🙏🏾
I understand soooo much better now!
For the first time ever, I didn't find an answer to my problem. I have 1 sheet which is 4 pages. 2 are data and the other two are absolutely blank and I can't get rid of them. Macmost is still my go to for anything 'how to'.
Do you mean when printing? See th-cam.com/video/w7WX0jXbJYM/w-d-xo.html
Thanks bunches. This really helped me understand your June 1, 2021 video...on functions we should know.
Another outstanding video. Thank you so much!
Excellent explanations, thanks!
Thanks for the great info.
Very helpful thank you
Good grief…. I have recently switched to Mac after 20 years of Windows. Looking to get away from Office too. Then I find this video and here’s my sign. This is stupid simple for what I need. Thanks man.
Very cool. 😎
Thank you
One of the best, most overlooked feature of Numbers. Since Excel lacks this design metaphor, many ugly and strangely formatted Excel sheets get created as a workaround.
Awesome 👏🏼 great info. SUSCRIBED. Can you make a video on how to merge two different worksheets into one?
Thank you!
Brilliant. I'm quickly gravitating away from Excel.
Can you add conditional formatting to a table? For example, duplicate items? Thanks, your videos have certainly helped tremendously!
To find duplicates, see th-cam.com/video/H0Vrwxkekk4/w-d-xo.html
any way you can show how to set up a value from one worksheet to another, in a temple kind of setup
I have a temple I work in but the majority of it is redoing from one sheet to the next think there must be a way of having a duping format so I can just put in at least some of it in the first and it carries over
I enjoyed this video. After a lifetime of using excel, numbers is challenging me. Do you ever think numbers will include the ability to make pivot tables? I ❤️ Pivot Tables.
It has them now!!! 🥳🎉
@@mauricioflores3732 thank you
Thank you Gary for all of your videos. So helpful. What if I only wanted to pull out "oranges" from one table into another table?
Not sure what you mean. If you want to copy data from one table to another, copy and paste should do it.
@@macmost I have a spreadsheet of names and paste and copy does work. I then use an "if" formula to find duplicates. I then use that data sheet to divide the names into groups on another sheet. I use a filter to group the names and then sort the names into ascending order based on first name. The problem is that the next time I want to do this the filter and sort does not work. Is this because the data changes each time I do the "if" formula?
@@timthompson8852 Sounds pretty complex. It is hard for me to grasp the whole picture here with your description, sorry. Just keep working at it, or get some firsthand help if you can't figure it out.
Good style - I’m hoping I can finally cut over to numbers - I’m still fluent in Lotus 123 but my platform options are running out.. I’m Mac but does numbers also run on Windows 🙂
Numbers is Mac/iPad/iPhone/Web but the web version is more for collaborating. I wouldn't use it instead of an app.
Hi Gary, Thank you for another informative video.
Is it possible to next or refer to another document in one document. For example I am making document with all my expenses and income for tax purposes.
In Document A I want to break down my income into each month but do not want to have to scroll a lot.
So I created a document A with 3 sheets each with 4 tables.
Is there a way to open Doc A from another document again to keep the scrolling to a minimum?
Also I could not get a one cell table to work with formulas like you did in the video. It seems to want to keep 2 rows at least. And sometimes dragging the "=" sign would not go up to delete rows but would go down to add rows. Has anything to do with this changed in the newer versions of numbers? I am on v11.1
No, you can't link documents like that. As for one-cell tables, make sure you turn off the header row.
@@macmost Thank you Gary.
Thanks for the video!
I need year + amount in a specific year in a sheet and make the results in a summery sheets - I have found out of that.
My problem: I need it for several sheets and have the results in a summary. Is possible? Or do I need to make a row for each sheet in the summery and add it all together in the summery sheet?
You should keep data together in one table. If you have divided it up among many tables on different sheets, then you'll just need to create a new table and reference the results from each table.
@macmostvideo Is there a way to sort sheets alphabetically in Numbers?
Sheet themselves? No. You just drag them to reorder them as you like. If you have so many sheets that this is a problem, I'd encourage you to rethink your data organization.
Long-time watcher, first-time commenter, new subscriber.
Can sheets be named by a formula? I want to have a sheet for each weekly offering at my church, with running YTD and MTD totals, along with summary charts on a separate sheet. Would love to have each week's sheet automatically generated, ready for data entry.
Yes, you can refer to any cell using strings created inside formulas. Look at the INDIRECT function for instance. But I would caution against having weekly sheets. Treat your data like a database and have it in one long table. If you need to display weekly information, have it pull from that table. See this for an example: th-cam.com/video/r_RRpZhUCzQ/w-d-xo.html
i
what if you already created a separate expenses list in a different table and different numbers file for each month? how to combine them quickly without adding row 1 by 1 and copy + paste the data 1 by 1?
The date feature could show you that I would think.
Hi Gary, thank you so much for teaching about us mac numbers. I have a windows laptop but also a iphone and I started to use numbers for in and outs of my small business. It's the first time that I'm using spreadsheets and you are very helpful. Still though I can't make a SUM from two different tables of the same or different sheets. Any idea what's the problem? Thanks in advance
The SUM function is for a range of cells. If you need to get the SUM of a range in one table and add the SUM of a range in another table, you need two SUM functions. So: =SUM(first range)+SUM(second range)
@@macmost Thank you for your reply Garry! I’m trying to make a SUM from two specific cells from different tables. Not a range of cells.
@@Rubahell Oh, so that's not a job for the SUM function at all. That's just addition. like =A1+A2
@@macmost Simple as that! Thank you!
I followed your tutorial very well until about the point of 9:20 minutes. I do not understand why you type the words sumif when starting your formula for the new cell. Why aren't you just clicking on the individual cells with the + number between each selected cell? What does "sumif" do and mean? Is there anything you can add to help me understand the material presented form 9:20 and 10:30 in your video; I use Numbers a lot and this would be a great additional tool. Thanks so m much. Love learning how to get the most out of my Mac!
SUMIF gets the sum of a range of cells IF a condition is met. Sure you could do a series of + operations, but that would mean manually do it each and every time, manually selecting which cells to add. The whole point of using a computer for this is to make things easier for you. You could add new rows with new dates and SUMIF will figure out which ones match those dates. Read the help info for SUMIF and watch th-cam.com/video/KU-nYXO7fPg/w-d-xo.html
Hi! I want add a text in to a formulation in the same cell, how i can made?
Not sure what you mean. Ask with more details here: macmost.com/ask
Hi, excel can open two spreadsheets of the same book at the same time (in a new window). In numbers, I want to see, manage, copy information of two tabs of the same document, In the same time on to windows I the same screen. I just see it can open in tabs the diferents documents. But in the same document I can’t see the way. Do you know about it?. Regards 🇲🇽
There's no easy way. But you can always open a second temporary document, copy and paste the other table to it, and then copy the information from that temporary document to the original one.
Hello-
How do you sum over multiple tables and sheet using the lookup function.
For example, I have 2 sheets with 2 tables in each containing the same product in different locations. How do I sum all tables that coordinate with the same product name ?
Use multiple SUMIF functions and add them together.
Hi Gary ! Do you know how to paste formula results as links? I seem to lose my link when I paste the formula result.
Links? I'm not sure what you mean.
Sir Garry how to print a single table from a sheet with multiple tables?
Thank you so much.
See th-cam.com/video/w7WX0jXbJYM/w-d-xo.html
Hi! Anyone knows if it's possible to keep a table visible while scrolling down the spreadsheet? I would like to keep it at the bottom. Thanksss
No way to do that.
How do I export numbers file so someone on a pc can open it in excel? What format do you save it when exporting to excel?
File, Export To, Excel.
What about iPad Pro with numbers can you do the same as Mac book pro
iPad Numbers has much of the same functionality, yes.
I did some computation getting some values from different tables. The total doesn’t come out right. But when i get from same table it comes out correct??
Check your formulas carefully. Must be a mistake in there.
How do you import another sheet from another worksheet? For example I have two spread sheet, one is a budget and another is a mortgage calculator. I hate having to switch between the two I would love to just click on a tab to see the other sheet. Also, my mortgage sheet has two tabs. Again I am trying to combined all three into one number document. Thanks
Do you mean combine from two documents into one document with multiple sheets? Copy and paste is how you do it. Copy a table from one document, paste it into a new sheet in your other document.
Can you tell us how to reorder the list of tables in the Sheet's Tab? When you click on a Sheet's Tab, if there are multiple Named Tables (or charts), you see a down-ward facing arrow. Click on the arrow on the right of the tab & you see the names of all the tables in that Sheet. It seems that they are displayed in the order they were created. How can I get the Names of the Tables to display in Alphabetical order? I've dragged & re-arranged the tables on my sheet so that they are in alphabetical order on the sheet, but the drop-down list from the Tab is not in alphabetical order. Thanks
They are in order of which in on top of the other. Use the Arrange menu and the first 4 items there to move the tables in front of or behind the others.
How do you have two lines of data in the tables section? I have long bank account names and numbers, and only need two columns. The large title disappears unless I keep enough empty columns. Is there a way to have a two line title so I can eliminate the extra columns without making the title disappear?
Not quite sure what you mean, but you can use Option+Return to insert a new line into a cell.
Sometimes all I need is a simple spreadsheet for entering data, so is there any way to keep the table in place so it doesn't shift around when I scroll up or down? I use Apple's Magic Mouse and the table seems to bounce around a bit when I try to scroll thru a table. In Microsoft's Excel, the table doesn't shift around so I can easily target the cells I want to edit. I tried locking the table, but that doesn't help as it only keeps me from making edits.
Not sure what you are looking for. The table needs to shift as you scroll or you wouldn't be able to see more of it. It definitely does this in Excel also, as you need to be able to see more of it there too.
@@macmost In some Excel templates, like Workbooks, they give you the option for an "endless" table that fills the entire sheet to input data in a spreadsheet. In Excel, when I scroll up/down, the columns scroll in a straight path without shifting side-to-side. And if I scroll left/right, the columns move in a straight path without shifting up and down. So the table stays in place while only the columns and rows move when you scroll but not the table itself. Also, in Numbers, if you scroll to the far left, you'll see a vertical gray bar on the left edge of the window and if you scroll to the very top, you'll see a gray horizontal bar just underneath the toolbar. It's like the table bounces around instead of being static.
I wish Numbers had a preference to have a table that scrolls in a linear fashion rather than like a rubberband. This can be slightly annoying when I'm trying to target specific cells, but the slightest touch of my mouse causes the table to bounce around. I thought holding down the shift key would help me to scroll linearly, but it didn't help. The best way to see this is to open a Numbers and Excel document side-by-side and try scrolling. There's something about the fluidity of Numbers' scrolling compared to the rigidity of Excel's scrolling. Both have their place, I just wish Numbers could let you choose between the two. Thank you for all the great content.
I've got a document with several sheets and I need to put those sheets in alphabetical order at the top. Does anyone know how to do it? It was pretty easy to it on Excel, but dragging on Mac Numbers is laborious and impractical for dozens of sheets. Also, a quick way to jump between sheets??
Why do you have dozens of sheets? Are you dividing up like data across sheets, maybe? Like one month or year per sheet. Maybe try a different strategy and put all like data in one table on one sheet (like a database) and use other sheets to analyze that data and do other things.
I'm using Tables to keep trace of articles, but now it has put a FREEZE on column one and I can't remove it to sort the column. How do I get that FREEZE off this column?
I'm guessing it isn't a freeze, but you just are trying to use a header row or column as a place of regular data. See th-cam.com/video/Vc5JmwCQiFk/w-d-xo.html to learn about header rows and columns.
I just had to upgrade from Numbers for Mac '09, which I much preferred. I hate the sidebar for editing, for one. But now I have an even more serious problem. When I insert a new table into a spreadsheet, it is transparent. So if I want to slide it partially over another table, I see the information coming through to my top table. This is a big problem for me, & I cannot find any solution via Google. Can anyone help me? The old Numbers would let me slide one table partially over another & only see the top table, so I could preserve the information on the bottom table without having it bleed thru to my top table, creating a mess. Help!!!
First, I would hide columns in the table if you want to preserve information in a table without seeing it. Try that instead, it is much cleaner and easier.
Otherwise, you can always select the table or just some cells and go to the Format sidebar, Cell, then change the Fill to a color fill. Choose any color you want, like a solid white.
@@macmost That hide suggestion did the trick! Thank you so much!!!
Can anyone help me? When I add a sheet, it doesn't show in the tab. thanks!
Do you see the tab at the top with the first sheet? Is it not next to that? Try adding it again.
How do I bring a specific template to sheet 2?
Templates are for documents, not sheets. But you can always create a new document with a template, then copy and paste the tables and other elements in the sheet you want from one document to another.
I have a saved numbers sheet I cannot figure out how to edit. I’ve done it before, I tap the + to add a sheet but it does nothing
What else besides adding a new sheet have you tried? Can you edit cells? Is there any kind of message when you try?
@@macmost
Only zoom & collaborate nothing else in tool bar. Can also tap print set up & text on far right. I decided to make a new one, I noticed it looks updated. Could it be because it’s an old version?
@@momovaryacting8798 Not sure what you are seeing, sorry. Maybe post a screenshot somewhere I can see? Or, use the contact form at macmost.com and you can email me a screenshot.
What if you want to have your numbers document pull data from another file such as a CSV file?
Pull data? Live? Numbers can't do that alone. You'd need some scripting or an app to handle that.
@@macmost Does numbers support deep linking?
@@merlingrim2843 What do you mean by "deep linking" exactly? An example?
@@macmost Check out stack overflow. Search for issue-deep-linking-to-ms-excel-from-ios-app. iOSAcademy also has a YT video on the subject.
@@merlingrim2843 That came up with an article dealing with Swift that at a glance doesn't seem to apply to Numbers spreadsheets. Tell me in a sentence or two what you want to DO here.
I wish that there were something like sheets in "Pages" so that I don't need to find and open the documents all over the place.
Maybe using Tabs instead of separate windows is what you are looking for?
How to used hyperlink in numbers??
Select the text (inside the cell) and then use Format, Add Link.
@@macmost thanks Gary.. 🙏🏽
How do I export a single sheet as pdf 😩
When you go to the Print preview (Command+P) there is a setting there for "This Sheet" or "All Sheets."
Nice presentation. However you say that in Excel there's only one Table per page/Worksheet. Actually you can have multiple Tables on each worksheet. I didn't realize this for years till someone told me the difference between Worksheets and Tables in Excel. Those differences are more obvious in Numbers, while being almost "hidden" in Excel.
Do you mean the ability to put a table inside the existing table? That's an interesting function, but not really what I am talking about here.
@@macmost No, this is more like designating a portion of the worksheet at a "Table" either by Insert>Table or by placing cursor inside the range you want as a Table and pressing Ctrl-T. That way I've actually placed several "Tables" on a single Sheet.
@@TArnoldFerguson When I try those things I get a table inside the main table, not a separate table like in Numbers.
@@macmost I think this is a matter of semantics. What you're calling a "main table" does not function like a "Table" (I'll use upper- and lower- case t's to differentiate. A "table" is essentially a worksheet with all the math and logic functions of spreadsheets. A "Table" has additional properties (like being nameable, pivot tables. etc.). I guess I'd say that a Table is like a super-table. I'm really talking above my abilities here, so forgive my meager attempts at an explanation.
Ok, Gary, but sometimes it is very risky to modify things that are already accepted by the majority in a not so critical aspect. Tell us what happens when you have to go back from Numbers to Excel regarding compatibility.
Try it. You can export from Numbers to Excel. You have options then on what to do with tables. You'll see. But I do suggest that if you are working on a document with others that are using Excel, that you use Excel too. Same for any app.
I really want to move away from Excel.
I can’t find two features that I use the most.
1) Remove duplicate rows.
2) split text by special character.
There are no quick buttons to do either of those. But you can use formulas to do them. For instance: th-cam.com/video/H0Vrwxkekk4/w-d-xo.html
First b
Not especially bothered about putting picture of horses into worksheet!!. Would rather know how the trackpad works on Numbers, for instance...
1st view
I'm trying my damndest and it aint working on my computer. EEERRR!!! = a1+b1 and I get ZERO!!!
What is in A1 and what is in B1? When you select A1, does it show "Actual" and the number at the bottom left. How about B1?
This is so confusing - not easy like excel at all
"Microsoft does that too!" LOL! MS Windows came first. It always does. Mac is the copycat plagiarizer.