General

How do I convert rows to columns
... 31 Mar 2010 17:44

keep source formatting when concatenating
In cell A1, my data are in bold font and underlined. In cell B1, my data are in bold font only. In cell C1, my data do not have any special formatting. When concatenating to D1 (=CONCATENATE(A1&" "&B1&" "&C1), the source formatting is not displaying in D1, i.e., nothing appears bolded or underlined. Is there a ... 31 Mar 2010 17:44

do you have examples of make vs. buy models in Excel?
I would like to obtain anyone's template in excel for doing "make versus buy" decisions ... 31 Mar 2010 15:29

how do you show the status bar if you accidently hide it?
... 2 Apr 2010 14:52

change links to a different source in the same workbook
I have links in sheet C that link to sheet B but now I need them to link to sheet A instead. Is there an easy way to change all the references in sheet C? or do I have to manually change them? I found help on changing the source workbook but I can't find anything about changing links to different worksheets ... 31 Mar 2010 15:29

Printing Large Posters 3' x 4'
How do you print, using a plotter, a worksheet that is 3 feet by 4 feet or larger using Excel 2007? Thanks ... 31 Mar 2010 17:44

Excel On-line
I have been searching for a tool to take a dashboard i have created in Excel and put it on a website for sharing. I have built a complete dashboard in excel, but i hate having to send it out to everyone via attachment. I have tried a few options, but nothing seems to preserve the excellent quality of Excel.... 31 Mar 2010 14:22

Sorting/Filtering Info
Hi, I have a 1500-row mailing list that includes the guests' account numbers in one of the columns. Some guests have multiple addresses (work, home, etc) so for that guest, there are multiple rows but the same account number. Is there a way to sort and/or filter that will identify all of the multiple account... 31 Mar 2010 15:29

how do I get rid of ###### that appear instead of text in excel?
I used to know how to do this, but I've forgotten...grr...how do I get rid of those nasty ######### that appear in the fields instead of what I enter...the correct words appear up in the input header, but the field just shows a series of pound signs...thanks! ... 1 Apr 2010 10:10

VLOOKUP returns 0 (zero) when lookup cell is blank
I have two columns of data that I vlookup to. They both contain text, numbers and some blank cells. Column 1 returns blanks correctly but column 2 returns 0. Is it a formatting issue? Any help is appreciated. ... 31 Mar 2010 21:04