- Robert F. Ryan, MBA, CPA is an independent business consultant, educator, writer and finance leader in a Fortune 50 multinational company. He has a passion for simplicity, quality, efficiency and a unique ability to explain things to people so they understand quickly and thoroughly. He's worked with spreadsheets extensively for almost thirty years including VisiCalc, Lotus 1-2-3 and Excel.
Category Archives: Excel Copy Formats
I ended last week’s blog introducing the concept of a default worksheet that we could insert at any time in any workbook to help make copying page formats even faster and easier. In today’s blog, we’ll actually save a default … Continue reading
Excel certainly has lots of options for formatting a page to be printed, but do we have to apply each of those features every time we print, especially if we want to print out a page in a way that’s … Continue reading
In last week’s blog, we demonstrated copying chart formats between regular charts. But, what about copying chart formats between PivotCharts? And, what about copying chart formats between regular charts and PivotCharts? These two questions are the subject of this week’s … Continue reading
Have you ever had a situation where you needed to change the format of a bunch of charts? Turns out Excel makes that an easy task by allowing us to copy only a chart’s format and apply it to other … Continue reading
Similar to last week’s blog, we’re going to make the format of particular cells or columns identical to another cell or column, and, again, we’ll use a spreadsheet showing how to analyze refinancing options to demonstrate this feature. (This file … Continue reading
Have you ever had a situation where you wanted to make the format of particular cells or columns identical to another cell or column? I encounter this situation somewhat frequently, and when I do, I use Excel’s format copying feature. … Continue reading