pls help. i have a excel sheet with code 1 code 2 code 3 description amount 1 amount 2 amount 3 15000 25000 35000 guest 1000 150 1150 i need...

ExamsOnline.com offers critical online exams and practice exams for certification prep services for MCSE, A+, Network+, CISCO CCNA, Oracle DBA, CNE,...

HELP!!! sheet rows numbers are not consecutive; tried to unhide but didn't work;

I have a sheet with 3 columns: A, B, C A is a dropdown with following values compile, edit, audit B is a dropdown and has the same values as A compile, edit,...

Hello, I have 6 workbooks all with a single worksheet. I want to bring them together into a single workbook with 6 worksheets. I can do it via copy & paste,...

we sell products that sometimes get "split" between 2 salespeople. I have set up a basic spreadsheet that tracks sales and profit but can't figure out how to...

Hi, i have seen the sharepoint function offered by MS Excel. Would like to check with you whether this could be performed and exported into a blog?

-- To be myself is the most important thing!!!

I have an excel sheet that I update and want others to view it only(view permissions only). My Question is: Can myself and other person edit the sheet at...

hi, when im making to much rows data like more than 30 thousand, i want to put the serial number by puting formula and it put serial number with out scroll...

When I select cells in Excel the shading is so light (blue) that I can barely tell which cells are selected from those that are not. Can I change the...

Hi, I need to change the color of a range of cells depending up on the value in another cell. Consider cells 1 2 3 4 5 , I need to change the color of all...

Can we create forms in excel that would populate the corrensponding fields in excel sheet? Also if we could create forms, can we make certain fields to be...

How do I convert columns that are numbered into letters ?

Hello, I create user form for database that contain dates in one column. But when I fill user form it copy the date in the database column like text and the...

We set up a spreadsheet that had macros in it. I deleted the macros, but our users are still getting a message asking if they want to enable the macros. I...

Can I create a 'header' of eight column headings?

I need a 31 day workbook with the 32 worksheet as a monthly. I need to add totals for all 31 on the 32 sheet for the monthly totals. I hope this makes...

I have in Several Columns a list of Customer Names and for each column I would like to do a Count of how many in each column but when I do...

Can any one recommend a good reference book for Excel formulas, functions and their use. or a list of available functions and how they are meant to be...