Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-22-2020, 07:29 AM
andiekit andiekit is offline Drop-down lists - can you change the measurements of them? Windows 10 Drop-down lists - can you change the measurements of them? Office 2016
Advanced Beginner
Drop-down lists - can you change the measurements of them?
 
Join Date: Sep 2019
Posts: 45
andiekit is on a distinguished road
Default Drop-down lists - can you change the measurements of them?

Hi all, I've just created my first drop-down list and added it to a table.



Only thing is that the depth of the row is very deep - far deeper than the other cells in the row.

Is there any way to make it less deep?

Thanks,

Andie xxx

PS drop-down list is in the "major nonconformity" cell, pictured.
Attached Images
File Type: jpg dropdown2.JPG (27.8 KB, 15 views)

Last edited by andiekit; 01-23-2020 at 02:45 AM.
Reply With Quote
  #2  
Old 01-22-2020, 12:11 PM
Charles Kenyon Charles Kenyon is offline Drop-down lists - can you change the measurements of them? Windows 10 Drop-down lists - can you change the measurements of them? Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Try attaching the file without confidential information.
Reply With Quote
  #3  
Old 01-22-2020, 02:15 PM
macropod's Avatar
macropod macropod is offline Drop-down lists - can you change the measurements of them? Windows 7 64bit Drop-down lists - can you change the measurements of them? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by andiekit View Post
Hi all, I've just created my first drop-down list and added it to a table.

Only thing is that the depth of the row is very deep - far deeper than the other cells in the row.

Is there any way to make it less deep?
Only by having fewer items in it...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 01-23-2020, 02:31 AM
andiekit andiekit is offline Drop-down lists - can you change the measurements of them? Windows 10 Drop-down lists - can you change the measurements of them? Office 2016
Advanced Beginner
Drop-down lists - can you change the measurements of them?
 
Join Date: Sep 2019
Posts: 45
andiekit is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
Try attaching the file without confidential information.
Sorry, what confidential information?
Reply With Quote
  #5  
Old 01-23-2020, 02:45 AM
andiekit andiekit is offline Drop-down lists - can you change the measurements of them? Windows 10 Drop-down lists - can you change the measurements of them? Office 2016
Advanced Beginner
Drop-down lists - can you change the measurements of them?
 
Join Date: Sep 2019
Posts: 45
andiekit is on a distinguished road
Default

PS Ah, I see. OK, sorted. So is there any way to reduce the amount of space around the text in the drop-down box?
Reply With Quote
  #6  
Old 01-23-2020, 02:48 AM
andiekit andiekit is offline Drop-down lists - can you change the measurements of them? Windows 10 Drop-down lists - can you change the measurements of them? Office 2016
Advanced Beginner
Drop-down lists - can you change the measurements of them?
 
Join Date: Sep 2019
Posts: 45
andiekit is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Only by having fewer items in it...
There are four items in the list - and there really need to be four for this drop-down. So no way around the issue then? Thanks for replying.
Reply With Quote
  #7  
Old 01-23-2020, 03:10 AM
andiekit andiekit is offline Drop-down lists - can you change the measurements of them? Windows 10 Drop-down lists - can you change the measurements of them? Office 2016
Advanced Beginner
Drop-down lists - can you change the measurements of them?
 
Join Date: Sep 2019
Posts: 45
andiekit is on a distinguished road
Default

PS Sorted. I just recreated that row and all was fine. No idea why it was happening in the first place, but all well now.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop-down lists - can you change the measurements of them? Drop down lists and pulling data from worksheet based on drop down selection cjoyce73 Excel 5 07-17-2017 07:40 AM
Drop-down lists - can you change the measurements of them? Help w/ Drop Down Lists jbd21 Excel 6 01-11-2017 12:59 AM
Drop-down lists - can you change the measurements of them? Drop down lists options inq80 Excel 2 10-17-2014 08:05 AM
Drop-down lists - can you change the measurements of them? exact measurements for tables lolaukey Word Tables 3 08-29-2012 09:16 PM
Drop Down Lists Browett Excel 0 12-19-2005 04:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft