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

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1602
  • Total likes: 178
  • 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.

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 10007
  • Total likes: 3741
  • DansDeals.com Hat Tips 7
    • 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 »
The thing with the hamster is that running on the wheel is actually what it is trying to do.

Offline Thingywingy

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2011
  • Posts: 4486
  • Total likes: 23
  • 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: 7245
  • Total likes: 282
  • 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: 4486
  • Total likes: 23
  • 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: 7245
  • Total likes: 282
  • 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: 4486
  • Total likes: 23
  • 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: 310
  • 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: 4486
  • Total likes: 23
  • 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: 7245
  • Total likes: 282
  • 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: 2645
  • Total likes: 48
  • 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?

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 10007
  • Total likes: 3741
  • DansDeals.com Hat Tips 7
    • 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
The thing with the hamster is that running on the wheel is actually what it is trying to do.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7245
  • Total likes: 282
  • 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: 2645
  • Total likes: 48
  • 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: 7245
  • Total likes: 282
  • 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