Over 1 million tech questions and answers.

Excel 2013 cell properties

Q: Excel 2013 cell properties


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,

Preferred Solution: Excel 2013 cell properties

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

A: Excel 2013 cell properties

Read other 13 answers

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

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

I would like to have my list in excel have every other row of information a separate color so that the list is easy to read. (i.e. blue row, no fill row, blue row, no fill row, blue row, no fill row, etc.) I would like to be able to sort the data in this list without the color of each row sorting with the information. Is it possible to lock the fill properties of cells so that it does not sort along with the information in that cell?

A:Excel Sorting without cell properties changing

Here's how.

Select however many rows you need (click'n'drag on the row headers).

Choose Conditional Formatting from the Format menu.

Set Condition 1 to Formula Is. In the box, enter


Click the Format button. On the Patterns tab, choose a suitable blue. Click OK. Back in the previous dialog, OK again. The formatting will not be affected by Sort.


Read other 1 answers

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


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

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

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

Hi, all!

I wish to purchase an HP dv5000t series laptop with a 12 Cell Li-Ion battery, but I saw a diagram on the HP site which showed a bulky mass at the back of the laptop, compared to a 6 cell which did not have this. It seems that such a laptop will not be able to sit flat on a desk.

Does anybody know from experience if this will be the case? If so, how bad of an angle is it? Will it interfere with normal use, etc?

Thanks! Your help is appreciated.

A:6 Cell Li-Ion Battery vs. 12 Cell (Physical Properties)

If HP sells the battery with the laptop then it'll work. While it may not sit flat that isn't a problem.

Read other 3 answers

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

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

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


Read other 3 answers

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:
Sub Unpost()
If Selection.Font.Underline = True
Then Selection.ClearFormats And Selection.Clearcontents
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.



Read other 1 answers

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.


Here is how I want the data to look

...A ...........B

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.


Public Sub CopyData()

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

ActiveCell.Offset(1, 0).Select

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


End Sub


Read other 2 answers


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

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)

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

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.


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!


Read other 3 answers

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:



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

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?


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

I am looking for a way to change the color of text in a range of Excel cells, based on a formula. If F4:F(end of sheet) is 5% less than cell E4:E(end of sheet, same row as F), change text color to red. If it is 5% more, change text color to blue. If neither condition is true, leave text color black. Is this possible? I was pretty sure it is using VBA, but was unsure how?

A:Conditional cell properties

It is. I did something similar years ago and have forgotten the details - but I do remember I based it on one of the sample VB scripts supplied with XL

Read other 3 answers

Good day:

I create pdf fillables using Adobe Pro 10. I have modify some cells to 6 point helvetica, left, multi-line. All the cells work in the table, but the last cell. It will not multi-line. Would anybody know why?


Read other answers


For a 'Yes/No' data type, my MS Access 2013 does not allow me to change from the default 'check box' to the 'text box' option under lookup field properties - display control. It was originally able to but I think something has happened to it.

The problem is not table or database specific as I have tried other tables and databases. I even reinstalled MS Access to make sure it was not the application's fault. It still exists and I don't know what went wrong.
Could someone please advise?

Thanks a lot.

A:MS Access 2013 Yes/No Lookup field properties can't select Text box

lycen, welcome to the Forum.
I am not sure how you managed to change it to a text field, as you can't do it in Access 2007, only to other types of "On/Off" type fields

Read other 3 answers

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


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

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.


Read other 1 answers

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?

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

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

Hi All,

Excel newbie here, I have a excel sheet and I would like to have a cell change colour after 6 weeks which I have worked out. but I would like it to change a different colour based on a word in another cell, can anyone help please???

I've attached a sample sheet that A3 turns blue after 6 weeks, but I would like it to chance yellow based on the word "TPO" in B or green based on the word "CA"... but keeping the 6 weeks rule also, hope this makes sense

A:Two formulas in one cell excel.

does NOT matter what the time is
"TPO" =yellow
"CA" = green

and then if over 6 weeks turns blue

setup up three rules in conditional formatting
and order them so that the Blue is first in the list and then use the STOP IF TRUE ticked

that should do it

Read other 1 answers

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


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

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


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



