How to format and delete empty cells with Google Sheets - power2Cloud blog

"Details make perfection and perfection is not a detail." Nothing could be truer. It is often the details that make the difference and improve our daily lives, including our workdays. Let's talk, for example, about the new G Suite features involving Google Sheets!

If you are in accounting and work with numbers, data and statistics on a daily basis, you will be happy to know that Google has included three new features to format and work more easily in Sheets, the G Suite App.

Cross-referencing and transcribing data you may have brought it back several times without realizing it, perhaps even forgetting to format it because you were in a hurry. Now you can save time and deliver documents with timely information, without manually correcting them or developing Scripts.

Sheets continues to work with you more and more efficiently. Google Sheets helps you tame data and numbers!

If you want to know how to format and delete empty cells in Google Sheets and learn about shortcuts compatible with your keyboard, here is a mini guide for you.

• To remove repeated data simply select the cells and columns you are interested in, go to Tools click on Data, then Remove Duplicates. In the dialog box you will be able to confirm the range of data selected. The operation will take very few seconds.
• To format entries and cut out whitespace, on the other hand, you will need to highlight the columns and rows you are interested in and click, again in the Tools bar of Sheets, Data then Cut Blank Space. Simple no?
• To find out the compatible shortcuts from your keyboard just click on Guide, then Keyboard Shortcuts. You will get the list of all the ones available: this will let you know the commands that will make it faster to use Google Sheets.