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.
Adjust the Security Level in Excel
If you’ve ever used any Excel files that had macros included, you’ve probably come across the security settings in Microsoft Excel. There are multiple levels of security that Excel provides depending on your comfort level of running macros on your computer. Below we’ll look at how to change this setting and what each setting does.
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 range of cells. Enter the Format Painter.
Read More
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 links and remove them if desired.
Read More
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.
Read More
