Over 1 million tech questions and answers.

Changing cell height in excel 2013

Q: Changing cell height in excel 2013


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?

Preferred Solution: Changing cell height in excel 2013

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

Excel XP, 2003, & 2007
What is the max size for auto-size height?
I have a spreadsheet for customer issues that I track. I add to one of the cells weekly and it auto sizes automatically...until...it hits a specific height. I've seen this in the past too.
1) What is that height?
2) Where is it set?
3) Can I change it?

I also have a cell that always adds an extra line in height. It is NOT an extra carriage return.
Why is that happening?

A:Solved: Excel - Cell height autosize

Read other 16 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


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,

A:Excel 2013 cell properties

Read other 13 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

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

Very limited experience with Excel...have a multi page workbook but can't figure out how to auto format existing text to fit in cells so there is no space either on top or bottom of the cell.

Only way I can get this so far is to manually move the bottom line of the text box up to the bottom of the actual text in box. But this causes the print out to overlap sometimes of the text lines in print view.

Is there a way to 'auto-format' individual cells to fit the text in the cell without leaving alot of space above or below the lines, or top/bottom lines, of the cell.

A:Having problem setting cell height to fit text in cell

When you are in the cell that you want to align with the top, Right Click & select Format Cells & when that opens Click on the Alignment Tab & then you will see Horizontal & Vertical, click on the Vertical drop down arrow & select Top. That will align the text to the top of the cell & eliminate that space.

When you move to the next cell to insert the Dollar amount it will be lined up with the bottom of the text in the previous cell, which is what you want.

Read other 1 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

First time coding VBA in excell and I want to execute some code anytime any cell changes in my worksheet. Cant figure out what event needs to call my code.

I attached the worksheet and my test code in the module.

A:Cant get code to execute upon changing a cell in Excel

Read other 10 answers

I am trying to use part of a macro to change the active cell to a cell address determined from data entered by the user. For example, a user enters a date, the date is compared to a list of dates and when a match is found the cell address is returned. I want to then make the returned address the active cell. Can this be done and if so how?

A:MS Excel - Changing the Active Cell Macro

You would need to use VB code. I don't think you can record a macro to do that...do you already have a way to find the matching date or do you need help on that part too?

Read other 3 answers

I have the following data:

Each of the cells is formatted as a date, and is a value.
What I would like to do (and what could be done under Lotus) is to record a macro that puts the ' in front of 1/1/05 and makes it a value. I realize there are other ways to do this, but the functionality of adding a character before a value is what I am looking for.

Functionally, I record this macro with these keystrokes:

F2 Home ' Enter

which results in this code:

ActiveCell.FormulaR1C1 = "'1/1/2005"

If I run this macro, it changes the cells underneath to 1/1/05, instead of keeping their date. Where am I going wrong here and how can I make this work?


A:Solved: Excel and VB: Changing cell value to text with macro

Read other 16 answers

Hi all,

I have done a decent amount of Java, but VB is slightly confusing to me.

I want to be able to write a loop which will copy data, transpose it and then paste it. It needs to do this several hundred times, with each copied data-set being on a new row.
Dim Num As Integer

For Num = 1 To 10 'start loop

'cut source cells

Selection.PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False _
, Transpose:=True

'Delete Source Rows
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp

Next Num ' end loop

'Autofit the data

