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)

40
votes
7answers
224k views

How do you auto resize cells in Excel?

I have copied some data into Excel 2010. I have found that some of the cells need to be widened to allow the data to fit. How do I automatically adjust the height of the cells to fit the content?
0
votes
2answers
56 views

Excel Graph with 2 X-Axis Non-Linear Mapping

I have the following problem someone might be able to help with. I have two risk scales, one from 1 to 11 (old) and one from 1 to 21 (new), where the mapping is non-linear, i.e. old scale->new scale ...
3
votes
1answer
5k views

Excel: #NAME? appearing when linking/referencing other spreadsheets/workbook cells

I'm updating a spreadsheet that refers to data in another worksheet =NameofWorksheet for some reason I get #NAME? in some of the cells, even when the actual path is correct. The only way to overcome ...
0
votes
2answers
24 views

Calculating the deviation from range of values?

I'm trying to find if there is a function to do what I could do with several IF statements, just to make it more robust and standard I suppose (and more readable) I have a spreadsheet with 4 columns ...
0
votes
4answers
4k views

INDEX MATCH based on 2 Criteria

I'm struggling to create a compound INDEX MATCH in Excel based on two criteria. My data set looks like this: RANGE SITE TYPE 2711260 LOB LBO 2711260 MYP WAN 2711266 ...
3
votes
1answer
7k views

How can I move linked Word/Excel files without breaking the links under Windows 7?

I currently operate under Windows XP and have multiple links between my Word and Excel files. I have to upgrade to Windows 7. When the .doc and .xls files are converted to .docm and .xlsm, ...
-1
votes
0answers
21 views

Mass edit hyperlinks on a Microsoft Project file

We had to replace our file server and long story short, user had Excel sheets and MS Project files with hyperlinks pointing to the old server which are now no longer working. I was able to find an ...
2
votes
1answer
3k views

Excel 2010 macro to separate a large data file into workbooks

I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet. I just need it to separate the files based on a column into a separate ...
0
votes
1answer
19 views

Trouble using “HLOOKUP” in Microsoft Excel 2010. Sometimes formula generates an error

Hi I have a table setup as- A B C D E F G H I J K L M 1 Row SDR_1 SDR_2 SDR_3 SIR_1 SIR_2 SIR_3 ...
4
votes
1answer
17k views

How to bypass the VBA project password from Excel

I need help with password retrieval or bypassing the password on a project that was done at work. The author has used MS Excel to do the project, and it's in the client's server. The server that we ...
0
votes
5answers
893 views

Excel COUNTIF Slow

I'm having an odd issue in excel that I haven't run into before. I have an excel sheet that I'm attempting to pull some specific records from, requiring that I know of duplicates. I am using a COUNTIF ...
1
vote
2answers
583 views

Set Width of Multiple Column in Excel

I have a bunch of columns on a worksheet, these columns do not have the same width, But all these columns must have in total a given width. How can I do that, keeping the ratio? So I have this: ...
2
votes
2answers
38 views

Counting the Cells in a Named Range without VBA

I have a disjoint set of 9 cells: A1,B3,C5,D7,E11,F13,G17,H19,I23. I have assigned a Name to these cells: MyPicksI have a simple formula to pick the value in one of these cells at random: ...
0
votes
0answers
16 views

How to validate autonumbering in MS Excel

I've made a running numbering function that autofills the numbers in every new row of my table. In most cases, I want to limit editing for this field, though sometimes I would need to keep it ...
0
votes
0answers
10 views

OneNote format changed after export to Excel

Following an export of the OneNote data into an Excel file for sharing, I cannot now make changes in the OneNote file. There is a cross shaped icon instead of a cursor that allows typing. ...
0
votes
1answer
14 views

Limiting editable fields in Excel

