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

Offline Lurker

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jul 2019
  • Posts: 4661
  • Total likes: 5104
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: As always, silence is NOT an admission of agreement on DDF. It just means that people lack the stamina to keep on arguing with made up "facts", illogical arguments, deceiving statements, nasty and degrading comments, and fuzzy math. - @yelped
Re: Excel Help and Problems
« Reply #1480 on: June 16, 2021, 12:42:43 PM »
ouch

Uh huh. The only sheet that was left was the one with a small amount of data. There goes the deadline.
Failing at maintaining Lurker status.

Offline David61

  • Dansdeals Gold Elite
  • ***
  • Join Date: Jan 2011
  • Posts: 220
  • Total likes: 53
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: NYC
Re: Excel Help and Problems
« Reply #1481 on: June 16, 2021, 01:03:46 PM »
Any recommendations for tutorials on excel to get from raw beginner-to-intermediate level of proficiency. Thanks.

(I know there are many out there, looking for assistance with selecting a good one). 

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1819
  • Total likes: 236
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1482 on: June 16, 2021, 07:05:11 PM »
Yea... I just dragged it from Downloads to the desktop. Poof.
I'm confused. Was it only dragging, or was it saving to CSV?

(Perhaps as a last ditch, try regular recovery/undelete software like Recuva and TestDisk.)

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1819
  • Total likes: 236
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1483 on: June 16, 2021, 07:06:14 PM »
Any recommendations for tutorials on excel to get from raw beginner-to-intermediate level of proficiency. Thanks.

(I know there are many out there, looking for assistance with selecting a good one).
Like in most things... Lynda/LinkedIn Learning's Essential Training course is a great place to start.

That would be the Excel 2019 Essential Training from Dennis Taylor.

Offline Lurker

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jul 2019
  • Posts: 4661
  • Total likes: 5104
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: As always, silence is NOT an admission of agreement on DDF. It just means that people lack the stamina to keep on arguing with made up "facts", illogical arguments, deceiving statements, nasty and degrading comments, and fuzzy math. - @yelped
Re: Excel Help and Problems
« Reply #1484 on: June 17, 2021, 03:06:17 PM »
I'm confused. Was it only dragging, or was it saving to CSV?

(Perhaps as a last ditch, try regular recovery/undelete software like Recuva and TestDisk.)

While it was open (for a few days), it was saving as a CSV. In order to move it, it needed to be closed. It was dragged from an open folder onto the desktop. Once it was reopened, only the last open page was there. Apparently, a CSV file will save multiple sheets as long as the file is open. But once it is closed, it only saves the last open sheet.
Failing at maintaining Lurker status.

Offline stooges44

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jan 2017
  • Posts: 5997
  • Total likes: 1820
  • DansDeals.com Hat Tips 262
    • View Profile
Re: Excel Help and Problems
« Reply #1485 on: June 17, 2021, 04:20:23 PM »
While it was open (for a few days), it was saving as a CSV. In order to move it, it needed to be closed. It was dragged from an open folder onto the desktop. Once it was reopened, only the last open page was there. Apparently, a CSV file will save multiple sheets as long as the file is open. But once it is closed, it only saves the last open sheet.

It was "gone" as soon as you clicked save the first time as a csv, you just didn't know it yet. Moving it had nothing to do with it. Any formats are also lost in a csv file.

Did you not get this warning the first time you hit save?



If it's not free shipping it's not worth it.

Offline Lurker

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jul 2019
  • Posts: 4661
  • Total likes: 5104
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: As always, silence is NOT an admission of agreement on DDF. It just means that people lack the stamina to keep on arguing with made up "facts", illogical arguments, deceiving statements, nasty and degrading comments, and fuzzy math. - @yelped
Re: Excel Help and Problems
« Reply #1486 on: June 24, 2021, 08:44:02 AM »
It was "gone" as soon as you clicked save the first time as a csv, you just didn't know it yet. Moving it had nothing to do with it. Any formats are also lost in a csv file.

Did you not get this warning the first time you hit save?




I don't believe I got that pop up. The account is linked to Onedrive, but it wasn't signed in. Don't know if that affected which warnings pop up.
Failing at maintaining Lurker status.

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12125
  • Total likes: 2174
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1487 on: June 24, 2021, 08:46:44 AM »
The popup is not related to onedrive
Workflowy. You won't know what you're missing until you try it.

Offline Definitions

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2018
  • Posts: 1360
  • Total likes: 265
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1488 on: July 21, 2021, 02:56:18 PM »
I want to have a shape that uses a macro when clicked to copy the values of multiple cells to other cells. (Ie. Cell a,b,c gets copied over to cells d,e,f respectively.) Sort of like a submit button that I will then use the data from cells d,e, and f to do other things.

