| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
This is so quickly done by the fill handle:
http://www.officearticles.com/excel/...soft_excel.htm Or do you need a macro? ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Johnny" wrote in message ... I need to set up a formula for an entire column, not by inserting a formula on each cell of that column (I've heard that it is possible, but I couldn't find a clue on how it's done). For example, I have 2 columns: column A and column B. I want to set up a formula for the entire column B, that will divide any number that is entered in one of the column A cells by 10000. Hope I've made myself clear enough and that someone could help me on this. Thank you in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match and count words | Excel Worksheet Functions | |||
| how do I change case in an entire column of text in Excel | Excel Worksheet Functions | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
| How to add the same value to an entire column? | Excel Discussion (Misc queries) | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Threaded Mode
