The 2013 version of Microsoft's spreadsheet application.
A lot of new tools have been included in this release:
- Improved Multi-threading and Memory Contention
- FlashFill
- PowerView
- PowerPivot
- Timeline Slicer
- Windows App
- Inquire
- 50 new functions
Questions tagged [microsoft-excel-2013]
1619 questions
72
votes
8 answers
How to turn plain text links into hyperlinks in excel?
I have a list of links in an Excel spreadsheet that I want to turn into hyperlinks so I can view them in a web browser. Is there a way I can change all of them to hyperlinks at once? I'm using Excel 2013. Thanks for your help!
Zach Russell
- 853
67
votes
11 answers
Excel copy-paste: always match destination formatting
I use Excel to crunch numbers, so I usually don't want to copy the formatting along with the text. But this is the default. Is there a way to default to always match destination formatting when pasting into Excel?
Leftium
- 9,335
53
votes
7 answers
Disable Excel 2013 cell animation
When clicking into a cell of a Excel 2013 sheet, the green border of the cell is animated while moving from the current cell to the new one.
This is really disturbing. How can I disable this animation?
FiveO
- 8,268
47
votes
8 answers
How can I stop Excel from opening a second blank window when opening a file from Explorer?
When I open an Excel file from Windows Explorer, I always get a second Excel window as well. Annoyingly, when I close it, it doesn't close, but the other window does!
This seems to be a common issue:
Excel 2013 starts up with blank screen when…
Deanna
- 1,184
33
votes
4 answers
AND function gives TRUE result for empty, BLANK cell - why?
I have blank B2 cell.
=ISBLANK(B2) gives TRUE
A simple logical test on it returns FALSE
=IF(B2,TRUE,FALSE) gives FALSE
Yet when directly used in an AND statement, it returns TRUE
=AND(B2,TRUE) gives TRUE
Of course, when indirectly used in an AND…
pulsar3424
- 333
32
votes
4 answers
Get rid of all ##### errors at once in excel
In Excel, I usually solve ##### errors by double-clicking offending column headers. However, this can get a bit tedious when there are multiple error columns. Is there a quicker way to solve this?
M.Hesse
- 343
29
votes
11 answers
How to prevent Excel to use the OS regional settings for date patterns in formulas
According to this question I have the following problem:
I want to use some Excel function (not the cell formatting) like TEXT(A1, {date_pattern})
But the person who answer my previous question make me found that the date pattern change according to…
рüффп
- 763
28
votes
6 answers
How do I add conditional formatting to cells containing #N/A in Excel?
I have a column in Excel 2013 filled with values found with VLOOKUP(). For some reason, I am unable to use conditional formatting to highlight cells which contain #N/A.
I tried creating highlighting rules for "Equal To..." and "Text That…
Stevoisiak
- 16,075
22
votes
5 answers
PERSONAL.xlsb not opening automatically
For some reason, my PERSONAL.xlsb file is no longer opening automatically.
I've checked the Trust Center and the file location (C:\Users[user]\AppData\Roaming\Microsoft\Excel\XLSTART) is a Trusted Location. I have also checked that the file is not…
aLearningLady
- 353
21
votes
2 answers
Is there a way to skip down to the next change in value in Excel?
For my current daily use of Excel, I have a sheet where hundreds of consecutive rows have the same value for a particular column. I’d like a way to quickly skip down to the next different value.
ctrl + ↓ goes to edge (i.e. the end or the next break…
21
votes
1 answer
In Excel 2013, where are Visual Basic (VBA), Macros and AddIn tools?
In Excel 2013, where are options and tools such as Visual Basic (VBA), Macros and AddIn tools? Are they supported?
BSalita
- 915
19
votes
1 answer
Excel save behaviour of CSV file with UTF8 encoding vs UTF8-Bom encoding
My original csv files are encoded with UTF8-BOM, this is so Excel can recognise the Unicode charcters (If its just encoded with UTF8 then Excel does not recognise the unicode characters).
My issue is that with a UTF8 encoded CSV file, when you…
user2945722
- 293
17
votes
4 answers
How to fill in missing dates in chart
I'm looking for a simple way to chart a list of values each correlating to a date. For example:
Date Value
11/7/13 2
11/8/13 2
11/11/13 3
11/14/13 2
Etc. The problem is, the chart does not show a proper trend since many dates have no…
user176692
- 273
14
votes
6 answers
How to disable SYLK warning for CSV files in Excel?
I load a lot of CSV files into Excel and some of them cause the warning where Excel thinks it's a SYLK file, not CSV. The cause is known.
How does one disable this warning? Is there a setting, a group policy, registry setting? Anything?
AngryHacker
- 19,327
13
votes
2 answers
Tab (\t) is not recognized as columns delimiter when pasting into Excel 2013
I'm pasting data separated by tab, usually the excel would be a "little" cleaver and separate the data by columns at each tab character.
I don't know why, but Excel doesn't recognize the tabs anymore and I have to use the text importing tools every…
Pedro77
- 2,049