column formula copying

  1. K

    Column formating

    I am using excel 2007 I need to format a column that calculates the difference in military time. I have the time calc formula, I need to format the entire column to preform the formula. I currently need to stretch the column's cells down the column and this has proven problematic with...
  2. J

    Sorting Citynames from an Entire Column

    Dear Excel expert, I have a whole column filled with information like the following example: G1:0 G2:0 G3:0 G4:Amsterdam G5:0 G6:0 G7:0 G8:Groningen ... etc. The whole column is filled with zero's and citynames in fixed sequential order. I want to filter the Zero's out in a different column...
  3. K

    Formula for copying a column of cells into another sheet

    Hi there, I'm very new to Excel, and I'm having trouble figuring a few things out. Hopefully this will be very easy for you guys! In Sheet 1, I have a column of cells that I would like to also appear in Sheet 2. If I add a new row to the column in Sheet 1, I would also like it to be updated...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top