Numbers for Mac: Enter text and numbers / Autofill

Autofill cells

You can quickly fill cells, or a row or column, with the same formula, data, or a logical sequence of data—for example, a series of numbers, letters, or dates.

Do any of the following:

  • Autofill one or more cells with content from adjacent cells: Select the cells with the content you want to copy, then move the pointer over a border of the selection until a yellow autofill handle appears. Drag the handle over the cells where you want to add the content.

    A selected cell with a yellow handle you can drag to autofill cells.

    Any data, cell format, formula, or fill associated with the selected cells is added, but comments aren’t. Autofilling overwrites existing data with the content you’re adding.

  • Autofill cells with sequential content or patterns from adjacent cells: Type the first two items of the series in the first two body cells (not header or footer cells) of the row or column you want to fill; for example, type A and B. Select these cells, move the pointer over a border of the selection until a yellow autofill handle (a dot) appears, then drag the handle over the cells you want to fill.

    You can also autofill cells using a pattern of values. For example, if two selected cells contain 1 and 4, the values 7 and 10 are added when you drag over the adjacent two cells (values are incremented by 3).

Autofilling doesn’t establish an ongoing relationship among cells in the group. After autofilling, you can change the cells independently of each other.

When you autofill cells, any formulas that refer to those cells are updated automatically to use the new value


CNET TIP: MacBook: 15 things to tweak when setting up a new MacBook

CNET TIP: MacBook:  15 things to tweak when setting up a new MacBook

BY  –  JANUARY 18, 2018

1. Check for updates

2. Show battery percentage

3. Set up Siri

4. Customize the Touch Bar

5. Sync folders via iCloud

6. Choose default browser

7. Set scrolling direction

8. Get your Dashboard

9. Add and remove items from Dock

10. Move the Dock

11. Set up Safari

12. Enable Night Shift

13. Set hours for Do Not Disturb

14. Set app download tolerance level

15. Choose how quickly your MacBook locks

OS X El Capitan: Use the Character Viewer

Use the Character Viewer to enter emoji, symbols, accented letters, and characters from other languages (such as Japanese, Chinese, or Korean) into your documents.

Open the Character Viewer: In a document, choose Edit > Emoji & Symbols, or press Control-Command-Space.

If you previously used the Character Viewer, or set the option in Keyboard preferences to show it in the Input menu, you can also open it from the Input menu.

To open Keyboard preferences, choose Apple menu >  System Preferences, click Keyboard, then click Keyboard.

Expand or collapse the Character Viewer: Click the expand or collapse button  in the upper-right corner of the viewer. You may need to scroll to the top of the viewer.

Browse characters and symbols: Click the buttons across the bottom of the viewer (if it’s collapsed) or along the left edge of the viewer (it it’s expanded). When the viewer’s expanded, additional categories are visible.

If you don’t see a character or symbol, try searching for it by the Unicode name (such as Question Mark) or code (such as U+003F).

For some emojis, such as those for people, you can hold down an emoji to see variations of it.

Insert a character or symbol in a document: Position the insertion point in the document where you want the item to appear, then click the item in the viewer. If the viewer’s expanded, double-click the item.

Make a symbol or character a favorite: Expand the viewer, select an item, then click Add to Favorites. Or drag the item onto Favorites (if shown) in the sidebar.

Customize the Character Viewer: Expand the viewer, then click the Action pop-up menu You can make the symbols larger so they’re easier to see. To change the categories shown in the viewer, choose Customize List, select or deselect categories, then click Done.

If an app doesn’t use Unicode (a worldwide character set that works with most languages), you may not be able to type some special characters and symbols. Try inserting a different character or using a different app.

OS X El Capitan: Use the Keyboard Viewer

OS X El Capitan: Use the Keyboard Viewer

See where characters for other languages, and special characters and symbols, are located on your keyboard.
  1. Click the Input menu in the menu bar, then choose the input source for the language whose keyboard you want to view.

  2. Choose Show Keyboard Viewer from the Input menu.

    If the command isn’t shown, choose Apple menu > System Preferences, click Keyboard, click Keyboard, then select “Show Keyboard, Emoji, & Symbol Viewers in menu bar.”

  3. Press the key on your keyboard that corresponds to the character shown in the Keyboard Viewer, or click keys in the Keyboard Viewer.

    Press a modifier key, or a combination of modifier keys, to see special characters or symbols you can type. For example, hold down the Option key or the Option and Shift keys.

If you changed your input source or keyboard layout in step 1, be sure to change it back, if necessary.

If you don’t see a specific character or symbol, try using the Character Viewer.