How To Use Autofill In Mac Numbers
Вставка
- Опубліковано 26 чер 2024
- macmost.com/e-2803 You can autofill cells in Numbers using copy and paste, a special autofill feature, and by simply adding new rows to a well-formed table. With the autofill feature, you can have values increase by 1, or using a pattern.
FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY
▶︎ UA-cam - macmost.com/j-youtube (And hit the 🔔)
▶︎ UA-cam Email Notifications - macmost.com/ytn ⭐️
▶︎ MacMost Weekly Email Newsletter - macmost.com/newsletter ✉️
SUPPORT MACMOST AT PATREON
▶︎ macmost.com/patreon ❤️
00:00 Intro
00:31 Method 1: Copy and Paste
01:53 Method 2: Autofill Cells Feature
02:20 Autofill With Increasing Values
02:49 Autofill With Patterns and Dates
04:34 Autofill Increasing Text Values
05:00 Autofill With Formulas
06:21 Method 3: Adding New Rows To a Table
07:42 Tip: Autofill With a Keyboard Shortcut
#macmost #mactutorial
Honestly, this channel deserves more than 100k views or even millions than those fancy office-background tech channels out there.
There is also a. Menu option for Autofill under the Table menu. It only works when you have already selected the cells. So the keyboard shortcuts at the end of this video are the better way to go.
You just saved my life. Im practicing with a csv with over 100k rows. Had a mini panic attack when I had to expand a new formula.Thanks.
You have NO idea how long I’ve been trying to do these actions with numbers and failing! This is awesome!
Very useful. A couple of those keyboard shortcuts I didn't know about. I also chronically omit a footer row when it would be advantageous to use one. Numbers is my preferred spreadsheet app, for sure.
Avery useful and informative video tutorial today! Thank you, Gary! 👏🏻❤️
Thanks for all of your great videos! They have been very helpful as I transition from windows to Mac!
I have to agree with an earlier comment that this channel deserves thousands more views. Have come new to the channel your concise informative videos are helping me master Numbers beyond just data entry.
Always great videos thanks!
Thank you Gary, very helpful.
7:55 is the most useful tip. Thanks!
So helpful. Thanks so much!
Amazing, so helpful!
Gary, more great tips. Thanks
Super helpful - thanks!
Wow that is great information Gary, can save a lot of work in numbers.👍
Thank you sir, it helped a lot.!
The double click is what I needed! Thank you.
this video saved me literally
thanks for the quick info how to make ascending number for cells... 02:20 - :)
Thank you.
Thank youuuu it was taking me forever to find how to do this with google searches!
thank you so much
Thank for your short keys
Thanks bunches
A thing I haven't found in Numbers that I really liked in Excel was doing autofill from a dialog which lets one set start value, step and number of cells in column(s)/row(s). Every way you've shown is tedious when one needs to fill a large number of cells, e.g. dates for all the days of several years.
Nothing like that. But the keyboard shortcut I showed should be non-tedious for your example.
The last 60 seconds have save me a lot of "click and drag"
thanks for the intresting tips , just a quick question : on my iphone i dont get that yelo dot in the middle of the selected box is any adjustment have to be done in setting ?
This video is for Mac, not iPhone. For iPhone, see support.apple.com/guide/numbers-iphone/autofill-cells-tan0e1129cf6/ios
Hi Gary. Thank you for your incredible useful content. I have a question. Is it anyhow that I can auto fill Sheets by date or number? instead I have to manually title every sheet?
Not sure what you are trying to do. You want to create a new sheet and have the title automatically set to something? How often do you need to create new sheets that this is an issue?
This has been very insightful. Thank you Gary. 🙏🏽
Is there a way to make sure the date is written in a specific format say 01-02-2024 ((Date(two digits)-Month(two digits)-Year(four digits)) and repeat this every next month in different sheet?
You can certainly set the format of the cell to whatever you want. But if you are creating new sheets (every month? why?) then you have to set the format there too.
@@macmost Thank you Gary. I have also seen and learnt a lot from your tracking expenses video in your Numbers playlist.
Reason for monthly sheet: I need to send a monthly expenses report on some items on a monthly basis.
I am a novice in using Numbers. (Still have to learn a lot) Thanks to your educational videos I am progressing slowly but surely. 🙏🏽🙇🏽
@@djr3386 see ua-cam.com/video/r_RRpZhUCzQ/v-deo.html for some ideas
@@macmost Thank you Gary for your time and consideration. 🙏🏽
Hi quick question, how do you change value colour - red negative green positive in numbers Mac ? Please
See ua-cam.com/video/-4wn6-f4gRg/v-deo.html
Is it possible to do this auto fill method when using numbers on an iPad ? On the iPad version it doesn’t show the Center dot when highlighting a box.
Yes. Select the cells. Then in the onscreen menu that would appear above the selection choose Cell Actions (or tap the "⚡️ Cell" button at the bottom) and one of the options is Autofill.
Great video thanks, I'm needing to do a column with consecutive financial years eg 2022 to 2023 (in the UK) so starting at Cell A2 2022 to 2023 Cell A3 2021 to 2022 Cell A4 2020 to 2021 Cell A5 2019 to 2020............and so on. I have not been able to autofill as it just keeps repeating the same numbers when I select 2 or more cells, then drag the yellow dot downwards. In other words Its repeating the pattern of what I have already typed but not what I want it to do which is automatically follow the sequence down to the year 2000. Is the a way to do that in Numbers please?
So you are using the exact text "2022 to 2023" in the cell? That's just text and Number can't know that you want two different words in that text to behave in a certain way for autofill. I would just type it for each cell (how many can you have -- only 20 if you go back 20 years). Otherwise, you can have a formula do this by subtracting the ROW() value from 2024 then append " to " and then ROW() value from 2023, etc.
@macmostvideo can we get a video showing how to display the last value in a column/row into a specified cell
See macmost.com/forum/how-do-i-find-the-last-value-in-a-column-in-numbers.html
As always you are great
I have a question is there a way to use the numbers keys in mac keyboard in English and the other keyboard keys in Arabic for example as it is exist in windows and I need to do it the same
Thanks
Not easily. There are some pretty hard-core ways to modify your keyboard using things like Karabiner-Elements that could do it.
@@macmost OK, Thanks I will try it.
@@macmost thanks, I installed the software and tried to change the number to specific international language but didn’t work also I searched on web and also some youtube tutorials but it is not obvious and cannot find a clear explication. Could you please help me on that?
@@mahmoodalganadi8917 You would simply reassign each of those keys to do what you want. It will take some hard work.
can u add a video on how to add spell number on numbers or how to add extension to convert numeric currency to words on numbers
You can't do that. There is no function in Numbers. Is this something you need to do every once in a while? Or do you need it done in bulk, like for each row in a large table?
Is there a way to let say I input a number in cell 2A then for it autofill cell 2F with a set number?
A cell can't "push" a value on another cell. It works the other way. So in F2 you have it "pull" the value. In F2 you would put =A2 as the simple formula to do that.
Is there a way to go rapidly to the last cell of a column in Number on iPad with the screen keyboard (not a physical one) ?
I can't think of a way. You'd need to interact with the table itself, not the keyboard.
Well I finally use this method: I write the letter "Z" in an empty cell a the bottom of table and use the "Find 🔍 " to rapidly go there on my iPad 🤣 !
in the numbers app on mac. is there a way to quickly jump to a specific row without manually scrolling? for example, lets say i have a large number documents with 1000 rows. I am on the 1000th row, and i want to skip to row 219 for example. Rather than scrolling, how could I get to row 216 within a few clicks?
I don't know of a faster way than using the scroll bar. Just grab the "thumb" part and you can quickly get anywhere.
I have an iPad. I’m using numbers on it without a keyboard. How can the yellow dot method for auto fill can be used if the typing is done with the touchscreen or the Apple Pencil?
This video is for Mac. Completely different on an iPhone or iPad. Select the cells to replicate, then tap on the group, select Cell Actions from the context menu, then tap the Autofill Cells button, then drag to expand the area.
Sir why does a finder window pop up when I open pages, numbers, quick time player and other stuffs. I couldn't change by preference which I did. How to solve this problem
Not sure what you mean. Do you mean the Open File dialog? The window that asks you to select a file to open? That's how it usually works.
I’m new to numbers and want to track the drivers at my taxi company across multiple spreadsheets. Any suggestions
Depends on what you mean by "track." You can definitely link data across sheets inside the same document in various ways.
Sir, when ever I copy and paste a value or formula into the column by selecting "d" or such. It pastes it into the header as well? How do I stop this?
Select D2 and then paste.
Can you set it up to automatically fill in todays date as you add data to a cell beside it
Automatically, no? You have to type the date or use Insert, Date & Time.
@@macmost wonder when or if they’ll add macros…
@@macmost thank you for the reply though!!
@@gregsonner8838 Macros? Like scripting? You can already script Numbers using AppleScript/JavaScript through Shortcuts or Automator.
Can we paste row data in as columns?
No, but you can paste into a new table, then Transpose the table. Then if you need you can copy and paste into another table after that.
Oh 😮 thank you so much !!!
What about if I want to change the date by month showing all days of the month with a month list like (January 2023 ) 1/1/2023, 1/2/2023, 1/3/2023 etc.. like in excel =date(b10,month(b12&1),1) how can I do this in numbers?
Not sure what you mean, but look up the DATE function and you'll probably find it.
Sir how do we autofill serial number, when we add a new row??
Not sure what you are asking. What is a "serial number" in your case?
Mine doesn’t do the auto fill for dates. It’s like I doesn’t recognise I want it to ascend dates and just repeats the same value. Very frustrating
You have to have at least two dates in there to show it you want them to be ascending.
👍
How do you add a date + lets say 9 months? For example 1/1/2002 + 9 months = 9/1/2022
If C9 holds your date value, then this will get the date + 9 months:
=DATE(YEAR(C9),MONTH(C9)+9,DAY(C9))
@@macmost nice, thank you. Your videos are always helpful.
why Excel on Mac , does not speak cells ?
What if you want to skip the weekends? I am a teacher trying to create a plan sheet. I spend hours on this at the start of every year. Please help lol
Use functions instead then. Look at the WORKDAY function. If you put the first date in B2, then in B3 put WORKDAY(B2,1) to find the next weekday. Then copy and paste B3 into B4 and below.
this is not working for me
😱
Numbers is crap
I thought I'd ask here because you seem to know more than anyone about Numbers. I've been trying to make an Amortisation Schedule following Moneyness Dot Biz's video Mortgage Calculator with Extra Payment. He's using Excel and I'm trying to copy what he's doing in Numbers. Unfortunately I seem to be getting different results than the ones he's getting in his demo. It would be great if you could do a video on how to do this in Numbers.
There's a mortgage calculator template in Numbers. Take a look at that and maybe it does what you need