Hi, I am trying to customise my format toolbar by adding sheet right to left /left to right button. When ever I drag these buttons from customize to toolbar...

pleeeeeez I double dog dare ya

I've been banging my head on my desk for two days over this problem! I want to customize the accounting format to show 0 as: $ 0.00 (with a $ to...

I have a column with dates that I'd like to use a count formula where it counts the total number of rows that are past a certain date. How can I write the...

i customized a cell with a now() date field so that it's date is always updated. i also designed the cell and add a "th" word so that today would be shown like...

Is there a way to use Data Validation to create an in-cell drop-down box from a range of cells...but before displaying that list in the drop-down box, can...

Can someone tell me if it's possible to customize FX button to skip the step of making one choose "Sum" each time. When needing to add many items of each...

Does anyone know how to customize a vlookup formula so that when it doesn't see the particular data in the table instead of it displaying #N/A but 0? Below is...

I have set up a customized date format in Excel that works with a txt file. However, if the date is only the year, i.e. 1955, without a day or month, it is...

How do I build a customized format for the Canadian postal code? Example: T2R 1N1 (Contains both text and numbers)

Dear expert, Wanna customize a macro in Tools-bar. Have right-click the tools-bar, then add the smily face button, have assigned the macro, finally rename and...

Hi! In 2005 I designed a workbook w/3 worksheets. Each sheet shares various information with the other. This year I needed the same thing, so I copied/pasted...

i have created worksheet with a customize toolbar with assigned macros to the buttons. This file will be a master file. Users will open, save as using a...

How do you reduce the size of a worksheet so that only 50 rows and/or a select number of columns can be scrolled.

I have a customer overseas that I write publications for. My customer has provided me with a list of words that they do not want to see in the publications...

Hi, I am trying to customise my format toolbar by adding sheet right to left /left to right button. When ever I drag these buttons from customize to toolbar...

Folks, The following is a sample of how the data is downloaded from SAP into Excel: Column A 50000 Free Goods Tax 57001 Free Goods Tax from SD 50023...

Does anyone know if Excel is capable of doing a V-Mask for a CUSUM?

Hello, Please let me know if any method is there in excell 2000 for cutting a cell from one worksheet and pasting it simultaneously onto other worksheets of...

Hi! Need help on this... I have a workbook with 2 sheets, one named "Effective" and other "Expired". As the name itself, "Effective" has all contracts we have...