Stack Overflow
Stack Overflow

Questions tagged [excel-2013]

The Excel-2013 tag is used for referencing the Excel Version 2013 spreadsheet application from Microsoft. If your question is about VBA then also tag it VBA. If it is about an Excel formula then tag it Excel-Formula.

Excel 2013 is the 15th version of Microsoft's commercial spreadsheet program. Microsoft has significantly enhanced the charting and Business Intelligence capabilities in this new release.

This tag is used for questions specific to the 2013 version of the program. However, it is usually used in tandem with other tags, to let SO users know what your question is about. If your question is about VBA then also tag it . If it is about an Excel formula, tag it . Questions about addins for Excel 2013 should be tagged .

Links:

1745 questions
65
votes
3 answers

be careful parts of your document may include personal information that cannot be removed by the Document Inspector

I use Excel 2013 and Power View and SQL Server 2008 R2. After create my Data Source and my chart in Excel When I want save my Excel file I get this message be careful parts of your document may include personal information that cannot be removed by…
Ardalan Shahgholi
  • 11,967
  • 21
  • 108
  • 144
45
votes
7 answers

Number format in excel: Showing % value without multiplying with 100

When I set format of a cell as %, it automatically multiply the value with 100 & show the value. So 5.66 becomes 566 %. I want to apply % format on a column but want to keep the values same as before. I just want % sign to be shown along with the…
SharpCoder
  • 18,279
  • 43
  • 153
  • 249
30
votes
1 answer

Clear contents and formatting of an Excel cell with a single command

If you want to clear the contents of a cell or range in Microsoft Excel, you can use .ClearContents. If you also want to clear the formatting, you can use…
MackM
  • 2,906
  • 5
  • 31
  • 45
26
votes
9 answers

What Excel formula returns the sheet name?

I have searched the excel function documentation and general MSDN search but have been unable to find a way to return the sheet name without VBA. Is there a way to get the sheet name in an excel formula without needing to resort to VBA?
SilS
  • 261
  • 1
  • 3
  • 4
25
votes
2 answers

Check if cell contains Non-Alpha characters in Excel

Is there a Non-VBA way to check Col B and Col C to see if they contains any characters that are Non-Alpha? Just to clarify by Non-Alpha I mean anything not part of the alphabet(case insensitive). Col B and Col C is a list of First and Last Names.…
Chad Portman
  • 1,134
  • 4
  • 12
  • 38
25
votes
1 answer

How to set 'Fit all columns on one page' in print tab

The only thing I would want is to always set the 'Fit all columns on one page' setting when users open the Print tab in Excel. And no, they don't want to do it themselves. What a surprise :) Here is a screenshot of where that is in Excel…
Pepys
  • 981
  • 7
  • 16
  • 34
23
votes
4 answers

Excel: Searching for multiple terms in a cell

I use this handy equation to search for a term inside of a cell in excel. =IF(ISNUMBER(SEARCH("*Gingrich*",C1)),"1","") This equation searches for the presence of Gingrich in C1, if it exists, it displays a 1. All I'd like to do is search for more…
Chris J. Vargo
  • 2,266
  • 7
  • 28
  • 43
21
votes
4 answers

VBA for Excel throws "Object variable or with block variable not set" when there is no Object

In my code, I have declared these variables: Dim Field_Name, Datatype, row As Integer Then, inside a For loop, I have this code: Field_Name = Worksheets(i).UsedRange.Find("Field Name").Column Datatype =…
wardzin
  • 373
  • 2
  • 4
  • 12
20
votes
3 answers

If two cells match, return value from third

Here's a simple explanation of what I'm having trouble with. Column A: List of 2300 order numbers Column B: Email Address associated with an order number Column C: List of 100 specific order numbers that I need the email address for So, I'm…
mn8809
  • 454
  • 1
  • 5
  • 13
19
votes
2 answers

What's the RIGHT way to reference named cells in Excel 2013 VBA? (I know I'm messing this up)

I have a cell (Ok there's a bunch but I'm just looking at one now) named "Classes". It's "C10" by Excel's grid notation. My code works perfectly when I reference the cell as Range("C10") = "Value" But when I use Classes = "Value" It just does…
StolenKitten
  • 611
  • 3
  • 6
  • 12
16
votes
5 answers

Is Excel VBA's Rnd() really this bad?

I need a pseudo random number generator for 2D Monte Carlo simulation that doesn't have the characteristic hyperplanes that you get with simple LCGs. I tested the random number generator Rnd() in Excel 2013 using the following code (takes about 5…
XYZ
  • 163
  • 1
  • 6
16
votes
4 answers

What does the number in the AddChart2 VBA macro represent?

I've use my Excel 2013 to record a macro in inserting a chart, a column-clustered chart in my case. In the view code option, it shows me a line of code as below: ActiveSheet.Shapes.Addchart2(286,xl3DColumnClustered).Select Please help me as I…
OneBaseNotch
  • 183
  • 1
  • 2
  • 7
16
votes
3 answers

How to script Excel 2013's Spreadsheet Compare?

I'm trying to incorporate the fancy new Spreadsheet Compare function from Excel 2013's Inquire Add-in, into a VBA script. The plan is to have a macro to automate comparison between two spreadsheets with predefined names, and to export all the…
410 gone
  • 782
  • 14
  • 25
13
votes
1 answer

CustomTaskPane in Excel doesn't appear in new Workbooks

I've added a CustomTaskPane to Excel 2013 that lets users quickly search for photos. It works well and fine if the user only opens/creates one workbook. Problem is if they open another workbook or create a new one, the task pane doesn't appear in…
Lee Harrison
  • 2,306
  • 21
  • 32
12
votes
6 answers

Camel case converter in an excel

I am trying to convert a field in an excel sheet (e.g. REC_LEN) to camel case. I am using this formula to do that =LEFT(A1) & RIGHT(SUBSTITUTE(PROPER(A1),"_",""), LEN( SUBSTITUTE(A1,"_",""))-1) This is giving me results like RecLen. I want to…
Twisha
  • 371
  • 2
  • 5
  • 17
1
2 3
…
99 100