484 Answered Questions for the topic Microsoft Excel
03/19/19
VBA number formatting?
I am writing a macro package to format numbers in accounting format so that I don't have to click "alt - h - fm" every time I want to make a number accounting format (which my job requires). I have...
more
Follows
•
1
Expert Answers
•2
![]()
![]()
Microsoft Excel Excel
03/19/19
How do you format cells as currency in Excel?
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel Excel
03/18/19
How do I copy a “find all” result to another spreadsheet?
Follows
•
2
Expert Answers
•1
![]()
Microsoft Excel Excel
03/18/19
If VLOOKUP finds two or more matching values in a column, can it compare which one has the highest value in a specific cell and then return the value from another cell?
Follows
•
2
Expert Answers
•1
![]()
03/18/19
How can I set contents of a spreadsheet cell to Accounting format with EPPlus?
I need to set the contents of certain columns to Accounting format.
This attempt:
public static readonly string NUMBER_FORMAT_ACCOUNTING = "$";
. . .
bidPriceCell.Style.Numberformat.Format...
more
Follows
•
2
Expert Answers
•1
![]()
Microsoft Excel Excel
03/18/19
How do I make capital letters in Excel?
Microsoft Excel Excel
03/18/19
In Excel, what is the formula to find the average summation, rank, and grade maximum and minimum value?
Follows
•
2
Expert Answers
•1
![]()
Microsoft Excel Excel
03/18/19
How do you make an addition formula in Excel?
Follows
•
1
Expert Answers
•2
![]()
![]()
Microsoft Excel Excel
03/18/19
What is the benefit of using Select Case over If-Then in Excel VBA?
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel Microsoft Word
03/18/19
How do I copy Word tables into Excel without splitting cells into multiple rows?
I have data in a Word table that includes line and paragraph breaks. When I copy the data into Excel, it splits each line and paragraph I want into multiple cells. How do I copy the data to Excel...
more
Follows
•
2
Expert Answers
•1
![]()
Microsoft Excel Excel
03/16/19
Is there a formula in Excel that returns the cell value of a table, by finding the column and row that meets certain criteria?
Follows
•
1
Expert Answers
•2
![]()
![]()
03/15/19
Excel - Formula is guessing wrong in Fill Down command?
I know this should be simple but I can't work it out.
I have a column that is calculated with the sum of the 3 columns to the left of it. E.g. SUM(C1-C3).
When I fill that down, each cell...
more
Follows
•
1
Expert Answers
•2
![]()
![]()
Microsoft Excel Excel
03/15/19
How can I record a cell value in Excel to another sheet each time it is changed by a user?
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel Excel
03/15/19
How do I find the top 3 values in Excel?
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel Excel
03/15/19
How do you alternate column colors in Excel?
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel Excel
03/15/19
What is the difference between Excel XLSX and XLSM?
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel Excel
03/15/19
How do I enter the round function when there is already a formula in the cell?
Follows
•
1
Expert Answers
•1
![]()
Microsoft Excel Excel
03/15/19
How do I automatically color cells in Excel?
Follows
•
1
Expert Answers
•1
![]()
Still looking for help? Get the right answer, fast.
Ask a question for free
Get a free answer to a quick problem.
Most questions answered within 4 hours.
OR
Find an Online Tutor Now
Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.
