![]() ![]() For example, when you are editing text, use a combination of the shortcuts listed on the 3rd row of the bingo sheet. Some of these keyboard shortcuts work best in combinations. If you are using a Mac, you are welcome to use the spreadsheet to modify the list and create your own hotkey bingo sheet with shortcuts for Mac. I've marked these with a ⊞ symbol and bold text (most of them are in the first 3 rows of the bingo sheet). Many of the shortcuts that you can use in Excel and Google Sheets work as general Windows hotkeys for other programs as well. Cross out or color in the shortcuts when you have mastered them. To help motivate you to learn more shortcuts, print this bingo-style list of shortcut keys and put it next to your computer. Most of these shortcuts will also work in Google Sheets. While not a random or complete list, if you master all of these shortcuts, you will be using about 95% of the shortcuts that I use on a regular basis. Instead, download and print a copy of my keyboard shortcut bingo sheet. Printing out a list of ALL spreadsheet shortcuts would be overwhelming. ![]() Using the keyboard efficiently can also help cut down on repetitive stress injuries that result from too much mouse use. ![]() More importantly, they make you more productive. In case of problems with cross-reference fields not being updated as expected, see my article Cross-reference Problems - Troubleshooting.Keyboard shortcuts can save you a LOT of time. See the Microsoft article List of field codes in Word for information about the individual types of Word fields, their syntax and how to use them. Learn the rules that apply to updating fields of different types in Word in the article Updating Fields in Word - How it Works. The gray shading is only visible on the screen in Word - it does not print and it is not visible in PDF. When field shading is set to Always, all fields are shown with gray shading on the screen as in the examples in the table above. Therefore, I recommend that you set the Word option for Field shading to Always (File > Options > Advanced > Show document content group > Fields shading > Always). If you manually modify a field result, the change will disappear the next time the field is updated unless the field has been locked. Since the result of a Word field is determined by the field code and is often influenced by content elsewhere, it is important to be able to distinguish fields from normal text so you don't accidentally change a field result by manually modifying its result. Recommendation - turn on field shading so you can distinguish fields from other content ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |