Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

3
votes
3answers
32k views

Excel: convert a column with hyperlinks to just display the links

In Excel, I have a column of links that display text instead of the actual link. I actually need the links, is there a way to bulk convert the entire column so that the links are exposed? Otherwise I ...
2
votes
1answer
1k views

Turn off (or increase size threshold) for clipboard warning in MS-Excel

This question asks how to programmatically turn off the "there is a large amount of information in the clipboard" warning" that MS-Excel pops up whenever you try to close an Excel file and the ...
4
votes
1answer
22k views

Excel 2011 Mac auto-recover file lost

Yesterday morning my colleagues Excel 2011 (on Mac OSX 10.8) crashed. He reopened Excel and was asked if he wanted to recover the previous document. Yes, he said and then got a document named ...
0
votes
1answer
973 views

Merging rows in an Excel document with the same email and preserving merged row data

I have an excel sheet of around 50,000 records of something like this: email product info moreinfo a@a.com 866 data data1 b@b.com 960 data data1 c@c.com 976 data data1 c@c.com ...
1
vote
0answers
268 views

Excel 2011 Conditional Formatting: compatibility issues

I would like to create a workbook in Excel 2011 for Mac that is fully usable in Excel 2003 (on Windows XP, Compatibility Pack installed). The purpose is a semi-automatic calendar, where one enters ...
0
votes
1answer
39 views

How to define a specific row height for Word table row similarly 'Row Height' feature in Excel?

In Excel we have 'Row Height' where we can enter a number to define the heihgt of a row. I want to do the same in Word but there is no such command when right clicking on the row. And currently we ...
-1
votes
1answer
23 views

Excel 2010 open more than one spread sheet in same window

How do I open more than one spreadsheet in the same window so that if I close one the others stay open or if I close the last one Excel stays open? Thank you.
0
votes
1answer
6k views

Any trick to calculating percentages when the base is a negative number

I am trying to calculate percent change when the base number (at time 1) can be a negative and the resulting number is positive (at time 2). My problem is the percent change from -4 to +4. A change ...
1
vote
3answers
3k views

Sum of different currencies Excel

I have an excel workbook which requires me to calculate the sum of different currencies on the same column, here is the result I'm looking for: The $40.00 in Dollars was calculated based on item A ...
2
votes
2answers
1k views

Excel Concatenate Time

I have had a look at this site, and across the net, but can't seem to solve this, which should be easy! Concatenate should work, but I wasn't able to make it work. Current spreadsheet looks like ...
0
votes
1answer
8k views

Excel vba code for adding a value to existing cell of sheet

i have this code to add value of a cell to existing value of other cell which is below Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not (Intersect(Target, Range("E3")) Is Nothing) ...
0
votes
1answer
18 views

How do I create a conditional format with 2 columns

I am trying to create a rule that would highlight a cell under these conditions: Column B>1 & Column C=O I want Column C to highlight if they meet these two conditions. Can someone help?
0
votes
1answer
3k views

How to Find and Replace worksheet name in a formula?

I have 100 worksheets with different names saved in a folder. I have another worksheet in another folder where I conduct analysis of data from one of those 100 worksheets. In this analysis worksheet, ...
1
vote
3answers
8k views

Calculating time in Excel between AM and PM

I have an Excel spreadsheet that calculates the difference between two times. The formula that I'm using, for example, is as follows: Cell A1 12:00 PM Cell B1 12:30 PM Cell C1 =minute(B1-A1) and the ...
1
vote
2answers
21 views

How to replicate efficient pasting from delimited text behavior in Excel?

Sometimes when I paste space delimited values from a text file into excel it automatically separates them into the correct columns. Other times I have to use the "Text to Columns" tool. I haven't ...
0
votes
1answer
5k views

How to customize Paste Value Excel Short Cut

I was reading in this other post about how to set up a macro to past values in Excel. I understand how to create he macro but I would like to set the keyboard shortcut to Ctrl d but excel pops up an ...
1
vote
2answers
3k views

Getting Excel to handle CRLF's correctly in CSV

