I use the auto filter all the time. I'm looking to highlight, follow ups, pendings, etc. then be able to use the drop down menu for "all red," "all blue,"...

I am trying to undue the "merge and centre" of my title. I would like to make the range smaller. Is this possible? Thank you.

using excel for the first time,want to know the basic about excel from the start,if a document is provided that would be more usefull Regards pooja

Just to round up (for now) the question on how to manipulate dates, here are some formulae (which assume the root date is in A1) for advancing dates. ...

hello community yesterday, 29th, a helpful person assisted me in solving - printing a column and a selected area - that was fine and successful. now, what...

The way i've been doing it is to rename the ranges so the formula can calculate. Is their an easier way? I've been playing with match and index arguments and...

I am making a spreadsheet to record compeditive times in an autocross. Colums a,b,and c, contain respectively driver number, driver name and car number. More...

Dear All, I am trying to access/connect oracle database to insert and select data from tables. I don't know what to use like ADO? ADOX? ADODB? or others? I...

I have tried to insert a logo into a spread sheet buut not a real pleasing result. First I scanned the image and then did an import into a spreadsheet but...

hello! i am sandy and i have not used excel for years and have forgotten most of what i learned. what i need to learn is how to set up a page or ? on how to...

I have 5 workbooks each with 6 worksheets. Each worksheet has 33 rows and 5 columns with data (numbers). How do I add the 6 worksheets into one...

I was editing a document and I closed the the application accidentally without saving it. is there any way to recover it ? Thank you.

What is the Excel formula to calculate what my rent would be in future years when a percentage rate increase is added each year ?

I'm pretty new to Excel ... I want to emulate my formatting in Word of a title with several bulleted subpoints indented and under it. Every time I hit "Enter"...

I've input data with the intention of printing labels, but first how do i set the data to automatically alphabetize.

Is it possible to exclude the column header from an entire column range, so that it is not included a COUNTA range?

Hi, I need to remove duplicate events from say: A1 to A500. These are numbers only. Any help will be greatly appreciated!

Dear Sir, I m using this function =IF(AND($A$1="gopal minerals",'Gopal Sales'!E60),'Gopal Sales'!E6,AND($A$1="Micro Products",'Micro Sales'!E60,'Micro...

Hi there, My name is Jerome. I would appreciate your help with the following problem. I have an excel sheet whcih contains data displayed in various levels....

Hi there, I was wondering if its possible to have 2 formulas in one cell. Such as vlookup one value and then vlookup another value and display both results...