Search results for query: *

Maybe I am imagining things, but I recall older versions of Excel doing something that the 2007 version is not. When using VLOOKUP function, where the table array is a named range, and the column index number is a number, I am having problems with Excel not properly updating the column index...

Is there any way to change the viewing order in the style pane in Word 2007? I would like to have my document open on one computer screen, and drag my available styles to a window on my second screen, and make it really big so that I can see all of my styles at once. The problem when doing...

That was exactly right Markus4! Thank you thank you thank you. My so-called "help desk" screwed around for a month before giving up and telling me to just live with it. Oh, and in case I forgot to say it, thank you.

I've got a file that was originally created from a company template probably about 7 years ago. Since then, it has been updated and modified many times. It contains some features like cross references and bookmarks. When I print this file, I get prompted for all kinds of information like...

Didn't quite understand where you were going with your reply, but I think Dhulbert intended some fixed references like: =IF(A4=A5,"",SUMIF($A$4:$C$8,A4,$C$4:$C$8)) That will output the fourth column the way that you have shown it above.

No, when I accept the changes, and my view is "Final Showing Markup", the rev lines still show in the column. That's fine with me, I don't want to retain all the comments and notes, just the line indicator in the column showing what changed from last revision. What I wanted to do was to save...

So I had a document in Word 2002. Tracked all the changes. Accepted all the changes. Issued the document. Now I want to start tracking changes made from this day forward, and want to forget about all previous changes. Is there a simple way to do this? I know that I could just copy...

Hi folks. Hope this is an easy one. I've been using Adobe Acrobat Professional 6.0 for all of two days, and I am trying to figure out how to save a document so that anyone who tries to print the document is forced to print the document and comments. Any suggestions?

Hi folks, I often am given large quantities of data from a database, which has been put into an excel file. I am then asked to perform calculations based upon the data that has been dumped on me. The problem is that often the "numbers" come accross in Excel's text format. I would...

Ah ha! Use the backslash in the custom format. eg. #.###\" Now it works with any font. Thanks for the suggestions.

Hmm... Look pretty good when I am using Arial as a font, but when I use a font like Letter Gothic, it doesn't look so nice anymore. If need be, I'll use a font that looks nice, but I know there is a better way to do this...

I know I've done it before but I can't remember how!!! I want to type in a number in a cell and have it displayed with a trailing double quotation mark. For example, enter the number 3 and have it appear as: 3" I'm fairly certain I need to use the char() function somewhere. Any help??

I have two files in Excel 97. One is a data file, the second is an "executive summary" of the first. The summary file contains a large number of DSUM formulas. For each of these formulas, the data range is located in the data file, the column reference is simply a number, and the...