Over 1 million tech questions and answers.

Excel 2013 Cell Property issue

Q: Excel 2013 Cell Property issue

Hello there,

I have some users here in the company who work in the same Excel file. It is used for Logistics planning for different countries.
The file is shared and some columns/cells are protected against editing, to prevent the removal of formula's etc.

Now every morning the colleague that manages the file has to restore almost half the sheets because the cell properties are scrambled. Cells that have a value general are changed into currency cells.

This colleague then unshares and unprotects the excel sheets and then restores the cell properties. Next the protection and share is added to the file again.

I do not believe these cells magically change by themselves, But how can we resolve this issue?
I am thinking of a bug in Excel 2013 (maybe the combination of protection/share). And am weirded out by this...

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Excel 2013 Cell Property issue

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 85.2

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
 
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
 
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers
RELEVANCY SCORE 85.2

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
 
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
 
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers
RELEVANCY SCORE 82.8

Hello,

Can you please kindly help me to solve the below interesting issue? (I will make my best to make myself understood, which is sometimes very difficult)

I need to see DIRECTLY in Windows Explorer (I use Win Xp) what is contained in the cell A1 on Worksheet1 of an Exel file (most often, the contents of the cell is a date in special Excel date format = yyyy-mm-dd, but sometimes the contents is a text). The purpose of all this is to sort Excel files (according to the contents A1 of the particular file) directly in Windows Explorer without the need for opening the files.

I hope that this could be realizable by transferring the contents of the cell into one of the standard Excel file properties that can be seen in )Windows Explorer) Details View (eg. Description, Subject or any other property) every time on saving the Excel file.

In addition:
- If the contents of the cell is "preserve", the Excel file property should be left as it was before I opened the file.
- If the contents of the cell is "delete", the Excel file property should be (strange to read)deleted.
-----------
EXAMPLE:
On saving the Exel file, whose cell A1 in Worksheet1 contains „2012-01-05“, this date should go into the Excel file property Description.
- However, if the contents of the cell is „shall be done later“ then „shall be done later“ should go into the property. If the contents is „preserve“, the property should be left as is. If the contents is „delete“, the property... Read more

A:Solved: Transfer of cell contents into an Excel file property

You marked this as solved so does that mean you got this sorted? If so could you post your solution so others may benefit from it?

Rollin
 

Read other 3 answers
RELEVANCY SCORE 76.8

Hello,

We work with an excel sheet with multiple colleagues, This workbook is protected on some columns/fields and the workbook is shared.

Now we have several columns that keep changing it's cell properties. For instance:
Column: License Plate, this should have the property general, but every morning a colleague has to manually change it from date to general again, next morning the same thing.

This colleague has first removed the protection and share, next changed the column property and next put the protection and share on again. In my opinion the right procedure.

Does anyone have an idea what could be causing this?

Thanks in advance,
Wouter
 

A:Excel 2013 cell properties

Read other 13 answers
RELEVANCY SCORE 76

Hello,

I am beginning to suspect this is not possible. What I want is to have a column with "notes" in which the cells (and the rows with them) expand downwards to accommodate additional text. Can this be done? All the online tutorials just seem to think people want lots of nice additional empty white space at the top of the cells when they change the cell height!

Am I missing something? And can anyone help?

A:Changing cell height in excel 2013

just select text wrap. Column will get longer not wider though. The effect will be visible after you will finish cell editing or of you preformat cell height then all will be as you write (assuming that cell is correctly pre-formatted)

Read other 2 answers
RELEVANCY SCORE 76

Hi guys,
almost a month ago I was working on a file on Excel 2010 (whose cells were 15 x 8,43), when all of a sudden Windows asked me to install the so-called "Windows 10 anniversary" update and, when I went on to open the file, I found out the cell width had gone from 8.43 to 8.38. As a result, only columns A through R would show on one page (before it was columns A through half of U), because each of them had gotten larger: I guess it was because 8.43 = 64 pixels and 8.38 = 72 pixels (so the number of pixels had increased)!

I thought it was an issue with an "old version" of Excel, so I uninstalled Office 2010 and had Office 2013 installed instead... and just the opposite happened: originally the cells were 15 x 8,38 (by default), but a second "Windows 10 anniversary" update last Friday brough the width back to 8.43. This is a problem, because I'm adding a bunch of pictures to my file in order to make them fit the cells containing them, and this constant width changes jeopardize that.

