Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 147825 times)

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11992
  • Total likes: 2017
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1470 on: March 18, 2021, 10:29:24 AM »
Type .15 into any cell, and do ctrl+c.
Then, select the data you want to multiply, right click, do paste special, and select multiply.
might want 1.15 in that cell
Workflowy. You won't know what you're missing until you try it.

Online AsherO

  • Global Moderator
  • Dansdeals Lifetime 20K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 24790
  • Total likes: 2506
  • DansDeals.com Hat Tips 75
    • View Profile
  • Location: NYC
Re: Excel Help and Problems
« Reply #1471 on: March 18, 2021, 11:31:03 AM »
Type .15 into any cell, and do ctrl+c.
Then, select the data you want to multiply, right click, do paste special, and select multiply.

I do it the long and ignorant way:
- add column
- =[cell from previous column] * 1.15
- auto fill the formula above to all rows
- copy the added column
- Paste special the added column over the original one, pasting values
- Delete the added column

Cool shortcut to do it simpler, thanks!

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 11992
  • Total likes: 2017
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1472 on: March 18, 2021, 11:32:55 AM »
I do it the long and ignorant way:
- add column
- =[cell from previous column] * 1.15
- auto fill the formula above to all rows
- copy the added column
- Paste special the added column over the original one, pasting values
- Delete the added column

Cool shortcut to do it simpler, thanks!
+1
Workflowy. You won't know what you're missing until you try it.

Online Yo ssi

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2019
  • Posts: 3510
  • Total likes: 1078
  • DansDeals.com Hat Tips 38
  • Gender: Male
    • View Profile
  • Programs: @myi so list them as Dan does!
Re: Excel Help and Problems
« Reply #1473 on: March 18, 2021, 05:02:45 PM »
I do it the long and ignorant way:
- add column
- =[cell from previous column] * 1.15
- auto fill the formula above to all rows
- copy the added column
- Paste special the added column over the original one, pasting values
- Delete the added column

Cool shortcut to do it simpler, thanks!
I was going to say to use a script 😜