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: iOS 11 will let you record your iPhone or iPad’s screen

iOS 11 will let you record your iPhone or iPad’s screen


To use the new screen recording feature, you’ll first need to add the feature’s button to Control Center. Open Settings > Control Center > Customize Controls then tap the green plus button next to Screen Recording. Learn more about what’s new in iOS 11’s Control Center here


Record without sound

With the shortcut added to Control Center, swipe up from the bottom of your iOS device’s screen and tap the Screen Recording button. The button will begin counting down from 3, giving you time to get to the screen you want to record. The status bar at the top of your phone’s display will turn red when it’s actively recording. Tap the red bar to instantly stop recording. 


Narrate as you record

A button to turn Microphone Audio On or Off will show up just beneath the record button. Tap the button to turn audio recording on, then tap Start Recording. The microphone button will turn red when activated as a reminder that audio will be captured. Now iOS 11 will record using your device’s microphone along with whatever is on the screen. Neat, right? 



View and share

Once you stop recording, the video is saved to the Camera Roll on your device. Open the Photos app to find it. You can then view, edit and share the recording as you would a video you recorded using the Camera app. 

CNET TIP: iPhone IOS 11 – How to fix 7 annoyances in iOS 11

CNET TIP: iPhone IOS 11 : How to fix 7 annoyances in iOS 11

1. Stop autoplay videos in the App Store

Auto-play videos are everywhere you turn, which you have probably noticed if you have visited Facebook, Twitter or pretty much any website lately. With iOS 11, auto-play videos have come to the redesigned App Store. If you don’t want demos of games and other apps to automatically start playing when you are scrolling through the App Store, it’s easy to disable them. Open Settings, go to iTunes & App Store, tap Video Autoplay and select Off.



2. Put an end to app rating requests

Apps asking you for your thoughts and opinion isn’t new to iOS 11, but a setting to disable them is. Now, you can put an end to an app interrupting you with a request for you to rate it. Head to Settings > iTunes & App Store and toggle off In-App Ratings & Reviews.



3. Turn off Bluetooth and Wi-Fi for reals

The buttons in the Control Center for Bluetooth and Wi-Fi no longer turn off your device’s Bluetooth and Wi-Fi radios. Instead, they simply disconnect you from devices and networks so you can continue to use AirDrop and AirPlay and the Apple Pencil and the Apple Watch. Read Rick Broida’s informative post on the topic for more detail, but the short of it is you need to dig into Settings to actually turn off Bluetooth and Wi-Fi. Those paths: Settings > Bluetooth > Off and Settings > Wi-Fi > Off.


4. What to do with screenshot thumbnails

I agree, the new iOS 11 screenshot tool is awesome. But if you want to take a screenshot and quickly save it to your camera roll without editing or annotating it, then you might get annoyed by the thumbnail preview that appears in the lower left corner of the screen. Turns out, you can just ignore them. Better yet, swipe to get rid of them. You do not need to tap on the thumbnail, tap 

Done and then tap Save to Photos to save a screenshot. Just let the thumbnail disappear after a few seconds or flick it away — either way, it’ll be saved to your photos.


5. Uncover the hidden auto-brightness setting

The auto-brightness control has moved from its logical spot in the Display & Brightness page in Settings. Where did it go? It’s now hiding out in the Accessibility page. Follow this path to find it: Settings > General > Accessibility > Display Accommodations.


6. No Night Shift in Control Center?

There are many new buttons you can add to the revamped Control Center, but the Night Shift button it not one of them. It is, however, only a 3D Touch or long-press away. Call up the Control Center and 3D Touch or long-press the brightness slider and you’ll see the Night Shift button at the bottom of the screen.


7. Declutter the iPad’s busy keyboard

This one is iPad-only. With iOS 11, the iPad’s keyboard gets double-mapped keys to make it easy to access symbols and numbers, which you might find to be #convenient. If you can’t get the hang of the flick gesture to type a key’s secondary symbol, however, and want to return to the old iPad keyboard without the double-mapped keys, head to Settings > General > Keyboard and toggle off Enable Key Flicks.

CNET TIP: iPhone IOS 11 Tips

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


Drag and drop text

Highlight and then press on a word or highlighted section to drag and drop it into other location. This only works within the same app and document on the iPhone, at least. 



FaceTime screenshots are a thing of the past

Instead of your trying to capture a precious moment during a FaceTime call by taking a screenshot, iOS 11 will let you take a Live Photo of the call. The toggle is in Settings > FaceTime. 

Tap the new shutter button while on a FaceTime call to take a FaceTime Live Photo. Pretty sweet, right? 


Emergency SOS

The Apple Watch is no longer the only Apple device with an Emergency SOS mode. Your iPhone can now call local authorities and contacts of your choosing if you simply press the power button five times. 

Depending on your preferences, which you can set in Settings > Emergency SOS, your phone will either prompt you to complete the call or will do it automatically.



Take notes from the lock screen

You can now add a shortcut to the Notes app in iOS 11’s revamped Control Center, and access the Notes from the lock screen. 

Hidden in Settings > Notes is an option to select whether you want Notes to open the last note you edited, or if you want to create a new note every time you access Notes from the lock screen.


Mark up all the things

A new sharing option has been added to iOS 11. It’s called Markup as PDF and it lets you do just what it says. 

When viewing a web page, a photo or a file, tap the Share icon and select Create PDF. You can then use the iOS markup tool to draw, sign or add text to the document before saving or sharing it. 


A new Shut Down button

If your power button breaks, you can still turn the phone off with a new Shut Down option in Settings > General. To turn your iPhone back on, you’ll need to have a charging cable handy, as the iPhone will turn on the moment it’s plugged in to charge. 



Photo, video format options

Apple is using a new photo and video file format starting with iOS 11, but if you’d rather not mess with it or are running into compatibility issues, you can revert back to the older format. 

Open Settings > Camera > Formats to set your own preference. 



Forget recent apps

The iPad’s new app dock has a section that displays recently used apps, but if you’re not a fan of the constant suggestions you can disable it. 

Open Settings > General > Multitasking and turn Show Recents to Off. 



One-handed keyboard!

Apple has added a one-handed keyboard option to the iPhone. There are two ways to activate it:

  • Settings > General > Keyboards > One Handed Keyboard 
  • Long-press on the emoji or globe icon on the keyboard

You can select a right- or left-handed keyboard, and switch back to a full keyboard either by following the same steps outlined above, or tapping on the arrow placed next to the keyboard. 



Universal notification control

Instead of having to go through each and every app’s notification settings to set your privacy preference, iOS 11 now has a universal setting for message previews. 

Go to Settings > Notifications > Show Previews. There you can select the default setting for all apps. 



iPad keyboard learns a new trick

When typing on the iPad’s digital keyboard, you no longer have to press the shift or symbol keys to insert some special characters. Instead, you can press a key and flick down on it to insert the corresponding symbol on it. 

For example, in this GIF, you can see the gesture used on the Q key to insert “11,” and again to insert the “!” through the comma key at the end of the sentence. 



iOS 11 App Store Purchased Section

When looking for previously purchased or installed apps in the App Store app, you’ll quickly notice the Purchased link isn’t readily available. 

Starting with iOS 11, you’ll need to open the App Store and tap on the profile icon where you’ll find Purchased once again. 



Live Photos during FaceTime calls

Taking screenshots of a FaceTime call to save a photo is no longer necessary. As of iOS 11, you can now capture a live photo of your screen during a call.

Both parties need to have the feature enabled for it to work. To enable it go to Settings > FaceTime > FaceTime Live Photos. 

Then the next time you’re in a FaceTime call, just tap on the shutter button. 


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