**40**

votes

**7**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**4**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**5**answers

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

**2**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**3**answers

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

**5**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**8**answers

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

**4**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**3**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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