V virendar254 New Member Dec 17, 2011 #1 if there are 200 sheets in workbook, how to go to sheet 153 straight with using arrow keys to save time.
if there are 200 sheets in workbook, how to go to sheet 153 straight with using arrow keys to save time.
SirJB7 Excel Rōnin Dec 17, 2011 #2 Hi, virendar254! Try pressing and holding Ctrl-PgUp/PgDn, if there are no Worksheet_Activate events that demand processing, it lets you navigate thru the workbook really fast. Regards!
Hi, virendar254! Try pressing and holding Ctrl-PgUp/PgDn, if there are no Worksheet_Activate events that demand processing, it lets you navigate thru the workbook really fast. Regards!
N NARAYANK991 Excel Ninja Dec 17, 2011 #3 Hi , Click on the Developer button , then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip Courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
Hi , Click on the Developer button , then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip Courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
N NARAYANK991 Excel Ninja Dec 17, 2011 #4 Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
N NARAYANK991 Excel Ninja Dec 17, 2011 #5 Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
N NARAYANK991 Excel Ninja Dec 17, 2011 #6 Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
N NARAYANK991 Excel Ninja Dec 17, 2011 #7 Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
N NARAYANK991 Excel Ninja Dec 17, 2011 #8 Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
N NARAYANK991 Excel Ninja Dec 17, 2011 #9 Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
N NARAYANK991 Excel Ninja Dec 17, 2011 #10 Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan
Hi , Click on the Developer button , and then Visual Basic. You should see all your worksheets listed in the Project Explorer window. Right click on the sheet you wish to go to , and select View Object. Tip courtesy : http://www.excelforum.com/excel-new-users/564376-go-to-sheet-number.html Narayan