(0000) |
JustLocal™ |
Think global, act local |
| Home | News | Benefits | Purchase | Areas Covered | FAQ | Conditions | Contact Us |
|
|
MyAnswers:
Microsoft Excel
NOTE: Only JustLocal advertisers can purchase MyAnswers solutions on the JustLocal page.
|
|
|
|
Click link |
Question |
Date |
Length |
|
|
|
|
|
|
||
|
|
|
I have a hyperlink in Excel 2007. How do I change the hyperlink to just be normal text?
|
03/02/08 |
244 |
|
|
|
|
I'm trying to add a jpeg image to an Excel spreadsheet for general distribution. Under Windows XP to image shows fine. Under Windows 2000 the image does not appear. What should I do?
|
01/11/06 |
226 |
|
|
|
|
I have a cell which has a Data Validation so the cell contains TRUE or FALSE. I also want the cell to be blank. In another cell I want to display text depending on the TRUE or FALSE value and no text for a blank value. What is the IF statement I need to write?
|
21/11/05 |
2118 |
|
|
|
|
I want to allow the user to enter true or false into a cell in Excel. In another cell I want to test the value of the true or false answer, and based on the answer display some text. How do I do this?
|
18/11/05 |
3065 |
|
|
|
|
When I enter a note in Excel and have it justified, the last line looks terrible with the few words having large gaps between them. How do I get around this?
|
06/10/05 |
170 |
|
|
|
|
When the user opened an Excel spreadsheet they received a message "This workbook contains links to other data sources". These links are because they copied and pasted from another spreadsheet. The user wanted to know how to find the links so they could be removed and replaced with non linked values.
|
06/10/05 |
444 |
|
|
|
|
How do I enter multiple lines into the one cell in Excel? If I press ENTER at the end of a line I immediately leave the cell.
|
04/08/05 |
437 |
|
|
|
|
I have a long formula in an Excel spreadsheet. When I copy the formula to another location the cell references change. Can I easily change the cell references into absolute references so they don't change when copying the formula?
|
16/06/05 |
639 |
|
|
|
|
When I go to print my Excel spreadsheet it is very small with a lot of empty space. I try to make adjustments but it does not help.
|
06/06/05 |
1996 |
|
|
|
|
I get a memory error when I try to load an Excel spreadsheet on my old notebook computer. The spreadsheet was created on my newer desktop computer.
|
22/05/05 |
512 |
|
|
|
|
I am using an Excel worksheet as a database for listing data, then this data is sorted so that certain items appear at the top of the list - all done with the auto sort. Fine so far! The problem comes in when I protect the worksheet. The auto sort no longer works. How can I get around this problem?
|
09/05/05 |
263 |
|
|
|
|
I am trying to set up an Excel spreadsheet as a data source using ODBC for other programs. I can see the data in MS Word, but I cannot see the data in OpenOffice.org. What am I doing wrong?
|
08/06/04 |
592 |
|
|
|
|
I want to create a customer database using an Excel table/ database. The one thing I cannot work out is how to 'define the database range with the name Database'.
|
16/04/04 |
695 |
|
|
|
|
My Excel spreadsheet warns that it has macros and yet I cannot find any macros in it.
|
16/03/04 |
2201 |
|
|
|
|
When I turn protection on the cell comments no longer print at the end of the sheet.
|
28/12/03 |
592 |
|
|
|
|
I received a protect Excel document which has the workbook showing as a reduced window but there is no icons on the title bar to maximise the window. What can I do?
|
03/06/03 |
272 |
|
|
|
|
How do I enter the same data into cells at the same time in Excel?
|
02/05/03 |
317 |
|
|
|
|
How do I move rows or columns in MS Excel?
|
01/05/03 |
354 |
|
|
|
|
Using Excel I would like to be able to insert the copyright symbol in my footer. How do I do this?
|
23/02/03 |
301 |
|
|
|
|
When I save an OpenOffice spreadsheet to Excel and print preview there are 29 pages whereas I only expect to see one. When I print I get a lot of blank pages.
|
05/02/03 |
732 |
|
|
|
|
|