How-Tos - Sharing Tips and Tutorials for Microsoft Office

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.

Latest Articles

Latest Commented

skyyang 6 hours ago How to generate all combinations of 3 or multiple columns in Excel?

@NikhilHello, Nikhil,

For getting all combinations from 5 columns, may be the below VBA code can help you, please change the cell references to your data.

Sub ListAllCombinations() 'Updateby Extendoffice Dim xDRg1, xDRg2, xDRg3, xDRg4, xDRg5 As Range Dim xRg As Range Dim xStr As String Dim xFN1, xFN2, xFN3, xFN4, xFN5 As Integer Dim xSV1, xSV2, xSV3, xSV4, xSV5 As String Set xDRg1 = Range("A2:A7") 'First column data Set xDRg2 = Range("B2:B7") 'Second column data Set xDRg3 = Range("C2:C7") 'Third column data Set xDRg4 = Range("D2:D7") 'Fourth column data Set xDRg5 = Range("E2:E7") 'Fifth column data xStr = "-" 'Separator Set xRg = Range("H2") 'Output cell For xFN1 = 1 To xDRg1.Count xSV1 = xDRg1.Item(xFN1).Text For xFN2 = 1 To xDRg2.Count xSV2 = xDRg2.Item(xFN2).Text For xFN3 = 1 To xDRg3.Count xSV3 = xDRg3.Item(xFN3).Text For xFN4 = 1 To xDRg4.Count xSV4 = xDRg4.Item(xFN4).Text For xFN5 = 1 To xDRg5.Count xSV5 = xDRg5.Item(xFN5).Text xRg.Value = xSV1 & xStr & xSV2 & xStr & xSV3 & xStr & xSV4 & xStr & xSV5 Set xRg = xRg.Offset(1, 0) Next Next Next Next Next End ...

Nikhil 13 hours ago How to generate all combinations of 3 or multiple columns in Excel?

HOw to do below formula for 5 columns? Trying to figure out but its giving error

=IFERROR(INDEX($A$2:$A$4,INT((ROW(1:1)-1)/((COUNTA($B$2:$B$6)*(COUNTA($C$2:$C$5)))))+1)&"-"&INDEX($B$2:$B$6,MOD(INT((ROW(1:1)-1)/COUNTA($C$2:$C$5)),COUNTA($B$2:$B$6))+1)&"-"&INDEX($C$2:$C$5,MOD((ROW(1:1)-1),COUNTA($C$2:$C$5))+1),"")

Ivana 1 days ago How to automatically link a cell color to another in Excel?

Hy,
I would like that when I manually change the color in column A sheet1 to automatically change the color in column A sheet2.
I'm asking for help. Thank you

Awad 1 days ago How to collapse or expand all groups in Outlook?

Thanks,,,i want to expand all conversation including sent in my expand list...please guide

Gordon 3 days ago How to apply color gradient across multiple cells?

Hello, Can you apply this to a range like 1 to 5 , cells having a number in them, having the 5 as the darkest ?

Would Kutools be able to do a little similar to above , but then arrange a row of numbers into a scale - not good at explaining. Say a survey answering on a scale of 1 to 5 , then graphical show one bar per question showing percent of answers in 1, 2 ,3 ,4 ,5 ; 5% 1's, 10% 2's 15% 3's and 50% 4's , 20% 5's but showing a gradient of colours in a horizontal bar (better if 2 colours).

Thanks , Gord

CJ 3 days ago How to vlookup and return whole / entire row of a matched value in Excel?

Also, I am unable to set up an account (tried twice and got an error twice) and cannot post a screenshot as a guest.

CJ 3 days ago How to vlookup and return whole / entire row of a matched value in Excel?

I've tried to replicate this table just as you had it but the formula does not work, what gives?

Jeffrey Scott 3 days ago How to lock or unlock cells based on values in another cell in Excel?

If my first column has strings can I lock that row specifically to the first column, where when I do a sort the full row will stay together on the sort?

ramy 3 days ago How to copy and paste cell sizes (column widths and row heights) in Excel?

Thanks for this feature

Please , I want to know how to copy range and paste in multiple sheets at once instead of pressing copy range evert time i want to copy

Thanks

Josh 3 days ago How to change the author name for comment in Word

I am very grateful for this information. The VBA codes works Perfectly on a document I don't want the writer to know who the reviewer is yet.

Thanks.