Force a Break to an External Link in Excel

If you’ve ever tried to break an external link in Excel without success, this is for you.  External links are sometimes created when copying a worksheet to another file or a new workbook.  If the Edit Links button on the Data ribbon doesn’t allow you to delete the external reference the following steps will show… Read More Force a Break to an External Link in Excel

Advertisement

How to apply banded rows in Excel without converting to a table

Excel 2010’s Table feature provides many different Table Styles including options for banded rows and customization.  What if you want to format your data with banded rows without having to convert it to a Table?  You can do this with Conditional Formatting. What’s a banded row?  It’s when every other row has a different shaded… Read More How to apply banded rows in Excel without converting to a table