Here are five tips for using Googlesheets if you normally use Excel.
1. Check your document is actually a Google Sheet
If you’ve imported it from Excel, it might still be an Excel file that’s being read by Google in compatibility mode. You can tell because name and file type of the workbook will end in XLSX.
This is the worst of both worlds, as you are getting neither Excel nor Google functionality. Save the file as a Google sheet (in the file menu)
