How-tos - Sharing Tips and Tutorials for Microsoft Office

Here we share the tips and tricks we know about Microsoft Office. It's sharing all those things that we learn and experience along the way of developing Office add-ins and using Microsoft Office.

{tab title="Latest Articles" class="blue"} {tab title="Most Read" class="green"} {tab title="Latest Commented" class="orange"}
bennynkadimeng79 1 days ago Quickly find numbers based on criteria in Excel
How to calculate odds and even numbers from lottery patterns in a cell

cool 1 days ago How to prevent Outlook from deleting meeting request when responding?
its greyed out for me . i'm unable to check the box. anyone else running into this issue ?? Please advise.

dsuspanic 1 days ago How to concatenate first letters of names/cells in Excel?
thanks for the info. how do you account for multiples of the same initials and can you write a formula to account for them? in other words, joe smith and john smyth, can you have some formula that uses a modified version of =CONCATENATE(LEFT(A2,1),".",LEFT(B2,1),"."), but also make initials for J.S.1, J.S.2 and then you can apply this to all rows?
Boaz 1 days ago How to prevent attendees from forwarding Outlook meeting?
From all the other posts and videos on this topic, this is the only one that really works.
Thank you
David 1 days ago How to concatenate first letters of names/cells in Excel?
thanks for the info. how do you account for multiples of the same initials and can you write a formula to account for them? in other words, joe smith and john smyth, can you have some formula that uses a modified version of =CONCATENATE(LEFT(A2,1),".",LEFT(B2,1),"."), but also make initials for J.S.1, J.S.2 and then you can apply this to all rows?

John 1 days ago How to count the page numbers of Pdf files in Excel?
is there a way to include .doc I noticed that it works for .docx but not .doc
Nela 1 days ago How to multiply hours and minutes by an hourly rate in Excel?
@Christine24 is the hours

PJ 1 days ago How to quickly create multiple sheets with same format in Excel?
I created a file that contains 12 sheets, one for each month. Each month should have the same page format. I finished decorating my page but when I look at each sheet, I realize that only January, March, July, and September were modified. Why did this happen? How do I fix it?
ashish_1794 1 days ago How to auto populate date in cell when adjacent cell is updated in Excel?
I do not want to enter date but a constant value in the cell, eg: a number or a text string. please suggest the code changes for the same.

Thanks
Abbey 2 days ago How to create your own search box in Excel?
hi! I used the basic highlight search bar, but am having a couple of issues. it is predicting my search and finding it with no issues... however, it always highlights the cell a couple below or above the searched one. Are you able to help me with this please?

{tab title="Most Commented" class="red"}
{/tabs}