A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

1
vote
1answer
6k views

How to print an Excel Spreadsheet as Grayscale?

I would like to print my filled cells in a different color to match the rest of my document. The filled cells contain green background and blue font. I want the cells to automatically print to grey ...
22
votes
4answers
8k views

How to keep selected text highlighted when focus changes in Microsoft Word/Excel

Related to this question: Show cell selection in Excel when not in focus except that my case concerns Microsoft Word. When I select text or a column/row in Microsoft Word or Excel (2003, 2007, 2010 ...
2
votes
1answer
660 views

Highlight specific points on a surface chart in excel

I was wondering if its possible to highlight a series of x,y,z points on a surface chart in excel, similar to what ive done manually in the picture.
2
votes
4answers
29k views

Use VBA to repeatedly generate random numbers

I know that in Excel one can use rand() function to generate random numbers, and each time pressing F9, all rand() results on that sheet will be refreshed. However, now I need to repeatedly generate ...
0
votes
2answers
1k views

Excel: Search and Replace based on Rules

I have a list in Excel more than 3000 rows that I would like to research and replace some words within the list based on another list. For example: List 1: Blackcurrant Juice 500ml Strawberry Juice ...
9
votes
4answers
54k views

Using find() in Excel to remove text from string

I'm using find to remove some of the test string in lookup cell value For instance I look-up the following in cell A2 Application: sales_rep_support and use find =RIGHT(a2,FIND(" ",a2)+4) to change ...
0
votes
1answer
4k views

Reset sort by color filter

I have a column with numbers, and some are with colored background. When I use "Sort by color" from Filter drop-down menu, Excel sorts the column by selected color. I wonder how do I revert to ...
3
votes
2answers
6k views

Excel reference named range with text and formula

Is it possible to refer to a named range by combining text with a formula? Say I get a name for a range via INDEX which returns a text but I also want to add something after the text like so: ...
3
votes
3answers
307 views

How do I convert a delimited list to a multicolumn table in excel?

I have a list like this: Friut;Taste;Color;Other;Apple;Good;Red and Blue;1;Orange;Really Good;Orange;12 And I want to convert it by selecting every 4 delimitations and turning them into rows like ...
0
votes
0answers
110 views

Inpute & Update record in excel

I am working on creating a user form to store data in excel & update record, I have 3 requirement to complete my user form design. How can i create a unique reference number (preferable ...
0
votes
2answers
3k views

How do I mark a cell if another cell contains data from a list in Excel?

I am working on a spreadsheet and I need to have a way to mark items that have been recently ordered. Each row is an item in inventory. I have a separate list of item numbers that have been recently ...
0
votes
2answers
3k views

How can I graph survey results in Excel?

I would like to graph my survey results with the numerical values of the responses listed on the vertical axis and the questions listed on the horizontal axis. For example, I imagine the questions ...
0
votes
1answer
157 views

Excel 2010 creating a single list out of many

I'm trying to create a single list excel file that combines three others. Basically we have three printers that independently keep track of copy/print usage for both black/white, and color. My main ...
0
votes
2answers
60 views

Macro workbook - display info on open

Goal: I'd like to display some basic information when a company intranet user opens a macro-enabled workbook. The information can be in text form, not more than a paragraph. Problem: The workbook is ....
2
votes
3answers
2k views

Zooming in onto an Excel linear graph

Consider the data as follows alg1 alg2 alg3 57,55 56,25 59,9 92,1 93,5 92,2 104,7 103,7 103,85 108,9 109,65 108,75 I would like to make ...
2
votes
1answer
2k views

Create a excel chart only with axis

I want to create an excel chart with only the axes namely x axis and y axis with x axis values ranging from 1 to 100 and y axis values ranging from 1 to 100 Is this possible? If so how to do it? ...
0
votes
1answer
847 views

Open Excel file after successful RDP connection

I have a PHP script that creates RDP files on the fly and it works great. The next step is to automatically open an Excel file once the RDP session is created, or simply "link" to the Excel file ...
3
votes
2answers
12k views

Conditional Removal of Duplicates from Excel

I have a list that has names in Column A and it contains duplicates. Column B has dates in them, but some cells are blank. Is there a way to ask Excel to remove duplicate rows based on name AND ...
2
votes
2answers
547 views

Excel - How to build pick lists dynamically

Here's worksheet A: Parent Kid Age ------ --- --- John Scott 5 John Lucas 7 John Elisabeth 12 Victoria Jason 3 Victoria Amy 5 Jenifer ...
0
votes
2answers
83 views

Mac OS 10.8.4 and Excel

I am trying to delete everything after the "," on each cell in a column of email addresses. For example: jonsmith@hotmail.com,2013-08-06 13:27:53,bounced sallyfield@google.com,2013-02-06 13:05:47,...
1
vote
1answer
147 views

Transposing columnar record data to rows in Excel

Can I reference a cell in another worksheet like this? Example: Worksheet A A1 Data1 A2 A3 Data2 A4 A5 Data3 Worksheet B (I want to copy by referencing the cells in Worksheet A) B1 '...
2
votes
1answer
14k views

Excel pivot table categorical variables the same in multiple columns (histogram)

I am relatively new to pivot tables, and there is one thing that I just can't figure out how to do. I have a worksheet that has several columns of categorical data. Each column (Groups 1, 2, 3) has ...
0
votes
1answer
404 views

Excel Form Control Text Resizing- Won't Highlight when Click Edit Text on Form Control

I added some form controls through the developer tab and linked them to macros successfully. They are checkbox type controls and I want to increase the font size in them, when i click edit text though ...
1
vote
2answers
664 views

Fill formula containing named range but change named range based on relative reference

I have a formula that I need to copy in many cells, but I don't know how to copy a named-range reference to another cell without changing it. NamedRange (a table imported from database connection) ...
-1
votes
1answer
65 views

Removing Hyperlinks in Excel without effecting the colors with which it was highlighted

I have a database in which there are email IDs that are marked in different colors based on the previous responses. I want to remove only hyperlinks, as whenever I am trying to work it is taking me to ...
0
votes
2answers
497 views

Excel: Use of spaces in filenames/sheetnames with INDIRECT()

Formula is: =INDIRECT("'Z:\ADMIN PROJECTS\[FORWARD ORDERS.xlsx]"&A1&"'!C$2") Value of A1 is SEPT 13 in text (to be replaced by another formula soon). Excel keeps giving me #REF. I'm pretty ...
0
votes
1answer
96 views

Trying to Consolidate using Excel - Need to Concatenate

I have a mail list that I need to merge the duplicate addresses together and concatenate the names. Example below: Name Street_Address --------- ---------------- JohnDoe 444 Elm Street ...
1
vote
3answers
3k views

Fast way to export data out into different excel files based on Column

There's some data like this (with over 500,000 entries) Name | State ---- ----- Billy Utah Sue California Joe Utah Sally California John Michigan ...
1
vote
1answer
596 views

Add an elapsed time format to a datetime in Excel

Given the value 4/1/2013 20:07:11 and a column called Elapsed Time which has values such as 00:00:00:00:000 which is 00:hh:mm:ss:fff, I'd like to derive a column which is the date value + the elapsed ...
3
votes
3answers
369 views

Filling empty spaces in a column with a series in Microsoft Excel

I have a list like this: A B Student ID Student Name 20496836 Barnes, Troy 28682693 Bennett, Shirley Edison, Annie 28395839 Hawthorne, Pierce ...
1
vote
1answer
720 views

Excel VBA, add hyperlink attached to comment's shape object

I'm wondering why the following code doesn't work: Dim shp as Shape With Range("D7") .AddComment .Comment.Visible = True Set shp = .Comment.Shape End With ActiveSheet.Hyperlinks.Add ...
1
vote
1answer
150 views

How can I use excel to create a multiple IF function?

I have a spreadsheet comparing numbers of programmes sold by my company. I want to create a formula that will total several variables. In one column I have the month then whether it is a "Finance" ...
1
vote
0answers
105 views

Splitting Excel file but retaining lookup data and formulas

I have a master expenses file that has a page for each employee summarising their expenses. The employee sheets run off a hidden data sheets. I want to send each employee a copy of their expenses ...
4
votes
7answers
52k views

How to stop Excel from formating the 16 digit account number in a way to avoid making the last digit zero?

I have large number of bank account numbers of different banks. Some banks account number start with zero and some have 16 digits. When I paste the data in Excel the leading zeros will be removed and ...
1
vote
1answer
910 views

Displaying Other Values Via COUNTIF in Excel

Basically I have a sheet like this: A B C D Name (From File 1) Name (From File 2) Phone Number Countif Walt ...
3
votes
3answers
2k views

Lost VBA when downgrading from Excel 2013 to Excel 2010

I am on Windows 7. In the past I was using Excel 2003. I installed Office 2013 and found that my Office 2003 was intact and I could run both versions. I made updates to some worksheets using Excel ...
0
votes
0answers
1k views

Creating readable XML for iOS

My client uses a process that uses XMLSS to create XML documents that can be opened in Microsoft Excel. In fact, simply renaming the files to .XLS, will ensure that the documents open in Excel by ...
1
vote
2answers
9k views

Filter for first unique instance a column in Excel?

How can I filter for unique values in a particular column (disregarding the values in the other columns for that row, and so the first instance of a new value would be fine)? So, for example: 1 ...
0
votes
1answer
527 views

How to format text with multiple periods in Excel?

I have text with numbers that I need to format in Excel. The format I tried using in excel is 00000.0000.0, which would work beautifully if it weren't for the double periods. 19271.23.8 -> 19271....
0
votes
1answer
250 views

Remove Duplicates in Excel 2013 keep row with most data in place

I have a spreadsheet that looks something like this: Full Name | Email | Phone Number --------- ------- ----------- Billy Bob bob@gmail.com ...
0
votes
1answer
189 views

Office 2007: .xls file opens excel with no workbook. “Ignore other apps that use DDE” already unchecked

Auto-recover failed to save a workbook I had open. I've tried to recover the wkbook by going to the auto-recover folder - found a .xlb file there, converted it to .xls. It is now opening excel, but no ...
3
votes
2answers
7k views

Split Text into Columns Function in Excel

I have an excel spreadsheet with rows of data as shown below. There is a code with the product name and then a number. QA32 Product One (Large) 23 AZ63 Product Two 96 PR65 Product Three 149 How do ...
3
votes
2answers
36k views

Conditionally format cells based on match in another sheet

I have an Excel spreadsheet with 2 worksheets. The first is just a header row and a single column of item names. The second is a list of item groups, with a header row and a title in the left most ...
0
votes
1answer
3k views

Can't get the formula to autofill correctly

In Excel I entered two formulas manually: B3 = C3 * C2 B4 = C4 * C2 I have a lot of rows so I wanna copy the formula down. The problem is, I select them both and then pull down. What happens is ...
0
votes
1answer
78 views

Excel: How to efficiently check whether a selected cell is referenced in any other cell

I want to check whether a selected cell ( say A1) is referenced in any other cell in the sheet I’m working in? Is there a similar tool that shows you arrows from the selected formula to referenced ...
1
vote
0answers
146 views

Excel97 crash, Windows 7, VBA, DEP

I've not be able to get Excel 97 VBA to run correctly on Win 7 without turning DEP entirely off. Access97 runs ok with just an Access DEP exception, But making Excel a DEP exception has not helped. ...
1
vote
2answers
619 views

Excel AutoFill Reference other sheet

I want a column to contain multiples of 9 in reference to cells on the first page (that I've titled Log). So column will be =Log!F9 then =Log!F18, etc. Is there a way to make this Autofill work? If I ...
5
votes
2answers
37k views

How do I split one row into multiple rows with Excel?

I have a product database in Excel with several hundred entries, each of which has from 1 to 3 "tiers" of pricing: Standard, Deluxe, and Premium. Each tier has its own SKU (A, B, or C added on to the ...
0
votes
3answers
1k views

Remove duplicates after filtering

After using this formula =IF(ISERROR(MATCH(A2,B:B,0)),A2,"") in column C, it nicely filters out the blacklisted numbers. But I need advice for a step further: How do I remove duplicates?
0
votes
2answers
135 views

Spreadsheet formula to list all unique entries EXCEPT for certain cells in a column

Ok, so I have 3 columns that look roughly like this: Name Paid To ======== ======== ======== John 10 Roy Jane 50 ...