General

Lost Format
Did you get this resolved? I'm having same issue. "Maureno" wrote: Excel version 2007 I now have 2 files that are losing their formats. It happened spontaneously to all the cell formating that I did today. I did not save it that way but when I closed out and restarted my computer, the file did... 8 Jul 2008 12:05

Formula to find cell
I need a formula to read a value in a single cell and use that value to determine how many cells left to go to retreive a value. For example, cell B3 contains the value 5. the formula in cell L4 would go down 2 rows (static value) and left 5 cells(using the value from cell B3) and retrieve the value in cell E6.... 8 Jul 2008 08:59

Excel 2007
In Excel 2003 you can press f4 which will repeat the last thing you've done, in 2007 this doesnt work. Does anyone know the keyboard short cut in 2007? ... 8 Jul 2008 17:13

Macro to set cell interior color?
I'd like to create a macro that will fill the current cell (or cells) with whatever the current fill color is. I tried to record a macro to do this, but it always fills the cell with the color that was current when the macro was recorded. Perhaps I could modify that macro in the VBA editor ... but I don't kn... 8 Jul 2008 19:16

MS Exel 2007
MS has moved me from power user back to novice... How do you get rid of the numeric column headers on a worksheet. I have somehow gone from the Alpha headers to numeric. The cell references looks like a lotus cell reference. ... 7 Jul 2008 17:39

Print range
I want to create a worksheet so that when I click Print, Excel will automatically print the area defined a top left cell that contains a particular value in a specified column and the lower right cell is a manually defined offset from the top left. In particular, the top left value is to be =TODAY() looked up ... 8 Jul 2008 08:59

Data-Validation -List - Pick from a drop down menu
Hi, To select years from the list in sheet1 and to look for year values from sheet2 i have used pick from the list option. Data-Validation -List - Pick from a drop down menu but this shows list years for all row entries. for eg if i have entries in sheet2 for years for the rows.. 2000,2001,2000,2007,2000,2000,2... 8 Jul 2008 16:11

Suddenly border of cell not highlighted when I click on it
Usually when I click on a cell, the border is highlighted in bold. Suddenly it's not highlighting, although everything else seems to work normally... ... 7 Jul 2008 17:39

Conditional Formatting "Between"
Is the "Between" option in Conditionl Formatting inclusive? In other words "between 5 and 35" will include numbers 5 and 35? ... 8 Jul 2008 04:54

#NAME showing in Excel 2007 but Excel 2003
I have a column linked to some website. The number can be shown in Excel 2003, but when I open this file in Excel 2007, there are only #NAME shown in the column. ... 7 Jul 2008 17:39