excel±í¸ñÔõôÉèÖÃÐÐÁÐÊý

ÒѾٱ¨ »Ø´ð
excel±í¸ñÔõôÉèÖÃÐÐÁÐÊý
ÎÊÔÚÏß¿Í·þ
ɨÂëÎÊÔÚÏß¿Í·þ
  • »Ø´ðÊý

    4

  • ä¯ÀÀÊý

    2,335

4¸ö»Ø´ð ĬÈÏÅÅÐò
  • ĬÈÏÅÅÐò
  • °´Ê±¼äÅÅÐò

ÒѲÉÄÉ
excel¹¤×÷±íµÄ65536ÐÐ*256ÁÐÊǸö¹Ì¶¨µÄÊý£¬²»ÄÜ×Ô¼ºÉèÖᣵ«¿ÉÒÔ²»Ê¹ÓöàÓàµÄÇøÓò£º
1¡¢Òþ²Ø¶àÓàµÄÐкÍÁС£ÔÚÃû³Æ¿ò(±à¼­¿ò×ó²à)ÖÐÊäÈë101:65536£¬»Ø³µ£¬È»ºóµã»÷²Ëµ¥¡°¸ñʽ¡ªÐСªÒþ²Ø¡±£¬Í¬Ñù¿ÉÒÔÒþ²Ø¶àÓàµÄÁС£
2¡¢µ¥Ôª¸ñĬÈÏÊÇ¡°Ëø¶¨¡±µÄ£¬Ñ¡ÔñҪʹÓõÄÇøÓòA1:AX100£¬ÉèÖõ¥Ôª¸ñ¸ñʽ£¬È¡Ïû¡°Ëø¶¨¡±£¬È»ºóÑ¡Ôñ¡°¹¤¾ß¡ª±£»¤¹¤×÷±í¡±£¬Èç¹ûÊÇExcel2003ÒÔÉÏ°æ±¾£¬¿ÉÒÔ×Ô¶¨Òå±£»¤·½Ê½£¬ÆäÖС°Ñ¡¶¨Ëø¶¨µ¥Ôª¸ñ¡±È¡ÏûËü¡£
3¡¢´ò¿ª¡°ÊÓͼ¡ª¹¤¾ßÀ¸¡ª¿Ø¼þ¹¤¾ßÏ䡱£¬µã»÷¡°ÊôÐÔ¡±°´Å¥£¬ÔÚScrollAreaÐÐÖÐÊäÈëÔÊÐíʹÓõĵ¥Ôª¸ñµØÖ·£ºA1:AX100£¬Õâʱ£¬ÆäËüÇøÓò±ã´¦ÓÚ½ûֹʹÓÃ״̬¡£ÔÚ¹¤¾ß¡ªÑ¡ÏîÖв»¹´Ñ¡¡°Íø¸ñÏß¡±£¬¶àÓàÇøÓò¾ÍÏñûÓÐËüÒ»Ñù¡£
È¡Ïû ÆÀÂÛ
²åÈëºó¿ÉÒÔÔÙÀ­¶àµÄ£¬ËùÒԲ̫¶à¾ÍÐÐ
È¡Ïû ÆÀÂÛ
Èçͼ

Êó±êµãÔÚ C6µ¥Ôª¸ñÉÏ£¬È»ºóͬʱ°´¼üÅÌ Alt ºÍ+ = ¼ü£¬OK¡¡À²£¡
È¡Ïû ÆÀÂÛ
ÒªÕ³ÌùµÄµ¥Ôª¸ñºÍsheetÊÇ·ñÓйæÂÉ£¬ÄÜ·ñʹÓÃÑ­»·»òÕßÅжÏÓï¾äÅжϳöÀ´£¬»¹ÊÇÒªÓÃÈËÈ¥ÈâÑÛ¿´µÄ£¿
È¡Ïû ÆÀÂÛ
ZOLÎÊ´ð > excel±í¸ñÔõôÉèÖÃÐÐÁÐÊý

¾Ù±¨

¸ÐлÄúΪÉçÇøµÄºÍг¹±Ï×Á¦Á¿ÇëÑ¡Ôñ¾Ù±¨ÀàÐÍ

¾Ù±¨³É¹¦

¾­¹ýºËʵºó½«»á×ö³ö´¦Àí
¸ÐлÄúΪÉçÇøºÍг×ö³ö¹±Ï×

ɨÂë²ÎÓëÐÂÆ·0ÔªÊÔÓÃ
ɹµ¥¡¢¶¥Â¥ºÀÀñµÈÄãÄÃ

ɨһɨ£¬¹Ø×¢ÎÒÃÇ
Ìáʾ

È·¶¨ÒªÈ¡Ïû´Ë´Î±¨Ãû£¬Í˳ö¸Ã»î¶¯£¿