Apply formula to entire column

  • Thread starter Thread starter MICHAEL
  • Start date Start date
M

MICHAEL

I need to apply a #/100 formula to an entire column. How
do I do this within the format cell capability.
 
Hi
try the following
- enter 100 in an empty cell and copy this cell
- select your data range
- goto 'Edit - Paste Special' and choose 'Divide'
 
If I understand you correctly, you wish to divide every cell in you
column by 100.

In an empty cell, enter 100. Highlight that cell and select "copy".
Now, highlight the column in question and select "paste special".
Check the "divide" box and your cells will be divided by 100.

Hope this solves your proble
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
need formula to apply to entire column not just one line 2
Remove punctuation mark, Split cells & average accross column 4
Copying conditional formatting to an entire column in Excel 2007 3
Conditional Format 1
Excel Named Ranges and Conditional Format 3
Conditional Formatting Pivot Table Excel 2007 1
CF Row after CF applied to Column 4

Back
Top