LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 67
Default How to... apply the same formula to every cell?

I've run a sales report by item showing monthly sales for the last 3 years.

I need to divide each cell by 4.

I am sure there is a much easier way than what I'm currently doing... right
now I'm clicking in each cell, entering the "=" before the result, arrowing
to the end & pasting the "/4".

I think I'll go insane if I have to do this to all the cells...

Is there a way to select a range of cells & have it apply the same formula
to all of the cells at once?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How many conditions can I apply to a cell? I need to apply 8. Markus Excel Discussion (Misc queries) 2 July 10th 08 01:06 PM
How do i apply the same formula for different cells in excel? Tristan New Users to Excel 1 June 8th 07 10:21 AM
HOW DO I APPLY A FORMULA FOR AND ENTIRE ROW? jcpayne Excel Worksheet Functions 2 July 19th 06 06:02 PM
apply formula to other rows ... berti Excel Discussion (Misc queries) 1 December 15th 05 08:30 AM
formatting won't apply to my cell with a formula Adrienne Excel Worksheet Functions 9 November 27th 05 05:44 PM


All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"