I've found out that "When using ClearType with the Windows Anniversary update, Excel column widths can be larger than in earlier versions of Windows. This happens in only some fonts, such as Calibri. It can affect all versions of Office 2016", so I have disabled ClearType and installed the fix (Windows update KB3197954). Now I'm stuck with blurry text all over my screen (no ClearType) and a grid whose cell width is 8,43 (which I assume was the "rig... Read more

A:Is default cell width for Excel 2013 8.43 or 8.38?

Anyone? Anyone at all?

Read other 9 answers
RELEVANCY SCORE 67.6

In cell j, I have formula =IF(SUMPRODUCT(ISNUMBER(SEARCH("VLXP",K2:AB2))+0)>=1,"Yes","No") that returns yes or no if VLXP is contained in any cell K2 through AB2 and it works correctly. What I would really like to do is then put into cell j the entire matching cell content or if not found return n/a. Is there a way to accomplish this maybe with VBA?
 

A:Solved: Excel if cell contains vlxp then put matching cell data in current cell

Read other 6 answers
RELEVANCY SCORE 66

When higlighting a cell/group of cells with a color (using the "fill color" icon in the toolbar) in Excel 2002 the color is not shown on the spreadsheet, but when the doc is printed the color is shown on the peice of paper. On the print preview you can see that the cell has been shaded. So the cell(s) is being colored in but the colors are not visible on the normal spreadsheet view. This is only true for the current user logged on / all other users are not experiencing this problem
 

A:Excel cell coloring issue

Any thoughts? This one has me baffled as all other users of this pc are not experiencing this Excel issue...I have searched excel sites, uninstalled all screensavers, background, ran ad-ware software etc...btw this is office 2k
 

Read other 3 answers
RELEVANCY SCORE 66

Excel 2013 can't be opened on my Windows 8.1 laptop, can any Microsoft specialist help me?

Read other answers
RELEVANCY SCORE 65.2

hi, i have 2-excel cells in the same sheet, both contain manually entered numbers; cell-2 changes frequently; if the existing entry in cell-1 is < than the new entry in cell-2, cell-1 should immediately reflect this new value. how do you create this formula?
 

A:Solved: excel-replace content of cell-1 if cell-2 is > cell-1

Read other 8 answers
RELEVANCY SCORE 65.2

Some of my .xlsx files denied to open. One of them showed an error message: File format not valid. Another file not so important how first one. Has somebody know Excel repair ways for my file? Many thanks for everyone?

A:Excel 2013 file issue

I have also had Excel issues in Windows 8 and 10 with Office 365 and know others have, too. An online repair has helped me. Go into the control panel click programs/uninstall and select Office 365...change...online repair. If you have another version of Office let us know. 

Read other 2 answers
RELEVANCY SCORE 64.4

I'm having an issue with an excel formula.

I have:
Code:
=
IF(D7="DSOA",'Common Milages'!D8,
IF(D7="SRHS", 'Common Milages'!D6,
IF(D7="ECT", 'Common Milages'!D7,
IF(D7="-","0",
))))
This code works fine on a single cell. The problem occurs when I try to duplicate it, either by using 'fill series' or copy and paste.

Excel automatically increments the cell numbers, so that D7 is D8, and so on as it goes down. This is a good thing.

But the formula also references a second sheet 'Common Milages'. The cell values in the formula that references this sheet always needs to stay the same. In other words 'Common Milages'!D6 should always be 'Common Milages'!D6, no matter where the formula is located.

Is there a way to exclude certain cell numbers from auto-incrementing?
 

A:Excel Formulas: Cell Value Auto-Incrementing Issue

Read other 6 answers
RELEVANCY SCORE 63.6

Hello All,
 
I have an issue regarding with one user accessing a Microsoft Excel 2013 Worksheet.  This user was emailed the worksheet and the macro button inside the worksheet will not work.  When she hovers of it, it is unable to be pressed.
 
The user than sent the worksheet to me to see if I could duplicate the issue the user had.  It opened correctly the way the originally sender intended it to.  I checked the settings within her Excel program to see if they differed from mine and they do not.
 
 
 
Can someone maybe assist me?  If not thanks for taking your time and ready my post.
 
 
 
Thanks ahead of time,
Justin W.
 
 

A:Microsoft Excel 2013 Macro Button Issue

is it possibly disabled? im sure you checked but had to ask

Read other 2 answers
RELEVANCY SCORE 62.8

Good Afternoon All,

I am working on developing a template using Word 2013 for Forensic Engineering reports and I would appreciate a little advice. I am trying to use custom document properties throughout the report to ensure consistency across the document of certain key pieces of information such as site address, report author, issue date and so forth. What I am hoping to achieve is to have a document control table inside the front cover (see attached screenshot) which can be filled out by the author of a new report and then get Word to read the values from this table into custom properties which I can in turn insert as fields elsewhere in the document where this information is required. This may seem trivial but I have done hundreds of similar engineering reports and reviewed hundreds of others and the amount of times I have literally encountered hundreds of incidences where the author of a report has say changed the site address and job number on the cover sheet but forgotten to change it say on headers or footers. This is not only embarassing for the company but could potentially be breach of data protection laws in that I can send out a report to one client which has the name and address of a previous client still embedded within it somewhere.

I have already figured out how to define and edit custom property fields and I am aware that I can link their values to the document via bookmarks. However, this is not a fail safe approach as if a user selects, delete... Read more

Read other answers
RELEVANCY SCORE 60.8

I have a sheet with 2 simple columns: Date and Price. I have imported the dates (##/##/####) and the prices ($###,###) by copy/pasting from the search results given to me by a niche database program I use. When the cells paste in, they all have the format "General".

When I try to format the "date" column into dates, it _does_ change the format as far as the cell is concerned, but the content of the cell doesn't adapt to the new format. For example, I have the date as 3/05/2001 and when I change it to a date format of MMM D, YYYY the content should change to March 5, 2001 but it doesn't. It is as if all the cells are forced to stay as text regardless of what the formatting is that I'm applying.

Same problem with the price column: if I change the format to include 2 decimal points, that format does apply to the cells, but the content of each cell remains without a decimal or anything following, as if the content is just text.

I have like 1000 rows in each column, and plan to do this analysis of the database's results frequently, so I'm hoping the answer isn't just to retype the data. There's got to be a way to copy/paste or export or something. Maybe I could copy/paste into notepad first to scrub out any formatting or locking from the niche database program?
 

A:Excel 2007 Cell Values Won't Take On Characteristics of Newly Applied Cell Format

Good news: Made some progress. In thinking that maybe each value had the textual single-quote forcing it to act like text, or maybe if I find/repaced all the dollar signs and commas that had been imported, I accidentally discovered that each and every value in my imported columns has a following space!

Bad news: Seems like Excel has a bug that thinks that if I say "Find=[singleSpace]" "Replace=[null]", then I should be given an error saying "Excel cannot find any data to replace". I think I'm doing the find/replace correctly because it worked on the dollar signs and commas.

Anybody know a workaround for the bug?
 

Read other 1 answers
RELEVANCY SCORE 60.8

I'm attempting to write my first macro for an Excel 2003 workbook. I'm not completely code illiterate (I've got moderate skills with AutoLISP), but I'm new to VBA and am not yet an Excel power user, so please be gentle.

The macro I want to write will:
check that the selected cell's content is underlined before proceeding
copy the content of the currently selected cell into an external plain text .log file
.log file lines should be: year/month/day - time - username - cell contents
.log file names will probably need to be generated
clear the cell's content and formatting (particularly underline and text/background color)
Here's what I have so far:
Code:
Sub Unpost()
If Selection.Font.Underline = True
Then Selection.ClearFormats And Selection.Clearcontents
Else
If MsgBox("The selected cell is not underlined...are you sure?", vbOkCancel) = vbOk
Then Selection.ClearFormats And Selection.Clearcontents
Else Exit Sub
End If
End If
End Sub
If I've written it correctly, it should currently do everything except log the cell contents. This, from what I've seen, is going to be the trickier part. I intend to use this macro 50+ times per weekday, so at some point the .log files will get too long to be useful, so I assume it will need to automatically create new logs (perhaps "year-month.log"). I've seen some useful info about appending to an external log here and here, ... Read more

A:Excel 2003 macro: log contents of selected cell, clear cell

You need to use the "File Scripting Object" to create and/or append text to a file. I've included a link below to get you started. If you are unable to figure it out on your own let me know and I'll write the code for you.

http://www.virtualsplat.com/tips/visual-basic-fso.asp

Rollin
 

Read other 1 answers
RELEVANCY SCORE 60.8

I'm working on a spreadsheet at the moment which displays a range of cells all containing values referenced from another spreadsheet (within the same workbook). This system works fine.

Every day, the original worksheet is updated. So, it has fields already arranged up until the end of the year. A row for every date. Now, needless to say, rows for dates in the future contain no values, and so when the spreadsheet I am working on now references those cells, it displays "$0.00" (which is correct, given I am dealing with financial figures).

Now, all of that works as expected, however, on the spreadsheet I am working on, all of those figures are displayed in a line graph. This line graph, at todays date, shows an enormous drop given that the fields for the rest of the year all show a zero balance.

What I need to do, is to get the remainder of those fields (every field that says "$0.00") to not display anything at all. So, if the value is $0.00, it would not display a value at all, and therefore not show anything on the graph.

Can someone tell me how I can achieve this? I'm sure it can be done with an "if" statement, but I'm not sure how to structure it.

Any help would be greatly appreciated.
 

A:Solved: Remove Cell Value If Cell Value Is Zero (Microsoft Office Excel 2007)

=If(a1="","",Sheet1!a1) and drag it down.

Where a1 is the first cell in spreadsheet you are working on, and sheet1!a1 is the sheet within workbook containing figure.

Not sure if the graph will recognize the "blank' cell as blank or "0"
You could try that

Pedro
 

Read other 3 answers
RELEVANCY SCORE 60.4

Hello,

I cant seem work out a solution for what I'm trying to do. I have an Excel workbook that has multiple sheets. On sheet 1 i want the data from cell "G3" to be copied onto sheet 2. But i want the location on sheet 2 to be based on whatever was entered into cell "D3" on sheet 1.

For example: Sheet 1, cell D3 I have the name John, in cell G3 i have 68. I want "68" to be pasted in sheet 2 in cell B26.

But if the name in Sheet 1 cell D3 is Suzie, then I want G3 to be pasted in Sheet 2 in cell D26. So I would need to identify the paste location for each person.

I want the data to paste to the next cell so that the next entry can be pasted below the last entry for that person (for John the first entry would go into cell B26, then the next entry would go into cell B27 and so on).

But i want it to be a specific range, i dont want data to be pasted past 20 cells (cell B45). If possible a message box could be created to let the user know that the max is reached.

I would appreciate anyone's help with this as i have been struggling for awhile to try to get this. Thank you
 

A:Excel - Copy paste cell into range based on another cell

Read other 12 answers
RELEVANCY SCORE 60.4

Using EXCEL, I have a need to copy the cell contents from upper cells in col. A down a few rows in col A. There are various changes in data in col A as you will see below. The periods in the following info are used as placeholders only. B1, A2, A3, A4, etc. are blank. I need a formula because I have 60,000 records in the spreadsheet. Thanks in advance.

Here is how the data looks now.

....A.....B
Apple.........
..........Fire
..........Ice
..........Snow
Peach
..........Sleet
..........Rain
..........Fog

Here is how I want the data to look

...A ...........B
Apple
Apple.......Fire
Apple.......Ice
Apple.......Snow
Peach
Peach.......Sleet
Peach.......Rain
Peach.......Fog
 

A:[Excel] Copy And Paste Upper Cell To Lower Cell

With the workbook open press ALT + F11 to bring up the Visual Basic Editor. Once the VB editor opens, click INSERT --> MODULE and paste the code below into the blank module. Close the VB editor and select the first cell in column A containing your data you want to copy down. Click TOOLS --> MACRO --> MACROS and select the macro from the list and run it. This macro will copy all your data except for the last value in column A because without actually seeing your workbook, I have no way knowing which line to stop at. Therefore, the code will end when it reaches the last value in column A.

Code:

Public Sub CopyData()

Do Until ActiveCell.Row = Cells(Rows.Count, "A").End(xlUp).Row

ActiveCell.Copy
ActiveCell.Offset(1, 0).Select

Do Until ActiveCell.Value <> ""
ActiveSheet.Paste
ActiveCell.Offset(1, 0).Select
Loop

Loop

End Sub


Rollin
 

Read other 2 answers
RELEVANCY SCORE 60

Using Excel 2003 in Windows XP

I would like to use the contents of one cell as the destination location for copying data.
For example
I have 2 worksheets 1) Results and 2) info
in info
A1 = 'ABC'
C1 = 'Results!O54' < this is calculated based on other data in sheet.

Using a macro, I'd like to copy contents of A1 to cell location 'Results!O54' more specifically to where ever C1 points... C1 will change based on other data in info sheet.

The macro record for action looks like this (but I would like the 'O54' to be based on contents of C1 which changes)
Range("A1").Select
Selection.Copy
Sheets("Results").Select
Range("O54").Select
ActiveSheet.Paste
Sheets("info").Select

There is more to it then that but I think this is where I am stumped.
 

A:Solved: Excel: Uses contents of Cell to select a cell

Sheets("info").Range("A1").Copy Destination:=Sheets("Results").Range(Sheets("info").Range("C1").Value)
 

Read other 3 answers
RELEVANCY SCORE 58.8

I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always start by saving my most recent version of the workbook with the date I last updated it in the filename, and then when I finish my updates for the day, I save the current day's updated workbook with the current day's date in the filename, etc. So after a while, I've got quite a stack of versions of the same workbook, albeit with slightly different data in some of the cells, from version to version.

Near the end of the year, it'd be neat to be able to compare the beginning and end of year versions, cell by cell, to see what changed.

Ideally, I'd like to sort of "subtract" one workbook from the other, cell by cell, and display something in the results that shows cells that differ btwn workbooks and cells that don't.

Obviously, I could just print the two versions, and plow through them both, side by side. But they're nearly 2,000 rows deep, all things considered, and with all the data we compile for each member, each row goes up to column AT! That's a lotta data to compare visually cell by cell.

Is anything like what I'd like to do possible?

Thx.

A:Can I compare 2 Excel spreadsheets cell by cell?

I think this might help if I read this correctly. I used this before to compare three lists I made a long time ago, then when I needed to update them I didn't want to sift through hundreds of entries.

Compare Two Lists in Excel - Easy Excel Tutorial

From MS https://support.microsoft.com/kb/213367

Also 4 Ways to Compare Data in Excel - wikiHow

Read other 1 answers
RELEVANCY SCORE 58.8

Is there a way to copy a col of formula's/math cells to a new col without excel modifying the coordinates?

Scenario: 150 cells of diff equations "located from a1 thru a150" you wish to move to d1 thru d150.

Problem: Excel modifies the coordinates of each pasted formula rendering garbage.

Individual f2, highlite,copy and then paste takes too much time if there are thousands of formulas to move.
thanks, nt
 

A:Copy cell to cell without excel modifying

Use absolute instead of relative references, ie:

$A$1:$A$150

Rgds,
Andy

EDIT: better explanation. You have 5 in A1, and the formula =A1 in B1. If you copy B1 to C1, C1 will read =B1. But if you make B1 =$A$1 and then copy it to C1, it'll hold.
 

Read other 1 answers
RELEVANCY SCORE 58.8

I have two cells, Cell "A" and cell "B", that have a formula in each. Cell "A" has a value that is correct and Cell "B" has a value that is correct. I now have a third cell (cell "C") with a formula that takes the values of cell "A" and cell "B" and multiplies them. The value of the product is wrong in cell "C" as compared to a value performed by a calculator. Cell "C" reports 51,550.64 whereas the calculator reports 51,540. What is the problem.

Thanks
 

A:Excel cell to cell multiply problem

I'm willing to bet that the number you are entering into the calculator are rounded off while the number that Excel is using is not truly rounded off. Even though Excel may display a certain number in a cell due to its format, it is probably using the true value of the number which probably includes several decimal places. What numbers are showing in cells A and B? How are cells A and B formatted? What happens if you increase the number of decimal points in these cells...do the cell number become larger? If so, then Excel is likely using the true values of the cells instead of the display values in its calculations. Provide details of how you are obtaining your cell values so we can confirm that this is happening.

Try the following

TOOLS --> OPTIONS and choose the Calculation Tab. Put a check in the box marked "Precision as Displayed."
NOTE: This will affect all other calculations on the workbook causing changes to other values on the sheet!

Rollin
 

Read other 3 answers
RELEVANCY SCORE 57.6

I am running Windows Vista Business SP1 and Excel Enterprise 2007. I work in finance, so having all of Excel's keyboard shortcuts available is critical to me. I often use the shortcut [ctrl]+1, which pops up the "format cell" window. However, this shortcut does not work anymore for me. All my other [ctrl]+ shortcuts work well, however, so I am confused as to what is causing the problem.

Can anyone help? Thanks in advance.
 

A:Solved: Excel 2007 issue: "format cell" keyboard shortcut (CTRL+1) not working

Read other 16 answers
RELEVANCY SCORE 56.8

I have an excel worksheet that is locked. I would like to create a Macro that will determine the last row with data, and unlock all the cells below that row.

Any help will be appreciated.
 

A:Solved: Excel -> Lock Property

Something like this might work:

Code:
Dim rngCell As Range

ActiveSheet.Cells.Locked = False

For Each rngCell In ActiveSheet.UsedRange.Cells
If rngCell.Value <> "" Then
rngCell.Locked = True
End If
Next rngCell

 

Read other 3 answers
RELEVANCY SCORE 54

Hi,

I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!
 

A:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"
 

Read other 1 answers
RELEVANCY SCORE 54

I cannot search for data in excel 2013. This is new issue. I do notice that in the find window there is an entry for Preview* in the box next to format in the options window that I have never seen before. I get the message cannot find what you are looking for but I know it is there because I am looking at it.

This is new issue. Worked until last night when I was doing a sort and had to make all merged cells uniform in size. Now I can sort but cannot find.

Have closed and reopened excel, but it did not correct problem.
 

A:Solved: Excel search does not work Excel 2013

Read other 7 answers
RELEVANCY SCORE 53.6

Hi,

I am using a desktop with Intel corei3-2100 and motherboard DH61 WWB and DELL LED 2030 monitor. when I right click on the desktop and select the graphic property, i getting a message like " need to install .net framework 3.0 " . Why this message coming,? Please contribute your suggestions

Thanks in advance

A:Need advice on graphic property issue.

you need to be running xp or later i don't think it's compatible with win98

Microsoft .NET Framework Redistributable Package - Free software downloads and software reviews - CNET Download.com

Read other 1 answers
RELEVANCY SCORE 50

Office 2010/Excel I accidentally entered an email address into a cell and now I can't get rid of that format in that cell. No matter what I do, whenever I try to enter text into that cell it is always illuminated in blue and is underlined, just like email addresses are.
How can I make this cell into a 'normal' one again?
Thanks.

A:Excel cell

I have Office 2007. In the Home tab is there a "Styling" option like this?

Highlight the cell and click Normal.

Read other 3 answers
RELEVANCY SCORE 50

I want to use the value typed into cell D5 in later code. It is a value from a list and I want the code to find the value of D5 so that it can locate where to copy the information to.

Can anyone help?
 

A:Cell Value VBA Excel

Please post your existing code and/or sample workbook.

Rollin
 

Read other 1 answers
RELEVANCY SCORE 49.6

Hi, I have a document that I wish to protect specific cells in. I have done this and whenever I double click or attempt to type in a protected field an error message appears. This is a good thing.

What I want to know is whether or not it is possible to prevent single clicking on protected cells as well. Basically, for the few fields I want data to be allowed to be entered in, I want them to be the only accessible fields. I don't even want to be able to do as little as click on cells other than the few left unprotected.

Is it possible to prevent any form of access, highlighting, clicking, typing on protected cells?
 

A:Cell Protection (MS Excel 97)

Read other 7 answers
RELEVANCY SCORE 49.6

I have already got the connection between the excel and the PPT open in my current code, and I am running a loop to add slides to the ppt based on another cell value. But, I now want to add a section of code to the loop that will look at the slide for the

OLEFormat.Object named "PageTitle" and replace the placeholder text with the

xlWB.Worksheets("Title").Range("C" & i).value from excel.

Any suggestions?
 

Read other answers
RELEVANCY SCORE 49.6

I would like to know if it is possible to set up tabs so that I can hit the tab button and go from (eg) A3 to G7 to B18 with out setting up buttons
 

A:cell movement in excel

Read other 12 answers
RELEVANCY SCORE 49.6

Trying to validate a cell as Decimal between 0 and 99999999999999.99. What I get is a rounded value like 12,345,678,901,234.1 instead of 12,345,678,901,234.12. Changing the edit to (13, 2) saves the decimal place but I loose the 10 trillion. Is this an Excel limitation or is there something else I can try. Using built in cell validation (Data --> Validation). What is the largest number Excel can handle? Thanks........
 

A:Excel Cell Validation

Excel's numbers are precise up to 15 digits, any other digits become 0's. This includes the decimal places.
 

Read other 1 answers
RELEVANCY SCORE 49.6

Quick question,

Can I fill a cell on Excel with something other than just solid color? Maybe crosshatching or some other pattern? I'm using Excel 2000.

Thanx!
 

A:excel cell fill

Originally posted by T-Bone:
Quick question,

Can I fill a cell on Excel with something other than just solid color? Maybe crosshatching or some other pattern? I'm using Excel 2000.

Thanx! Click to expand...

Have you tried Format/Cells/Pattern, click on the Pattern button at the bottom of the window?
 

Read other 2 answers
RELEVANCY SCORE 49.6

I am trying to return the value of the last completed cell in a row.

Using arrays, I've tried lookup, but it doesn't seem to like a formula as the critera. Match returns the position in the array, but not the value.

This is for a spreadsheet that is updated monthly--not necessarily on the first of the month so logic using dates won't work. I trying to create a summary table to automatically use the latest entries from the spreadsheet.
 

A:Excel-value of last nonblank cell in a row

Match will get you the row number, so use it in the Index function..

=Index(array,Match(),colnum)

So I'm not reinventing the wheel, Bob Phillips has a nice write-up on it...

http://www.xldynamic.com/source/xld.LastValue.html

HTH
 

Read other 3 answers
RELEVANCY SCORE 49.6

If in cell A1, the user was able to write a cell number of their choice, say B5.
In the cells that they would be choosing, would be numbers. In cell A2, I want to use the contents of the cell that the user has typed into A1. Not the contents of A1, but the contents of the cell that has its cell number in A1. In this case, I would want to use the contents of B5. There will be around 15 boxes in which the user is free to write any cell number they choose. Then, in the formula box (A2) I would read the contents of these cells, and if something was there get its contents and then use the cell number that it says in a sum, in which the numbers in all of the cells which the user has chosen were added up.
What could I do?
 

A:Excel 97 Cell Contents

Read other 9 answers
RELEVANCY SCORE 49.6

I just made a spreadsheet and i have formuals in certain rows i do not want to have changed. I understand to protect things i have to protect the sheet. But becasue some people will be needed to make changes to different variables i need to have certain cells "unlocked" so that they can go in and freely input there info on a weekly basis but not have the ability to delete the forumlas i wish to have locked in.

Can anyone help me please.

Time is of the essence.

Im handing the reigns over on monday.....

Thanks for any and all help.

A:Excel Cell Protection.

Protect the entire sheet. Then unprotect cells you allow to change.

Read other 3 answers
RELEVANCY SCORE 49.6

Anyone know if / how to make a cell in an Excel worksheet "blink"? I want to catch the attention to the cell I want others to fill in.

Thanks for your help.
 

A:Excel - blinking cell

I don't think this ism possible, you could however add some code so that when the sheet is activated a small routine runs two or three loops and changing the background color making it look like blinking adn if necessary have the cell keep this color if needs attention adn when the cell is corrected the on change routine would reset it to the default background.
 

Read other 1 answers
RELEVANCY SCORE 49.6

I'm creating a database on excel to work out my incomings/outgoings etc.

I have a row with titles on. How do I keep those visible while a scroll through everything else? Someone who knows how to do this should know what I mean.

-Jack
 

A:Excel cell problems

Read other 7 answers
RELEVANCY SCORE 49.6

Hi,

I've this strange requirement. I've 10 digit numbers in a column. These 10 digits can be any number from 0 to 9 and at any position. 0 can be the starting digit too.

I customized the cells using Format option and entered 0000000000 so that all numbers are displayed even with preciding 0's. All this comes fine. But when I pick up the number from another downstream applicaiton, it takes obnly the part of the number ignoring the leading 0's.
Can someone polease help me how to set this right!!!!!

Thanks in anticipation.

-Kashyap
 

A:Excel cell formats

Hi,

To what is the purpose of retaining the leading zero's for dependent calculations/manipulation? If you make the leading zero's permanent, this would effectively make the numbers text. Is that what you want?

If you want as text, here are some things you can do:

• Preceed the cell entry with a single apostrophe (denotes textual values and will be treated as such)
• Use a secondary cell to calculate your leading zero's (e.g. ..

=REPT("0",10-LEN(A1))&A1

..where A1 is your number entry)
• Use a routine like this in your worksheet module (right click Worksheet tab --> View Code)

