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]
1610 questions
64
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,209
- 9
- 48
- 79
59
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
- 723
- 1
- 7
- 10
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,228
- 12
- 48
- 77
45
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,154
- 2
- 10
- 18
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
- 4
- 8
31
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
- 313
- 3
- 5
28
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…
рüффп
- 744
- 6
- 13
- 26
27
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
- 13,555
- 39
- 101
- 154
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
- 875
- 4
- 13
- 20
19
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…
Tyler James Young
- 295
- 1
- 2
- 9
19
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
- 323
- 2
- 3
- 10
16
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
- 263
- 1
- 2
- 6
16
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
- 263
- 1
- 2
- 5
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
- 18,217
- 67
- 156
- 209
12
votes
5 answers
Fill formulas until end of adjacent table
I'm trying to fill a column with a simple formula using cells from an adjacent table. I know how to do that by dragging the mouse, but it's a very long column, so I'd like to use AutoFill.
However, if I press Ctrl-Shift-Down, all the rows until…
Tim Pietzcker
- 2,670
- 10
- 43
- 49