General

leftmost number value
Hi! how can i make this formula to return the leftmost number only? this is an array formula =INDEX(A6:AA6,,MIN(IF(A6:AA6<>"",COLUMN(A6:AA6)))) Thanks! ... 26 Apr 2010 22:52

Unable to use the back/forward buttons in the OPEN menu
I recently upgraded to Excel 2007 and Windows 7. Previously I was able to ask the program to 'open' and then go back/forward through the folders to get to the next location as needed. Now I have to start over every time. The back and forward buttons are alway gray and the address bar is blank if I try to pull i... 26 Apr 2010 21:45

Stepping in to a cell
Right, this might sound like a really basic question but I can't find the answer anywhere. How do I step in to a cell with data in it without either double-clicking or clicking on it and then clicking in to the text bar at the top of the page. I often use excel without the mouse when I am doing stuff and I cann... 26 Apr 2010 22:52

Mirroring excel file content
Hello, I have an excel file with a large amount of data that i need to make accessible to a large number of users in the office. There are also a couple of people who need to be able to edit this file to make changes. The porblem that we have at the moment is that those who only need read only access are c... 27 Apr 2010 08:47

locking cells
excel version 2003 i have 4 cells that once one is select i dont want the user to be able to type in the others is there anyway to control this ... 27 Apr 2010 08:47

Data QUERY Data Extract
We are switching from QP to Excel. I will need to do a query and extract the data to another sheet in the notebook what I have now looks like Data Query Roll A3...h200 Criteria (changes often/contains header) Deposit C1...C10 Extract to Sheet A3..G10 is there somethiung similar? I keep getting hit on ext... 26 Apr 2010 20:38

not able to assign macro
I've created a drop down list with Data Valuation and would like to allow multiple selections. I used the macro on contextures.com to create the macro, however, when I return to the sheet right click, assign macro isn't an option and running it doesn't work either. I'm on Excel 2007 and the much loved Vista H... 27 Apr 2010 11:03

spreadsheet part and part without grid lines
I want part of my excel spreadsheet to have gridlines and the other part without ... 26 Apr 2010 19:31

How to give find function ( same as of ctrl F) in formula bar
Hi all, Is it possibel the to give find functionality ( ctrl F) in formula bar. For example I have to find cell A1 value in b:b in entire column , The A1 value may contain in the column B more than one times. So I have to give find fucntion for the range of b:b Please help Pol ... 27 Apr 2010 11:03

Zero Values
I have a simple formula that inserts a value in a cell from one spreadsheet into the cell of another spreadsheet. If the source cell doesn't have a value, the destination cell has a zero in the cell. I would like to display a blank if the source cell doesn't contain a value - any ideas? Paul C. Peterson ... 26 Apr 2010 18:22