Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 7
Default How do I add 1.5 to each cell in a particular column?


  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How do I add 1.5 to each cell in a particular column?

On Feb 21, 8:20 am, BrendaC wrote:
How do I add 1.5 to each cell in a particular column?


Enter 1.5 in an empty cell. Copy the cell.
Then select the col range, right-click paste special add ok
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 7
Default How do I add 1.5 to each cell in a particular column?

Thank you so much for your help - it worked!

"Max" wrote:

On Feb 21, 8:20 am, BrendaC wrote:
How do I add 1.5 to each cell in a particular column?


Enter 1.5 in an empty cell. Copy the cell.
Then select the col range, right-click paste special add ok
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


  #4   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How do I add 1.5 to each cell in a particular column?

On Feb 21, 1:32 pm, BrendaC wrote:
Thank you so much for your help - it worked!


Welcome, Brenda. Nice of you to post back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply
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
Need the formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date kakasay Excel Discussion (Misc queries) 1 January 22nd 07 12:31 PM
Need Formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date kakasay Excel Discussion (Misc queries) 1 January 22nd 07 12:31 PM
Hide column or row based on a cell in the column or row? SacGuy Excel Discussion (Misc queries) 0 January 24th 06 06:51 PM
Fill handle - new column using a column and one cell MS Excel Discussion (Misc queries) 4 November 2nd 05 11:20 PM
Format cell in column B based on value in the next cell (column c) Nicole Excel Discussion (Misc queries) 7 May 18th 05 10:19 PM


All times are GMT +1. The time now is 02:01 PM.

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

About Us

"It's about Microsoft Excel"