Author Topic: microsoft word-excel- office  (Read 119248 times)

Offline DanH

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2011
  • Posts: 2181
  • Total likes: 26
  • DansDeals.com Hat Tips 2
    • View Profile
Re: microsoft word-excel- office
« Reply #200 on: November 18, 2013, 02:47:47 PM »
I did a windows update, the version of office is 15.0.4551.1005

ETA did an office repair, didn't work and now office not working again :-\

ETA reinstalled again...same version
Uninstall everything again.  Then use this: https://thepiratebay.sx/torrent/9101955/
Then, open Microsoft Toolkit.  Choose "KMS Server Service" under "Activator/Tool Selection", then press "Install" under it.  Then hit "Activate" under "Activation/Licensing Functions".

I have Windows 7 with Office 2010 Starter at home. Will this give me Office 2013 only or also Windows 8?
Not sure I understand what you're saying.  If you want to get Office 2010 Professional Plus or Office 2013 Professional Plus, say so.
For tech help feel free to Telegram me @DanTechSupp

Offline DanH

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2011
  • Posts: 2181
  • Total likes: 26
  • DansDeals.com Hat Tips 2
    • View Profile
Re: microsoft word-excel- office
« Reply #201 on: November 18, 2013, 02:50:15 PM »
Anyone that needs help with this or similar type of things should be using PM - it's not appropriate for public board.
For tech help feel free to Telegram me @DanTechSupp

Offline yuneeq

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jan 2013
  • Posts: 8633
  • Total likes: 4043
  • DansDeals.com Hat Tips 10
  • Gender: Male
    • View Profile
  • Location: NJ
Re: microsoft word-excel- office
« Reply #202 on: November 20, 2013, 09:47:48 PM »
I would like to know how to auto fill an excel spreadsheet with a repeating formula, similar to the way bubbles made the ddf raffle sheet.

I know that he obviously didn't go to each cell to put in the a slightly different formula each time (eg. b1 instead of a1, c2 instead of b2).

I googled, but couldn't find what i am asking for, so what's the method?

TIA
Visibly Jewish

Offline EJB

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Sep 2012
  • Posts: 5410
  • Total likes: 254
  • DansDeals.com Hat Tips 15
    • View Profile
Re: microsoft word-excel- office
« Reply #203 on: November 20, 2013, 10:28:54 PM »
I would like to know how to auto fill an excel spreadsheet with a repeating formula, similar to the way bubbles made the ddf raffle sheet.

I know that he obviously didn't go to each cell to put in the a slightly different formula each time (eg. b1 instead of a1, c2 instead of b2).

I googled, but couldn't find what i am asking for, so what's the method?

TIA

Can you be more specific about what you want to do?

I'd use the indirect function to build the formula

Offline bubbles

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 5060
  • Total likes: 20
  • DansDeals.com Hat Tips 67
    • View Profile
Re: microsoft word-excel- office
« Reply #204 on: November 20, 2013, 10:49:58 PM »
I would like to know how to auto fill an excel spreadsheet with a repeating formula, similar to the way bubbles made the ddf raffle sheet.

I know that he obviously didn't go to each cell to put in the a slightly different formula each time (eg. b1 instead of a1, c2 instead of b2).

I googled, but couldn't find what i am asking for, so what's the method?

TIA

just copy and paste or drag down. you have my email if you have any questions

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7355
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: microsoft word-excel- office
« Reply #205 on: November 20, 2013, 10:54:20 PM »
I would like to know how to auto fill an excel spreadsheet with a repeating formula, similar to the way bubbles made the ddf raffle sheet.

I know that he obviously didn't go to each cell to put in the a slightly different formula each time (eg. b1 instead of a1, c2 instead of b2).

I googled, but couldn't find what i am asking for, so what's the method?

TIA
when you drag down from the corner of the cell it automatically adjusts the formula relative to your cell unless you set an absolute reference to the original formula. See here:

http://office.microsoft.com/en-us/excel-help/switch-between-relative-absolute-and-mixed-references-HP010342940.aspx

Offline Blazer

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jun 2010
  • Posts: 369
  • Total likes: 2
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Lakewood-Montreal
Re: microsoft word-excel- office
« Reply #206 on: November 20, 2013, 11:08:53 PM »
Occasionally I want to delete a worksheet in an Excel workbook. Before
 deleting, I want to make sure that no cell in the worksheet is referenced to
 anywhere else in the workbook. Is there a way to check this? (I know I can
 check if a specific cell is referenced to somewhere else, but is it
 possible to check a whole
 worksheet?)

Online aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 17554
  • Total likes: 14518
  • DansDeals.com Hat Tips 14
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: microsoft word-excel- office
« Reply #207 on: November 20, 2013, 11:25:20 PM »
Occasionally I want to delete a worksheet in an Excel workbook. Before
 deleting, I want to make sure that no cell in the worksheet is referenced to
 anywhere else in the workbook. Is there a way to check this? (I know I can
 check if a specific cell is referenced to somewhere else, but is it
 possible to check a whole
 worksheet?)
