Excel Help and Problems

[Yisroel Tech]

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.

[aygart]

oKing? What's that?

Clicking okay

[Thingywingy]

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...?

[churnbabychurn]

Just tried that. Didn't help...?

U using table format?

[Thingywingy]

U using table format?

Nope

[churnbabychurn]

Nope

Try it

[Thingywingy]

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...?

[Work-for-ur-muny]

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.

[Thingywingy]

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...?

[churnbabychurn]

Any good free and safe xml to CSV tools?

[yitzf]

Any good free and safe xml to CSV tools?

Excel data tab -> from other sources, doesn't work?

[aygart]

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

[churnbabychurn]

Excel data tab -> from other sources, doesn't work?

Nah.. all messed up

[yitzf]

Nah.. all messed up

Could it be your file?
I got sample XML files from here and here, and they imported beautifully to Excel.

[churnbabychurn]

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

[yitzf]

Sure can.. file is pretty big though just the text is 26 mb

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

[DanH]

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?

[churnbabychurn]

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

[Something Fishy]

I have a list of 10,000 entries. I only want to keep each 100th. Is there a way to do this easily?

[churnbabychurn]

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.