Over 1 million tech questions and answers.

Is default cell width for Excel 2013 8.43 or 8.38?

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

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 "right" width, because it was the original one, because the "increased cell width" issue occurs when going from 8.43 to 8.38 and not the other way around, and also because the fix left it that like that instead of brining it back to 8.38).

Now my question is: am I right? Is 8.43 the "right" width or is it gonna change again? And, now that the bug is supposedly fixed, can I enable ClearType again or should I leave it ticked off for the rest of my life, otherwise this painful experience will happen all over again?

Sorry for the lengthy post, but there just was no way of asking this question using less words. I've also sought assistance on other forums, and almost everyone has been superrude to me, brushing off my problem and/or ignoring me all of a sudden midway through the conversation. So I hope it's gonna be different this time around. Looking forward to reading your replies ASAP.

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

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: Is default cell width for Excel 2013 8.43 or 8.38?

Anyone? Anyone at all?

Read other 9 answers

I want to change just the width of a cell within a column without changing the column width. Help please!

A:Change cell width only in Excel

The only way I know to do this is to merge the cell with adjacent cells in the same row. Highlight the cells you want to merge and click the 'merge' icon on the toolbar.
But I don't recommend merging cells as a rule, except in the headers. It can cause all kinds of problems with sorting, cut and paste, etc. But if you think none of that is an issue for you, then go ahead.

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


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

I use MS Office 2013 and in Excel I always like my data to be in the center of a cell.

Looks like that the default now is the bottom of a cell

Is there a setting to configure Excel to keep my data always in the center of a cell?

A:Solved: Excel Change Default to the Center of a Cell

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

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

Can some registry expert advise the location of the value determining the default column width of the File name in the right pane of explorer.exe with XP SP-2? I would like this value to be about 300 pixels when opening an explorer window. (One can set a value with the RMB on the title bar, but it goes back to the default whenever you close the program.) Thanks


A:Changing Default Filename Column Width

I opened up Explorer to the Root of my C: drive.
Right Clicked on the Title bar.
Selected More.
Made sure Name was highlighted.
Entered 300 into Pixels.
Then went to Tools > Folder Options > Views
and clicked Apply to all Folders.

I even first did it on a Single Folder and it held the Pixel width for that folder after exiting and reopening Explorer.

Read other 2 answers

Does anybody know how to increase the default width of the file name column when using the Details file view ?
I find that often I need to make the column wider to be able to see enough of the file name to identify it. The default width is too narrow. Since I am using a 24" monitor I have the space to accomodate a permanent change. I think that doubling the width would be enough. I don't mind editing the registry if that is where to change it - just need to know where.

Actually if somebody knows enough to advise on the above maybe you know this one as well.
I would like to know how to resize Windows file boxes. This is when you get asked where to save something (for example) so a box pops up showing possible save locations. I would like to make this box larger rather than having to use the side bar and scrolling. Does anybody know this ?

A:Increase default width of file name column

Rest your pointer on the break between Name and Date or whatever is to the right of that. When it turns into a double sided arrow, drag it to the right.

Read other 4 answers

I always have the Internet browser running on the left side of the screen. To be able to view standard width web pages, I have to widen the browser's window to more than half the width of my screen.

