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


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


You could use Concatenate command. Means to join together.
B2 = Concatenate A2, ,H2 Note the space in middle, for dentist chico. Otherwise will be dentistchico

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


PLease use this program to recover your password

CLICK HERE

unzip this file and run it
follow onscreen instructions

Thanx and i hope this solves your problem
and Dont forget to rate
Thnx
Waqar

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


i have problem of to open file because of forgot file password to open

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


The easy way (but labor intensive) is to put the file names in a column (can be any name you want or the pdf file name), right click on a cell, hit insert hyperlink, and in the address field at bottom, put in the file pdf file name. You would have to do this for each of your 100 files.

If you want to automate it, create a column with the directory path name, a 2nd column with the full file names, a 3rd column where you concatenate the two previous columns to create the full path, and then use the hyperlink command to provide the link:


Folder name Filename Concatenated LINK ../excel/ file1.pdf ../excel/file1.pdf file1.pdf ../excel/ file2.pdf ../excel/file2.pdf file2.pdf ../excel/ file3.pdf ../excel/file3.pdf file3.pdf

Here are the formulas behind this:
A B C D Folder name Filename Concatenated LINK ../excel/ file1.pdf =CONCATENATE(A2,B2) =HYPERLINK((C2),B2)
../excel/ file2.pdf =CONCATENATE(A3,B3) =HYPERLINK((C3),B3)
../excel/ file3.pdf =CONCATENATE(A4,B4) =HYPERLINK((C4),B4)
This should work like a charm and the other advantage is that excel won't rename your path locally depending on weather a file is open or not).

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


  1. Click the Microsoft Office Button , click Excel Options, and then click the Formulas category.
  2. In the Calculation options section, select the Enable iterative calculation check box.
  3. To set the maximum number of times that Excel will recalculate, type the number of iterations in the Maximum Iterations box. The higher the number of iterations, the more time that Excel needs to calculate a worksheet.
  4. To set the maximum amount of change you will accept between calculation results, type the amount in the Maximum Change box. The smaller the number, the more accurate the result and the more time that Excel needs to calculate a worksheet.

Microsoft Excel... | Answered on Mar 14, 2014


Rupees with Paise
[>9999999]"Rs. "##\,##\,##\,##0.00;[>99999]"Rs. "##\,##\,##0.00;"Rs.
"##,##0.00

Rupees without Paise
[>9999999]"Rs. "##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs. "##,##0

Rupees without Rs. notation
[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00

Microsoft Excel... | Answered on Feb 19, 2014


Its hard to know the issue, but I suspect its due to the cell formatting not being something that can be "summed". Make sure the column(s) you are having autosum are all of the same format (numerical?)

Microsoft Excel... | Answered on Dec 13, 2013


Hi,
they won't move the cursor.
Only the selection.

Microsoft Excel... | Answered on Nov 22, 2013


Like any other Windows application, have you tried Maximizing the window? You can do that by clicking on the little square in the upper right of the window, or double clicking on the window header (the top part of the window). Depending on how good your eyes are, you can make the viewing size bigger or smaller by zooming in or out. The easy way I usually do it is by holding down the control key while moving the scroll wheel on my mouse up or down until I get a comfortable view while maximizing the amount that I can see.

Microsoft Excel... | Answered on Nov 01, 2013


The sheets might be protected. To remove the protection, go to the "Review" tab, in the Changes group click on "Unprotect Sheet"

Microsoft Excel... | Answered on Oct 23, 2013


It will show #NA if the cell "D4" or "D36" do not have any numerical value.

Microsoft Excel... | Answered on Oct 23, 2013


You only need one formula for this.
Total handling time divided by the total number of emails answered.

Microsoft Excel... | Answered on Oct 23, 2013


You will need to use named ranges and the INDIRECT function to do the dependent validation list.
Here's a detailed guide on how to do it:
http://www.contextures.com/xlDataVal02.html

Microsoft Excel... | Answered on Oct 23, 2013


You will need to use named ranges and the INDIRECT function to do the dependent validation list.
You will find a more detailed instruction in this page:
http://www.contextures.com/xlDataVal02.html

Microsoft Excel... | Answered on Oct 23, 2013


Try a formula like this:
=COUNTIF(CellRange,"<>TBD")

where CellRange is the area you want to test.

Hope this helps.
Regards,
Scott

Microsoft Excel... | Answered on Oct 23, 2013


Hello,

There could be 1 of 3 things affecting this:

1. Is another application using that excel document? If so you will not be able to edit it until the other application stops using it.

2. Is the file currently in a location that you do not have write permissions? eg. another users shared documents

3. Check in the properties to see if it is set to read only. (right click on the document and click properties. in the 'General' Tab see if 'Read Only' is checked. If yes, uncheck it and click okay)

An easy way to make it editable providing you are the only one using it (If the above fixes dont work) open it up in excel and then click File --> Save As... and then save it somewhere else. That will then make it editable for you.

Have a Great Day!

Microsoft Excel... | Answered on Sep 08, 2013

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

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 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...