Google Sheets Tips Articles

Checkmark added with text
Google Sheets Tips

How to Insert Check Mark Symbol in Google Sheets

If you work with checklists in Google Sheets or use it to keep track of tasks/projects, you can also use checkmark symbols to show the tasks/projects that have been completed. It adds a layer of

Script File in Google Sheets
Google Sheets Tips

Does Google Sheets have Macros?

The short answer is YES – macros can be used in Google Sheets. Macro – as a computing term – means – a set of instructions/steps allows you to perform particular tasks. In simple words,

Save an Excel file as Google Sheets
Google Sheets Tips

How to Convert Excel to Google Sheets (Step-by-Step)

The war between Google Sheets and Excel users rages on. These are two of the most popular spreadsheet programs. Those who are comfortable using Google sheets swear by it, while Excel lovers prefer to stay

Enter 000000 in the Custom Number Formatting dialog box
Google Sheets Tips

How to Keep Leading Zeros in Google Sheets

If you work with numbers in Google Sheets, there is one thing that can often frustrate many users. When you enter a number in a cell in Google sheets that has leading zeros, it will

Click on the Unmerge option
Google Sheets Tips

How to Unmerge Cells in Google Sheets (Quick Guide)

Merging cells is quite common when you’re working with data in Google Sheets. A lot of times, people merge cells while creating headers or labels. And you can also easily unmerge cells in Google Sheets.