| Thread | Last Post | Replies |
|
| Keyboard shortcut for Page Setup in excel 2007 | 14 Feb 2008 05:59 GMT | 5 |
In all prveious version of excel i could easily page setup th Alt key. but in excel 2007 i tried and waste lot of time but could not find similiar keyboard shortcut. Please tell me.
|
| Text Box | 14 Feb 2008 03:37 GMT | 4 |
How do I add a drop down list to a Text Box?
 Signature Ed
|
| Convert number to text with proper accounting for Cheque Printing | 14 Feb 2008 03:08 GMT | 1 |
How to convert number to text with proper accounting for Cheque Printing. 10101.01 = Ten Thousand One Hundred One and One Only. 1000.00 = One Thousand Only. 1060.00 = One Thousand Sixty Only.
|
| Automatically put AutoShape in certain spots | 14 Feb 2008 01:48 GMT | 3 |
I am trying to automatically put an autoshape (circle) around certain words when it applys. For example, I am making a worksheet for employees absences. When they put a "1" in a cell, I want it to automatically circle the reason they were absent. If it is a "2" then it will ...
|
| Selecting cells of a specific color only. | 14 Feb 2008 01:39 GMT | 9 |
Is there a way to find and select cells only of a certain color in order to speed the formating of these cells. Any help would be appreciated. Thanks David
|
| conditional Reminder | 14 Feb 2008 00:48 GMT | 2 |
Need Help!!! In A1, I have Permit Expiry date (eg. 1/12/2009), and than In B1, I want to make reminder cell with conditions: If TODAY, permit expiry more than a year ==> Cell will have GREEN shading
|
| Auto Numbering | 14 Feb 2008 00:35 GMT | 9 |
I want my invoices to automatically go up in number. EX. Invoice 1, Invoice 2... I want this to happen every time I open my template to create a new invoice. I can't remember how to do this. Can anyone provide me with an answer?
|
| Setting an Icon Set conditional format for a single cell??? | 14 Feb 2008 00:20 GMT | 4 |
This is my first question here and I'm pretty new to Excel, but I have a question about the Icon Set conditional formatting. From what I understand it's intended for use of a range of cells. However, I have a single cell that I want to display 1 of the 3 light icons
|
| how macro or vba to print | 14 Feb 2008 00:10 GMT | 3 |
i have an excel sheet that gets filled in with different data every week, one week there are 20 rows the next week it maybe 11, is there a way to create a macro or that only prints the range that i need each week
|
| Remove leading zeros | 14 Feb 2008 00:07 GMT | 9 |
We are uploading data from another application to a .txt file and then opening the .txt in Excel 2003. The data is employee numbers, which we are copying and pasting into our learning management system. In the LMS we need the number without the leading zeros. Formating as ...
|
| Workbook | 14 Feb 2008 00:06 GMT | 1 |
I have a workbook that requires daily weekly & monthly totals, however each day has a lot ofinfo so i have made a page for mon_ Friday with a weekly summary sheet, now i am confused as to how to get monthly totals as I should really have had daily 1st - 31st of the month but it ...
|
| I have two IF | 13 Feb 2008 23:52 GMT | 4 |
I have a lot of questions lately it would seem... Ok, so I have two 'ifs'. Basically if __ is true AND __ is true, then cell B80 will be the value in B2. Ok, so here's my example:
|
| Nested IF Function | 13 Feb 2008 23:14 GMT | 4 |
I asked a question yesterday and got a quick answer and then today I realized that I had asked the wrong question. :| Can the IF function look at a number and if the number is less than 249, add 10
|
| Searching for a request form | 13 Feb 2008 22:40 GMT | 1 |
I need a form like a vacation request form but it would be used to request approval of promo items, like who it is going to , why, date, reference #, dept. head's approval and signature salesman's id#, etc. Does anyone have anything close
|
| Forms Control | 13 Feb 2008 22:37 GMT | 1 |
I am trying to change the size of the font in a combi-box form control. I can't seem to find a command, and changing the font on the control page is ineffective... ?any help out there?
|