Is there a way to do that?


Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1819
  • Total likes: 236
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1489 on: July 21, 2021, 03:17:29 PM »
I want to have a shape that uses a macro when clicked to copy the values of multiple cells to other cells. (Ie. Cell a,b,c gets copied over to cells d,e,f respectively.) Sort of like a submit button that I will then use the data from cells d,e, and f to do other things.

Is there a way to do that?
Certainly possible with a bit of coding, check out this guide:
https://www.teachexcel.com/excel-tutorial/input-form-to-get-data-and-store-it-in-another-tab-in-excel_1570.html

(As an alternative - depending on the use case, if the input is done by other people and can be done online - is to use a real Form like https://forms.office.com/ or https://www.google.com/forms/about/)

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 517
  • Total likes: 11
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1490 on: August 08, 2021, 06:29:39 PM »
I searched for the word help thread, and couldn't find it, so I'm posting here.

please help if you can, thank you.

Im trying to add a background picture to word, the sole purpose of adding the picture is so that I can see where to add content over the picture.
I dont want that when i print, it should print the picture too, just the words. I already have paper with that background, so i only need the words.
Im guessing it has something to do with templates, but have no experience there.

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1819
  • Total likes: 236
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1491 on: August 08, 2021, 06:37:59 PM »
I searched for the word help thread, and couldn't find it, so I'm posting here.

please help if you can, thank you.

Im trying to add a background picture to word, the sole purpose of adding the picture is so that I can see where to add content over the picture.
I dont want that when i print, it should print the picture too, just the words. I already have paper with that background, so i only need the words.
Im guessing it has something to do with templates, but have no experience there.
You can open a thread... it doesn't bite...

A template is if you need that same background again and again and don't want to need to every time.

But do you already have a way to add it and not print it?

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 517
  • Total likes: 11
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1492 on: August 08, 2021, 07:00:48 PM »
no.
I thought to add it by inserting picture.

and yes i want to be able to use the same page again and again, (though i could prob do save as every time)

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1819
  • Total likes: 236
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1493 on: August 08, 2021, 07:24:24 PM »
no.
I thought to add it by inserting picture.

and yes i want to be able to use the same page again and again, (though i could prob do save as every time)
If you just add the picture, it will be difficult to write over it. The best way for this is to add it in the Header.

I just don't know of a normal way to make it not print.

Offline Definitions

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2018
  • Posts: 1360
  • Total likes: 265
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1494 on: August 08, 2021, 07:26:24 PM »
Insert the background picture set it to be behind text then insert text boxes over wherever you want to type then delete the original picture.

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 517
  • Total likes: 11
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1495 on: August 08, 2021, 08:29:58 PM »
I dont actually have a printer here with me now, but it sounds like a good idea.
thanks all

If there is a simpler idea, i'm all ears, of course.

Offline Yo ssi

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2019
  • Posts: 3997
  • Total likes: 1275
  • DansDeals.com Hat Tips 38
  • Gender: Male
    • View Profile
Re: Excel Help and Problems
« Reply #1496 on: August 08, 2021, 10:16:09 PM »
Insert the background picture set it to be behind text then insert text boxes over wherever you want to type then delete the original picture.
There is no layers in word. But a workaround is to have 2 pictures one with the background you want to print and one with the markings. Just send to back the one you don't want shown. (This avoids having to delete the picture so you can reuse it.)

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 517
  • Total likes: 11
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1497 on: August 08, 2021, 11:05:56 PM »
There is no layers in word. But a workaround is to have 2 pictures one with the background you want to print and one with the markings. Just send to back the one you don't want shown. (This avoids having to delete the picture so you can reuse it.)

When I send to back do I still see it? It just doesn't print?
Why do I need to have 2 pictures, why not just the 1 background and keep it always in the back?

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12125
  • Total likes: 2174
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1498 on: August 08, 2021, 11:07:51 PM »

When I send to back do I still see it? It just doesn't print?
Why do I need to have 2 pictures, why not just the 1 background and keep it always in the back?
The point was to have an image of a plain white rectangle which can go in front of the real image when you don't want to see (print) it.
Workflowy. You won't know what you're missing until you try it.

Offline Definitions

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2018
  • Posts: 1360
  • Total likes: 265
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1499 on: August 08, 2021, 11:32:16 PM »
There is no layers in word. But a workaround is to have 2 pictures one with the background you want to print and one with the markings. Just send to back the one you don't want shown. (This avoids having to delete the picture so you can reuse it.)
Multiple layers aren't needed. I'm talking about this thingy