20 Most Recent Microsoft Excel for PC - Page 4 Questions & Answers


Move the column to A. Mark entire sheet and sort ascending. There are more raffined ways to do this, but this is an easy quick fix...

Microsoft Excel... | Answered on Sep 07, 2014


Sounds like your issue can be solved readily with a pivot table.
If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.
Insert the Pivot table into a new worksheet.
A new sheet will open with a strange-looking control panel on the right of the window.
Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

Microsoft Excel... | Answered on Sep 03, 2014


A pro-forma would usually include all the taxes that are payable by the vendor on behalf of the buyer. These are usually state sales taxes, or in some countries, may appear as a value-added tax (VAT) or goods & services tax (GST) applied as a percent markup of the transaction. The taxes included in a pro-forma should be those that apply to the transaction being taxed.

Is it a good? A service? A commodity, a major asset? Are there other fees & charges levied by local government that do not attract sales taxes?

The answer is:
It depends on what you are taxing, and in whose jurisdiction you are levying the tax and what rules apply to the calculation of the tax. Familiarise yourself with your applicable tax legislation.

Microsoft Excel... | Answered on Sep 01, 2014


I assume that you are creating a pro-forma for others to use. Very simply, you could offer a cell that asks the user to nominate the applicable tax rate for their tax jurisdiction, or, if you know (or assume the value), place that into a cell then multiply the taxable amount by 1+the tax rate, ie I buy shoes for $4 and have a 10% tax rate. Multiply the price of the shoe by 1.04 and you have the final price, inclusive of taxes.

Usually all fees and charges are applied before the taxes are calculated., but check your local tax rules because some government levied charges may not be taxable.

Microsoft Excel... | Answered on Sep 01, 2014


Turning off excel compatibility mode

http://bit.ly/1B8LaJb

Microsoft Excel... | Answered on Sep 01, 2014


Select the data range that you want to sort alphabetically.
Ensure that the active cell is in the column with the names you want to sort.
Hit the Sort Tool on the toolbar (its the one with an A, a Z and a down arrow on it - it's probably next to a Funnel)
Your data should now be sorted.

Microsoft Excel... | Answered on Aug 31, 2014


use this link to download rupee symbolhttp://posterous.com/getfile/files.posterous.com/foradian/N1tP4q7jagR6ej3v82aOEfG45qQ1QpHspimeQOBh5WePATALQdA9v3DWpnjC/Rupee.ttf

Microsoft Excel... | Answered on Aug 23, 2014


Power off the machine.

Microsoft Excel... | Answered on Aug 04, 2014


format the columns to 'date/time' and 'add' cells

Microsoft Excel... | Answered on Jul 31, 2014


It might be as simple as Frozen Panes.
Go Window / Unfreeze Panes and see whether that fixes your problem for you.

Microsoft Excel... | Answered on Jul 17, 2014


It's a bit counter-intuitive...
Go Insert / Name / Define and the Define Name Dialog box will open & display the existing Range Names.
Select a Range Name to delete and hit the delete button.
Repeat as required.
Hit OK to finish.
Done.

Microsoft Excel... | Answered on Jul 17, 2014


If the value in A1 is 100, and the value of A2 is 120, then the formula =(A2/A1)-1 will return 0.2. If the cell containing the formula is then formatted to display as percentage it will show as 20%.

Microsoft Excel... | Answered on Jul 16, 2014


You've probably "frozen" your pane. "Freeze Panes" is a feature which allows you to keep one or more left-hand columns or top rows visible while you scroll through your worksheet.

When you ac

You didn't say which version of Excel your're using, but in Excel 2007, you can either freeze the Row 1, Column A, or any number of rows and columns based on which cell is selected (i.e., where your cursor is) when you click on "Freeze Panes."

In Excel 2007*, the way to fix this would be to click on the "View" tab, then the "Freeze Panes" icon, which will give you several choices. Click on "Unfreeze Panes." There you go.

* The steps are similar in other versions.

Microsoft Excel... | Answered on Jun 21, 2014


=1000/8.25%
=13,333.3333*

Microsoft Excel... | Answered on Jun 09, 2014


Try using a formula like this in Col AI:

=IF(AG9<>1,0,MAX(AI$1:AI8)+1)

A couple of notes:
1. You'll need to adjust the references for this formula in the first row of each new column you use.
2. If you don't want Zeros for the cells that don't increment, the you can use "" instead to get blanks.

Microsoft Excel... | Answered on Jun 09, 2014


The WorkDay Function returns a number that's the serial date that is the indicated number of working days from a given date (the starting date). Working days EXCLUDE weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.
The Syntax is:
=WORKDAY(start_date,days,holidays)
where:
- start_date is in Date format (and can be a calculated value);
- days is a number of elapsed days after start_date (can be calculated, can be negative to indicate a date BEFORE start_date);
- holidays is an array of holidays you can specify if desired.

Microsoft Excel... | Answered on Jun 09, 2014


cells are referenced by column and row. columns use a letter reference and rows use a number reference. to reference pages use the page name. For example if you are entering a formula in a cell on a page named sheet2 and part of the information is located on the page named sheet1, you would use a reference as follows:

sheet1!C3 This reference is for the cell on the page named sheet1 in the third column and the third row.

Hope this helps

Microsoft Excel... | Answered on Jun 07, 2014


Hi Anonymous, I want to help you with your problem, but I need more information from you. Can you please add details in the comment box?
In general, VLookUp can be used to find a value within a range (that's organised vertically), and then return a corresponding value from an adjacent column.
If you can describe in a little more detail what you want to do, I'm sure we can figure out a way to get it done.
Regards,
Scott

Microsoft Excel... | Answered on Jun 05, 2014

Not finding what you are looking for?
Microsoft Excel for PC Logo

670 questions posted

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

Peter Dragonetti

Level 3 Expert

798 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

View Most Popular

Excel Microsoft

  • Excel Microsoft

Most Popular Question

excel 2007 document recovery repeating

  • Computers & Internet
Loading...