Learn about Using Excel’s Flash Fill to Enter Data
Flash Fill is a great time saving feature that allows you to fill in data based on an example or existing pattern. It usually starts working when it senses a pattern in your data. It’s great when you need to combine columns of data or even change the formatting of data. Below are the step-by-step instructions for using Excel’s Flash Fill to enter data. Continue reading “Using Excel’s Flash Fill to Enter Data”
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”
Learn how to use KeyTips to access Office Ribbon commands via the keyboard.
KeyTips / Access Keys
Access keys are shortcut keys that give you access to the ribbon commands without using your mouse. Once you press the ALT key, KeyTips appear over each command available in the current view, including the Quick Access Toolbar. Depending on which letter you press, you may be shown additional KeyTips. Continue reading “KeyTips – Using the Keyboard to Access the Office Ribbons”