SHORTCUTS FOR GOOGLE SHEETS FOR MAC FULL
SHORTCUTS FOR GOOGLE SHEETS FOR MAC SOFTWARE

Left-click on a cell and type the formula =image then paste the link to the image in quotation marks within a pair of parenthesis.Left-click on a cell and select “Insert” in the menu and then scroll the cursor over “Image” and select “Image in cell.”.This is helpful if you’re using spreadsheets to track brands (and need their logos), competitor products (if you’re conducting a competitive analysis), or any other images you may need to track alongside other data. Spreadsheets are known for collecting all the text and numerical data you can input, but Google Sheets lets you add images as well. Instead of sending a long, complicated explanation in an email, you can tag teammates and show them what you’re talking about – streamlining communication. To do this, type the symbol followed by their email address.Īn example comment tagging someone would look like this: “Hey have you seen this?” This makes sure that if anyone checks the spreadsheet, they’ll notice a comment was left.īut you can also leave a specific comment for a specific person and let Google Sheets notify them that they were tagged in a comment. When you leave a comment, a small yellow triangle will appear in the upper right-hand side of the cell. Left-click on a cell and enter keyboard shortcut Ctrl + Alt + M (Apple users enter.Left-click on a cell then click “Insert” from the Google Sheets menu and select “Comment.”.

Right-click on a specific cell and choose “Comment” from the menu.

There are 3 ways to leave a comment in cells: Remote team communication is happening more than ever today, and one of the most important features Google Sheets offers is the ability to leave comments on specific cells. This added feature makes switching to Google Sheets that much easier.

SHORTCUTS FOR GOOGLE SHEETS FOR MAC SOFTWARE

You can now “enable compatible spreadsheet shortcuts” and use common keyboard shortcuts from other spreadsheet software like Excel within Google Sheets. Plus, Google Sheets released a few exciting updates to their shortcuts last May. You can click any of these to be taken to the specific shortcuts in that category. On the left-hand side of this popup will be categories for the keyboard shortcuts:

If you’re using Windows, hold Ctrl and “forward slash.”Ī popup should appear with a LOOONG list of keyboard shortcuts. If you’re using Apple, hold Command and “forward slash.”

SHORTCUTS FOR GOOGLE SHEETS FOR MAC FULL

The first one you should know about helps you access the full list of keyboard shortcuts within Google Sheets itself. Keyboard shortcuts are the quintessential “hack” and Google Sheets has plenty that you should know.

Shortcuts for google sheets for mac