How To - Excel

Excel

Results 21 - 40 of about 176

Excel - Macro to search and replace

I have two workbooks with identical setup. item name address 1 address 2... Read more

Excel

May 12, 2010 at 05:50 AM
Excel - The LEFT function

[Excel] The LEFT function This function allows you to... Read more

Excel

November 21, 2011 at 12:11 PM
Excel - Remove #Value error message

How to remove the #Value error while leaving the formula in cell? The... Read more

Excel

December 8, 2011 at 05:02 AM
Excel - Create drop down list on certain cells

I wanted to create a drop down list from data in Sheet2. I have tried the... Read more

Excel

October 3, 2012 at 04:28 AM
Excel - Delete certain cells of active row

I would like a code for the following: Check which row is... Read more

Excel

March 6, 2010 at 05:18 AM
Excel - Filter data through a formula

I need a formula of the following quotation: Column A Belongs To... Read more

Excel

February 11, 2012 at 07:12 AM
Quickly create a simple holiday schedule

Here's a simple tip on how creating an Holiday schedule. A1: Enter... Read more

Excel

June 19, 2009 at 05:35 AM
Excel - VLOOKUP to filter rows based on numbers

I have list of Incident numbers (both Closed and open) in Column A and only... Read more

Excel

March 23, 2010 at 08:02 AM
The logic functions

A short explanation on the use of the following functions: IF, AND, OR,... Read more

Excel

August 26, 2013 at 06:44 AM
Excel - Formatting Individual characters

Generally, formatting options covers whole cells (all of the contents).... Read more

Excel

October 31, 2012 at 09:15 AM
Repainting a cell using excel VBA

I am writing a code in excel VBA to generate a report.I am totally new to... Read more

Excel

November 4, 2009 at 12:56 AM
Excel - Changing cell formula to text

Consider that I have: In cell A4, it contains a formula... Read more

Excel

March 22, 2012 at 10:43 AM
VBA - Setting the AutoFilter function

I have a problem with a macro, I want apply a filter on a field so that when... Read more

Excel

September 12, 2011 at 11:20 AM
Excel - Input mask issue

I would like to assign a custom input mask to a textbox like... Read more

Excel

April 26, 2012 at 07:36 AM
Excel - The DEGREES function

Under Excel the angles are expressed in radians. To convert them to degrees,... Read more

Excel

June 20, 2012 at 12:00 PM
Excel (all versions) - How to copy a simple formula?

To copy a simple formula over a wide range of cells (columns and/or rows),... Read more

Excel

July 16, 2013 at 05:24 AM
Import file names in Excel

I have a folder with a series of Outlook files (with the .msg extension),... Read more

Excel

October 15, 2014 at 04:00 AM
Excel - The TRIM function

The TRIM function removes all empty spaces in a text string, except those... Read more

Excel

November 15, 2011 at 11:05 AM
Excel - Copy and paste values from specific columns

I want to, copy/paste values on the specific column based on cell A2. i.e. ... Read more

Excel

July 30, 2012 at 08:28 AM
Excel - The FIXED function

This function will return as value, a text representation of number rounded... Read more

Excel

November 15, 2011 at 11:12 AM

Subscribe To Our Newsletter!