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 101869 times)

Offline Jkhein

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Oct 2010
  • Posts: 4536
  • Total likes: 13
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Problem
« Reply #1005 on: July 20, 2017, 12:36:58 AM »
Is there a way to have a link to a product (eg. on home depot website) and the other column should retrieve the product picture from that page?

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7190
  • Total likes: 275
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Problem
« Reply #1006 on: July 20, 2017, 04:09:57 AM »
Is there a way to have a link to a product (eg. on home depot website) and the other column should retrieve the product picture from that page?
https://superuser.com/questions/52760/embed-pictures-from-web-by-url-in-excel-spreadsheet-or-oo-calc

Yeah

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7190
  • Total likes: 275
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1007 on: August 15, 2017, 11:09:37 AM »
Going crazy here.. I use filters alot... when I click the dropdown on a filter, it only stays open for two seconds and then closes, and cursor jumps to random cell?! what is going on? tried restarting PC etc

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9556
  • Total likes: 376
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1008 on: August 15, 2017, 11:51:13 AM »
Going crazy here.. I use filters alot... when I click the dropdown on a filter, it only stays open for two seconds and then closes, and cursor jumps to random cell?! what is going on? tried restarting PC etc
Is this only one spreadsheet, or all?
If you turn filters off and back on does that fix it?
Workflowy. You won't know what you're missing until you try it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7190
  • Total likes: 275
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1009 on: August 15, 2017, 12:08:34 PM »
Is this only one spreadsheet, or all?
If you turn filters off and back on does that fix it?
All and no doesn't help...

Offline aygart

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: May 2008
  • Posts: 7406
  • Total likes: 1964
  • DansDeals.com Hat Tips 7
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Help and Problems
« Reply #1010 on: August 15, 2017, 12:21:16 PM »
All and no doesn't help...
maybe try turning off/disconnecting mouse and keyboard separately and testing then.
You have the right to remain silent. Anything you say can and will be used to start a religious discussion.

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9556
  • Total likes: 376
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1011 on: August 15, 2017, 12:36:54 PM »
All and no doesn't help...
Do you have any macros in personal.xlsb? Maybe one of them is misbehaving.

You can also try uninstalling/reinstalling microsoft, but maybe that should be a last resort since it's a project.
maybe try turning off/disconnecting mouse and keyboard separately and testing then.
Good idea!
Workflowy. You won't know what you're missing until you try it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7190
  • Total likes: 275
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1012 on: August 15, 2017, 04:16:41 PM »
Do you have any macros in personal.xlsb? Maybe one of them is misbehaving.

You can also try uninstalling/reinstalling microsoft, but maybe that should be a last resort since it's a project.Good idea!
Had some macros.. deleted em all.deleted personal.
Changed mouse and keyboard.
Repaired office.
Aghh. Still acting up

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9556
  • Total likes: 376
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1013 on: August 15, 2017, 06:03:24 PM »
Had some macros.. deleted em all.deleted personal.
Changed mouse and keyboard.
Repaired office.
Aghh. Still acting up
Oy! I think I'm out of ideas then.
Workflowy. You won't know what you're missing until you try it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7190
  • Total likes: 275
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1014 on: August 18, 2017, 12:12:52 PM »
excel 2016 - how to switch sheet from right to left to left to right??

Used to be under page layout, simple button. - Now even google doesnt know!?

Offline aygart

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: May 2008
  • Posts: 7406
  • Total likes: 1964
  • DansDeals.com Hat Tips 7
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Help and Problems
« Reply #1015 on: August 18, 2017, 06:35:10 PM »
excel 2016 - how to switch sheet from right to left to left to right??

Used to be under page layout, simple button. - Now even google doesnt know!?
Do you have hebrew installed as an input language?
You have the right to remain silent. Anything you say can and will be used to start a religious discussion.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7190
  • Total likes: 275
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1016 on: August 19, 2017, 09:23:35 PM »
Do you have hebrew installed as an input language?
Probably not...

It's a standard feature in Excel. Switch whole sheet direction. Cell a1 on right. Just can't find it in 2016..

Offline aygart

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: May 2008
  • Posts: 7406
  • Total likes: 1964
  • DansDeals.com Hat Tips 7
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Help and Problems
« Reply #1017 on: August 19, 2017, 09:38:50 PM »
Probably not...

It's a standard feature in Excel. Switch whole sheet direction. Cell a1 on right. Just can't find it in 2016..
It only shows up with a right to left language installed. If you go to the customize ribbon options you will see it greyed out under page layout tab.
You have the right to remain silent. Anything you say can and will be used to start a religious discussion.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7190
  • Total likes: 275
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1018 on: August 19, 2017, 09:40:17 PM »
It only shows up with a right to left language installed. If you go to the customize ribbon options you will see it greyed out under page layout tab.
Oh.. I'm actually using a laptop instead of my regular pc.. I guess I have to install Hebrew thx

Offline Thingywingy

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2011
  • Posts: 4433
  • Total likes: 20
  • DansDeals.com Hat Tips 24
    • View Profile
Re: Excel Help and Problems
« Reply #1019 on: August 25, 2017, 05:26:44 PM »
I applied shading to alternating cells as described in this Office support page. but for some reason the shading does not appear when I print? Any solutions?

I opened the page setup window from the page layout tab, went to the sheet tab and the black and white in the print section is not checked. I saw that online as a possible reason...
« Last Edit: August 25, 2017, 05:38:18 PM by Thingywingy »
I am sometimes accused of overthinking things. I am still mulling over whether that accusation has merit.