New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Number's shortcut for Fill Down


Post Reply New Thread Subscribe

 
Thread Tools
ojosdelangel

 
ojosdelangel's Avatar
 
Member Since: Nov 19, 2009
Location: Vancouver, BC, Canada
Posts: 6
ojosdelangel is on a distinguished road

ojosdelangel is offline
We just bought a Mac and I use Excel (now Numbers) for a TON of things. I also use the fill down tool a lot. I'm wondering if anyone knows of a keyboard shortcut for the Fill Down option?

This is driving me bonkers!

Thank you!

~Natalie
QUOTE Thanks
Collin Bl

 
Collin Bl's Avatar
 
Member Since: Apr 07, 2009
Location: Napier NZ
Posts: 3,283
Collin Bl is a jewel in the roughCollin Bl is a jewel in the roughCollin Bl is a jewel in the rough
Mac Specs: 27 iMac i5, MBP 13 & iMac 20, 2TB dual TC, AppleTV, iPh4S

Collin Bl is offline
just drag handle in bottom right corner of cell and drag down - if u wnt a series then put box round 2 cells and drag down


Click for full size
QUOTE Thanks
ojosdelangel

 
ojosdelangel's Avatar
 
Member Since: Nov 19, 2009
Location: Vancouver, BC, Canada
Posts: 6
ojosdelangel is on a distinguished road

ojosdelangel is offline
Thank you, thank you, thank you!!!!!
QUOTE Thanks
halightw

 
Member Since: Nov 25, 2009
Posts: 1
halightw is on a distinguished road

halightw is offline
That doesn't really answer the question.... which was for a KEYBOARD shortcut. I just started using Numbers instead of Excel myself and I am finding the lack of keyboard support particularly annoying. Especially the lack of a shortcut for Fill. Fortunately you can assign your own shortcuts in Mac OS X

Goto Systems Preferences, select Keyboard, and Click on Keyboard Shortcuts, Click the plus "+" sign to add a shortcut, select or Add Numbers as the Application and put "Fill Down" in the command spot and then assign your shortcut. I assigned command D, similar to Excel.

Now I must rant about the lack of keyboard support in Numbers. I really don't understand why Apple didn't include shortcuts like the one above by default. It's kind of an obvious thing and any Excel power user would be quite unhappy without it. There are also some other annoyances with the keyboard such as the inability to specify a range with the cursor keys when entering a formula. For example Try typing "=sum(" and the using your cursor and shift keys to specify the range... you can't do it, you have to move your hand all the way over to your mouse, position, click and drag for the range... This takes way longer to do, especially if you're just doing a quick little sum or other function where the cells are very close by. While the mouse can be a very useful accessory I really dislike being forced to use it unnecessarily. The mouse should be used to help us not hinder. The invention of the mouse was a great thing but it is not the only way to do things... I would be willing to wager large amounts of money that a Excel power user that knows all the keyboard shortcuts is an order of magnitude faster than someone who uses the mouse. If Apple wants those same power users to switch to Mac/Numbers they should have the same capabilities in their software.
QUOTE Thanks
nabl

 
nabl's Avatar
 
Member Since: Dec 13, 2007
Location: United States of America
Posts: 256
nabl has a spectacular aura about
Mac Specs: 2.1GHz MacBook with 4GB RAM, Mac OS X 10.6, iLife and iWork 09

nabl is offline
Quote:
Originally Posted by halightw View Post
Now I must rant about the lack of keyboard support in Numbers. I really don't understand why Apple didn't include shortcuts like the one above by default. It's kind of an obvious thing and any Excel power user would be quite unhappy without it. There are also some other annoyances with the keyboard such as the inability to specify a range with the cursor keys when entering a formula. For example Try typing "=sum(" and the using your cursor and shift keys to specify the range... you can't do it, you have to move your hand all the way over to your mouse, position, click and drag for the range... This takes way longer to do, especially if you're just doing a quick little sum or other function where the cells are very close by. While the mouse can be a very useful accessory I really dislike being forced to use it unnecessarily. The mouse should be used to help us not hinder. The invention of the mouse was a great thing but it is not the only way to do things... I would be willing to wager large amounts of money that a Excel power user that knows all the keyboard shortcuts is an order of magnitude faster than someone who uses the mouse. If Apple wants those same power users to switch to Mac/Numbers they should have the same capabilities in their software.
To select cells using the arrow keys while typing a formula, hold the Option key while pressing the arrow keys. You can also hold Shift to make ranges, and each time you let up on the Option key, a comma is inserted and a new cell or range begins. It's quite handy.
QUOTE Thanks

Post Reply New Thread Subscribe


« ColorSync Profiles for Microsoft Word | What is Abk.app? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
iTunes Track numbers with audible files charliexedd OS X - Apps and Games 1 11-07-2009 03:28 PM
Audacity keyboard shortcut bug dauber Music, Audio, and Podcasting 1 04-29-2009 01:12 PM
Copying data from email into numbers on iMac Andy and Shell Apple Desktops 0 03-08-2009 06:22 PM
Cutting and Pasting from emails into Numbers Andy and Shell Switcher Hangout 0 03-08-2009 06:20 PM
How to Set a Shortcut key to launch an application? imme Switcher Hangout 2 04-01-2008 12:47 PM

All times are GMT -4. The time now is 04:40 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?