Excel Keyboard Shortcuts from Microsoft
A few years ago, I wrote a post listing many of the keyboard shortcuts that are available in Microsoft Excel. They included anything from copy & paste shortcuts to formatting shortcuts that could increase your productivity within Excel. Well it looks like Microsoft has posted a printer-friendly list of Excel shortcuts for you to use.
View Two Workbooks at the Same Time
Excel has a built-in way to be able to view two workbooks at the same time side by side. This can be useful when comparing similar values or graphs between workbooks without having to flip back and forth or without copying data from one workbook to the other.
Quick Formatting Using Excel’s Format Painter
Formatting an entire spreadsheet to look just the way you desire can take longer than you’d expect. Clicking back and forth between the formatting options, usually repetitively, can possibly move the completion time of your project back. Excel does provide a quick way to copy a cell’s formatting and paste it to another cell or [...]
Find (and Delete) External Links
I’ve talked with many people that express frustration about having external links in their spreadsheet, but not being able to find them. If this has affected you, you’ve most likely noticed the warning Excel provides asking if you want to update external links when opening your spreadsheet. There are a few ways to locate these [...]
Adding Subscripts and Superscripts to a Cell
Ever wanted to add a subscript or a superscript to the contents of a cell? Excel provides a method to do just that, although it might not be intuitive to do so.