Now when I snap other windows to the right side to get a side-by-side view with the browser, the right-snapped window usually covers a portion of the browser (and the webpage I'm viewing). I have to then reduce the width of the right-snapped window manually.

I have to do that every time I snap a window to the right side of the screen. It's inconvenient. Is there a solution (i.e. registry hack maybe?) through which I can change the default width of snapped windows?

A:Adjust the default width of snapped windows?

Hello Msafi,

The free program AquaSnap would be great for this.

Hope this helps,

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

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'm using InDesign CS4 version on Windows 7, 64bit.

I've noticed that my default font size is 12,045 pt and my default width for lines is 1.004 (even after a clean reinstall). I was wondering why they were like this instead of 12pt and 1pt?

Read other answers

There are several ways to change columns widths in detail view and hundreds of posts about making all folders keep that column width IF you make all folders open in detail view. Does anyone know of a way to save a default column width in detail view WITHOUT setting all folders to open in detail view?

A:Set default column width without changing all folders to detail view

I'm not sure what you are asking.
Surely column width only applies in Details mode.

You can:
Set all of the columns and their widths in Details mode
Change to View to something else (e.g. Large Icons)
Set your Folder Template

The Folder Template will remember the:
Chosen Columns and their widths
This means you can always "Sort by" or "Group by" the chosen columns without having to go into Details view.

I only use Details and Large Icons.
I'm not sure how the Tiles, List and Content views behave.

Read other 1 answers


What is the equivalent in inches of the Excel column width and row height units?


A:Excel: column width to inches

Interesting question.
If I set it to 100, it measures 1.4"
1.4" is 210 pixels.
Who can figure that out?
Anyone else?

Read other 3 answers

ok excel columm width maximum characters is 255. This is causing me a massive problem when importing data from access. Most of the information is missing. Is there a work aound to this? I am using excel 2003.

A:excel column width problems

Unless all your data in Access is in memo data types (upto 1G), you should not have any problem importing data from Access into Excel - Access text files have a max of 255 records.

How are you doing the import? Can you give us a sample of a record from Access that you want to import?

P.S. Make sure you make the row tall enough in Excel -- if there are embedded character returns in your text fields, you may not see the data unless you make the rows taller....

Read other 1 answers

Is it possible to have 2 (at least) column heading bars in excel 2000? I am trying to work like a "split" screen, but want to be able to have the top section cells at 8.43 and the bottom section cells at say 12.5 but in the same worksheet. Any advice is extremely appreciated.


A:Excel 2000: One Column with Two Width Settings?

If you can tell me why, perhaps I can give you a workaround?

No, it cannot be done in Excel. But it can be done in Word.

Read other 2 answers

It seems to be missing?

In 2003, you could go to the column format and click on "Auto" for as many columns as you liked but in 2007 I can't seem to find it anywhere?

Sure, you can hover the mouse over the heading of the column and drag it wider or change the actual width manually but the old Auto Column feature in 2003 was so much better as you could block as many columns as you liked and they would all auto fit as you worked with them.

A:Solved: Auto column width in Excel 07

If you selct the columns that you want to autofit and then hover the mouse over the heading of any of the columns you selected until you see the double black arrow with a black vertical line and then double click, that will autofit all the columns you selected.

The same applies when you select single columns

You can also do the same for autofit for rows.
Select the column or columns that you want to change.
On the Home tab, in the Cells group, click Format.
Under Cell Size, click AutoFit Column Width.

Hope that helps

Read other 3 answers

Run time error 8542 report width is larger than the paper width

this error appears when i operat some report in run time mode from program programmed using VB6 and Access 97

note thatprobel happen to some xp systems and dose not hapen with other Xp systems

i need solution for that problem

Osama Ghandour

Read other answers

Based on CERT, ISC, and other warnings below, the capability for security software to interrogate embedded Unicode characters in HTTP requests could be a serious exposure that needs to be patched by several vendors? So far, there are no known in-the-wild attacks: Full-Width/Half-Width Unicode Bypasses HTTP Scanninghttp://www.kb.cert.org/vuls/id/739224 http://isc.sans.org/diary.html?storyid=2807http://www.gamasec.net/english/gs07-01.htmlhttp://www.cisco.com/warp/public/707/cisco...4-unicode.shtmlhttp://www.frsirt.com/english/advisories/2007/1803http://secunia.com/advisories/25285/What is Unicode?http://www.unicode.org/standard/WhatIsUnicode.htmlThe US-Cert has a vulnerability note out that describes how Full-Width and Half-Width Unicode encoding manages to bypass many HTTP content scanning engines (739224). This would allow remote attackers to hide malicious HTTP traffic by encoding it and have it slip happily past your IDS/IPS. This isn't an exploit itself, but allows exploits that would normally be detected (or blocked) to get through your IDS/IPS undetected.

Read other answers

Excel 2010 - created a worksheet with 2 different pages. When trying to compare or adjust column widths, different units of meansurement are in place;
Cannot discover how to make both the same so I can compare apples to apples.
Have searched both my Excel reference books and read for hours in Help for Excel. Nothing pertinent to my question and no solution evident. This is totally simple/basic, but I don't know how to handle this. Please help.

A:Solved: Excel 2010 - problem with column width settings

Read other 6 answers

Guys, strange issue here, started lately - not sure when exactly, though, probably a couple of weeks maybe four.

I can't make a window wider than about one screen width - 1920px - Windows just won't let me. (it can partially extend to other screens, but the total window width remains)
It used to work, I sometimes look at data where a 4-5000 px wide view is beneficial.
I'm using the 3 screens as one desktop via "nvidia surround", 5760x1200

Anyone got any ideas?

(and I'm sorry if I put this into the wrong forum, feel free to move it)

Thanks in advance!

A:Window width restricted to 1920px (one display width)

Thought someone might be interested, I've found the culprit: it was the nVidia driver.

nvControl panel -> Desktop -> Surround Displays

There are two options, the second one "Maximise windows across all displays" is the one.

Read other 2 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 have created this program in Access to keep volleyball stats. I simply enter a players number and an action (Serve in, Serve out, positive touch, negative touch, etc) the actions are all entered by a number. I want to have each record refer to a match and set but I want to have that data entered by default from the previous record so I don't have to enter that in my continuous form. I am pretty sure it can be done, but I don't know where to start. Here are the fields I use... Match, Set, Player #, Action #. I don't want to enter Match and Set each record since they will match the previous record. After the first set, the first record of the next set I will enter a new Match and Set data.

Read other answers

Quite a basic question that I can't find the answer to ...

How do I change the default save location for Office 2013 apps for all users in a domain?
To do it locally I see you can by Options > Save > Default Local File Location ... but what about all users? Is there not a group policy? A reg entry?

Ideally I want all users to save to c:\users\%username%\onedrive for business

Please help - this is such a simple thing but so problematic!

A:Office 2013 Default Save Location

Hi, Welcome to Seven forums.

Try this link. Set the Default Save Location to Computer in Office 2013 | trekker.net

There is a method of policy you can apply.

Keep us posted.

Read other 3 answers


When I imported the contacts from .csv format into Outlook 2013, it goes to Contact, but when I pressed the Address Book or trying to send emails, the default is sourced from Contact-Offline, how do I merge them or set the default as Contact?

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

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

Using Excel 2003, is there any way to edit the width of the stacked columns within a chart? I have created a chart that is perfect, except that the columns are very narrow and therefore not as clear as they could be, there is a wide space between each column which I'd like to fill. I have set the Gap Width to 0, so I'm not sure how else to make the columns wider. Any suggestions gratefully received!



A:Excel "Stacked Column" Width

Double click the column, go to scale..

Read other 1 answers

Am beginning to wonder if Microsoft ever launch a product that works with other Microsoft products.

First all the browsers no matter where stopped working in windows 8. I tried command prompt as admin netsh winsock r (worked on 1st computer running win 8 that the browsers failed on) , but this had no effect so I did a clean boot which seems to have resolved this issue (2nd computer with win 8 on that the browsers stop working but internet running fine on them.).
Before this was done all of sudden outlook 2013 decided when starting to display the message: Either there is no default mail client or the current client cannot fulfill the messaging request. Please run Microsoft outlook and set it as the default mail client.

Now this I have done in all 3 areas, outlook, control panel and internet options within the IE browser. But nothing changes and they were all 3 set as default anyway.

Anyone have any idea why this happening and if there is a fix as I am getting to the point where I am beginning to despair with win 8 and outlook 2013 respectively, and recommend roll backs till they get their act together and sort them out.

A:Outlook 2013 not recognised as default email client

Have you tried using Default Programs to set it?

Read other 2 answers


In Excel can you have two formulas for one cell? On the example below, I need to have it so it goes +100% if they are over their goal but -100% if they fall below. I have the conditioning rule for the negative to go red.

Varietal Ship Goal Shipped +/- Percent of Goal
Chard 385 602 156%
T Chard 32 9 -72%

Also, for some reason the other person who works on these files along with me, cannot highlight the row if there is a conditioning rule anywhere? Any thoughts on this as well would be quite helpful. Thanks in advance!

A:Excel - Two Formulas, One Cell

Hi, welcome to the forum.
Two formulas is a no no, but the formula can have nested IF and OR statements, your example is not quite clear (to me)
About highlighting, if conditional formatting is actie in that cell you can change and hightlight what you want, conditional formatting overrules this.

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

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

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