Is there a way to make Excel display a comment when a cell is selected (as opposed to moving the cursor over the cell)? And, is it possible to make the comment...

Right now I am using =Now() to display the current time. However, this isn't perfect bc it only gives the time when there was last activity on the workbook. ...

Looking for an idea of how to copy parts of a spreadsheet, ignoring hidden cells. I just want to paste exactly what I see! Thanks in advance! --- Message...

Hi, I am new to the board and using XL2002. There are instances when I enter more than 1 entry in a cell. For instance, cell A2 can have the 12 months of...

cannot open completed worksheet from folder that is in My documents. Cannot do anything with it.

Is there a feature of Excel or a macro that I could write to disable 'save' (both the icon and the drop down option)?

I was keying in some information in excel and all of them begins with http://www.... It kind of irritates me when I am always clicking onto the information and...

Hi. Is there a way to enter a TRULY null value in a cell? I intend for the formula below to leave the cell blank if the criteria is met. My problem is that...

I've just come across something which is concerning me a little. I have a large table of data, comparable to a list of customer orders. The first column...

Hi. I have a pivot table that combines data from many workbooks. One column contains varying lengths of text, so automatically resizes to much wider than...

Hi, I am wanting to get a formula where if I type 1 - 99 I should get A =100 or 199 I should get B =200 or 299 I should get C =300 or 399 I should get...

In Office XP I used the Access Links add in for Excel to export spreadsheet information into a database. I could not do this by importing into Access...

Hi, I am trying to run a letter to our membership by group, but listing all members from that group on the letter. I've written the letter in Word and done...

Hello, I have a rows of data in which I want to get, for each row, the position (not the value) of the first and last non-blank cell in the row. Basically...

Excel XP had an add-in "AccessLinks", which allowed the export of worksheet information to an Access table. This does not appear to be available in 2003. Is...

I have multiple databases in Excel with similar data that I need to pull into one large database. The only way I know to combine the information is cut...

Does someone know of VBA code that will bring up a "find" type of dialogue box that when the user types in the data, the data is searched for and if found, the...

I have 30 sheets in a workbook, and I want cell V43 in each worksheet to have the named range Page_Num. If I had one sheet with this range name, then copied...

I am trying to see if I can create a frequency function that will change as I autofilter different criteria. I have a file with over 15,000 rows returning...

I have created an questionnaire in Excel, where the respondents fill in the amounts to questions and select different options. This questionniare is going to...