**3**

votes

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**3**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**5**answers

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 ...