Software : Google updates Sheets as battle with Office 365 intensifies

---

Google updates Sheets as battle with Office 365 intensifies Posted: Google's spreadsheet application Sheets has been updated to make handling big data sets more manageable for power users. They will be able to add data labels to display the exact value of bars or points; Google has also introduced a number of features including being able to filter rows and columns by conditions, adding calculated fields to pivot tables and use the GETPIVOTDATA function. Another notable addition has been to bring in extra steps to prevent accidental edits; sheet owners will be able to restrict editing to a specific set of users and specific range as well as warning people who may be trying to edit certain cells. Touch of glass The latest updates come as Microsoft is preparing the launch of Windows 10. The operating system will contain a free version of Office called Office Touch which offers a small subset of what's available on Office 2016. Users can also use Office Online, which is quietly firming up to become a capable competitor to Google Apps. Check out our preview of Office 2016 as well as our review of Office 2013. Learn also how you can download both of them for free (as time-limited trials).

Mac Tips: How to send any file with Mail Drop in OS X Posted: Mail Drop was introduced in OS X Yosemite as a way to send large files and attachments via the OS X Mail.app without having to go through any Mail servers. It works by uploading the file to your iCloud account (instead of sending it as an attachment), which in turn gets processed as an attachment on the receiving end without any additional work. To the receiver, this message looks normal, but is delivered in a different fashion. In order to use Mail Drop, you'll have to attach a 20MB or larger file for Mail to offer up the service for you to use; if you think this is too small (or too large) of a file size limit, then you can change this threshold to use the feature inside of the Terminal. To begin, quit the Mail app on your Mac, then open the Terminal (located in /Applications/Utilities). From there, enter the following command: defaults write com.apple.mail minSizeKB 10000 This command will change the minimum size in Kilobytes for Mail to offer up the use of the service. Here, we've set it to 10MBs (or 10000 KBs). Press return to activate the new setting, then relaunch Mail for the changes to go into effect. If you ever wish to change Mail Drop back to the original 20MB limit, then quit the Mail app and enter this command into the Terminal, followed by the return key: defaults write com.apple.mail minSizeKB 20000

You are subscribed to email updates from TechRadar: All latest Applications news feeds To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google Inc., 1600 Amphitheatre Parkway, Mountain View, CA 94043, United States