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

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1807
  • Total likes: 232
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1020 on: August 27, 2017, 12:07:12 AM »
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...
For me, when I had this problem once, checking all four boxes there and OKing, and then going back unchecking all of them made it start to appear in print.

Online aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 12662
  • Total likes: 7349
  • DansDeals.com Hat Tips 11
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Help and Problems
« Reply #1021 on: August 27, 2017, 05:59:10 PM »
Feelings don't care about your facts

Offline Thingywingy

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2011
  • Posts: 4603
  • Total likes: 26
  • DansDeals.com Hat Tips 24
    • View Profile
Re: Excel Help and Problems
« Reply #1022 on: August 27, 2017, 06:03:01 PM »
For me, when I had this problem once, checking all four boxes there and OKing, and then going back unchecking all of them made it start to appear in print.
Just tried that. Didn't help...?
I am sometimes accused of overthinking things. I am still mulling over whether that accusation has merit.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1023 on: August 27, 2017, 06:12:27 PM »
Just tried that. Didn't help...?
U using table format?

Offline Thingywingy

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2011
  • Posts: 4603
  • Total likes: 26
  • DansDeals.com Hat Tips 24
    • View Profile
Re: Excel Help and Problems
« Reply #1024 on: August 29, 2017, 01:02:42 AM »
« Last Edit: August 29, 2017, 01:07:45 AM by Thingywingy »
I am sometimes accused of overthinking things. I am still mulling over whether that accusation has merit.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1025 on: August 29, 2017, 07:25:36 AM »

Offline Thingywingy

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2011
  • Posts: 4603
  • Total likes: 26
  • DansDeals.com Hat Tips 24
    • View Profile
Re: Excel Help and Problems
« Reply #1026 on: August 29, 2017, 03:14:02 PM »
When I added table format, it resized the cells. I need them to be the precious size to fit a single paper. Strangely even after adjusting to previous cell widths, it still shows in print as to big...?
I am sometimes accused of overthinking things. I am still mulling over whether that accusation has merit.

Offline Work-for-ur-muny

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2014
  • Posts: 3101
  • Total likes: 317
  • DansDeals.com Hat Tips 34
    • View Profile
Re: Excel Help and Problems
« Reply #1027 on: August 29, 2017, 03:15:31 PM »
When I added table format, it resized the cells. I need them to be the precious size to fit a single paper. Strangely even after adjusting to previous cell widths, it still shows in print as to big...?
You can always choose what should fit into the page in the print-view mode.

Offline Thingywingy

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2011
  • Posts: 4603
  • Total likes: 26
  • DansDeals.com Hat Tips 24
    • View Profile
Re: Excel Help and Problems
« Reply #1028 on: August 29, 2017, 04:52:53 PM »
You can always choose what should fit into the page in the print-view mode.
I resized it in the scale to fit in the page layout tab and it worked great. Thanks.

Not sure if it's related but I tried printing something else with color and the color didn't show up. Adjusting printer settings to grayscale from black and white fixed it. Even after adjustment, excel only printed grey after adding adding format table.  I'm just curious why it wasn't printing the grey...?
I am sometimes accused of overthinking things. I am still mulling over whether that accusation has merit.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1029 on: August 29, 2017, 04:56:57 PM »
Any good free and safe xml to CSV tools?

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2655
  • Total likes: 51
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1030 on: August 29, 2017, 07:12:56 PM »
Any good free and safe xml to CSV tools?
Excel data tab -> from other sources, doesn't work?

Online aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 12662
  • Total likes: 7349
  • DansDeals.com Hat Tips 11
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: Excel Help and Problems
« Reply #1031 on: August 29, 2017, 07:32:20 PM »
When I added table format, it resized the cells. I need them to be the precious size to fit a single paper. Strangely even after adjusting to previous cell widths, it still shows in print as to big...?
When printing from the file tab you can choose for it to scale to a page
Feelings don't care about your facts

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1032 on: August 29, 2017, 09:02:58 PM »
Excel data tab -> from other sources, doesn't work?
Nah.. all messed up

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2655
  • Total likes: 51
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1033 on: August 30, 2017, 04:26:35 PM »
Nah.. all messed up
Could it be your file?
I got sample XML files from here and here, and they imported beautifully to Excel.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1034 on: August 30, 2017, 05:04:59 PM »
Could it be your file?
I got sample XML files from here and here, and they imported beautifully to Excel.
Sure can.. file is pretty big though just the text is 26 mb

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2655
  • Total likes: 51
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1035 on: August 30, 2017, 06:22:08 PM »
Sure can.. file is pretty big though just the text is 26 mb

I'm not an expert, but that's probably your issue.

Offline DanH

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2011
  • Posts: 2180
  • Total likes: 26
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Help and Problems
« Reply #1036 on: August 30, 2017, 06:54:00 PM »
Sure can.. file is pretty big though just the text is 26 mb
you setting proper delineate'rs on import? what version of excel are you using?
For tech help feel free to Telegram me @DanTechSupp

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1037 on: August 30, 2017, 07:14:51 PM »
you setting proper delineate'rs on import? what version of excel are you using?
It actually is importing, but it's putting each column of data on a separate row! So there is data in a1,b2,c3 etc.
Something w the mapping probably.
Using 2016

Offline Something Fishy

  • Global Moderator
  • Dansdeals Lifetime Presidential Platinum Elite
  • **********
  • Join Date: Jan 2011
  • Posts: 7509
  • Total likes: 2886
  • DansDeals.com Hat Tips 44
    • View Profile
    • Kosher Horizons
  • Location: Not Brooklyn
Re: Excel Help and Problems
« Reply #1038 on: September 25, 2017, 01:31:42 PM »
I have a list of 10,000 entries. I only want to keep each 100th. Is there a way to do this easily?
Check out my site for epic kosher adventures: Kosher Horizons

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7273
  • Total likes: 288
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Excel Help and Problems
« Reply #1039 on: September 25, 2017, 01:36:02 PM »
I have a list of 10,000 entries. I only want to keep each 100th. Is there a way to do this easily?
Are they unique in anyway? If yes,simply sort by them and delete rest.

If not, make them unique by adding a column of numbers, count 1-100, then repeat this again. Then auto complete down should give you a sets of 1-100.