ใครทำ EXCEL เป็นช่วยตอบคำถามหน่อยค่ะ (เรียบร้อยแล้วขอบคุณค่ะ)

[pat_meaw]

ใครเซียน Excel ช่วยบอกหน่อยได้ไหมคะว่า ทำไม่ถึง Insert cells แล้วมันฟ้องขึ้นมาแบบนี้

ไม่สามารถ Insert copy หรือวางอะไรได้เลย ไม่เคยเจออ่ะค่ะ ไม่รู้ไปทำอะไรผิดไว้   

[Ernestino]

Excel seems to think that you have information all the way down in row 65,536.  Figure out what your REAL last row of data is.  Highlight the next row down from that REAL last row all the way down to row 65,536.  Delete those rows and save your workbook. Now you should be able to insert.

[j_nobita]

goto cell IV65536
click delete

finish

[Ernestino]

goto cell IV65536
click delete

finish

If you can't find anything in the last row (press control + down arrow
to jump there, then start at column A and work across) then the easiest
way is to go to the last row you know you have data in, select all the
rows below it by holding the mouse button on the number of the first
empty row then dragging down, then choosing Edit->Delete.

[civicrx_nfs]

thank you teacher  see you again on tomorrow

may i go to toilet please ? 

[pat_meaw]

Thank you all ka

Done 

[pat_meaw]

when already done, it seems affects the scroll bar (too small)

my worksheet had all columns used (A1 to IV65536)

[civicrx_nfs]

good evening 

[pat_meaw]

good evening 

 

[taxman : ปทุมธานี]

เค้าทำอะไรกันหรอคับ   

[j_nobita]

ok I have 2 choice for you

1. Resize view from 100% to 75% or some value that you can see .
2. used separate command ( windows>>separate ) to separate detail column and data column

Is it ok ?

[pat_meaw]

ok I have 2 choice for you

1. Resize view from 100% to 75% or some value that you can see .
2. used separate command ( windows>>separate ) to separate detail column and data column

Is it ok ?

1. about 300 row and (A - AZ) column used ,can't see all table.
2. not work ka. T.T

[j_nobita]

1. about 300 row and (A - AZ) column used ,can't see all table.
2. not work ka. T.T

 :'( :'( :'(

[j_nobita]

Ok I have new idea

1. use view by full screen view
excel command >> view >> full screen

2. Order new monitor from 17" to 30 "

 

[Ernestino]

Ok I have new idea


2. Order new monitor from 17" to 30 "

 

 :'( :'( :'( :'(

[pat_meaw]

Ok I have new idea

1. use view by full screen view
excel command >> view >> full screen

2. Order new monitor from 17" to 30 "

 

Could you pay to get a new monitor for me 555+

i got it.
Create a new worksheet,
then go back to the Data worksheet and copy and paste the data in the new worksheet.

There are some problems can't solve.



Thank you for your help ka. 

[masaru]

       :'(

[@GuY]

civic  โกอินเตอร์แล้วฟุ้ยยยย

[Uncle_T]

ใครว่าง ๆ ช่วยบอกลุงหน่อย เมืองไทย ไปทางไหนคร๊าบบบบบ...หายไป 2-3 วัน กลับมา เขาคุยอารายกันก็ม่ายรู้อ่ะ ... อิอิอิ

[Ernestino]

ฟุด ฟิด ฟอ ฟายยยยยยยยยยยยยยยยยยยยยยยยยยยยยย

[jojo-civic 96]

 เป็นกระทู้แรกนับจากที่เคยดูและขุดมานาน ที่มีการสนทนาภาษาอังกฤษมากที่สุด 

[thailiv]