Can I limit only specific fields to be non-editable by users in Excel? The 'Protect sheet' function only offers protection to the entire file with specific fields editable, I want the opposite (most ...
0
votes
2answers
5k views

How to sort only part of multiple columns in Excel

I want to highlight, for example, rows 5-15 across columns C, D, and E, and sort only that block in ascending order by one of the columns. The trick is that I want all included columns to follow suit ...
4
votes
1answer
2k views

Linking Excel 2013 cell to Word 2013 table cell adds unwanted line breaks

I have a problem where I am trying to copy an excel cell that contains content using a formula, into a word document table cell and link them such that the formatting is used in word. What happens is ...
0
votes
2answers
26 views

Removing the duplicate values and showing them in a new sheet [duplicate]

I have created an excel file for deliveries in my company and when we order products i put their dispatch number in the file. But when I try to check these dispatch numbers with post I always have ...
0
votes
1answer
4k views

Excel data validation to whole column

I want apply data validation list to a whole column in excel 2010. How can I do that with out copying the validation rule
1
vote
3answers
13k views

How do I assign a number value to a non-numerical value in Excel

I have some survey responses with values like "VU" for "Very Unlikely" and "S" for Sometimes. Each survey response occupies a cell. For each cell containing a survey response, I want to fill another ...
2
votes
5answers
12k views

Subscript/Superscript Hotkey for Excel 2010 Macro?

Background In Excel 2010, for some ridiculous reason, there is no built-in hotkey (or even a button on the toolbar) for subscripting/superscripting text within a text cell. You can, however, ...
-2
votes
2answers
35 views

Adding 2 formulas in excel

How do I add these 2 formulas together? =IF(OR(AND(G14="No"), AND(G25="No")), "F") If this formula does not result in "F", then ...
0
votes
0answers
13 views

Cannot use Buttons with VBA in 2003 but can use buttons from same sheet in 2010 Excel

I have excel 2003 and 2010 installed on our computers. I reinstalled both, did a system restore. I manually uninstalled all updates from the past month (this started happening 1-1.5 weeks ago) I am ...
5
votes
2answers
772 views

Allowing users to unhide (format) only chosen columns

TL;DR, what I want to achieve: Hide some columns which I do not want to show to anyone (check) Hide some columns which I want to show only to some users (check) Set separate passwords for both ...
0
votes
2answers
25 views

Excel fill dates except Sunday

I want to fill a series of dates but Skip Sundays. When I right click the fill handle it only has weekday option, which will skip Saturday too. That's not what I need. How do I approach this? thanks!
0
votes
1answer
2k views

Relocate filters on an Excel worksheet with a Pivot Table

In my worksheet where I have my pivot table I have many different filters to chose between. To the eye it doesn't really look nice and I want to be able to maybe split that long list of filters into ...
6
votes
8answers
17k views

Changing bounds of excel file embedded in powerpoint

When I embed an excel files into powerpoint, I'm having two issues. On some of the spreadsheets, empty columns are displayed on the right hand side of the powerpoint slide On other spreadsheets that ...
3
votes
4answers
10k views

Excel chart, how to make a formula produce gaps?

I have a chart in Excel 2007 that is basically just a line graph. Some cells that make up the series data cannot produce a value through their formula, and I'd like the chart to place a gap in that ...
1
vote
1answer
25 views

Find first number greater than x and return another value in that row

I have created an investment spreadsheet. In one column I have the ending balance each year. In another column I have the years. A B 2000 500K 2001 450K 2003 1.2M 2004 1.5M How can I display ...
0
votes
1answer
217 views

Is it possible to insert multiple objects at once in Excel 2007?

My co-worker keeps a spreadsheet of candidate data, which includes the resume of each candidate inserted as an object. How can we insert multiple objects (resumes) at one time, instead of going ...
1
vote
2answers
27 views

How do I compare two list of data that contains a certain number in Excell?

How do I compare two lists of columns that contains a certain number? Please look at my example below: Column 1 Column 2 ------------------- 300 Room 305 301 Room 306 302 Room ...
0
votes
2answers
53 views

Adding multiple IF formulas into one cell

I have the four formulas below that I need compiled into one cell block. Please help! =IF(SOURCE!C24>=90,"A"," ") =IF(AND(SOURCE!C24>=80,SOURCE!C24<90),"B"," ") ...
1
vote
1answer
19 views

Summing multiple cells that match row AND column criteria?

I've been given a file with 2 years worth of dates as column headers and sales info below. There's also a column that contains Year data. I'm trying to sort by both Year and Day of the Week. I'm ...
0
votes
3answers
2k views

Run excel macros (vba) from vbscript file

I have a vbs file that pulls information from my database and exports the data to an Excel file (C:\file.csv). Once this is done, I run a series of macros (vba) to format this data. These macros are ...
0
votes
0answers
12 views

automatic insertion of the date of filling an adjacent cell in excel [duplicate]

I have created an excel file for my company and several people have access to this file. because of that I need to know when a cell is filled. I want to dedicate a cell to show the date and time of ...
1
vote
2answers
2k views

How to convert excel individual cell values to percentage change values over time

I have two years of excel data showing daily share prices of a particular stock. I want to change those values to show percentage change (on a daily basis) from the zero date (ie the first day of the ...
1
vote
1answer
29 views

Fill cells with a repetitive pattern in excel

I have cells like 1,1,1,2,2,2. How do I use fill handle to continue to fill with 3,3,3,4,4,4,5,5,5 and so on? I have tried the fill series but it doesn't seem to work.
0
votes
1answer
16 views

How can I create multiple spreadsheets using the value of a column?

I have a workbook (Req_PO_Log_V2.xls) that has all of the expenditures for our repair and maintenance funds from our current FY. The lay out is as follows: | Date | Req Number | Acct | Vendor # | ...
-1
votes
0answers
11 views

To format data in excel cell from html to text

I have exported data from database to excel but couple of columns having data in HTML format, can anyone please help me with vba code or excel functions to format it. Data in my report change ...
2
votes
2answers
33 views

Average of Count of Cells for Day of Week in MS Excel

I'm looking to do an average of rows per week day. And so far, I haven't been able to figure it out. I'm using Excel 2011 for Mac. Here's a sample screenshot: Here's the screenshot of the ...
0
votes
2answers
65 views

IF Statement with VLOOKUP

I'm trying to get a value from the ADD Taxable which is column 10 in the Check (sheet). I only want the value from column 10 if the Earn Type on Timecard (Sheet) has BONUS in it. I'm using the TC Ref ...
0
votes
1answer
24 views

How to find first date after given date in a sorted column

I have two columns of sorted dates in Excel. Given a date in column 1, how do I find the first date in column 2 after the given date?
1
vote
1answer
24 views

How to highlight the first cell in a column that matches criteria with conditional formatting

In one column of a spreadsheet I want to highlight the first cell ONLY above a specific number. For example, if a column has values increasing from 0 in the first row to x in the last row, how do I ...
0
votes
1answer
17 views

Setup powerpivot on a server?

I have a client that uses PowerPivot. They save the Power Pivot inside Excel files and have pivottable reports in the same Excel files. They feel that this puts to much strain on their computers. ...
2
votes
1answer
29 views

How can I filter which columns will be shown on a spreadsheet?

I have filters set up for each column, however I also want to be able to filter which of the columns show. For example, I have 70 different columns, all with different headings. How can I create a ...
0
votes
1answer
27 views

How to create multiple named ranges with a fixed size from one column?

I am wondering if there is a way to create named ranges with a fixed size (252 cells) from one column. I have 51,156 numbers in column B. I want the first 252 numbers (B1:B252) to become named range ...
0
votes
1answer
35 views

Microsoft Excel Query - Formatting Columns

I have got an excel sheet data that looks like this: Order Id Rate Item Quantity XXX 4 Ball 100 XXX 4 Hockey 500 XXX 4 Hockey 500 AAA ...
0
votes
1answer
22 views

Multiple Label Filters in a pivot table

Is it possible to have multiple label filters in a pivot table? I see that I can use 'contains' which could work but I am having issue with the syntax if this is possible. I'm thinking something like ...
0
votes
1answer
26 views

How to open multiple concatenated hyperlinks at the same time?

I used the Concatenate function to join links like this: Column 1: http://twitter.com/ Column 2: username Column 3: http://twitter.com/username I actually wrote the function like this: ...