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

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 537
  • Total likes: 17
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1500 on: August 08, 2021, 11:47:53 PM »
will it not print the background?

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1997
  • Total likes: 297
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1501 on: August 08, 2021, 11:53:13 PM »
The real way to do this would be to insert the picture in the Header (with Text Wrap set to Behind Text) and then print with a code like the one here https://www.extendoffice.com/documents/word/5453-word-print-without-header-and-footer.html

Online Definitions

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2018
  • Posts: 1529
  • Total likes: 326
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1502 on: August 08, 2021, 11:54:05 PM »
will it not print the background?
It will if you keep it there. The idea was to set up the text boxes on top of the image where you want it to be filled in. Then just delete the image and use it as a template. Basically the same thing as what yo ssi was saying

Offline unavailable

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Dec 2013
  • Posts: 537
  • Total likes: 17
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1503 on: August 09, 2021, 12:07:04 AM »
what I did until now, was, I wrote the words in the place I thought they belonged. Then I printed it, and adjusted where needed, after a few tries it was good.
I just thought that with todays' software, there is prob a better ore effective way, looks like there isn't.

Offline yoruel

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2013
  • Posts: 716
  • Total likes: 5
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York
Re: Excel Help and Problems
« Reply #1504 on: February 02, 2022, 12:59:39 PM »
Withiut VBA, can I Auto complete text in a drop down list cell.
I used data validation to create my drop down list.
We have over 300 items to enter.

Online skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3649
  • Total likes: 701
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Help and Problems
« Reply #1505 on: February 02, 2022, 01:04:27 PM »
Withiut VBA, can I Auto complete text in a drop down list cell.
I used data validation to create my drop down list.
We have over 300 items to enter.
Try this:
https://superuser.com/questions/1419626/how-can-i-add-autocomplete-to-an-excel-drop-down-validation

Offline yoruel

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: May 2013
  • Posts: 716
  • Total likes: 5
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York
Re: Excel Help and Problems
« Reply #1506 on: February 02, 2022, 01:30:05 PM »
Thank you.
Problem is need to always create a new combo box

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2659
  • Total likes: 52
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1507 on: February 02, 2022, 06:07:58 PM »
Withiut VBA, can I Auto complete text in a drop down list cell.
I used data validation to create my drop down list.
We have over 300 items to enter.

Just announced 2 days ago. They're rolling it out slowly.
https://techcommunity.microsoft.com/t5/excel-blog/speed-up-data-entry-and-validation-with-autocomplete-for/ba-p/3072083

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1997
  • Total likes: 297
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Excel Help and Problems
« Reply #1508 on: February 03, 2022, 12:24:55 PM »

Offline ushdadude

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Apr 2013
  • Posts: 6077
  • Total likes: 687
  • DansDeals.com Hat Tips 5
    • View Profile
  • Location: NY
Re: Excel Help and Problems
« Reply #1509 on: February 03, 2022, 12:30:40 PM »
Excel saved a list of tracking numbers in scientific notation. when i convert back to a regular number the last 6 digits are all 000000. Anyway to get that data back?

Online Definitions

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2018
  • Posts: 1529
  • Total likes: 326
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Excel Help and Problems
« Reply #1510 on: February 03, 2022, 04:00:59 PM »
Excel saved a list of tracking numbers in scientific notation. when i convert back to a regular number the last 6 digits are all 000000. Anyway to get that data back?
If you still have the original before you converted it change it to text.

I wonder if Ctrl z would work too

Offline ushdadude

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Apr 2013
  • Posts: 6077
  • Total likes: 687
  • DansDeals.com Hat Tips 5
    • View Profile
  • Location: NY
Re: Excel Help and Problems
« Reply #1511 on: February 03, 2022, 04:15:56 PM »
If you still have the original before you converted it change it to text.

I wonder if Ctrl z would work too
i don't have access to it but BH when i opened it sheets, the data was there

Offline JM

  • Dansdeals Gold Elite
  • ***
  • Join Date: Dec 2020
  • Posts: 142
  • Total likes: 35
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1512 on: February 06, 2022, 12:21:40 PM »
i don't have access to it but BH when i opened it sheets, the data was there

