latest
What are Excel macros?
Learn what Excel macros are, how to create them, and where you can use macros to automate tasks, save time, and boost productivity
Excel macros increase productivity and save time when creating a complex workbook or worksheet. Even if you start with some of the best Microsoft Excel templates, adding macros simplifies using your spreadsheet in the future. Here's an explanation of what Excel macros are, what you can do with a macro, how to write and record macros to customize your workbook, and how to run macros to automate and speed up repetitive tasks.
CSV Files UTF-8, UTF-16, and UTF-32, and which should I use?
What do all those weird CSV formats mean?
There are so many file formats it's hard to keep track of them. Whether writing a paper on a Chromebook or saving a photo on your Android phone, each file has several potential formats. One format that comes up often when working with spreadsheets is a CSV file, which allows you to store data as text and move it between applications. There are multiple types of CSV files, so what's the difference between each of them?
How to freeze and unfreeze a row or column in Google Sheets
Keep all the important details in view with a quick freeze
Spreadsheets are the ultimate business tool for organizing and analyzing data. But all the data analysis in the world won't help you if you don't understand what you're working with, or worse, you can't get your boss to understand it. One problem with large data sets in spreadsheets is that as soon as you scroll down, you can't see your column headers, and it becomes easy to lose track of what's in which column.
Google Sheets is great for working on spreadsheets with lots of data in the cloud. But seeing only a portion of your entries in a document can look strange. That’s nothing to worry about since the app usually hides or overlaps excess text entries to preserve the structure of a sheet. However, if you're putting together an extensive office report on one of the top affordable Chromebooks or a simple item description on your smartphone, you can make your spreadsheet more presentable and readable with text wrapping in Google Sheets. Here's everything you need to know about the feature.
How to hide columns and rows in Google Sheets
Organize your data and restore your sanity with these simple tricks
We've all been there. Staring at a cluttered spreadsheet, trying to find a piece of information. It can be frustrating, time-consuming, and lead to mistakes. Google Sheets allows you to hide columns and rows, decluttering your workspace and making the experience smoother. This article shows how to go about it, whether you're working on a top-of-the-line Chromebook or Android phone.
Google Sheets is packed with many powerful features, and its third-party add-ons take the spreadsheet experience further. Whether you want to import data from multiple productivity tools, start an email campaign, use visual diagrams, or add formatting tweaks to tables in a spreadsheet, there's a Google Sheets add-on to complete the job. However, finding the right one can be tedious and confusing. Since Google Sheets is a web app, the mentioned add-ons are available on Windows, Mac, and the top Chromebooks.
How to use mathematical formulas in Google Sheets
It might just be the solution to your spreadsheet problems
Even if you don't work with or around spreadsheets on a daily basis, you likely understand the basics: data (names, numbers, dates) are placed into cells and organized into rows and columns. Although this may be the limit of most people's understanding of spreadsheets, you need to push beyond this if you want to cross the line from the mundane world of data entry to the realm of data manipulation. Having a nice Chromebook wouldn't hurt, either.
Google Sheets is making it easier to access its most important features
Helping to speed up your spreadsheet-filled day
Google Sheets is already super-popular, reaching a milestone of 1 billion installs on the Play Store only a few months ago, and it's only getting better all the time. The tool makes editing, organizing, and analyzing information across multiple users a breeze. However, there’s always room for improvement, and that's why Google is updating the menus in Sheets for better usability.
Google Sheets hits 1 billion installs on the Play Store, just in time for you to balance your budget
A new milestone for the ever-popular spreadsheet tool
Love them or hate them, spreadsheets are a necessary part of modern life. From keeping track of monthly expenses to making to-do lists, apps like Google Sheets make it easy to organize all of your data into a simple document. More than two years after hitting 500 million installs on the Play Store, Sheets is now the newest app to become a member of the 1 billion club.
New Google Sheets Smart Fill feature aims to make your spreadsheets less tedious to fill out
The rollout begins today
Nobody likes making spreadsheets, so Google is introducing Smart Fill for Google Sheets to help ease the pain. It basically checks previous columns for patterns, offering options to autofill the entirety of the next column based on what it thinks you'll want.
Google Sheets is a handy tool for tabulating and working on data, especially since it's cross-platform and free to use. While it doesn't yet match the functionality of Microsoft Excel, it has been consistently picking up new features every month — from deduplication and trimming of whitespace to enhanced formatting tools. Today, the Sheets team announced three new data reporting tools that can help get you closer to a dashboard running only on Google Sheets.
Google Sheets, which recently crossed the half-billion installs milestone, is a handy tool to create shared spreadsheets that can be co-edited in real-time. Today, the Google Docs team announced a series of tweaks aimed to improve the experience of formatting images, charts, and Pivot Tables.
Back in September, Microsoft teased an interesting new feature at its annual Ignite conference: Insert Data from Picture — a combination of OCR (optical character recognition) and AI (unicorn dust) that promises to convert pesky printed material into rows of editable Excel data (the office format of champions). Beta users of Excel for Android were supposed to get the feature "soon," which turned out to be five months later — it's now live, and works pretty well for a first iteration.
Google has announced a series of new features for Sheets today, including macro support and improvements to spreadsheet printing. While Google Sheets has long been perfectly capable of creating and handling basic or even moderately complex spreadsheets, it fails to fully replicate the functionality of Microsoft Excel, making it a nonstarter for most power users. For professional use cases, Excel still reigns supreme, and Google needs to address Sheets' shortcomings if it ever hopes to make it a viable alternative for professional customers.
Leaving comments in specific places, just like you would in a word processor document, actually makes perfect sense. This is especially true on a mobile device, where it can be easy to miss the forest for the trees due to screen size limitations.
Google is keeping up its fast pace of updates to its office productivity apps, this time with meaningful improvements to both Slides and Sheets for Android. Building on existing presentation abilities, Slides gets notification forward/back toggles as well as an option to watch your audience while presenting to a Hangouts call. Sheets now gives Android users the option to easily edit charts, which were basically view-only previously.
Anyone who has to pore over data on a regular basis knows that it's a best practice to look at some graphs, run basic descriptive statistics, and just generally play around to make sure you aren't missing anything obvious and to assure yourself that there are no mistakes in data entry. This can get really repetitive and sometimes corners get cut. Google is trying to make it easier for you as they have automated the process in Sheets for Android and the web.
There's a pretty basic version of Microsoft Office available for Android in the Play Store, but you won't have much luck trying to install that on anything much larger than a Galaxy Note or Nexus 6. For tablets, the company has something different in the works, and it's now ready to give out tastes to Android users who are eager enough to sign up and get in line.
Google has rebuilt Sheets, the spreadsheet-related portion of its online office suite, and is making the new version available immediately. None of these changes directly affect the Android version of the app, but given that this is the desktop browser-based companion to what Google would consider the platform's best spreadsheet editor, it may be time to give the service another go if you aren't already a committed user. The new version of Sheets comes with a range of new features, including offline support. Now users can work offline and have their files automatically update after reconnecting.
Just when you thought Quickoffice was becoming out of touch with its user base (specifically, with their wallets) the company has released a fairly major update to its two main Android apps.