What I need to do I'm sure is simple but I can't get the formula/format correct. What I want to do is be able to autofill weekday only, one week blocks at a...

Simple I know but have stumped everyone. How do I format a worksheet to view only the selected print area in the working area. In other words I do not want to...

I've searched and searched but can not find a template for a daily work order or even a daily activity sheet. A work order database would be great as...

kindly let me know about a tool that converts figures into words in excel

Despite my limitation with writing codes, I need to find a simple to follow code to hide rows without information in a specific column in three tables that I...

Hi, In A1 i've got 31-dec-2005 as a date I need to get the month as text into A6 ie dec Any ideas? -- Cheers

Hello We try to use pivot table using external data from access to bypass 65K lines limitation . . . the pivot table blocks at 195.233 lines Is there an...

Hey Guys, here is my situation. I have two workbooks (excel files) WorkbookA.xls and WorkbookB.xls. I would like to combine them both into...

I created a file which uses advance filtering on a database worksheet. On clicking a button, the advance filtering work its magic. But when I copy another set...

I recently deployed Microsoft Office 2003 and configured using the customization wizard, amongst other "cosmetic" changes I set Macro security in the apps to...

I have created a chart with 2 columns of Nos. and a third column with the results from the subtraction of column 1 from 2. At the bottom of each colum I also...

This might be a bit complicated, at least for me it is I need to calculate a total weighed average of a few weighed averages of grades so i have few columns...

Hi, ı want to fill series based on cell data, a sample is below a1 b1 james 10 jane 8 ... .. result should be james 1 james 2

Go to Excel Help menu and enter limits, Excel will cut off text displayed in a cell. I believe the count is 1024 characters. Does not matter they...

When I do an autosum some of the numbers are equally negative numbers. But I want them to just SHOW zero instead. Is this possible?

is it possible to automatically convert total amount figures for example into words in Excel worksheets? (i.e. 1,205 will appear in anohter cell as "one...

I have a workbook with 10 worksheets in it. I have the dragged those worksheets and arranged them in the workbook in a certain order (the tabs from left to...

I can't find the keyboard shortcut to zoom in or out on a worksheet. Please help!

Comparing columns D and F, If the data doesn't match, I need a blank inserted where the columns don't match. How can I achieve this?

I have a workbook with 4 columns containing lists of names from 4 different workbooks pasted as links to a name list in each of those workbooks, one list per...