I am creating CSV files to be opened in Excel. The rows are separated by CRLF and that's fine, but some of the input data contains CRLF data in it as well. Per the usual standards, I surround them ...
0
votes
1answer
19 views

How to return the name of uniquely named sheet

So I've searched high and low and cannot seem to find an answer to this question. Spent almost two days trying every thing I could find on line, but none were specific enough to my situation. Without ...
0
votes
1answer
10 views

Any addins in excel to display scientfic notation as written

Are there any addins in excel to display scientfic notation as written? I want to see 5 x 10^-23 instead of 5E-23
0
votes
1answer
36 views

Excel VBA: How to find last row of a worksheet containing actual data

I know how to find the last row of my worksheet that has any type of data or values Dim lastRow As Integer With ActiveSheet lastRow = .Range("B" & .Rows.Count).End(xlUp).Row End With ...
0
votes
1answer
27 views

Excel Timeline Chart (Vehicle Tracking)

Using Excel 2010 I understand how to create a Gantt Chart to simulate a timeline. Very similar to this https://ablebits.com/_img-blog/_comments/gantt-chart-months.png. My task is a little bit ...
1
vote
0answers
36 views

How to calculate average daily sales for each month in a pivot table

I need to calculate the averages I have in a month. What I'm expecting is to calculate 936, 184, 943, and 230 and get an average of 573. However, when Excel calculates these values in a pivot ...
0
votes
0answers
38 views

I need a macro to separate a column of names into 4 different shifts

Our system creates a report for accuracy. Our manager wants it separated by shifts. From those lists, it will go to a report 'by shift' along with the information on the row with each. I need a macro ...
0
votes
0answers
67 views

Change Excel cell value on each saved revision

Is there a way of increasing cell values on each file save? I have a version number on a macro-enabled spreadsheet, and I want it to increase by say 0.1 each time I save the file. I would rather not ...
0
votes
1answer
23 views

How to fix a database after sorting only a few columns when other columns were hidden

I have sorted a giant database with lots of information when several columns were hidden. One of the columns was sorted by date and when I unhid all the columns, half of all the information in the ...
1
vote
0answers
12 views

Refresh data in depth trough multiple closed workbooks

Situation I have 3 Workbooks in the format .xlsx, Source, Manipulation and Result. Result has a link to a cell in Manipulation wich again, has a link to a cell in Source. As the data is manipulated ...
0
votes
1answer
73 views

Macro to manage sport ranking and calendar?

I need to write a macro (or a different easy way) to manage ranking and calendar for a curling tournament. The event will follow the Shenkel system: first match determined by general draw after ...
1
vote
2answers
39 views

Excel formula to convert date formats

Assuming I have cells that have text values mentioned as: 02/23/15 to 03/01/15 Can I use excel functions to convert this to something like 23-Feb-15 to 1-Mar-15 So far I have looked at formula ...
1
vote
2answers
41 views

Excel Convert the correct Date type

I'm currently following the date type dd/mm/yyyy i need to have another row showing the month in mmm type. E.g. From 13/09/2014 to SEP My formula is =Text(A2, "mmm") which is the correct formula, ...
0
votes
0answers
10 views

Excel Powerview plot Summation of Multiple Series

Currently, I have a PowerPivot Data model based on the following table: My corresponding data model is shown below. I have a calculated column which keeps running totals for each contractor's man ...
0
votes
2answers
49 views

Excel SUM is not equal to manually-typed value

In the screenshot above in Excel I have opened a CSV file of money transactions from my bank. The transaction date is in column A, the amount in B, and the bank's computed balance in D. I'm ...
0
votes
0answers
14 views

Excel Template Show Associated Tasks

I found a template in excel 2013 called "Weekly Time Planner". It has a mechanism that filters another table when clicking upon a certain item. For example, I select one project in the project ...
1
vote
2answers
34 views

Excel table not formatting new rows appropriately - where does formatting come from?

I have an excel table and all rows are formatted the same. When I add a new row, the formatting does not match the rows above - so every time I add a row I have to select the above row and copy/paste ...
0
votes
1answer
279 views

How to convert data in table format to pivot format

