LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,501
Default Sr. Citizens Question, Please

And here's a senior citizen answering.

Select B1 and enter the formula
=A1/10
hit enter

select b1 again and note the little black box (Fill handle) on the bottom
right hand corner.
Double click it and the formula will fill down as far as there are data in
column A

Mike
"Robert11" wrote:

Hello,

Embarrased to ask something so simple, but am in my 70's now, and haven't
used Excel in quite a whle.

Have a long column "A" of numbers.

Would like to create an adjacent column, B, with each number in the first
column A being divided by, e.g., 10.
(and showing up in this adjacent B column)

So, I select the first column, and now what, please ?

Much thanks,
appreciate the help.

Bob



 
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
where can I see my question and answer? Yesterday I ask a question IP Excel Discussion (Misc queries) 2 May 10th 08 04:08 PM
Question Poo Excel Discussion (Misc queries) 2 June 13th 07 01:13 PM
Newbie Question - Subtraction Formula Question [email protected] Excel Discussion (Misc queries) 3 May 5th 06 05:50 PM
IF THEN QUESTION??? Yugo New Users to Excel 5 February 5th 06 08:00 PM
The question is an excel question that I need to figure out howto do in excel. Terry Excel Worksheet Functions 3 January 23rd 06 06:22 PM


All times are GMT +1. The time now is 01:52 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"