close

I have created a spreadsheet with pull down menus, I have forgotten some
information that needs to be put in the pull down, how to I fix that ?


put cursor in the cell with the menu
go to Data tab,
Validation
settings
it will tell you where your information is located.
go to that area, insert your new info and then make sure you change the
cell range in the Data box (Validation window)--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: www.excelforum.com/member.php...oamp;userid=24677
View this thread: www.excelforum.com/showthread...hreadid=513348

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()