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

 

https://support.apple.com/kb/PH26375?viewlocale=en_US&locale=fr_FR

Advertisements

APP – Alfred

wpid-alfred-logo-png-2012-05-3-03-55.jpg
Alfred  –  is a keyboard-driven productivity application, helping you launch apps and search your local computer as well as the web with great speed.

FREE  —  Rated 4+
Category: Productivity  /   Seller: Running with Crayons Ltd © 2012 Running with

FEATURES:
* Application launcher: Launch any application with a quick shortcut. Alfred will learn which apps you use often and prioritise them when you search
* Search your Mac: Quickly find and open files, bookmarks, contacts, music and more. You will never again have to wonder just where you saved that important document.
* Search the web: Search or launch your favourite websites: Maps, Amazon, eBay, Wikipedia and many more.
* Calculate and Spell: Just start typing to do a quick calculation or look up spellings, definitions or synonyms and antonyms.
* System Commands: Control your Mac with speed and efficiency. Empty trash, start the Screen Saver, restart, shut down, eject a drive and more.
* Custom Searches: Create your own web searches for frequently used websites and wikis.

get it FREE @ APP STORE  or iTUNES

or go to  http://www.alfredapp.com/

Running with Crayons Ltd Web Site

http://itunes.apple.com/us/app/alfred/id405843582?mt=12

APP – ClipMenu

wpid-clipmenu-logo-2012-04-30-19-03.png
ClipMenu  –  A clipboard manager for Mac OS X,  And a Snippet tool!

ClipMenu can manage clipboard history. You will have saved many items and use that later. You can record 8 clipboard types, from plain text to image.  To paste a recorded item, you just pop up menu by invoking the shortcut key, and select a menu item from the menu.  You can also register texts you frequently use, like e-mail addresses, user IDs and so on, as snippets. You can paste these snippets from the menu, too.

FREE  —  Rated 4+

Unlimited clipboard history items:  You can adjust the number of clipboard history items freely, if you have sufficient memory in your Mac. The default value is 20.

Multiple clipboard types: ClipMenu can record clipboard history in the following clipboard types:  Plain text,  Rich Text Format (RTF), (RTFD), PDF, Filenames, URL, TIFF image,  PICT image

Show images in the menu: If you record image types to clipboard history, ClipMenu can show pieces of the images in the menu. The image’s width and height is adjustable.

Snippet: ClipMenu can manage re-usable text as snippet. You can select it from menu and paste it anytime.

Access with mouse: When you start ClipMenu, you can see the application icon in the Status bar. You can pull down a menu and select to paste clipboard history items or snippets.

Shortcut keys to pop up menus: You can also pop up menus to select clipboard history and text snippets by pressing particular key combinations. It’s very useful for users those who uses larger displays.

Tooltip: When your mouse hovers over a menu item for a second, ClipMenu pops up a tooltip to show full length of text in the clipboard history item. You can see it before pasting it.

http://www.clipmenu.com

APP – Dropbox

wpid-dropbox_logo-2012-04-29-02-51.png
Dropbox  –  Dropbox is a free service that lets you bring all your photos, docs, and videos anywhere. After you install Dropbox on your computer, any file you save to your Dropbox will automatically save to all your computers, your iPhone and iPad and even the Dropbox website! With the Dropbox app, you can take everything that matters to you on the go.

FREE  —  Rated 4+
Category: Productivity  /   Seller: Dropbox, Inc.   © 2011 Dropbox

Read your docs or flip through your albums when you’re out and about. Save photos or videos to your Dropbox and share them with friends in just a couple taps. Even if you accidentally leave your iPhone in a taxi, your stuff is always safe on Dropbox.

Features:
● Always have your stuff with you, no matter where you are.
● Add files to “Favorites” for fast, offline viewing.
● Easily save photos and videos to your Dropbox.
● Share your photos and docs with family and friends.
● Save email attachments straight to your Dropbox.

get it FREE @ APP STORE  or iTUNES

or go to Dropbox Web Site

http://itunes.apple.com/us/app/dropbox/id327630330?mt=8

APP – EVERNOTE

wpid-evernote-logo-png-2012-04-28-02-23.png

Evernote  –  is an easy-to-use, free app that helps you remember everything across all of the devices you use. Stay organized, save your ideas and improve productivity. Evernote lets you take notes, capture articles, screens and other things from the internet, also capture photos, create to-do lists, record voice reminders–and makes these notes completely searchable, whether you are at home, at work, or on the go.

FREE  —  Rated 4+
Category: Productivity  /   Seller: Evernote   © Evernote Corporation 2012

Key Features:

– Sync all of your notes across the computers and devices you use
– Create and edit text notes, to-dos and task lists
– Save, sync and share files
– Record voice and audio notes
– Search for text inside images
– Organize notes by notebooks and tags
– Email notes and save tweets to your Evernote account
– Connect Evernote to other apps and products you use
– Share notes with friends and colleagues via Facebook and Twitter

get it FREE @ APP STORE  or iTUNES

or go to  http://evernote.com/

 

APP – SKYPE

wpid-skype-logo-2012-04-27-18-52.png
Skype  –  Call, video call and instant message anyone else on Skype for FREE with Skype for your iPhone or iPod touch.

Plus call and text your Contacts (or any other number) at Skype’s low rates. It’s great value with Skype Credit.

FREE  —  Rated 4+
Category: Social Networking  /   Seller:   Skype Software S.a.r.l.   / © (c) 2003 – 2012 Skype Limited

Share moments over free* video calls with front and rear-facing cameras:
Enjoy video calls with Skype contacts on, iPhone, iPod touch or iPad, compatible mobiles, PCs, Macs or Skype-enabled TVs.

Call Skype-to-Skype, wherever you are:
Call Skype contacts for free on 3G* or Wi-Fi.

Save on calls to Contacts or any phone number:
Text and call phones anywhere with Skype Credit. It’s especially good value to international numbers.

Send instant messages for an instant response:
Message friends, wherever, and whenever the mood strikes.

get it FREE @ APP STORE  or iTUNES

or go to

Skype Website   http://www.skype.com/

http://itunes.apple.com/us/app/skype/id304878510?mt=8  

APP – Bento

wpid-bento-logo-2012-04-25-19-17.png

BENTO  –  Organize contacts, track projects, plan events, and manage things – all in one easy to use iPhone personal database! Bento for iPhone is one of the top iPhone apps and the most popular personal database for iPhone. Use it standalone or synchronize with Bento in your other devices.

For Mac, iPhone. iPad, and iPod Touch

Bento i$ not Free, but its worthy the price.    –  Rated 4+
Category: Produtivity / DATABASE  /   Seller:   FileMaker, Inc.   © 2011 FileMaker Inc.

get it @ APP STORE  for Mac or iTUNES Store

or go to

http://www.filemaker.com/products/bento/

http://itunes.apple.com/us/app/bento/id314638461?mt=8