microsoft word-excel- office

[DanH]

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.

[DanH]

Anyone that needs help with this or similar type of things should be using PM - it's not appropriate for public board.

[yuneeq]

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

[EJB]

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

[bubbles]

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

[churnbabychurn]

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

[Blazer]

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

[aygart]

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

[churnbabychurn]

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.

[Blazer]

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.

[Blazer]

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.

[churnbabychurn]

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.

[yuneeq]

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

[meshugener]

Is there a way to search for duplicate entries on a sheet?

[churnbabychurn]

select all. Then trace.

doesnt work

[churnbabychurn]

Is there a way to search for duplicate entries on a sheet?

Data, filter, advanced, unique records.

[meshugener]

Thanks

[Feivish]

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

[Centro]

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.

[churnbabychurn]

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.