In the future if you put a single apostrophe (') in front of a tracking number or a zip or anything with a potential leading 0, it'll prevent excel from messing with the number

Offline ushdadude

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Apr 2013
  • Posts: 6077
  • Total likes: 687
  • DansDeals.com Hat Tips 5
    • View Profile
  • Location: NY
Re: Excel Help and Problems
« Reply #1513 on: February 06, 2022, 02:04:05 PM »
In the future if you put a single apostrophe (') in front of a tracking number or a zip or anything with a potential leading 0, it'll prevent excel from messing with the number


Thanks,
Vegetables that's what I do but this was a long list of numbers I imported

Online AsherO

  • Global Moderator
  • Dansdeals Lifetime 20K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 28805
  • Total likes: 5690
  • DansDeals.com Hat Tips 78
    • View Profile
  • Location: NYC
Re: Excel Help and Problems
« Reply #1514 on: February 06, 2022, 03:49:27 PM »

Thanks,
Vegetables that's what I do but this was a long list of numbers I imported

Paste values into columns formatted as text.

Offline jose34

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2016
  • Posts: 2250
  • Total likes: 123
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Help and Problems
« Reply #1515 on: February 08, 2022, 02:20:03 PM »
What would be the formulta if I wanted to Excel to:
I have data coming into Excel from another cell and I wanted to add or subtract based on that number.

For example: if the incoming number is below 5 I want Excel to subtract the incoming number by 5 (for example incoming number is 2 so Excel should subtract 5-2), if the incoming number is above 5 ( for example incoming number is 7 so Excel should add 5+7) I want it to add the incoming number.

Offline JuryDuty

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Nov 2018
  • Posts: 916
  • Total likes: 149
  • DansDeals.com Hat Tips 16
    • View Profile
  • Location: New York
  • Programs: Hyatt Explorist
Re: Excel Help and Problems
« Reply #1516 on: February 08, 2022, 02:24:59 PM »
What would be the formulta if I wanted to Excel to:
I have data coming into Excel from another cell and I wanted to add or subtract based on that number.

For example: if the incoming number is below 5 I want Excel to subtract the incoming number by 5 (for example incoming number is 2 so Excel should subtract 5-2), if the incoming number is above 5 ( for example incoming number is 7 so Excel should add 5+7) I want it to add the incoming number.

You'd have to specify what you want if it equals 5. But =if(a2>5,b2-a2,b2+a2) something like that. A2 would be the incoming number, b2 is the number you would be adding or subtracting it from
Jury Duty: A time with nothing to do but chill and write a TR. Kinda like the beach without a view and an ocean breeze.

Offline JuryDuty

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Nov 2018
  • Posts: 916
  • Total likes: 149
  • DansDeals.com Hat Tips 16
    • View Profile
  • Location: New York
  • Programs: Hyatt Explorist
Re: Excel Help and Problems
« Reply #1517 on: February 08, 2022, 02:27:28 PM »
Question: recently, I've been using flash fill, and the equation fills out correctly but the number appears as a copy of the first cell. If I save the file, the numbers are corrected, matching the equation. Any idea what's happening?
Jury Duty: A time with nothing to do but chill and write a TR. Kinda like the beach without a view and an ocean breeze.

Online skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3649
  • Total likes: 701
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Excel Help and Problems
« Reply #1518 on: February 08, 2022, 03:43:05 PM »
Question: recently, I've been using flash fill, and the equation fills out correctly but the number appears as a copy of the first cell. If I save the file, the numbers are corrected, matching the equation. Any idea what's happening?
You probably have calc on manual, and when you save it recalculates.

Offline hocker

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Oct 2009
  • Posts: 3482
  • Total likes: 78
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: Excel Help and Problems
« Reply #1519 on: March 30, 2022, 02:27:18 PM »
If anyone can help me with a simple conditional formatting I'd really appreciate it. I'm trying to compare two lists and highlight cells in column 1 that also appear in the list on sheet 2. Tried google and for some reason it is not working.