If you want to unhide all Worksheets in a Workbook at once, this simple macro makes easy work for you. VBA Code Sub UnhideAllWorksheets() ‘Step 1: Declare your variables Dim ws As Worksheet ‘Step 2: Start looping through all worksheets For Each ws In ActiveWorkbook.Worksheets ‘Step 3: Loop to next…
Sometimes, you may want to delete all Worksheets except the active one, if the Workbook have many Worksheets, it seems very boring to do it manually. In these situations, you can use this simple macro. VBA Code Sub DeleteAllWorksheetsExceptActive() ‘Step 1: Declare your variables Dim ws As Worksheet ‘Step 2:…
If you always add and name a new Worksheet with specific name in your Workbook, sometimes it seems very boring to do it manually. This simple macro can help you. VBA Code Add and Name a New Worksheet with Current Date Sub AddAndNameWithCurrentDate() ‘Step 1: Tell Excel what to do…
When you create a chart to analyze the trend of the data, it is useful to add a horizontal Average Line across the chart, so that you can compare the data clearly and easily. In this tutorial, I’ll show you how to add an Average Line to Column Chart in Excel 2010….
Nightingale Rose Diagram is the most famous statistical diagram. It’s a form of the Pie Chart now known as the Polar Area Diagram. We often see it in the Business Magazines, Newspapers and Journal of Finance. In this tutorials, I’ll show you two styles of Nightingale Rose Diagram Template use…
The Quick Access Toolbar (QAT) is an area of the user interface that provides quick access to commands. You can make Excel easier to use by customizing the Quick Access Toolbar to include the Excel commands you use most often. By default, the Quick Access Toolbar is located at the top left of…
Excel 2010 comes with a new user interface called the Ribbon, which consists of a series of horizontal tabs, each containing a variety of commands grouped according to function. Most features in Excel 2010 are available through the commands on the Ribbon tabs. In addition, the Ribbon can be customized…
Beginners to Excel are often intimidated by all the different elements that appear within Excel’s user interface. After you become familiar with the various parts, it all starts to make sense. Excel 2010 User interface Below figure shows a typical Excel 2010 user interface, with the important parts labeled. This…