ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to use Tab in Excel (https://www.excelbanter.com/excel-worksheet-functions/78290-how-use-tab-excel.html)

sadath

How to use Tab in Excel
 

Hello :)

Can anyone suggest me, how to go to a specific cell, when i hit the TAB
Key.

Thanx in Advance

SADATh :)


--
sadath
------------------------------------------------------------------------
sadath's Profile: http://www.excelforum.com/member.php...o&userid=32603
View this thread: http://www.excelforum.com/showthread...hreadid=524015


paul

How to use Tab in Excel
 
select all the cells you want to be able to tab to,then right click whilst
still holding ctrl down and select format cell,protection,and untick the
locked box,release ctrl,go to tools,protection,protect sheet,when you press
tab the curor will jump to the nearest unlocked cell.
--
paul
remove nospam for email addy!



"sadath" wrote:


Hello :)

Can anyone suggest me, how to go to a specific cell, when i hit the TAB
Key.

Thanx in Advance

SADATh :)


--
sadath
------------------------------------------------------------------------
sadath's Profile: http://www.excelforum.com/member.php...o&userid=32603
View this thread: http://www.excelforum.com/showthread...hreadid=524015



sadath

How to use Tab in Excel
 

Paul

Thank you for your solution,

Cheers

SADATH


--
sadath
------------------------------------------------------------------------
sadath's Profile: http://www.excelforum.com/member.php...o&userid=32603
View this thread: http://www.excelforum.com/showthread...hreadid=524015



All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com