Hi, Say for example that you have 1234 in Cell D2 and you'd like that same number in D2 through D232. You could enter the number into D@ then hold your shift and arrow down to D232, but that would be painful. If D232 happens to be the bottom of your spreadsheet, then, first make sure that you're focused on D2, then hold ctrl and shift, then press the down arrow. This will select everything from D2 to the bottom of that column, which happens to be D232. If D232 is not right at the bottom of the sheet, then make sure that focus is on D2, then press VO-shift-f3 (add FN if needed) to turn off cursor tracking. Now, navigate down to D232 the quickest way you can, then press VO-cmd-f5 to bring the mouse to the VO-cursor. Then press the shift key and click your Trackpad once. This should select D2 through D232 inclusive.
Now that those cells are selected, press VO-m to go up to the menubar, press t to take you to the Table menu, press the down arrow once, then press a, u which should land you on Auto Fill. Press the right arrow once to open the sub-menu and then down once to Fill Down. All cells from D2 through D232 will now have 1234 in them. If this is text, the same will occur. If this is a formula, Numbers will adjust the cell references accordingly. Later... Tim Kilburn Fort McMurray, AB Canada On Jul 24, 2016, at 08:53, Jeff Berwick <[email protected]> wrote: Hi all, Does anybody know how I can fill a column with the same data for a couple hundred rows in a worksheet? Using the latest version of Numbers on El Capitan. Thx, Jeff -- The following information is important for all members of the Mac Visionaries list. If you have any questions or concerns about the running of this list, or if you feel that a member's post is inappropriate, please contact the owners or moderators directly rather than posting on the list itself. Your Mac Visionaries list moderator is Mark Taylor and your owner is Cara Quinn - you can reach Cara at [email protected] The archives for this list can be searched at: http://www.mail-archive.com/[email protected]/ --- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout. -- The following information is important for all members of the Mac Visionaries list. If you have any questions or concerns about the running of this list, or if you feel that a member's post is inappropriate, please contact the owners or moderators directly rather than posting on the list itself. Your Mac Visionaries list moderator is Mark Taylor and your owner is Cara Quinn - you can reach Cara at [email protected] The archives for this list can be searched at: http://www.mail-archive.com/[email protected]/ --- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
