Search results

Thank you, Hui. This is very helpful. From your list, a potential cause may be: "Had anybody opened the file in a newer version and then saved it in an older version, Excel may have reset the used ranges in that case" Its interesting if Excel can potentially halve the size even if the file is...

Thanks Hui. That's very helpful. However, the first halving happened when both files were saved as 97-2003 version. Isn't that odd? Thanks

Hi listers I have had this problem twice that Excel files reduced to almost half the size. First time from 14MB to almost 8MB (both files in Excel 97-2003). The second time from 8MB to 2.6 MB (this time file saved as Microsoft Excel Macro-Enabled Worksheet instead of Excel 97-2003). The...

thank you. I'll give this one a go.

Hi listers, This is probably a simple question for many of you. I am working with someone else's workbook and have renamed cells and some names are redundant. So I want to find (and maybe list) all cells that are not used in any formula in the workbook and then delete them. Is there an easy and...

Thank you both. This is very helpful and will save me a lot of time. Many thanks!

Hi Excel gurus, I have a quick question and would appreciate advice. I have a lot of named cells which I use in different formulae. Every time I want to go to the actual location of the named cell I go the Name Manager and find the named cell and then close it and then go to the location. This...

Thanks. Yes, they are using Excel 2007. Now I want to make my file universally accessible. How do I overcome this problem? Thanks

Hi listers, I am working with Excel 2010. I have used conditional formatting rules using simple formulae and a specific RGB color format (to define red, green and amber colours). However, when I sent the file to my colleague, it was all in one colour. Can anyone suggest a solution to this...

Excellent. This works perfectly! Thank you again!

Excel 2010. Thanks.

Sorry just a follow-up. I can easily add vertical error bars from the chart layout menu but cannot find horizontal error bars. Any suggestions? Thanks.

Excellent! Exactly what I wanted. I was making the mistake of using a negative number which didn't work. You are a Ninja!!

Thanks, Hui. Sorry for the late reply. This is very helpful. Attached is what I was looking for. Now I need advice on drawing confidence interval for the point estimate (see attached). I would really appreciate your help.

Hi colleagues, I am struggling with perhaps a simple dashboard question. I am trying to replicate bar charts in KPI dashboard - revisited II (available on chandoo.org). My minimum value and first quartile are below zero while median, third quartile and max are positive. I also have a target KPI...

I simply used 'normal' paste function which pasted it as an embedded table. I would like to paste it directly in Excel columns, keeping the column width the same. So would really appreciate your help. Thank you!

Hi listers, I know I can paste from powerpoint and keep the formatting but the column width is all over the place and I need to change it manually for each column. Is there a quick way to import table as it appears in powerpoint (not as an object or picture)? Thank you

Thanks. I am happy to use VBA then.

P.S. It would be ideal not to have macros in the file but perhaps there is no way around it? Thank you.

Thank you, Faseeh. Much appreciated. This works for the size but not for fatness. Could we do something like whats on this webpage? http://ccgtools.england.nhs.uk/ccgoutcomes/html/atlas.html Thank you Shehzad

Dear listers, I would appreciate help with this. I have added an upward/downward arrow in a cell using an Excel symbol. I would like the height and fatness of the arrow to change with the value of a cell. So if say the value of cell A1 changes from 10 to 50, then I would like the arrow to...

Excellent Deepak!! Totally spot on. Thank you so much for your help. Much appreciated! ExcelStuff

Thanks, Deepak. This is excellent and works perfect on your workbook! Can I ask a silly question: how do I import this to my workbook? I am more familiar with writing or copy/pasting sub routines directly into my file but this one doesn't seem to work in this way. Also would I need to run this...

Hi listers, I want to include a box (or a cell) in my front sheet so the user can specify the zoom level for the entire workbook. I have come across the following macro which lets you zoom to a specified percentage but not exactly what I am looking for. Sub SetZoom()Dim ws As Worksheet...

Thanks, Somendra and Luke. Elegant solutions and spot on. Very very helpful indeed! Now, I suppose a couple of minor thing: 1. How do I insert a line break in the message? I would like to add a next line in the same message box saying "Are you sure?" 2. How do you "beautify" the message, like...