Numbers includes several different keyboards to make adding data to your spreadsheet simple. You can also turn your iPhone, iPad, or iPod touch sideways to edit in the landscape orientation.
- Apple Numeric Keyboard Wired
- Apple Laptop With Number Keypad
- Apple Numeric Keyboard Review
- Apple Numeric Keyboard Wireless
When you enter data, Numbers automatically recognizes what you put in a cell and formats it appropriately. For example, if you enter '$100', Numbers automatically formats the cell for currency and uses the Numeric Keyboard when you edit the cell.
If you want to change the format of a cell, tap the cell that you want to edit, tap the Format button , then tap Format. Tap a format to apply it to the cell, or tap the More Info button to see the details of a format.
Text keyboard
This is the default keyboard that you can use to type words, numbers, dates, and more. On iPad,* you can also use the gesture keys to enter numbers and other characters. To quickly enter a number or symbol, drag down on a key and then lift your finger.
Macally 22 Keys Bluetooth Wireless Numeric Keypad for Mac with Arrow Keys & 10 Key Bluetooth Number Pad for Easy Data Entry - Number Keypad for MacBook Pro Air Laptop, iMac, Apple, iPhone, iPad Etc. 4.4 out of 5 stars 333. Magic Keyboard with Numeric Keypad features an extended layout, with document navigation controls for quick scrolling and full-size arrow keys for gaming. A scissor mechanism beneath each key allows for increased stability, while optimized key travel and a low profile provide a comfortable and precise typing experience. Magic Keyboard with Numeric Keypad features an extended layout, with document navigation controls for quick scrolling and full-size arrow keys for gaming. A scissor mechanism beneath each key allows for increased stability, while optimized key travel and a low profile provide a comfortable and precise typing experience. The numeric keypad is also great for spreadsheets and finance applications. Overview Magic Keyboard with Numeric Keypad features an extended layout, with document navigation controls for quick scrolling and full-size arrow keys for gaming. Apple Wireless Keyboard, Magic Keyboard, and many Bluetooth keyboards that use the Apple keyboard layout work with these iOS devices: iPad (all models) iPhone 3GS or later; iPod touch (3rd generation or later) The following Apple keyboards work with iOS: Magic Keyboard with Numeric Keypad. Numeric keypad; Lightning connector, built-in battery.
Numeric keyboard
Tap the Numeric Keyboard button to enter numbers, currency values, and fractions. You can also use this keyboard to add a star rating, checkbox, or enter numbers in scientific E-notation format.
Date, time, and duration keyboards
Tap the Date and Time Keyboard button , then tap the Date & Time button or Duration button to use the keyboards designed to quickly enter dates and times. To adjust an existing time value, use the - and + buttons above the keyboard.
Formula keyboard
You can use the formula keyboard to add functions, numbers, and symbols to formulas. If a keyboard isn't already visible, tap the Show Keyboard button , then tap the Formula Keyboard button to begin editing a formula. To quickly enter a number or symbol on an iPad,*drag down on a key and then lift your finger, or switch to the numeric keyboard on iPhone. You can also enter a symbol by tapping a symbol above the keyboard.
Apple Numeric Keyboard Wired
* This feature might not be available on all iPad models.
Control features on your Mac
By default, the top row of keys on your Apple keyboard control many different features on your Mac. For example, pressing the keys with speaker icons adjusts the volume.
If your Mac has a Touch Bar, learn about using function keys on MacBook Pro with Touch Bar.
Use standard function keys
Standard function keys work differently depending on the app and the keyboard shortcuts that you've set up. Some apps have their own keyboard shortcut preferences that you can customize.
To use the standard function keys, hold the Function (Fn)/Globe key when pressing a function key. For example, pressing both Fn and F12 (speaker icon) performs the action assigned to the F12 key instead of raising the volume of your speakers.
If your keyboard doesn’t have an Fn key, try pressing and holding the Control key when pressing a function key.
Apple Laptop With Number Keypad
Change the default function key behavior
If you want to change the top row of keys to work as standard function keys without holding the Fn key, follow these steps:
- Choose Apple menu > System Preferences.
- Click Keyboard.
- Select 'Use F1, F2, etc. keys as standard function keys'.
If you don't see 'Use F1, F2, etc. keys as standard function keys'
If you don't see 'Use F1, F2, etc. keys as standard function keys', you might be using a keyboard not made by Apple. These keyboards might need a utility to change the keyboard functions. Check with your keyboard manufacturer for more information.
Apple Numeric Keyboard Review
Learn more
Apple Numeric Keyboard Wireless
Learn about using function keys on MacBook Pro with Touch Bar.