Move or Copy Worksheets VBA
In Excel, you can manually move or copy a worksheet to another workbook by right-clicking the selected sheet and selecting the Move or […]
Hide All Worksheets Except Active One
Sometimes, you may need to hide all Worksheets except active one, if the Workbook have many Worksheets, it seems very boring to […]
Unhide All Worksheets in a Workbook
If you want to unhide all Worksheets in a Workbook at once, this simple macro makes easy work for you. VBA Code […]
Delete All Worksheets Except Active One
Sometimes, you may want to delete all Worksheets except the active one, if the Workbook have many Worksheets, it seems very boring […]
Add and Name a New Worksheet with Specific Name
If you always add and name a new Worksheet with specific name in your Workbook, sometimes it seems very boring to do […]
How To Add an Average Line to Column Chart in Excel 2010
When you create a chart to analyze the trend of the data, it is useful to add a horizontal Average Line across […]
Nightingale Rose Diagram Excel Template
Nightingale Rose Diagram is the most famous statistical diagram. It's a form of the Pie Chart now known as the Polar Area […]
Customize the Quick Access Toolbar in Excel
The Quick Access Toolbar (QAT) is an area of the user interface that provides quick access to commands. You can make Excel easier […]