Top "Excel-2013" questions

The Excel-2013 tag is used for referencing the Excel Version 2013 spreadsheet application from Microsoft.

Loop through folder, renaming files that meet specific criteria using VBA?

I am new to VBA (and have only a bit of training in java), but assembled this bit of code …

vba excel excel-2013
Using VBA to insert and keep images in file - Excel 2013

I'm working on a macro for a friend of mine who needs to import a set of images in an …

image excel vba shape excel-2013
Solver.xlam is missing?

I created a program in Excel 2010 on my PC that relies on the built-in solver for Excel. I made sure …

excel vba macos excel-2013 excel-2011
Excel ran out of resources while attempting to calculate one or more formulas

I have a workbook to do 'smart'-graphs on my expenses. It's been running for a year and there are now …

excel excel-2013 vba
excel vba not exporting pagesetup to pdf correctly

I have code which formats a worksheet to the desired setup and layout (one page wide and tall in landscape). …

vba excel excel-2010 excel-2013
How to add a filter & sort button in cell?

How can I insert the filter and sort button in the cell as in the picture?

excel excel-2013 dropdown
Create Bar Chart in Excel with Start Time and Duration

I want to create what is essentially a Gantt chart in Excel 2013 with time of day as the x-axis, date …

excel time charts excel-2013
Separate octets of IP address using formulas

I want to separate out the octets of an IP address using Formulas. I have tried some things like substitute &…

excel excel-formula formula excel-2013
How to filter an Excel table based on values in a column shard with another table?

To start, I don't think VLOOKUP will work for me because I have dozens of columns in each table. Let's …

excel excel-formula vlookup excel-2013
Append & prepend string to existing rows

I have a table of numbers: 1 2 3 4 5 6 7 . . . What i would like to get: *1* *2* *3* *4* *5* *6* *7* . . . I have written a formula, but i dont …

excel excel-formula excel-2013