(nb The reason for the cut-paste-copy-pastespecial is because Excel won't cut and paste-special across different sheets.)

As you can see, I'm nearly there, but currently all it does is paste each new set of data over the existing one in cell A34. How do I make it increment the destination row by 4 or 5 on each iteration?

This is incredibly simple, but it won't let me j... Read more

A:Solved: Changing a Cell Reference: Noob question in VBA/Excel

You use Activecell.Offset(r,c).select to move from the current cell. You increment r for rows and c for columns.
Excel has no problems with "Paste Special Transpose" when moving from sheet to sheet. I just recorded this Macro of doing just that -
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True

Read other 2 answers

I have built a simple timesheet for someone in my dept, which includes amongst other things:

- hours worked over a month,
- how many hours owed/extra worked
- a cumulative of this figure over the months.

The requestor wants to be able to type a letter such as 'e' to represent a 07:30hr shift. So they type 'e' and the cell contents change to 07:30. There are about 6 different codes.

Normally a Vlookup would work EXCEPT you can't change the contents of the cell your are working upon.....cicrular referencing!

I could see two ways forward: either a function that allows the above

OR (perhaps more favourably)

leaving the lookups until the hour calculations at the base of the form. i.e Instead of a simple Sum for the hours worked that month, it could read the values in the range, look them up from a table(vlookup), and then sum the looked up figures to give the answer in the 'hours worked' cell.

I vaguely remember this being possible from my university days but can't remember how.

Can anyone help me?

A:Excel 2003: automatically changing a cell's contents based on keyword entered

Read other 9 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, 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 want to have a range of cells store something. When one of those cells data is changed, I need another cell to show the date of when the cells data was changed automatically. For example: If Someone changes cell B2, A2 will show the date B2 was changed. Or B78 changes, A78 should show what date B78 changed. I need this to happen for the entire column. Is there a way to have this happen automatically? Please help, if you can.

A:Changing Cell Info, Date tracks when cell changed

Read other 6 answers

Is there a way I can change the whole taskbar's height through regedit for a more customized setting? Here's some images to better understand what I'm trying to do:

What my taskbar looks like now:
What my taskbar looks w/ small icons:
Are those the only two options or can I adjust the height so it's in-between the two? (Mainly so I can see the date underneath the time w/ small icons.)

Thanks in advance

A:Changing Entire Taskbar Height?

Hello Thummel,

If you like, you could unlock the taskbar, drag the taskbar to change it's height, then lock the taskbar when finished.

Taskbar - Resize - Windows 7 Help Forums

Hope this helps,

Read other 3 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

I made numerous rows in excel with a height of zero since I didn't know about hiding them. Now I want to make them any non zero number to get them back in order to hide them now. Problem is I dont know how to select these rows and change the height.
I tried imputing the rows manually in the upper left box but this only lets me change the height of one row at a time, I need to do this with almost 200 rows. This is excel 2007 by the way.

A:Excel row height help

In 2003 .. Find the Row height you want ...
Select all the columns n rows .. Crtl+A
Format >> Row >> Height

Read other 2 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

Hey Guys,

So I'm working on a Macro that draws information from one sheet to another in order to build a better looking Report of that information.

However when I draw something larger like a description or status, which has multiple lines of text, I can't get my cell on the new sheet to automatically change its height to fit the text.

Anyone else run into this issue?


A:Excel Row Height Issue

You have to set the cell's properties too
if you do cell.columns.autofit
and cell.rows.autofit
But specific height are possible too and will affect the whoe row as well ats the whole column

When Copying and pasting you also have to indicat that you want to paste the format so it will be an identical copy

Read other 1 answers

One of my users is working on an Excel document with wrapped text in some cells. He wants to auto-fit the height of those rows so all of the wrapped text shows. When he tries the normal auto-fit options (double clicking between row numbers, choosing auto row height from the menus), it actually adjusts the row to a small height that hides much of the text. He is using Excel 2007, but I swear I've seen this myself using 2003 as well. It seems to be a property or problem with the document, not with the program.

Any ideas what might cause the auto row height to malfunction like this?

A:Excel auto row height not working

Read other 6 answers

Hi everyone,
One information before starting: I am French, and like any good French, angry with foreign languages &#8203;&#8203;....
Sorry by advance for bad english ...

I resurrected an post a bit old, of February 2011 (Mr Davo) because I have the same problem of line height suddenly increased to 409 points in opening certain files created with versions prior to Excel 2010.
I observed that this phenomenon always occurs concomitantly with an object, an embedded drawing, or comment in a cell that is open in the first line increased. Then, a random number of line could be touched by "the thing" .... horrible !!! I confirm that i have see the problem only in (my..) Excel 2010.

Desperate to find a French forum that talks about this problem, I came here.
Someone else has encountered this problem you it? To date, I found only two posts on teh Web (including this one) that evokes the question.

best regards,

Read other answers

Hey guys

Until recently, I have been using Microsoft's Works spreadsheet, but am now using Microsoft Office Home and Student 2007.

When I open my old spreadsheets (works) in excel, I get an elevated height of the cells contents.

When I manually fill a cell, the height is normal.

When Excel's Format\AutoFit Row Height is used, the height of contents of the cell from works is 15.75 whereas the height of something manually imputed is 8.

Enclosed is a small JPEG of the of the situation.


A:Solved: Height difference in Excel

Works has many such non-compatibilities.

What happens if you select the entire spreadsheet (the top cell left of A and above 1
Then autofit.

When pasting in from Works, use paste special, values. Then Works should not override Excel

Read other 2 answers

Hi Everyone,

I am experiencing a strange issue with Microsoft Excel (2007 & 2010).

When I open an Excel document (.xls) that was originally a CSV file there are random rows that are 409 points high!

The rows are so high that it is not possible to see what is in them. If I scroll a 409 point row the "page jumps" and the contents of the row are not viewable, e.g.: if I am at row 1 and row 2 is "mis-behaving" I scroll down the page and then row 3 is visible (row 2 is never shown, even though it is there!).

I can manually right click on the offending row and select "Row Height", then I can enter a normal value, such as 12.75 (which is my regular row height) and the contents of the row will become visible.

This strange row height behaviour is not occuring on every row of an imported CSV file, but instead seems to be happening quite randomly.

Any help with this issue will be greatly appreciated.

Kind Regards,


A:Strange row height behaviour in Excel

Have you checked all cells in the offending rows to see if there are any extra line breaks?


Read other 2 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

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

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

hello everybody,
I faced problem with Excel 2007: AutoFit Row Height feature. In my computer, when I open some excel files, contain Wrap Cells ( all text in this cell can't see ) .. if I want to see all text, I made Format>Autofit Row Height manually .. In another computer also running same Excel 2007 version, It can see all hide text (automatically fit row height) when open this file .. i don't know why .. I want to fit row height automatically when I open that kind of files .. how should I do??

Read other answers

I have an Acer Aspire X1800 in a ridiculously small case. Everything gets way too hot and no room for cooling. Plus according to eXtreme Power supply calculator the supplied 220W PSU is well below recommended minimum (and making noises!). So I've nearly finished moving the hardware across to a Thermaltake V4 case with 450W PSU ($73 all up).
I want to keep the old Nvidia 9500GT graphics card but it has a low profile (~1/2 height) mounting bracket with DVI & hdmi holes. The card does really need to be secured. Any suggestions????
(I don't want to buy another graphics card as this is not my main PC)

Edit: I'm asking the question here because I'm guessing quite a few people may have thought about doing something similar. ie. OEM PCs from a crappy little case to a decent sized case.

A:Half height PCI mounting bracket BUT full height slot.

Did you check your box for your video card. I have a half height video card that had a short and long mounting bracket. If not, you may be able to find them online.


Read other 5 answers

Windows XP
Excel 2003
I am new to VB Macros in Excel, but have had little trouble finding what I need and altering macros to suit my specific needs.  I have run into one now, however, I cannot get to work.
I have an invoice form with a variable length description.  The descriptions are in cells d7 through d34.  My problem is that D7 through F7 are merged.  When I enter a description that is longer than will fit on one row, it does not expand the row height.  I found that to be a known problem in excel and found a macro to do what I need.
What I am trying to accomplish is to enter the description in D7.  Upon pressing TAB or ENTER, I want the row to expand in height to display all the text.
Here is the code I am using. 
Private Sub WorksheetChange(ByVal Target As Range)
    Select Case Target.Address
    Case "$d$17", "$D$18"
        Call AutoFitMergedCellRowHeight
    End Select
End Sub

Sub AutoFitMergedCellRowHeight()

Dim CurrentRowHeight As Single, MergedCellRgWidth As Single
Dim CurrCell As Range
Dim ActiveCellWidth As Single, PossNewRowHeight As Single
If ActiveCell.MergeCells Then
    With ActiveCell.MergeArea
        If .Rows.Count = 1 And .WrapText = True Then
            Application.ScreenUpdating... Read more

Read other answers

1/2 Height PCI car in full height system

How can I fit a 1/2 height PCI card to a system with only full-height bays? is this impossible?

A:1/2 Height PCI card in full height system

no, i'll get photos. It has a SMALLER back plate

Read other 5 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 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

Does anyone know is it possible to replace a 9.5mm height internal HDD 1TB with a 7mm height internal HDD 1TB? Does is it fit if replace ? HP Pavilion 14-v024tx Notebook

Read other answers

Does anyone know is it possible to replace a 9.5mm height internal HDD 1TB with a 7mm height internal HDD 1TB? Does is it fit if replace ? HP Pavilion 14-v024tx Notebook

Read other answers

I need to be able to change the colour of a cell in Excell by typing the colour name in the cell.

I have 12 colours that signify teams and I would like to type in a cell the word BLUE and the cell change to that colour without displaying the typed word.

Any idea's

A:Changing the cell colour in Excell

Read other 9 answers

Okay.. here is one of those stupid simple things I never had to do before and can't figure out how to do it.. I know it's basic.. but .. I self taught so my training skipped around a lot.. sorry!

Basically I did a graph for a yearly set of values, not yet filled in.

My boss wants these charts to show percentages through 100% even blank, but it keeps defaulting to 0.something ranges.

For the life of me I cannot remember how to do this and on my search of the site was harry in trying to figure out a decent search range. Any help is most sincerely appreciated. I have a feeling it wil be a smack my head kind of thing.

Thank you!

A:Solved: Excel Graph: Not changing Cells, Changing Chart Value

Read other 7 answers

I am creating a spreadsheet for work. I am trying to make it so when someone changes a cells data the date that the cells info was changed appears in another cell. I need the date that the cell was changed to stay there until it is changed again. Was changed again the cell should update with the date it was changed. Please help.

A:Changing Cell info, have date track it.

Read other 12 answers

I want to change the width of a cell in a row in a table in Word 2003 without changing the entire column width. At times, when I change the column width, it will only do the cell in that column, without the rest above or below randomly. But it won't do it when I want it to. I have tried using the shift, control and alt keys while clicking on the vertical left margin of the cell but to no avail. Does anyone know how to do this directly without a work around of splitting cells or merging them them or making the lines invisible?
Dr. Joe

A:Solved: Changing cell width in row in table

Read this ---> Resize all or part of a table

Read other 3 answers

We have a computer in our office that will be changing users. This shuffling of computers is a pretty common thing in our office - as new computers are acquired, the existing ones are often shuffled around to different users. However this machine has Office 2013 on it, which is somehow "tied" to the Microsoft account of the previous user, using that person's personal email address and credentials.

How can I get the machine to work with the new user (Active Director user on our office network domain)? I have heard that Office 2013 can be transferred to another computer, but that is not happening here. It needs to be used by a different user.

What can we do?

A:Computer with Office 2013 changing users

Perhaps this MS website could help you.


Read other 2 answers