This Excel tutorial explains how to use Excel Hyperlink Function to add hyperlink to Cell and send email. Excel Hyperlink Function Excel Hyperlink Function is to add a hyperlink to a Cell. You can add hyperlink without using any Function. Right click on a Cell and then select Hyperlink to enter a web address or email address. With Excel Hyperlink Function, you only need to enter argume...

This Excel tutorial explains how to get foreign exchange rate in Excel using VBA and non-VBA. You may also want to read: Get exchange rate using VBA Access Function Excel currency converter template Foreign Exchange Rate Websites Excel allows you to create an external connection to website where you can get the data directly in the spreadsheet. To begin with, look for a dynamic web...

This Excel VBA tutorial explains how to use Hyperlinks Function to send email and add hyperlink to Cell. Excel VBA Hyperlinks Function The purpose of the Hyperlinks Function is to remove or add hyperlink to a Cell, the hyperlink can be an email or a website. There is another Worksheet Function Hyperlink (without s). Hyperlinks.Add Method Syntax expression.Add(Anchor, Address, SubAddress, S...

This Excel tutorial explains how to enable and disable Protected View in Excel and other Office applications. Protected View in Excel Protected View feature is used to protect your computer from virus when you try to open Excel workbook from the Internet or other unsafe locations, or open attachment in Outlook email. The protection is achieved by disabling some features and making the Workbook r...

This Excel tutorial explains how to find last row using Excel worksheet formula. Excel find the last row Finding the last row in Excel is very important especially for creating dynamic data Range, which can be used for setting dynamic Print Area, dynamic Data Validation list, dynamic data source for Pivot Table, etc. When you google this topic, most article talks about how to find the las...

This Excel tutorial demonstrates how to set default font type in Excel. Excel set default font This is a quick tutorial to show you where to set default font type in Excel. You probably need to know this after you upgrade to a new version of Excel. I will demonstrate how to do so in Excel 2013, click here for 2010 version. Click on FILE tab Click on Options on the left menu &...

This Excel tutorial explains how to create dynamic Data Validation list that automatically adjusts the data Range. You may also want to read: Excel Dynamic Print Area Excel dynamic data range Excel graph dynamic data range Create Excel Data Validation list Excel Data Validation list restricts users to select values from a drop down box. When the input is different from the predefined...

This Excel tutorial explains how to use Share Workbook function to allow multiple users to open the workbook at the same time. Excel Share Workbook Share Workbook function allows multiple users to open the workbook at the same time. Assume that we have a staff list workbook that is placed in the network share drive.   Click on REVIEW > Share Workbook   Check t...

This Excel VBA tutorial demonstrates how to combine worksheets columns into one worksheet. You may also want to read: Excel VBA Consolidate worksheets into one worksheet Excel VBA consolidate multiple workbooks into one workbook Excel convert data from column to row Excel VBA combine worksheets columns into one worksheet There are two types of combine worksheets Worksheets have the ...

This Excel tutorial explains how to create Excel dynamic data range using Name Range. You may also want to read: Excel dynamic Data Validation list Excel Dynamic Print Area Excel graph dynamic data range Excel dynamic data range The purpose of Excel dynamic data range is to select data range based on how many data you have input instead of using a fixed range. Assume that you ha...