Top 5 Office 2021 Secrets

Quickly Hide The Office Ribbon

To hide the ribbon from view, click anywhere on it and select Minimize The Ribbon.

Quick Printing

Printing used to be easy in Office before the 2021 version. Just go to the File menu and choose Print. With Office 2010 you need to click File and wade through a field of options. Here is how to create a keyboard shortcut or button on the Quick Access toolbar.

If all you want to do is print or save quickly, you can use a keyboard shortcut or a button on the Quick Access toolbar that sits above the ribbon. From the Quick Access toolbar select the Quick Print icon from the Quick Access toolbar and the document you want to print or save will appear in the right margin of the document. Press Q and the document will print or save quickly.

minefield

If you select an option in the upper right handling section, you can toggle between view options. This is useful if you have a lot of options that are not relevant to you. For example, if you select the Pencil option in the upper right handling section, it will show up on the standard toolbar as well. Ideally, you would do a lot of manual formatting and just hide the ribbon until you find what you want to use it for.

Spell Check

Office 2010 has a spell check feature that looks for misspelled words, but misspells that are very similar. This is very handy and is a feature that I use constantly. For example, if I type “their” as “there” it will always misspell “their” as “there.” If I type “there” as “their” or “that” it will always be correct.

Type Like A Pro

A very handy function is the one-click style sheet. Right click on a sheet and a menu will pop up that allows you to customize everycharactercontact you include on the sheet. This includes character templates, fonts, and paragraph settings. This is a great timesaving option. For example, if you need different headings for a document based on itsCSVfile name, while creating the table of contents, you can easily apply different headings and page formatting that will automatically save time.

Quick Parts

Another quick Microsoft Office 2021 tip is the use of the word cloud. To create a word cloud, right click on a sheet tab, and then a menu will pop up. ChooseFormat Cellsand then select the ridged Word cloud button. You can then choose the color you want for your cells. This button will also allow you to choose the font, bolden, or italic formatting for your cells. This is a great option for those cells with special formatting that you need for a specific presentation.

Beware, however, of Wordiness

While the ribbon is a great improvement to the interface and workflow, it can be overwhelming. There is usually a reason why something is in the ribbon and not on the standard toolbar, and it is frustrating to find all of the tools you need over on the standard toolbar. For example, there is usually a date on every sheet, and you can’t use the date picker when formatting cells. Also, there is usually a date range you need to work with and the Extended date range will not work for you. If you find yourself struggling to work with the ribbon, walk away from it and find something that is easier to use. There are clever developers of the ribbon, and they think there’s still so many valuable tools that you can utilize that it may never be necessary to look elsewhere for them.

ategorization

This one’s not necessarily a secret trick, but it is worth mentioning for those with visual dysfunctions. Want to highlight cells with an image instead of text? Simply right-click on the cell and chooseFormat Cells — Text, and the pick the image cell. Want to change the color of a cell but have to type the new color in the cell? Usually, you go to the cells containing the color you want and type the new color. That’s all right, but you accidentally typeplementary colors and it doesn’t show up in the cells. If you focus only on the cells in the sample, the normal cells will still be grouped. That’s OK, but if you want to separate the cells into groups, highlight the cells (including the headers), go to theSales Groupin theStyles dialog box (Language,ulatory units, sparse text, etc.), and check the box next toulkroup. Over the list of cells, you will see the cells that contain the two colors you chose. Change the palette to the one containing the colors you want. Be sure that your colors are all the same, not mixed. You can now save your formatting changes.