Read other 3 answers

Hi All,

Excel newbie here, I have a excel sheet and I would like to have a cell change colour after 6 weeks which I have worked out. but I would like it to change a different colour based on a word in another cell, can anyone help please???

I've attached a sample sheet that A3 turns blue after 6 weeks, but I would like it to chance yellow based on the word "TPO" in B or green based on the word "CA"... but keeping the 6 weeks rule also, hope this makes sense

Read other answers

This post is from another board. I have seen this problem quite a while ago and resolved it (Excel 97), but can not remember what caused it.
As I "remember" the solution was relatively minor, but .....

Anyone have a clue?


"On my XP machine, for some reason recently if I open Excel 2002 and try to click anywhere on the spreadsheet, it will highlight a cell. Then I move the mouse and it keeps dragging an area to select. The problem is I click it another 10,000 times and it won't stop selecting cells. I have no clue why this mouse isn't working correctly. It works just fine everywhere else, but for some reason in Excel it suddenly found an error or something in the software and it seems to like it."

A:Excel - Cell Selection

Read other 7 answers

i enter a whole number (any cell) and the result is a decimal number.
ie: enter 4 - result .4
have tried diffirent things with no change.

A:excel - cell format.

Read other 7 answers

Is there a formula to make a cell change color when that cell has a specific numeric value? IE:

I have a small table. The total value column (say D5 - D10) is the cells I want to be color coded. D5 has the value 5. D6 has 6, D7 - 7, D8 - 8, D9 - 9, D10 - 10. Any cell that has a value of 5 and under is colored red, 6 - 8 is yellow and 9 and over is green so therefore D5 should be red, D6 to D8 is yellow and D9 - D10 is green.

Attached is an example.

A:Excel: value changes cell color

Under Format - Conditional Format

You should be able to accomplish what you need. It has 3 conditions to test for to apply your choice of cell format.

Read other 3 answers


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.


A:Excel cell formats


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


..where A1 is your number entry)
Use a routine like this in your worksheet module (right click Worksheet tab --> View 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


Read other 1 answers

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.


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

Is it possible to change the color of a cell using a formula in Excel?

A:Cell color in Excel

Read other 13 answers

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

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





A:Excel - I Have Two Formulas I need to Add to One Cell

Read other 7 answers

Hi there,

Can I run two function formulae at once in one cell in Excel? For example - I need to trim and change to proper text in a certain cell, so I want to run the =trim(A2) and =Proper(A2) at once - instead of running one - then copying and pasting special, then running the other.

Is this possible?

A:Two Formulae in one cell - MS Excel.

Hi gabyggod,

use this:


should do the trick!


Read other 3 answers

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

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

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

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

Sub NewInvoice()
' Will replace Ctrl+n with "when workbooks opens do this"
' got that part ok already.
' NewINvoice Macro
' Keyboard Shortcut: Ctrl+n
' get new number for invoice
Dim x As Integer
Workbooks.Open Filename:="d:\number.xls"
x = Workbooks("number.xls").Worksheets("Sheet1").Cells(1, 1)
' Sheets("Quote").Activate
ThisWorkbook.Worksheets("Invoice").Range("n4:n4") = x
x = x + 1
Workbooks("number.xls").Worksheets("Sheet1").Cells(1, 1) = x

' I need HELP!!! here.....I'll write in plain English what I want to happen.
' Can somebody please write it so it works???

' select n4
' save current file (invoice.xls) using "File menu, Save As"
' use the contents of n4 as the filename.xls
' eg: n4=2 so new filename is 2.xls leaving original "invoice.xls" as blank
' so that when finished editing invoice, on close of Excel it asks do you want to save changes?
' tell it "yes" and it saves as 2.xls not overwriting invoce.xls

' any help would be much appreciated!!!!!
End Sub

A:Excel. Using cell value as new filename.

How about you save invoice.xls as invoice.xlt instead? that way, you have the template, doubleclicking it will open a new xls doc based on that template.
But, that will not allow you to save the file in the manner you want, for that, you will have to add the following to your code:

ActiveWorkbook.saveas Filename:=Range("n4").Value

see if that works

Read other 3 answers