How To Go Directly To the Desired Worksheet In MS Excel (Tip)

First of all, Do you know How to Count the Number of Worksheets in the MS Excel? Read my previous Tip to Count Number of Worksheets in MS Excel.


Now coming directly to the Tip. We have more Number of Worksheets in the Workbook, it is very difficult to reach directly to the Desired Worksheet. We have a Small Trick to reach the same by following below Steps.


How?


'Right Click' on the any of the Backward or Forward Worksheet Buttons. Then you can find First 15 Worksheet Names and followed by 'More Sheets..' Option. If you Click 'More Sheets..' then Active box will appear, which has All Active Worksheets in the Workbook. You can Click any of the Worksheet Name to go directly to that Desired Worksheet.

Formula To Count The Number Of Sheets In The Excel Workbook (Version 2003 And Below)

In fact, MS Excel doesn't have any Straight Formula to Count the Number of Sheets in the Workbook. But, we have Indirect Way to Count the same.

HOW?

First we need to "Define Name" by Referring to =GET.WORKBOOK(1)&T(NOW())

Then, Use the below Formula to Count the Number of Sheets

=COUNTA(INDEX(DEFINED NAME,0))

This is the formula to change DD.MM.YY format to MM-DD-YY

   The following is the simple formula to change the DD.MM.YY Date Format to MM-DD-YY. In 2007 and above excel versions you can change the same through the Format Option (Right Click, Format, under Number tab, click Date).


But you can't use the DD.MM.YY format in 2003 and below Excel versions for different date formats. For that you need to first change the date format to MM-DD-YY then use the format option for different date formats.