Microsoft Office Excel

Items relating to Microsoft Office Excel.

Excel - Create Named Ranges from Column Headers

Submitted by Tech-Karma on Sun, 06/12/2011 - 08:42

If you've ever wanted to create a series of named ranges from column headers, the following contains code that you'll need to add to the VB Editor in Excel (CTRL+F11):

Excel - Find and Manage Named Ranges

Submitted by Tech-Karma on Sun, 06/12/2011 - 06:42

Once you've created and defined named ranges in your Excel spreadsheet, use the Name Manager to find and manage your named ranges.

Excel - Show Formulas

Submitted by Tech-Karma on Sat, 06/11/2011 - 09:00

How to show formulas in Excel instead of the actual formula results.

Excel - Get Formula for a Cell

Submitted by Tech-Karma on Sat, 06/11/2011 - 06:00

In Excel, if you're looking to see the function for a particular cell and not all cells, you can use the following:

Create this function in VB (accessible through CTRL + F11)

Excel - Concatenate Numeric Text Format

Submitted by Tech-Karma on Sat, 06/11/2011 - 06:00

Use the following to force Excel to handle your numeric items as you want them to be handled instead of having Excel decide how to handle the conversion of numeric items to text:

Excel - Access Named Range in a Function

Submitted by Tech-Karma on Thu, 06/09/2011 - 09:00

Once you've created named ranges in Excel you may want to access cells within the named range...

Syndicate content