## How to display date using Excel function

Excel is equipped with a variety of functions that are assigned various tasks within the excel environment. The date function is one of excel's features. If you're working on data that involves specified dates and date references, you need to learn to use this function. Like other excel features, the date function plays a vital

## How to Add Odd Numbers Only in Range

If you have a worksheet full of odd numbers and you want to add them, you can use this formula to get their sum. The formula {=SUM(Range*(MOD(Range,2)=1))} Do not type out of the brackets. Hold CTRL+shift, then press Enter while still in edit mode to create an array formula. RANGE= is the range of values

## How to link a cell to a picture

IN the earlier version, people used to call picture links camera snapshots. It's quite helpful when it comes to placing company logos into a company document. The picture link enables the user to resize the logo when they resize the size of the cell. It's easy for the user to insert, resize, move or filter

## How to put multiple data in one cell in excel

You can combine more data from different into a single cell. There are many ways we can combine data into one cell, for example, "The ampersand symbol" the CONCAT function. The steps to combine multiple data from different cells into a single cell 1. Open up your workbook. 2. Select the cell you want to

## How to fix Excel keeps shutting down problem

Excel is undoubtedly a very useful and good application when it comes to editing and scripting documents. However, they say anything with advantages has corresponding disadvantages; the same applies when working with Excel. Locking up and shutting down unexpectedly is a major problem experienced by Excel users when working on their workbooks. The following factors

## How to Split/Divide Excel Cells – 4 Methods with Examples

We are used to working with whole excel cells within columns and rows. At times, you find yourself working with data imported from other sources or even working with data that is not in the format you are used to. Such data can appear in one cell alone (especially when working with texts with limited

Categories VBA

## How to do a case sensitive lookup in Excel

Most users know the VLOOKUP function is not that case-sensitive. For example, when you look up for DAN, dan, Dan to VLOOKUP, all this is the same. The function will return the first matching value regardless of its case.   ​VLOOKUP Case sensitive functions. You can have a table like this; as you can see,

## How to create a table in Excel

Microsoft tablets are created to group and analyze data for easy understanding visually. They are beneficial to every user or Excel as they give structure to substantial data sets from lists. Some users assume that the rows and columns in Excel already represent data tables. It is simply not true as the data is only

## How to create and edit a drop-down in Excel

Working with Excel worksheets can be more efficient and straightforward by using drop-down lists. These lists allow you to create a list of choices that you can select from a given field. Therefore, drop-down lists are a great data entry tool when you want a user to select items from a list you have created

## How to reduce Excel file size

Excel worksheet files can be too large sometimes. Such files need a lot of patience when dealing with them as they take a lot of time to update when you make changes. They also respond slow when opening, which in short makes them time waters especially when you have limited time to handle the document.