Super User Stack Exchange
Super User Stack Exchange

Questions tagged [microsoft-excel-2013]

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
1614 questions
63
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
  • 763
8
votes
1 answer

How to change excel legend order?

I have a excel graph with two lines using the primary axis and a column using the secondary axis. The legend currently lists the column first followed by the two lines. I would like to list the lines first in the legend since the axis they are…
drv82
  • 91
6
votes
3 answers

How does Excel decide to use an absolute path for external links rather than relative path

There seems to be a difference in the behavior of relative links in Excel 2013 from Excel 2010. What I'm experiencing in Excel 2013 is the following: If the option 'Save external link values' is checked, then links in formulas are always saved as…
Ben Aaronson
  • 171
  • 1
  • 1
  • 4
5
votes
11 answers

Newly inserted rows in a table do not get properly formatted

I have a table (not just a cell range, but a full table with table name, etc.). I have applied striped formatting to it. When I add new blank rows to the end of the table, they don't change colors as the rest of the rows, but use the formatting of…
Alexander Popov
  • 1,125
4
votes
1 answer

Restore Multiple Document Interface on Excel 2013

Is there a way to restore the old Multiple Document Interface (MDI) to Excel 2013? i.e. when multiple Excel files are open, there is only one instance of Excel in the Windows taskbar. Some reading tells me this has been removed, but I hope there is…
Richard Le Mesurier
  • 228
  • 4
  • 13
4
votes
2 answers

how to save an excel workbook with multiple worksheets into multiple corresponding csv files in excel 2013?

i have an excel workbook which has got some 125 worksheets and i need to be able to save each of those 125 worksheets into csv files(so that i end up with a total of 125 csv files) am currently able to do this manually(file>save as>csv file type)…
user221238
  • 75
  • 1
  • 5
  • 13
4
votes
2 answers

Find and Replace ':' colon gives "That function isn't valid" error on Replace All

When I try to use Find and Replace in Excel 2013 by entering a colon into the 'Find what' field and any text into the 'Replace with' field I get "That function isn't valid" error on clicking 'Replace All'. I am guessing that the colon is some kind…
Paul C
  • 619
3
votes
2 answers

How do I insert columns without changing cell reference of a formula?

I have the following formula in cell A1 where I am simply adding and subtracting some numbers... =B1+D1+F1-C1-E1-G1 And I repeat this going down to row 100 such that the formula in A2 is... =B2+D2+F2-C2-E2-G2 And so on. Then I run a macro…
D Smith
  • 31
  • 1
  • 1
  • 2
3
votes
1 answer

Reference Multiple Excel Workbooks at the same time

I am trying to compile data from multiple workbooks into a single one. So far I had the idea of referencing cells from other workbooks, something like using ='C:\Users\me\Documents\[sample.xlsx]Sheet1'!A1 However typing in each individual workbook…
austinw
  • 31
3
votes
1 answer

Setting Row Height via Excel VBA with merged cells and word wrap

What is the Excel VBA code that will set the correct (all characters visible and not excess space) row height with merged cells and word wrap on. My font is Calibri 11. Is there some simple relationship between font size, column size and row height…
Ed Holden
  • 31
3
votes
1 answer

How do I enable vertical gridlines in Excel 2013 Pivot Chart?

By default, when creating a stacked area Pivot Chart, Excel 2013 does not include vertical gridlines. How can I enable them?
Riley Major
  • 171
3
votes
1 answer

How change format to UTC format in Microsoft excel

i have this format [2015/07/29:02:05:21 PM] i have to change this format to UTC format(yyyy-mm-ddThh:mm:ss) in multiple cell.
Lakhvinder
  • 31
2
votes
1 answer

How to hyperlink within the current sheet in a copy of the sheet?

If I create a hyperlink in Excel, and then I make a copy of that sheet, if I click on the hyperlink in the new copy, it would link me back to the cell in the previous sheet and not the newly created sheet. How can I create a hyperlink that always…
Ben
  • 445
2
votes
1 answer

#value error when updating SUMIFS formulas with range from another workbook in Excel 2013

I have on a local folder a source file with a two-column table with key-value pairs and a destination file which uses data from the source as follows: link to a specific cell: ='C:\Temp[source.xlsx]Sheet1'!$B1 query a value from a…
Sebastian Deac
  • 21
2
votes
2 answers

Is there a quicker way to open/import a file in Excel 2013?

Nowadays (Excel 2013, with an impossible-to-find About dialog, by the way), the File Open dialog/page in Excel is cloud-enabled and Windows 8-ified. This means that it defaults to show the recent workbooks, and to browse for a file on my computer I…
MattBianco
  • 2,253
1
2 3
…
12 13