#Google sheets shortcuts how to

Set 1 as the keyboard shortcut for the macro. Open macros manager from macros in the tools menu. Open the macro import from the tools menu to add the function to the sheet. Selection Shortcuts Select entire google sheet, Ctrl + A Select entire google sheet, Ctrl + Shift + Space Add adjacent cells to selection, Shift + Click Add.

The function colors the active selection range from the active sheet in green. SpreadsheetApp.getActiveSheet().getActiveRange().setBackground('#93c47d') Open the script editor from the tools menu.

#Google sheets shortcuts how to

Now I just need to select the appropriate cells in the worksheet, pressĬTR+ALT+SHIFT+1 and the macro colors itself for me.īelow I have described step by step how to add such improvement in your spreadsheet. And this is possible in Google Sheets, but it gives us an even better opportunity, which is to connect a keyboard shortcut to the macro, which was just the perfect solution for me. Just assign a macro to the button and it’s done. Looking for a solution to my problem, I became interested in macros as in good old Excel. Because of this I began to feel tired and irritated when marking these links. I often clicked on a different color from the color palette. Every day I choose one link for each portal. If you’re using Windows, hold Ctrl and forward slash. If you’re using Apple, hold Command and forward slash. The first one you should know about helps you access the full list of keyboard shortcuts within Google Sheets itself.

I decided that I would color their cells green. Keyboard shortcuts are the quintessential hack and Google Sheets has plenty that you should know. Since I do not share all links identically, on every portal I do it quite randomly, I had to mark the links that I have already shared. Contains a list of all links to articles on the blog, which I shared on various social networks (each has its own sheet). While working on blog advertising, I created a special spreadsheet.