I would need help in converting table which is in table format to a pivot format. Below is the sample data which I have: Product Currency Value US UK Japan Ind Local MNC Product 1 ...
3
votes
3answers
16k views

How can I enable the creation and editing of hyperlinks in shared Excel worksheets?

I have hyperlinks in some Excel 2010 (both .xlsx and .xls formats) worksheets. If I enable sharing of the workbook I can no longer edit or create hyperlinks - the options no longer exist on the menu ...
1
vote
2answers
46 views

How to avoid opening a workbook referenced in vlookup between 3 workbooks

Situation: I have three excel workbooks of which Workbook1 and Workbook2 contain my data. In Workbook3 there is a VLOOKUP which references to the data in Workbook1 and Workbook2. All of that works ...
0
votes
0answers
195 views

I'm looking to create some VBA code to search for other instances of certain string, move original instance above found

I'm looking to create a fairly basic VBA macro to automate a process in excel. I'll otherwise have to manually repeat hundreds of times. I have a sheet with several hundred rows of data, with about 20 ...
0
votes
1answer
1k views

Link Excel workbooks so that I can use them on another computer (Excel 2011 for Mac)

We have an Excel spreadsheet that uses data from another workbook. We use Dropbox to share the files. When I open the spreadsheet on another Mac or PC the links need relinking. Is there a way to ...
0
votes
2answers
133 views

Excel changing UNC paths in shared workbook

Excel documents stored on network drive, for example, \\networkdata\Excel\Shared Data workbook.xls contains tables with data entered into. Report.xls contains UNC paths pointing to ...
1
vote
1answer
433 views

Microsoft Excel Ceiling function

I've got a lot of data that I'm trying to enter into an excel spreadsheet. All the data in columns after the first are of the form: Previous column data * 1.3 {rounded up to the nearest ...
0
votes
1answer
19 views

Excel leaving formula when selecting another sheet

I am attempting to reference a range in another workbook in a vlookup. I type =vlookup(a1, and then go to the other workbook to select the range, but alas, I am no longer in the vlookup formula. I ...
0
votes
0answers
17 views

Combine table in Excel

I want to do a training matrix in Excel and track its completion. My fist table represents all the documents on which we should (or not!) be trained related to job title. Doc Name | For all ...
1
vote
2answers
38 views

Multiple IF Statement

I have a question about IF statements. I wanted to use VBA, but the other guy I am working with doesn't know how to do it, so I am trying to only use worksheet formulas. So, I figured the best way ...
0
votes
1answer
4k views

How to merge multiple sheets of Excel files to one Excel file?

I need to merge hundred Excel files into one Excel file. Each Excel file needs to be merged into its own worksheet in the workbook and the destination worksheet needs to have the name of the original ...
2
votes
1answer
2k views

How to revoke a macro in Excel?

After the execution of a macro in Excel, there's no button to revoke it, unless you close the book and choose not to save it. Is there a neat and easy way to just revoke it?
0
votes
1answer
234 views

How can I embed a tracking GIF in an Excel document?

I want to add www.sometrack.com/blah.gif to an Excel document. My goal is to embed a trackable element (e.g. a GIF). I want to send a person this document, and if they open it, the pixel opens ...
0
votes
0answers
21 views

Changing font of bilingual (Chinese & English) text in Excel

I have a large Excel file containing both English and Chinese text. I would like to change the font of the English text but whenever I do so, the Chinese text switches to another Chinese font, which ...
0
votes
2answers
31 views

Hide rows based on the value of another cell

First, I've tried these threads, to no avail (1, 2, and others which I am prohibited to mention since my rank doesn't allow for more than two links). I am almost certain I'm just missing some simple ...
0
votes
1answer
29 views

Excel macro to populate one cell in a sequence from a given range

Currently, after I enter a number in cell A1, the data in the spreadsheet changes; then I run a macro macro1 to save it to PDF. The problem is when I need to enter more than 30 such numbers into the ...
3
votes
5answers
26k views

Display Blank when Referencing Blank Cell in Excel 2010

I have an Excel 2010 workbook that contains a number of individual worksheets. The cells on one of the sheets are linked to individual cells on two other worksheets in the same workbook. I'm using a ...