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. 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.
SHORTCUT ON MAC FOR HIGHLIGHT IN GOOGLE DOC 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. 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). We are left with the merged, new “Name” Column.While working on blog advertising, I created a special spreadsheet. Now you can delete the FirstName and LastName columns and the original Name Column.
First, Copy the Name Column :Ĭreate a new column and do “Paste Values only”. You have to first convert the “Name” column to values. This is because the Name Column is constructed using those first two columns. You may want to delete the FirstName and LastName columns (the source columns) However, then the Name field also will become empty.
0 kommentar(er)
