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

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 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...

Hi, I have column of monthly investment returns. If the return for a particular month is less than zero I want to regard the return for that month as zero but...

I'm not sure if this is an Excel or Word problem. I have an exported file from a database which has multiple lines that need to be merged into a form...

SOME OF MY CELLS ARE NOT SHOWING UP ,IN MY SOURCE DATA ON BARTENDER IF I PUT NUMBERS IN THE CELL IT WORKS FINE, BUT LETERS DO NOT SHOW UP.IVE TRIED CHANGING...

i have the following text string "Home: installation on Cognos (5.5 hrs)" the number represents the number of hours i want to have separated from the text"...

I have data that I have summarized where I need to count the occurance of particular words (i.e. No Answer, Unconfirmed, Wrong Number). Is there a way in a...

Like the subject says, try it out. Its REALLY annoying. Does anyone know how to change it?

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...

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...

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 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...

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

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

How do you delete all the 'names' defined @ workbook? I can only do it 1 at time now using 'Insert'-'Name'-'Define'......however, I have hundreds of them...