Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have created a document that includes some merged cells.
Here is what I have: -------- Merged cells (Info need to be typed here) -------- Merged cells (Info needs to be typed here) The body is the full spread sheet with drop down validation on each column. -------- Merged cells (info needs to be typed here. -------- Merged cells (info need to be typed here. I have locked the entire document, EXCEPT for the merged cells and the body where the user needs to input their info. I would like the user to be able to tab thru the document, but the tabs only work for the body of the document. What can I do to this so the user can start at the top and tab down thru the the merged cells throught the entire spreadsheet. Thank You. Debbie Lower |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
While working on the spreadsheet last night, I discovered
that if I uncheck the "Hide Gridlines" box in options, the tab and enter feature would work. I guess my only option is to show the gridlines if I want the users to be able to tab through the form. Does anyone have any other idea's on how to Hide the gridlines and still be able to tab through the form? Thanks! -----Original Message----- I have created a document that includes some merged cells. Here is what I have: -------- Merged cells (Info need to be typed here) -------- Merged cells (Info needs to be typed here) The body is the full spread sheet with drop down validation on each column. -------- Merged cells (info needs to be typed here. -------- Merged cells (info need to be typed here. I have locked the entire document, EXCEPT for the merged cells and the body where the user needs to input their info. I would like the user to be able to tab thru the document, but the tabs only work for the body of the document. What can I do to this so the user can start at the top and tab down thru the the merged cells throught the entire spreadsheet. Thank You. Debbie Lower . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy paste non merged to merged cells | Excel Worksheet Functions | |||
Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
Make merged cells a feature that can be used in a shared workbook | Excel Worksheet Functions | |||
how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions |