Figure 7: Un-highlighted text selected. Then, click the Format Painter button (highlighted in red within Figure 7 ) similarly to copy the non-highlighting attribute. To remove highlighting from text, you can simply select some non-highlighted text within the PowerPoint slide.Click the Align command again, then select one of the six alignment options. From the Format tab, click the Align command, then select Align to Slide. To select multiple objects at once, hold the Shift key while you click. 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.Select the objects you want to align. Navigate to Keyboard preference pane and select the Keyboard Shortcuts tab.There are so many things that a lot of us do regularly in Google Sheets.Follow these steps to learn more: Open a presentation in PowerPoint. The Subtract command is one of Merge Shape commands in PowerPoint 2016 for Mac. Switch to PowerPoint, click anywhere in the outline, and choose EditSelect.
Repeat the Last ActionIf you can only pick up one Google Sheets shortcut from this article, it should be this one.Below is the Google Sheets keyboard shortcut to repeat the last action:With this shortcut, you will be able to repeat the last action you performed again with a single button.For 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.Just remember that it will only repeat the last action. Top 20 Google Sheets Keyboard ShortcutsHere is a list of my top 20 Google Sheets keyboard shortcuts.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). In the Keyboard Shortcuts dialog box that opens, enable the ‘ Enable compatible spreadsheet shortcuts‘ optionOnce you do this, you will get access to a lot of shortcuts that are also the same in Excel. 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).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.So let’s get started! Enabling Compatible Shortcuts in Google SheetsBefore I take you to the shortcuts, there is something you need to do to make sure you have access to all these shortcuts.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.Below are the steps to enable compatible shortcuts in Google Sheets: For instance, to select the title and image in the slide shown below, click either, hold. With these shapes selected, click the Shape Format tab on the Ribbon (highlighted in blue within Figure 2 ).The easiest way to select multiple objects on a slide is to hold down the Shift key and start clicking. Using skype for macGoogle Sheets will insert the same number of new rows as the ones that you have selected already. For example, if you want to insert three-row, first select three rows/cells and then use the above shortcuts. Cut/Copy/Paste/Undo/RedoThese are the staple shortcuts that are standard and work across applications (Google applications as well as outside Google such as Excel and PowerPoint).Below are the shortcuts to Cut/Copy/Paste/Undo/Redo:Inserting a new row or column is again something we need to do quite often.Below is the keyboard shortcut to quickly insert a row (or insert a column) in Google Sheets:In case you’re not using Chrome on PC, you need to hold the Shift key with the ALT key when using these shortcuts.Note: In case you want to insert multiple rows at one go (or multiple columns at one go), you can use the same shortcut. This is also useful when you want to convert formula to values.You can copy the cells that have the formulas and simply paste them as value over them. Paste Value Only (or Paste format only)When you copy and paste cells in Google Sheets, it will copy the value in the cell as well as the formula and the formatting of the cell ( including the conditional formatting).With this shortcut, you can copy the cell and only paste the value in some other cell. Select the Whole Row (or Select Whole Column)This could be useful when you want to apply or remove the formatting from the entire row or column at one go.Below are the shortcuts to select the whole row or column in one go in Google Sheets:6. Related tutorials: How to Delete Empty Rows in Google Sheets 5. Delete Row or Delete ColumnJust like way we inserted rows and columns, you can also easily delete rows and columns using a keyboard shortcut.Below is the keyboard shortcut to quickly delete a row in Google Sheets:In case you’re not using Chrome on PC, you need to hold the Shift key with the ALT key when using these shortcuts. Cell Alignment (Center, Left, Right) Shortcuts in Google SheetsAlignment options are again something used quite often, and Google Sheets has made it quite easy to change the alignment by adding these options in the toolbar.But in case you prefer shortcuts to change the alignment (center, right, left), here are the shortcuts:11. This means that if you use it once, it will apply the formatting and if you use it again, it will remove the formatting. Formatting Shortcuts (Bold, Underline, Italics, Strikethrough)There are a bunch of formatting shortcuts that can save you time and make it a good experience working with Google Sheets.And thankfully, these are the standard keyboard shortcuts that you may already know if you have been using computers for a while.Below are the commonly used formatting keyboard shortcuts:While the first three are quite standard, the shortcut to apply strikethrough in Google Sheets is specific to Google Sheets (in Excel you need to use Control + 5 to apply strikethrough formatting).Also, note that these are toggle shortcuts. ![]()
0 Comments
Leave a Reply. |
AuthorMichael ArchivesCategories |