In case youвЂ™re not using Chrome on PC, you need to hold the Shift key with the ALT key when using these shortcuts. Inserting a new row or column is again something we need to do quite often.Д«elow is the keyboard shortcut to quickly insert a row (or insert a column) in Google Sheets: These are the staple shortcuts that are standard and work across applications (Google applications as well as outside Google such as Excel and PowerPoint).Д«elow are the shortcuts to Cut/Copy/Paste/Undo/Redo: So if you make the cell color red make the font style bold, using F4 will only apply bold font format as that was the last action it remembers. Just remember that it will only repeat the last action. With this shortcut, you will be able to repeat the last action you performed again with a single button.ДЇor example, if you color a cell red, you can go to any other cell and simply press F4 and it will color this cell red as well. If you can only pick up one Google Sheets shortcut from this article, it should be this one.Д«elow is the Google Sheets keyboard shortcut to repeat the last action: In case you want to get the whole list, I have a bigger list at the end of this article (click here to jump to the bigger list). Here is a list of my top 20 Google Sheets keyboard shortcuts. Once you do this, you will get access to a lot of shortcuts that are also the same in Excel.

In the Keyboard Shortcuts dialog box that opens, enable the вЂ Enable compatible spreadsheet shortcutsвЂ option.

Since Google Sheets is a web-based tool, a lot of the keyboard shortcuts that are available in other spreadsheet tools such as MS Excel are not available and you need to enable these.Д«elow are the steps to enable compatible shortcuts in Google Sheets: So letвЂ™s get started! Enabling Compatible Shortcuts in Google SheetsД«efore I take you to the shortcuts, there is something you need to do to make sure you have access to all these shortcuts.

In case you want a quick list, click here to get to the table at the end of this article that shows all Google Sheets keyboard shortcuts in one place. In this article, I am sharing my top 20 Google Sheets keyboard shortcuts that I find myself using quite often (and I am sure these will also save you time). YouвЂ™ll be amazed at how much faster you can work when you know only a couple of shortcuts (mostly for the tasks that you do a lot вЂ“ such as formatting cells or deleting rows). And while a lot of these options are readily available with a few clicks, you can be a lot of more productive if you get used to a few Google Sheets keyboard shortcuts. If you donвЂ™t want to copy the formula from the cell above and you just want the value, you can use this useful shortcut.There are so many things that a lot of us do regularly in Google Sheets. Copy value from the cell above PC: Ctrl+ Shift+ вЂќ Mac: вЊѓ+ в‡§+ вЂќ Copy formula from the cell above PC: Ctrl+ вЂ Mac: вЊѓ+ вЂД¬opying the formula from the cell above is a great way to make an exact copy of a formula. If you donвЂ™t want certain sensitive data to be visible, you can hide them (hidden rows and columns do not print). Sometimes it can be useful to hide rows in your worksheet.

Bonus: Hold down Shift and the left/right arrows to select multiple columns. Likewise, selecting entire columns can be a great timesaver too. Select entire column PC: Ctrl+ Space Mac:вЊѓ+ Space Bonus: Hold down Shift and the up/down arrows to select multiple rows. Use this shortcut to select a single entire row. Selecting an entire row can be a great timesaver. Select entire row PC:В Shift+Space Mac: в‡§+ Space You will be asked where the data is for your table, and then your table will automatically be created. Use this shortcut to quickly insert a table. If you want to add an outline (outer) border around your selected cells, just use this quick shortcut.

Add border to cells PC: Alt+H, B Mac: +Option+0 Here are eightВ useful keyboard shortcuts to speed up your work in Excel. We can always use a few shortcuts to save time.

Mac keyboard shortcuts for excel