When selecting text (or cells in Excel), Microsoft includes a Mini toolbar giving you many common formatting options, so you do not have to constantly navigate to the Home ribbon or remember shortcut keys. The options shown on the Mini toolbar will vary, depending upon what you have selected. This option is available in Excel, One Note, Outlook, PowerPoint and Word. It cannot be customized. Examples of the Mini Toolbar within Word –
To activate, select the text you want to format, and the Mini toolbar will appear. You can also right click anywhere to activate it.
NOTE: If you do not see the Mini Toolbar, it may be turned off.
To Turn On/Off the Mini Toolbar
Click the File Tab, select Options, then click the General button. (OR Select (ALT F, T and click the General button.)
Navigate to the User Interface options section and checkShow Mini Toolbar on selection to turn on the option or uncheck to turn off the option.
Excel has a great feature for importing data directly into your Excel worksheet. You can import data from files (Excel, CSV, HTML), databases (Access, SQL), tables, Web, ODBC, etc., making it quicker and easier to share information. Below are the step by step instructions for using the Get Data feature in Excel 2016. Continue reading “Using the Get Data Feature in Excel 2016”
Learn about taking Linked Notes within OneNote, linking them with Word, PowerPoint, Internet Explorer and other OneNote pages.
Using Linked Notes allows you to dock OneNote to a side of your screen so you can work within other applications on the other side. This gives you the capability to automatically link your notes to what you’re looking at. Linked Notes works with Internet Explorer, Word 2016, PowerPoint 2016 and other OneNote 2016 pages. Below are the instructions for taking linked notes within OneNote. Continue reading “Taking Linked Notes within OneNote”
Learn how to Utilize the Excel Watch Window to monitor changes within cells on large worksheets.
When working with a large worksheet or a collection of related worksheets, the data may frequently change. The Excel Watch window allows you to save time by monitoring the results of selected cells in a separate window. Below are the step by step instructions for utilizing the Excel Watch Window. Continue reading “Utilizing the Excel Watch Window”
Learn how to create and work with Excel Headers and Footers.
It’s easy to add headers and footer to your Excel spreadsheets, similar to those added to Word documents. The Excel headers and footers allow you to include document details, such as titles, dates, page numbers, locations, etc. while also making the spreadsheet more professional looking in appearance. Below are the step-by-step instructions for working with Excel Headers and Footers. Continue reading “Excel Headers and Footers”
Learn to navigate Excel’s tabs, ribbons, and backstage using shortcut keys.
In previous blogs, I’ve given you the shortcut keys to both Word and PowerPoint. So, to add to your collection here are the Excel 2016 tabs/ribbons shortcut keys. Remember, shortcut keys allow you to navigate the tabs and ribbons without having to use the mouse. This means you don’t have to keep going back and forth from the keyboard to the mouse! Continue reading “Excel 2016 Tabs/Ribbons Shortcut Keys”
Learn how to freeze panes in Excel – Columns, Rows, and both columns and rows.
Working with large spreadsheets can become unmanageable very quickly. Trying to enter data in rows or columns is impossible when the headings disappear off the screen as you can easily enter data into the wrong cells. Event trying to review the data can become very cumbersome. The ability to freeze rows and/or columns allows you to efficiently enter data into large spreadsheets without having to continually scroll to the headings to ensure you are in the right cells. It also allows you to hone into specific data quickly. Below are the step-by-step instructions for freezing rows, columns, and both rows and columns. Continue reading “Freezing Panes in Excel”