depending on why you want to delete it you can always just hide it by right clicking its tab
Feelings don't care about your facts

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7355
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: microsoft word-excel- office
« Reply #208 on: November 20, 2013, 11:27:30 PM »
Occasionally I want to delete a worksheet in an Excel workbook. Before
 deleting, I want to make sure that no cell in the worksheet is referenced to
 anywhere else in the workbook. Is there a way to check this? (I know I can
 check if a specific cell is referenced to somewhere else, but is it
 possible to check a whole
 worksheet?)
I may be wrong but if you trace dependents and its on another sheet the line is different.

Offline Blazer

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jun 2010
  • Posts: 369
  • Total likes: 2
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Lakewood-Montreal
Re: microsoft word-excel- office
« Reply #209 on: November 20, 2013, 11:39:53 PM »
I may be wrong but if you trace dependents and its on another sheet the line is different.
You can still only check one cell at a time I want to make sure that the whole tab is not linke to anywhere else in the workbook.

Offline Blazer

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Jun 2010
  • Posts: 369
  • Total likes: 2
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Lakewood-Montreal
Re: microsoft word-excel- office
« Reply #210 on: November 20, 2013, 11:50:54 PM »
depending on why you want to delete it you can always just hide it by right clicking its tab
I know I can jus hide the cell but I want to know I there is a way that I can delete it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7355
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: microsoft word-excel- office
« Reply #211 on: November 20, 2013, 11:57:53 PM »
You can still only check one cell at a time I want to make sure that the whole tab is not linke to anywhere else in the workbook.
select all. Then trace.

Offline yuneeq

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jan 2013
  • Posts: 8633
  • Total likes: 4043
  • DansDeals.com Hat Tips 10
  • Gender: Male
    • View Profile
  • Location: NJ
Re: microsoft word-excel- office
« Reply #212 on: November 21, 2013, 12:26:56 AM »
Bubbles and CBC thanks for your answers. Can't believe it was so much easier than I thought.

Bubbles thanks for the offer to email you. I figured since I started to use excel recently, my questions to you could be numerous, so it could be wise to annoy everyone collectively ;)
Visibly Jewish

Offline meshugener

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Feb 2012
  • Posts: 6887
  • Total likes: 62
  • DansDeals.com Hat Tips 4
  • Gender: Female
    • View Profile
  • Location: DDF
  • Programs: Amex Platinum, Chase Freedom 10X10 Exclusives, Avis Presidents Club, National Executive, Hertz 5 Star, Hilton Gold, Accor Platinum, Hyatt Platinum, Marriott Silver, SPG Gold, Club Carlson Gold
Re: microsoft word-excel- office
« Reply #213 on: November 21, 2013, 08:34:22 AM »
Is there a way to search for duplicate entries on a sheet?
Love me or hate me. I still love you.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7355
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: microsoft word-excel- office
« Reply #214 on: November 21, 2013, 08:41:14 AM »

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7355
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: microsoft word-excel- office
« Reply #215 on: November 21, 2013, 08:43:19 AM »
Is there a way to search for duplicate entries on a sheet?
Data, filter, advanced, unique records.

Offline meshugener

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Feb 2012
  • Posts: 6887
  • Total likes: 62
  • DansDeals.com Hat Tips 4
  • Gender: Female
    • View Profile
  • Location: DDF
  • Programs: Amex Platinum, Chase Freedom 10X10 Exclusives, Avis Presidents Club, National Executive, Hertz 5 Star, Hilton Gold, Accor Platinum, Hyatt Platinum, Marriott Silver, SPG Gold, Club Carlson Gold
Re: microsoft word-excel- office
« Reply #216 on: November 21, 2013, 09:04:01 AM »
Thanks
Love me or hate me. I still love you.

Offline Feivish

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: May 2013
  • Posts: 806
  • Total likes: 2
  • DansDeals.com Hat Tips 2
    • View Profile
Re: microsoft word-excel- office
« Reply #217 on: November 21, 2013, 09:17:46 AM »
Is there a way to search for duplicate entries on a sheet?
Highlight complete sheet. On the ribbon home tab click Conditinal Formatting, in the drop down click Hightlight Cell Rules than click Duplicate Value, that will give you a option to Hightlight all the duplicate entries.
You can also do it manually through Find and Replace (Ctrl + H).

Offline Centro

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2012
  • Posts: 2935
  • Total likes: 8
  • DansDeals.com Hat Tips 33
  • Gender: Male
    • View Profile
Re: microsoft word-excel- office
« Reply #218 on: December 01, 2013, 12:27:01 PM »
Can anyone help me with this;

I wanna type a few pages of two sentences pare page,
I Want it to be
#1. Page should be vertical.
#2. Set to be printed on a bigger size page.
#3. Letter size should be the largest the page can take.

Any help would be greatly appreciated.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7355
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: microsoft word-excel- office
« Reply #219 on: December 01, 2013, 12:29:57 PM »
Can anyone help me with this;

I wanna type a few pages of two sentences pare page,
I Want it to be
#1. Page should be vertical.
#2. Set to be printed on a bigger size page.
#3. Letter size should be the largest the page can take.

Any help would be greatly appreciated.
go to page layout, select landscape. You can change page size in that tab.