Google sheets shortcuts
That’s all, now you can call the macro with the keyboard shortcut CTRL+ALT+SHIFT+1. 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. To open a list of keyboard shortcuts in Google Sheets, press Ctrl + / (Windows and Chrome OS), Cmd + / (macOS) If you want to see the complete list, check out the Google Sheets support page. 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. Display Find & Replace, Ctrl + H Saveby default save in Drive, Ctrl + S Print, Ctrl + P Show common keyboard shortcuts, Ctrl + / Insert new sheet, Shift +.
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. Selection Shortcuts Select entire google sheet, Ctrl + A Select entire google sheet, Ctrl + Shift + Space Add adjacent cells to selection, Shift + Click Add. I decided that I would color their cells green.
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.