Excel/Expert Profile

Mary A. Lindsey

On Vacation
returns 07/31/2017

Follow me on:


I can answer Microsoft Excel 2000-2007 questions regarding formatting, styles, shortcut keys, templates, forms, etc, but will not answer any macro questions.

Experience in the area

I have over 15 years experience working in corporate America as legal and financial document support specialist. I have designed a template that converts html and Excel files to inserts these numerical data into Word documents so that there will be no document corruption because of file size and graphics that comes as part of HTML and Excel.




I am a Microsoft Office Master Instructor (MOS), Certiport Administrator and Proctor (97-2003)

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
Ty06/04/1610Thanks for the reply. I actually figured .....
John08/27/15101010Thank you Mary. As I said; probably .....
Prashant S Akerkar06/26/13101010Dear Mary Thank you. Thanks & Regards .....
John Lord06/06/13101010Thank you for your speedy response. I .....

Recent Answers from Mary A. Lindsey

2016-05-31 Text Only:

Hi Ty,     Apologies for the late reply.    Unfortunately if the numbers and all other data has been entered as text, I do not see how you can 'calculate' the data, except if they are numbers.  What i

2016-02-28 row based data:

Hello Bruce,     Thank you for your question.    What you are trying to accomplish can be done with Named Ranges.  Here's how:    Define and use names in formulas    By using names, you can make your formulas

2015-09-01 I need help creating the correct function in 2003 Excel:

Hi Michael,     Thank you for the question.    For this item:      (1)   "Somehow I need to combine them to make sure the ordered items are not more than what I have in stock but I do not want the inventory

2015-08-26 Conditional formatting:

Hi John,     You can use Conditional Formatting to get this done.    To create the first rule:    Select cells A1 through F##. Do this by dragging from A2 to A##.  Then, click Home > Conditional Formatting

2015-05-31 Conditional Formatting:

Hello Randy,     Recommendation:    Once you have completed the formula and are happy with the result, use the autofill function (or copy and paste the formula) to complete the list    Sincerely hope this


Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here


All Answers

Answers by Expert:

Ask Experts


©2016 About.com. All rights reserved.