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


The answer depends on the password type and document version. They are classified here: http://passcovery.com/helpdesk/knowledgebase.php?article=47

Look for your password and Excel version and use these tips, if possible.

Microsoft Excel... | Answered on Oct 13, 2015


go google and type in --manual for excel version (what ever it is ) and down load the pdf file
go to a book shop and buy a Excel for dummies book
or e-bay and excel for dummies or other excel explained books
explaining it as a reply will be as confusing as the reply would be pages long

Microsoft Excel... | Answered on Oct 13, 2015


I was like that when the problem exists when double-clicking in Windows Explorer. Then I get the message that the program isn't responding and have the option to close or wait. After a few moments Excel does eventually open and I can work on the file. I do not have the problem when I open the file directly form Excel.
Read here, perhaps this article will help you - Excel Restore Toolbox http://www.excel.restoretools.com/

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


One appraoch that comes to mind is to nest an AND function into your IF statement along the lines of IF(AND(Test1isTrue, NOT(ProductColleccted)), TrueAction, FalseAction)

Microsoft Excel... | Answered on May 02, 2015


I don't think you can. It's a real resource hog especially if youre using 2010/13. See below.

Excel 2003 is officially limited to 1 Gigabyte (GB) of memory.
This limit appears to be a limit on the working set memory used by the Excel process, which is the memory reported by Windows Task Manager.
Although Excel 2003 has a substantially increased memory capacity, many of the individual specific memory limits listed below have not changed in Excel 2003.

Excel 2007 is limited to 2 Gigabytes of memory for the Excel process under Windows XP/Vista (Windows memory limit).
This 2 Gigabyte limit is a limit on the Virtual Memory address space. Virtual memory used by a process is larger than the working set memory reported by Windows Task Manager, so the amount of useable memory under Excel 2007 is considerably less than twice that of Excel 2003.
Because Excel 2007 (Excel12) also requires more memory to store the indexes to the increased number of rows and columns you may not be able to load larger workbooks under Excel 2007 than was possible under Excel 2003. Memory Fragmentation may also mean that it is difficult to make use of all of the available 2 GB of virtual memory.

Many of the individual memory limits listed below have been removed in Excel 2007.

Excel 2010 is available in 2 versions: 32-bit (2 Gigabytes of virtual memory) and 64-bit (8-Terabytes (which is 8000 Gigabytes of virtual memory)).
The 32-bit version has the same memory limits as Excel 2007, but the 64-bit version, when used with a 64-bit Windows operating system, will have extremely large memory limits.
Note that the different versions of Windows Vista 64-bit and Windows 7 64-bit support differing amounts of RAM.

Microsoft Excel... | Answered on Mar 20, 2015


Nowadays, with the development of the technology, you are able to remove excel password so as to access your files again safely and very easily with excel password reset programs. And Excel password recovery is a popular tool that can reset Excel password from Excel 97 to Excel 2007. Meanwhile, it can open your file again without any damage or data loss at all.
To recover your password, you can follow a step-by-step guide on how to recover Excel password for 2007 edition.
Step 1:Download Excel Password Recovery and install it.
Step 2:Click Open and select the file you need.
Step 3: Choose an attack type to recover Excel 2007 password.
Step 4: Attack settings.
Step 5: Click Start on the taskbar, and when the operation finished, you will recover the lost Excel 2007 password

Microsoft Excel... | Answered on Mar 13, 2015


The easiest way is to add a field, name it attendance or something and assign a value of one. Then sum column a / sum column b for average.

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


The best way is to contribute in Learning class outdoors, because beeing between other studens and masters could growth your knowledge well, you can ask your questions easily and get the answers clearly and useful.Also, other studens will ask other useful questions which help you to increase your knowledge,infact, people there, share their idea and it's good for you. ---- The other way is to use books, learning books about Excell,  and of course you should not stand just on one book, you have to study many books about it. ----- Other useful thing is to travel between websites about excell and forum.Websites are full about excell 2007, they are updating soon and you can get your answers through these websites, and you could learn many tricks and notes about excell 2007. -------- the other thing is Media files about excel, but i guess they aren't enough quality to teaching! -------- Don't forget the practise, and do some real projects to get enough exprienss.
I provide some usefull links about excel 2007 bellow. Check them, I hope they could help you.
www.baycongroup.com/el0.htm

