General

Print and shrink automatically so that worksheet fits on paper?
I have occasionally worksheets which are larger than a paper page. In order to be able to print all content on ONE paper page I have to scale the size down to e.g.68% Finding the exact scale value needs some user unfriendly fiddling try and error. Is there a way to tell Excel 2003: "Hey Excel, scale down the... 15 Apr 2010 12:32

VLOOKUP function part 2...
Apologies for the repeat thread, just there is so much traffic here that the last part of my query went without an answer. Sheet "Employee Data" holds usernames of about 1500 employees in the format "joe.bloggs" in column A and employee payroll numbers in the format 00001, 00002, etc in column B I am looking ... 15 Apr 2010 12:32

Unpivoting a worksheet
Hello, I have tried to search for tips on how to unpivot a worksheet, and it seems that everyone is refering to the article http://j-walk.com/ss/excel/usertips/tip068.htm .. This article, however, does not apply to Excel 2007 which I use. Could anyone please tell me how to do this in Excel 2007? Thx, in a... 15 Apr 2010 18:07

Change Default Auto-Fill-In month
If I format a cell as a date mm/dd/yy; If I only type in the month and date, "4/15" ,excel will automatically fill in the the current year, so the cell will end up displaying 4/15/10. But if I only type in the date, "15", then excel will fill in the January 2000 as the default month and year, so the cell will ... 19 Apr 2010 12:37

Filter with criteria!
Hello! I have 2 woorksheet. One contains raw data one is a summary sheet. In the raw data shhet, under the "catergory" column, I need to count and filter out all the Apples" in this column. The challege is , the number of apples counted should be from Jan, Feb and Mar respectively. Results counted must be ... 15 Apr 2010 04:50

Macros to Button
Can someone please tell me how to assign Macros to a Button? ... 15 Apr 2010 08:05

Excel 2007, can't edit 2003 document
When I open the excel 2003 document in 2007 we cannot edit nor view any formulas in the formula bar, plus the ribbon is greyed out. The workbook is not protected with read only. What is going on? ... 15 Apr 2010 14:46

hide columns before printing
Hi, Before actually printing my sheet I want to hide column A and B. Can I do this automatically without having to hide them manually? Thanks -- Mvg. Jean-Paul De Winter ... 21 Apr 2010 07:24

vlookup based on IP range
Hi Every One, I hope you all are doing well, I required your help to resolve my issue in excel. On single worksheet i have two different sheet name as 1.IP Range 2. Result. Question: EG:IP Range Start IP End IP Area 192.168.1.4 195.182.254.254 AG 10.15.33.10 10.18.56.254 EMEA 10.128.33.5 10.132.40.... 16 Apr 2010 06:11

Predefined text list
I need to set up predefined text lists and then link them to certain cells and limit the entry in that cell to the predefined list - how do I do this??? ... 15 Apr 2010 01:34