Code:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
'** Change A1:A10 to desired range of change
If Intersect(Target, Range("A1:A10")) Is Nothing Then Exit Sub
'** Add desired amount of leading zero values
Target.Value = "'" & WorksheetFunction.Rept("0", 10 - _
Len(Target)) & Target.Value
End Sub

HTH
 

Read other 1 answers
RELEVANCY SCORE 49.6

EDIT (Again): ok, saving is working now too. Even thuogh I don't actually know what was wrong with my original code

EDIT:
Reading is working now but saving isn't. Please help me figure out how to save my spreadsheet. I'm calling:

inputBook.Worksheets.Add(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
sheet = (Microsoft.Office.Interop.Excel.Worksheet)((inputBook.Worksheets).get_Item("Sheet1"));

((Microsoft.Office.Interop.Excel.Range)(sheet.Cells[row, column])).Value2 = "some text";

book.SaveAs(output, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
it saves, but the .xls file is completely empty. Please help me solve this!
>Original Post:
>
>
>I need to read cells' values in C#, from a spreadsheet. That's pretty much it. I need to be able to write to them later too, but I can't even get Read to work. Here is my whole code:
>
>
>string input = @"C:\Users\James\Desktop\foo.xls";
>Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
>Microsoft.Office.Interop.Excel.Workbook inputBook = app.Workbooks.Open(input, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true... Read more

Read other answers
RELEVANCY SCORE 49.6

Range("A2").end(xldown)

If I want to move to next cell, what statement i have to write.
want the next cell in downwards directions as using Range("A2").end(xldown).next.select takes me towards right direction
 

A:Excel-Moving to next cell using VBA

Hi and welcome. Let me move you to business applications for better assistance.
 

Read other 3 answers
RELEVANCY SCORE 49.6

I am trying to populate some cells in excel from sheet1 to a continuous column cells in sheet2... so I would like to do is use vlookup to find the next non-blank cell in a range on sheet 1 and populate a column in sheet 2 from top to bottom. this is what I have so far.
=IF( AND( NOT( ISBLANK(Estimate!D3) ),$I$36=TRUE),VLOOKUP(Estimate!D3,Pricing!$C$4:$G$200,2,FALSE),"")

=IF( AND( NOT( ISBLANK(Estimate!D4) ),$I$36=TRUE),VLOOKUP(Estimate!D4,Pricing!$C$4:$G$200,2,FALSE),"")
 

A:excel next non-blank cell

got it figured out. see below.

=IF(A2<$K$35,"0.00%", IF(A2<$K$36,-$J$35, IF(A2<$K$37,-$J$36,IF(A2<$K$38,-$J$37,IF(A2<$K$39,-$J$38,-$J$39)))))

thanx for your help
 

Read other 1 answers
RELEVANCY SCORE 49.6

I have HTML in a cell. There's something like this in the cell:

Code:
<a href="http://www.google.com">Google</a>
I want to get the web address from that cell and put it into another cell (I assume I use a formula). Any idea?

It is also possible the cell may contain multiple URL lines like that, and I would like for each extra URL for it to be put in a new cell.
 

A:Excel: Get certain text from cell?

Read other 6 answers