Microsoft Excel for PC - Page 4 - Answered Questions & Fixed issues


Power off the machine.

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


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

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


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 | 71 views


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 | 69 views


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 | 246 views


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 | 104 views


=1000/8.25%
=13,333.3333*

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


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 | 71 views


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 | 186 views


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 | 94 views


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 | 116 views


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 | 151 views


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 | 128 views


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 | 48 views


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

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


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 | 40 views


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 | 107 views

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

Loading...