How to Strikethrough in Excel

How to Strikethrough in excel and Count Strikethrough Cells What is it: Strikethrough is a Font Effect in Excel Format Cells options. In this tutorial you will learn how to strikethrough a word/vale in Excel cell. Below is an example of how strike through looks like in excel [highlighted in red…

Continue reading

SAP BusinessObjects Dashboards (Xcelsius) – Tutorials 1

Introduction to (Xcelsius) SAP BusinessObjects Dashboards – Tutorials 1 What is it: Xcelsius is an enterprise software developed by BusinessObjects, a company specializing in Business Intelligence. BusinessObjects was acquired by SAP and now it’s called SAP BusinessObjects. SAP BusinessObjects Dashboards provide tools for Enterprise Reporting, Query and Analysis, Enterprise information…

Continue reading

VBA Code to Change File Extension

Change File Extension using VBA Code (with Images) What is it: This VBA code will help you change file extension of the files in a particular folder/directory. For eg. If you want to change the extension of the Excel files received in .xlsx to .xls or visaversa then this VBA…

Continue reading

Excel Formula to Sum Cell Values from Multiple Worksheets

Excel Formula to Sum Cell Values from Multiple Worksheets What is it: If you have multiple work sheets in your excel workbook and you want to create a Summary page with totals from all the individual work sheets then you can use the below excel formula or excel shortcut to…

Continue reading

Excel Formula to convert mm/dd/yyyy to dd/mm/yyyy

Excel Formula to convert dd/mm/yyyy to mm/dd/yyyy (with Images) dd/mm/yyyy to mm/dd/yyyy Cell format using Excel Formula What is it? This excel formula will help you to convert Date Format which is in dd/mm/yyyy to mm/dd/yyyy Eg: January, 7, 2014 (1/7/2014) to July, 1, 2014 (7/1/2014) Why is it? This…

Continue reading

VBA Code to Close all Workbooks in One Go

VBA Code to close all workbooks all Workbooks in One Go What is it: This VBA Code will help you close all workbooks opened in the system in one go. Why: When you are creating an Excel Macro to create a consolidated report from multiple individual workbooks and after updating…

Continue reading

VBA Code to Open Excel File from Folder

Open Excel File from Folder with VBA Code What is it: This VBA Code will help you browse and Open Excel File from Folder or a directory. Why: When you create a program and if you want to provide the user an option to select a particular Excel file and…

Continue reading

5 Reasons/Causes for Excel Insert button greyed out on the Developer tab

Excel Insert Button Greyed Out? 5 Solutions (with Images) What is it: Insert button under Developer tab helps you insert Form Controls and ActiveX Controls like Combo Box, List Box, Spin Button etc on your User Form or Excel worksheet. But there are few situations when this Excel Insert Button greyed out…

Continue reading

How to Disable Track Changes in Excel to Enable Insert under Developer Tab

Disable Track Changes to Enable Insert button (with Images) Step by step instructions to Disable Track Changes What is it: Insert button under Developer tab is greyed out and not allowing you to click? Why is it disabled: One of the reasons for this option is grayed out or disabled because you might have enabled…

Continue reading