ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Tab Stops (https://www.excelbanter.com/excel-programming/327916-tab-stops.html)

brentm

Tab Stops
 
Does anyone know how to set a spreadsheet to only tab to certain cells in a
given row? For example, in row 1, I want user input in cells B1, D1 & G1.
Can I make it so that on row 1, it automatically tabs just to these cells? I
still want the other cells viewable. Thanks.

BrentM

Charlie

Tab Stops
 
You can lock the cells (or entire column) and then protect the workbook.
Menu Format--Cells... ProtectionTab, Menu Tools--Protection--Protect Sheet

"brentm" wrote:

Does anyone know how to set a spreadsheet to only tab to certain cells in a
given row? For example, in row 1, I want user input in cells B1, D1 & G1.
Can I make it so that on row 1, it automatically tabs just to these cells? I
still want the other cells viewable. Thanks.

BrentM


Bob Phillips[_6_]

Tab Stops
 
See http://www.xldynamic.com/source/xld.xlFAQ0008.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"brentm" wrote in message
...
Does anyone know how to set a spreadsheet to only tab to certain cells in

a
given row? For example, in row 1, I want user input in cells B1, D1 & G1.
Can I make it so that on row 1, it automatically tabs just to these cells?

I
still want the other cells viewable. Thanks.

BrentM





All times are GMT +1. The time now is 08:37 AM.

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