| Thread | Last Post | Replies |
|
| Displaying column and row names | 22 Aug 2008 18:34 GMT | 3 |
I have a spreadsheet where someone has hidden just the column name (A, B, C - AZ and so on) as well as the numbered row names. How do I get them to display on the screen? I do not want to hide/unhide entire columns or rows, I know how to. I want to see the alpha and numeric ...
|
| I want to use speling check but is in gray. How do I change it | 22 Aug 2008 18:26 GMT | 1 |
 Signature Mexican American Single Woman.
|
| lookup values on two worksheets | 22 Aug 2008 18:22 GMT | 1 |
I looked at the forums before I posted this question, didn't exactly see my question: I have two spreadsheets (e.g. A and B). Both contain instances of the same data. My data is mainly for Part Numbers and vendors.
|
| Storing multiple ranges using a macro | 22 Aug 2008 18:11 GMT | 1 |
I have to play with lot of ranges in a worksheet. Say range1 is from A1:A10, range2 is from B1:B10 and so on. I have 1000s of such ranges. One of doing it is defining individial ranges say
|
| microsoft excel | 22 Aug 2008 17:49 GMT | 5 |
Say i have an excel file, and i edit it and save it. Now in the properties of this file it now shows the last date modified. Is there any way to revert to that file. Can i undo the most recent save?????? Any way possible. Can i view what has been modified. PLEASE REPLY ASAP ...
|
| SUMIF or IF to display number of days or N/A | 22 Aug 2008 17:37 GMT | 4 |
I am trying to display the number of days between 2 dates if the cell in the range is greater then 0 or if the range cell is 0, I want to display N/A. BD3 = 40 BB3 = 4-18-07
|
| How to increment a cell by 1 on mouse click or move to another cel | 22 Aug 2008 16:57 GMT | 1 |
I am simply trying to stop youg grandson cheating on a simple maths programme by putting in trial & error answers and if wrong going back to have another go. I need something to count down from 10 (say) or up from 1 Cheers in hope.
|
| Automatically Extend Formula in Count function with Additional Row | 22 Aug 2008 16:43 GMT | 3 |
I am creating a form in excel about complaint resolution. It is a protected sheet and only some cells are unlocked to edit. Users will also be able to add/delete rows. One column asks the user whether or not the complaint was resolved. A drop down list allows them to choose yes ...
|
| Excel shortcut keys | 22 Aug 2008 16:32 GMT | 1 |
In earlier versions of Excel the Help menu provided a tabular view of all shortcuts ready for printing but I cannot find anything similar in Excel 2003.
|
| Question about HEaders & Footers | 22 Aug 2008 16:29 GMT | 1 |
I am trying to import a graphic into my workbook as a header and footer. I go into the custom header wizard and click on the picture icon to bring it in, it comes in, only it shows up in the middle of the page behind the data. When I try to bring in the footer, it populates in ...
|
| send e-mails | 22 Aug 2008 16:28 GMT | 1 |
I wish to send an e-mail to each member of a society advising of a forthcoming event, based on the send date in the event record being equal to today's date. I then wish to change the send date to stop any further e-mails for the event.
|
| How to get number of all rows in every datasheet together? | 22 Aug 2008 16:24 GMT | 1 |
I have to count all rows in every datasheet and than get the sum of all rows of the Excel file, that contain data. It is a large Excel file with about 80 datasheets so do it manuall is not possible.
|
| Suppressing zero value for calculated items | 22 Aug 2008 16:21 GMT | 3 |
Hi, has anyone figured out how to suppress zero results for calculated items in a pivot? I have tried to use an "IF zero then NULL" formula but this does not work - I assume item calculations do not allow the use of standard Excel function?
|
| Move logo from word document to excel header | 22 Aug 2008 16:08 GMT | 3 |
I'm creating a excel template for my boss to use on future projects. I have a logo saved in a word document. I would like to use it in the excel header. I've tried several things but can't figure out any way to make this work. I hope someone can help!!
|
| How to get the value from string? | 22 Aug 2008 16:00 GMT | 2 |
There is text Apple Computers & Components (17704) in Cell A1, and I would like to separate Text Apple Computers & Components in Cell B1, and to separate number 17704 in Cell C1. The size of text and number can be any length, does anyone have any suggestions?
|