www.gcflearnfree.org/computer/topic.aspx?id=143

www.computer-training-software.com/excel-2007.htm

www.topshareware.com/Quic-Excel-2007-tutorial-Packs-download-58139. htm

www.cbtplanet.com/microsoft-desktop-training/microsoft-excel-2007.ht

www.totaltraining.com/prod/microsoft/excel2007_ess.asp

www.netwind.com/html/microsoft-excel-2007-training.html

office.microsoft.com/exce

------ Good luck

Microsoft Excel... | Answered on Jan 06, 2015


how can we do vlookup two sheet on excle?

E.g

Sheet1 Sheet2
Class Marks

here there are two types of Sheets.If i want to combiend two sheet via vlookup.could you teach me what should do i for same ASAP.

thaks.

Microsoft Excel... | Answered on Jan 06, 2015


You should find what you want here:
http://www.usd.edu/trio/tut/excel/

Microsoft Excel... | Answered on Jan 06, 2015


You can download a manual at:
Excel 2000
www.it.miami.edu/classes/pdfs/excel.pdf

Excel 2007
http://office.microsoft.com/en-us/excel/HA101680001033.aspx

good luck, thanks for rating y solution

Microsoft Excel... | Answered on Jan 06, 2015


Be sure the Excel format/version you are uploading is what's expected (2003,2007, etc.). Further, your naming convention of the file may not be valid. See your classes uploading specifications and be sure you're file is up to par!

Microsoft Excel... | Answered on Jan 06, 2015


Conditional formating should be able to this. But how is your data organized? (Column headers, Row headers etc.)

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


There are 2 types of direct cell references that you can use when you're writing formulas: Relative References & Absolute References.
A Relative Reference is the address of a cell (e.g. A5). When a Relative Reference in a formula is copied from one cell to another, the Reference gets changed automatically. e.g. If you put a formula in cell c5 as A5+1, when you copy this from c5 to c6 the formula A5+1 will automatically change to A6+1.
An Absolute Cell Reference does not change when its copied to another location. As in the example above if the formula in cell C5 is written as $A$5+1, if you copy this formula from C5 to C6 it will remain as $A$5+1 (NOT change to $A$6+1.
The $ sign signifies Absolute, and can be applied to the Row reference, the Column reference, or both Column & Row (as in the example).

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


If it isn't too big of a spreadsheet, you can sort it on the column which has the numbers in it, which will put all the 1's in the top of the stack and you can then select just the cells with 1's in them and Excel will count the number of cells that you currently have selected. The number will show up in the Name Box (above cell A1) as: R2 X C2 (for two rows and one column currently selected). Rows are horizontal and columns are vertical.

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


One way would be to create a colunn C and use the formula: =COUNTIF(B$2:B$200,A2) in cell C2. Then copy the formula down to C200. (assuming you have 200 entries in B...). This will put a "1" next to every number in Column A that has a match in column B. Then you could put a conditional formula in column A that will highlight the cell if the value in column C is equal to 1. Alternatively you could also simply filter for 1's in column C and then manually highlight the cells that show up in A!

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


The Little Green Triangle (LGT) is an indicator to alert you to a potential error in your formula. The LGT doesn't stop you from entering a formula (with or without an error), it's just an alert to check that it's OK. If you're happy with the formula you've entered, then you can just ignore the LGT and carry on.
If it's bugging you, you can turn off background error checking.
Go Tools / Error Checking / Options / and uncheck "Enable background error checking". That will turn off the LGTs.

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


If you have a number in Cell A2 (say 100), and you put the amount of percentage increase or decrease in Cell A3 (say -10%), then put this formula into Cell A4 to calculate the answer:
=A2*(1+A3) , which then shows as the answer (90).

Microsoft Excel... | Answered on Sep 08, 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...