General

How do I reference a cell to automatically update in a header
How do I reference a cell in a worksheet to automatically report in a header or a footer. ... 26 Feb 2010 04:10

Anyway of accessing the internet from within excel 2007?
Anyway of accessing the internet from within excel 2007? THANKS Robin ... 26 Feb 2010 09:40

Compatibility Checker
When I save a Excel 2007 worksheet with settings for an Excel 2003 file, the compatibility checker comes up and says the following: "Some cells or styles in this worksheet contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available." ... 25 Feb 2010 19:25

Looping Macros that change
I have 14 worksheets. Each worksheet has a different email address in A2 The macro assoicated with that worksheet references a particular file that will be emailed, ie.On worksheet 1 C:\Myfiles\FA2E.snp, but on worksheet2 the file will be C:\Myfiles\FA3E.snp. etc. I need to loop through each worksheet and have... 25 Feb 2010 18:16

Can you name a group of cells?
This may be a stupid question, but I have lots of data to display in the first row of cells, and I'd like to be able to condense it a little bit so it's easier to read. Grouping is the best option I've come up with so far, but I need to be able to name the groups because there will be several. Thanks! ... 25 Feb 2010 17:08

Dual Y Axis in Line Plots
How does this work in Excel 2007? "Bill Martin" wrote: amitsaurav wrote: How can i plot line graphs having dual Y axis at two ends? The two Y axis have to be of different scales in the same plot. If you've set up to plot two lines, using the XY plot format, then: 1) Right click on one o... 25 Feb 2010 11:26

add or subtract every 5th column
i have a spread sheet and want a running total based on values in every 5th & 7th cell for the entire row. now my formula is =A3+M3+S3+Y3+AE3+AK3-L3-R3-X3-AD3-AJ3 I want to continue to (or redo the formula) add every 5th cell and subtract every 7th cell without having to select each one ... 25 Feb 2010 11:26

i downloaded a plug in and it does not show up in the ribbon
i downloaded a plug-in from this site http://download.cnet.com/GetRates-Historical-Fx-Data-Excel-Add-In/3000-18483_4-10914605.html there is supposed to be a tab that says getratesforex next to view after you download it and that does not happen. here's what my ribbon looks like after i've downloaded it http:/... 26 Feb 2010 11:57

Fill a 15 Characters Data with Zeros
I am getting nuts with this.... I have an amount in A1: 108.203 And I need to fill A2 that must be 15 characters with the value of A1 and the remain characters before the first number (1) must be fill with Zeros. E.I.: The result must be: A2= 00000000108.203 Is there a way to do it? Thanks in advance f... 24 Feb 2010 23:19

undo concatenated cells
I have a list like this in column A: cell A1. CHHKSHANAN000021,CHHKSHASAV001873,CHHKSHAOCF000026 cell A2. APLU020852965,APLU020852976,APLU020852966,APLU020852977 ....but much longer. I want the data in separate cell (i.e., a1, a2, a3): CHHKSHANAN000021 CHHKSHASAV001873 CHHKSHAOCF000026 I had tried the... 24 Feb 2010 21:07