Omega Owners Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

Please check the Forum Guidelines at the top of the Newbie section

Pages: [1]   Go Down

Author Topic: Excel Help  (Read 2189 times)

0 Members and 1 Guest are viewing this topic.

Mr Skrunts

  • Get A Life!!
  • *****
  • Offline Offline
  • Gender: Male
  • Skruntie Land.
  • Posts: 25677
  • 3.O Elite Saloon with all the toys,
    • 2003 CD 2.2 Auto
    • View Profile
Excel Help
« on: 08 November 2016, 09:06:54 »
Silly question time.

If value of A1 is £1

Then need that value to be changeable in multiple cells then how do I achieve it.



I have always added the value =a1 to maybe b2, then =b2 in call b3 etc

TIA :y
Logged
Ask yourself :  " WHY do I believe in what I believe?"

Remember that my opinions expressed here are not representative of the opinions of other members on the OOF Forum.

Ever Ready

  • Omega Knight
  • *****
  • Offline Offline
  • Gender: Male
  • Scotland
  • Posts: 1681
    • 2.2 CD Auto, Pug 308Hdi
    • View Profile
Re: Excel Help
« Reply #1 on: 08 November 2016, 09:22:37 »
Just about to leave for work but was wondering what version of Excel you have.

e.g. 2003-2016 or Office 365

Hope fully someone will come along soon.
Logged
An ounce of experience is worth more than a pound of enthusiasm.

LC0112G

  • Omega Baron
  • *****
  • Offline Offline
  • 0
  • Posts: 2532
    • View Profile
Re: Excel Help
« Reply #2 on: 08 November 2016, 09:28:37 »
If you want to replicate the value of one cell in other multiple cells, you paste "=$A$1" into all the other cells. Then any value you type in cell A1 will be replicated in all the other cells.

The $ signs basically lock the index so that they don't auto-increment when you paste them into the adjacent cells.

Works in Excell 97 :-)
Logged

Mister Rog

  • Omega Baron
  • *****
  • Offline Offline
  • Gender: Male
  • Wales
  • Posts: 2626
    • Volvo XC70 & V70 D3
    • View Profile
Re: Excel Help
« Reply #3 on: 08 November 2016, 09:38:02 »
Quote from: LC0112G on 08 November 2016, 09:28:37
If you want to replicate the value of one cell in other multiple cells, you paste "=$A$1" into all the other cells. Then any value you type in cell A1 will be replicated in all the other cells.

The $ signs basically lock the index so that they don't auto-increment when you paste them into the adjacent cells.

Works in Excell 97 :-)

And all others as far as I am aware

Also work in Libre Office which is what I use 'cos it's free  !   :y

Logged
“The desire to be a politician should bar you for life from ever becoming one.” Billy Connolly

Mr Skrunts

  • Get A Life!!
  • *****
  • Offline Offline
  • Gender: Male
  • Skruntie Land.
  • Posts: 25677
  • 3.O Elite Saloon with all the toys,
    • 2003 CD 2.2 Auto
    • View Profile
Re: Excel Help
« Reply #4 on: 08 November 2016, 10:14:21 »
Quote from: Ever Ready on 08 November 2016, 09:22:37
Just about to leave for work but was wondering what version of Excel you have.

e.g. 2003-2016 or Office 365

Hope fully someone will come along soon.

2007
Logged
Ask yourself :  " WHY do I believe in what I believe?"

Remember that my opinions expressed here are not representative of the opinions of other members on the OOF Forum.

Mr Skrunts

  • Get A Life!!
  • *****
  • Offline Offline
  • Gender: Male
  • Skruntie Land.
  • Posts: 25677
  • 3.O Elite Saloon with all the toys,
    • 2003 CD 2.2 Auto
    • View Profile
Re: Excel Help
« Reply #5 on: 08 November 2016, 10:15:22 »
Quote from: LC0112G on 08 November 2016, 09:28:37
If you want to replicate the value of one cell in other multiple cells, you paste "=$A$1" into all the other cells. Then any value you type in cell A1 will be replicated in all the other cells.

The $ signs basically lock the index so that they don't auto-increment when you paste them into the adjacent cells.

Works in Excell 97 :-)

Many thanks  :y
Logged
Ask yourself :  " WHY do I believe in what I believe?"

Remember that my opinions expressed here are not representative of the opinions of other members on the OOF Forum.

zirk

  • Omega Queen
  • *****
  • Offline Offline
  • Gender: Male
  • Epping Forest
  • Posts: 11443
  • 3.2 Manual Special Saloon ReMapped and LPG'd and
    • 3.2 Manual Special Estate
    • View Profile
Re: Excel Help
« Reply #6 on: 08 November 2016, 22:38:48 »
Excel eh, crickey, Im still using Lotus 123.
Logged

Terbs

  • Omega Lord
  • *****
  • Offline Offline
  • Brackley/Wareham
  • Posts: 5714
  • The Freezer Geezer
    • CD Saloon 2003
    • View Profile
Re: Excel Help
« Reply #7 on: 08 November 2016, 22:43:42 »
Glad to read that piece of advice on cells. I have been using, (and I suppose it does the same thing,)...=sum(A1) and paste that in the cells I want it transferred to. (using A1 as the example cell) :)
Logged
Wrong Switch Tony......flicking the wrong bit for 50 years

Mr Skrunts

  • Get A Life!!
  • *****
  • Offline Offline
  • Gender: Male
  • Skruntie Land.
  • Posts: 25677
  • 3.O Elite Saloon with all the toys,
    • 2003 CD 2.2 Auto
    • View Profile
Re: Excel Help
« Reply #8 on: 09 November 2016, 00:27:19 »
Quote from: terbert on 08 November 2016, 22:43:42
Glad to read that piece of advice on cells. I have been using, (and I suppose it does the same thing,)...=sum(A1) and paste that in the cells I want it transferred to. (using A1 as the example cell) :)

Brilliant advice, been meaning to find out for ages  :y
Logged
Ask yourself :  " WHY do I believe in what I believe?"

Remember that my opinions expressed here are not representative of the opinions of other members on the OOF Forum.

Mr Skrunts

  • Get A Life!!
  • *****
  • Offline Offline
  • Gender: Male
  • Skruntie Land.
  • Posts: 25677
  • 3.O Elite Saloon with all the toys,
    • 2003 CD 2.2 Auto
    • View Profile
More Excel Help Please
« Reply #9 on: 15 November 2016, 09:30:18 »
Next question ::)

Adding dates

Is there a simple way to add dates

Needing a list

6/11/16
6/12/16
6/ 1/17
etc etc

Am help some one who has gone from a weekly wage to a salary,

Was simple before

A1 6/11/16
A2=A1+7 etc
Logged
Ask yourself :  " WHY do I believe in what I believe?"

Remember that my opinions expressed here are not representative of the opinions of other members on the OOF Forum.

Gaffers

  • Omega Queen
  • *****
  • Offline Offline
  • Gender: Male
  • NE Hampshire/Surrey
  • Posts: 11322
    • Ford Ranger Wildtrak
    • View Profile
Re: Excel Help
« Reply #10 on: 15 November 2016, 11:11:24 »
I think you need to look at the =MONTH() function
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.041 seconds with 21 queries.