การเปลี่ยนตำแหน่งข้อมูลจากแนวตั้งเป็นแนวนอน

2006/Nov/22

การเปลี่ยนตำแหน่งข้อมูลจากแนวตั้งเป็นแนวนอน
มีคำถามจากผู้เข้าเรียน ว่า สามารถเปลี่ยนตำแหน่งข้อมูลจากแนวตั้งเป็นแนวนอนได้หรือไม่ เพื่อความเข้าใจว่าต้องการจะเปลี่ยนข้อมูลจากแนวตั้งเป็นแนวนอน ให้ดูที่รูปที่ 001 ครับ

เลือกย่านข้อมูล (A1:D13) -> คลิกเมาส์ขวาบนพื้นที่เลือกไว้เพื่อเรียกเมนูคำสั่งลัด -> เลือกคำสั่ง Copy เพื่อคัดลอกข้อมูล ตามรูป 002

จากนั้นให้เลือกทีเซลล์ ที่ต้องการจะวางข้อมูล (F4) -> คลิกเมาส์ขวาบนเซลล์ (F4)เพื่อเรียกเมนูคำสั่งลัด -> เลือกคำสั่งPaste Special... เพื่อวางข้อมูลที่คัดลอกไว้ ตามรูป 003

ในหน้าต่าง Paste Special ให้เลือก (เช็คถูก) ที่คำสั่ง Transpose -> เลือกปุ่ม OK ตามรูปที่ 004

เราก็จะได้ข้อมูลในแนวนอน ดังรูปที่ 005 ตามต้องการแล้วครับ

แจ้งปัญหาการใช้งาน OpenOffice.org ได้ที่ sridetch.p@egat.co.th

edit @ 2006/11/22 23:34:57
edit @ 2006/11/24 14:33:11

edit @ 3 Jul 2010 20:29:16 by BigTUI ^_^

tag: calc, copy, excel, oo, openoffice, org, paste, speacial, ตารางคำนวน
posted by bigtui, at 2006-Nov-22 22:30:2590

Bright colors, exquisite workmanship, durable material and up-to-date style all lead to the great fame of the goods in Coach Outlet.

#1 by coach outlet (98.126.141.12) At 2011-08-22 08:00,

That is in case you are looking for authentic Coach Purses. In case you are wanting a fake Coach Tote or a replica Coach Tote, then you may find them elsewhere for less.

#2 by coach purses (98.126.141.12) At 2011-08-22 08:42,

Here you can find the latest products in different kinds of Coach Bags making best materials.They are leisure practical products in the new generations.

#3 by coach bags (120.32.217.184) At 2011-08-22 13:04,

By the fashion, novel appearance, sophisticated technology, superior quality, Coach Outlet won domestic and international customers, their products exported to the Middle East, Southeast Asia and other regions.

#4 by coach outlet (120.32.217.184) At 2011-08-22 13:32,

Bright colors, exquisite workmanship, durable material and up-to-date style all lead to the great fame of the goods in Coach Outlet.

#5 by coach outlet (120.32.217.184) At 2011-08-22 14:12,

Here is a world of louis vuitton outlet where you can find all kinds of new style and fashion Louis Vuitton bags. We really want to lead the trend and let our customer in the pursuit of luxury and fashion, satisfied the needs of customers.

#6 by louis vuitton outlet (120.32.217.184) At 2011-08-22 14:35,

Coach Outlet Online Store guarantee that all the coach handbags offered are own high quality.

#7 by coach outlet (120.32.217.184) At 2011-08-22 14:52,

The Coach Factory Outlet has been in business for many years. You can log in to find more information about its products and services.If people began to create a certain coach handbags, this fashionable line will be a coach.

#8 by coach outlet (120.32.217.184) At 2011-08-22 14:58,

coach outlet store have Coach handbags,Coach Shoulder Bags,Coach Briefcases and so on,these bags are so perfectly reproduced,you won't even be able to tell the difference!

#9 by coach outlet (120.32.217.184) At 2011-08-22 15:06,

Louis vuitton outlet online just like a person who want to show himself in front of other people, because he is confident enough, he can attain the respect of other people.

#10 by louis vuitton outlet (120.32.217.184) At 2011-08-22 15:06,

Coach Factory Outlet uses graceful accessories to match the classical logo of coach, which is the best combination of coach. The handmade coach products?can make you more charming and graceful.

#11 by coach outlet (120.32.217.184) At 2011-08-22 15:11,

Louis Vuitton Outlet Online do promotion this time and all the LV goods can save much money. Choose LV, choose right!

#12 by louis vuitton outlet (120.32.217.184) At 2011-08-22 15:16,

any louis vuitton outlet New backpack features usa a function grownup overall look. Varied piece allows that it is captivated me within the approve and also further than your body.Louis Vuitton Outlet Store can be found in Shanghai and Hong Kong.

#13 by louis vuitton outlet (120.32.217.184) At 2011-08-22 15:20,

The choices are likely to be basically countless seeing that Louis Vuitton Outlet occurs with the help of completely new and also incredible concepts once in a while.louis vuitton outlet online is the method to show the confidence of our handbags.

#14 by louis vuitton outlet (120.32.217.184) At 2011-08-22 15:25,

It is a symbol regarding position not to mention nature, Here I would like to launch a excellent bags pertaining to business men, which may be Louis Vuitton Online Cupertino M56398.

#15 by louis vuitton online (96.43.136.77) At 2011-08-22 15:38,

Bags of many different models, materials and colors at the Louis Vuitton Sale outlet can be significant along with ample, nevertheless quite trendy, fantastic requirement.

#16 by louis vuitton sale (96.43.136.77) At 2011-08-22 16:01,

even you put me down,i will never give in !

#17 by cheap nfl jerseys (120.33.239.75) At 2011-08-23 16:58,

uk uggs disocunt for you!

#18 by uk uggs (120.33.239.66) At 2011-09-02 14:00,

UGG Classic Short Boots for you in uk!

#19 by ugg boots uk (120.33.239.66) At 2011-09-19 09:37,

ugg Australia outlet ugg boots online!

#20 by ugg Australia (120.33.239.66) At 2011-09-24 07:22,

louis vuitton handbags

#21 by louis vuitton handbags (222.76.180.216) At 2011-10-14 13:56,

louis vuitton bags

#22 by louis vuitton bags (222.76.180.216) At 2011-10-14 14:42,

louis vuitton uk

#23 by louis vuitton uk (69.30.254.150) At 2011-10-18 14:39,

In the past, Louis Vuitton only emphasis on classic, but in recent year, Louis Vuitton change its strategy and style to acquire new breakthrough

#24 by louis vuitton bags (120.32.219.36) At 2011-10-25 08:39,

The choices are likely to be basically countless seeing that Louis Vuitton Outlet occurs with the help of completely new and also incredible concepts once in a while.

#25 by louis vuitton outlet (120.32.219.36) At 2011-10-25 08:46,

Coach is a leading American designer and maker of luxury lifestyle handbags and accessories.There is no doubt that here Coach Factory Outlet is the exact place you should visit.coach factory outlet online featured with stylish leather bags and signature materials, and carry this bag, it can designate people seem to be captivatingly feminine and good-looking.

#26 by coach factory outlet (120.32.219.36) At 2011-10-25 08:53,

Coach Factory Outlet is famous for the discounts it offers. Latest coach purses and sunglasses can be purchased at discounted rates from this coach outlet store.Coach Factory Online is actually a stylish Coach online store to sell perfect quality and discount Coach handbags, Coach bags, Coach wallets and Cheap Coach Purse.

#27 by coach factory outlet (120.32.219.36) At 2011-10-25 08:57,

Designed in elegant curved shapes with perfect styles, Louis Vuitton Handbags of this summer will undoubtedly give you a shock.They will match all your summer dresses.

#28 by louis vuitton handbags (120.32.222.228) At 2011-10-26 13:16,

cheap uggs for you online!

#29 by cheap uggs (120.33.239.66) At 2011-10-27 10:48,

The choices are likely to be basically countless seeing that Coach Outlet occurs with the help of completely new and also incredible concepts once in a while.If you love designer fashion purses you may have come across all the coach outlet store online and accessories on Coach Factory Outlet.It's a great place to buy the items.

#30 by coach outlet (208.110.86.76) At 2011-10-31 07:46,

Such Cheap Coach Purses are the dreaming ones of lots of women. We all believe we don't say anything more again. The quality are absolutely we can guarantee.discount coach handbags, leaders and affordable for the American luxury brand known to create attractive designer coach outlet online store and accessories.

#31 by coach purses (120.32.223.71) At 2011-10-31 07:49,

Where there are women, there are bags. Where there are bags, there are coach outlet store online.

#32 by coach outlet store online (120.32.222.52) At 2011-10-31 07:51,

coach outlet online is the eldest, voice of reason, and authority of the Left 4 Dead 2 team, playing a similar role to Bill in Left 4 Dead.coach outlet store supplies customers with cheaper Coach items of authentic quality. Come to the Coach Factory Outlet to find your own kingdom of vogue.

#33 by coach outlet online (120.32.223.71) At 2011-10-31 07:59,

If you have enough leisure time, you may go to the mall or go to the Louis Vuitton franchised store to have a good look at varieties of
louis vuitton uk the diverse styles and rich colors of the purses with low cost will surely impress you a lot!

#34 by louis vuitton uk (110.80.41.166) At 2011-11-24 10:04,

Here you can find the latest products in different kinds of
coach outlet store online

making best materials.They are leisure practical products in the new generations.

#35 by coach outlet store online (110.80.41.166) At 2011-11-24 12:07,

Here you can find the latest products in different kinds of
coach outlet store online

making best materials.They are leisure practical products in the new generations.

#36 by coach outlet store online (110.80.41.166) At 2011-11-24 12:43,

All of the Beach?Jewelry on this page is made with christian louboutin sale. Also be sure to check out our Hand jewelry for a perfect match to your barefoot sandals/Nude Sandals.

#37 by christian louboutin sale (110.80.41.166) At 2011-11-24 12:46,

Remember the coach outlet provide and uniqueness for long time.

#38 by coach outlet (120.32.218.197) At 2011-11-24 13:43,

Varied piece allows that it is captivated me within the approve and also further than your body.

#39 by louis vuitton outlet (120.32.218.197) At 2011-11-24 13:45,

The gucci uk will make you the eye-catcher.

#40 by gucci uk (120.32.218.197) At 2011-11-24 13:47,

There are some practical and beautiful items for sale.

#41 by coach factory outlet online (120.32.218.197) At 2011-11-24 13:48,

hermes birkin offers you exquisite crystal jewelry.

#42 by hermes birkin (120.32.218.197) At 2011-11-24 13:48,

I heard of coach outlet online through the advertisement when I was shopping.

#43 by coach outlet online (120.32.218.197) At 2011-11-24 14:08,

This delightful fully faceted clear crystal hanging ornament at the hermes birkin will make a sparkling gift to celebrate the arrival of a new baby.

#44 by hermes birkin (213.229.64.220) At 2011-11-24 14:37,

Welcome to order Discount louis vuitton uk and lead a fashionable, luxury and elegant life from our Louis Vuitton Canada Outlet Store.

#45 by louis vuitton uk (120.32.218.197) At 2011-11-24 14:54,

The gucci uk will make you the eye-catcher. The most quality fashion jewelry design classical crystal creation makes the pendant the favorite of the fashion, gucci outlet has become necessary in everyday life of women seeking fashion and simple designs simple and elegant to look at very affordable and practical.

#46 by gucci uk (120.32.223.146) At 2011-11-25 09:59,

Make a statement of fashion and style with this opulent hermes birkin bag.

#47 by hermes birkin bag (120.32.223.146) At 2011-11-25 10:47,

Do you think you're familiar with armani watches?

#48 by armani watches (120.32.223.146) At 2011-11-25 13:21,

Shortened to armani watches is a French fashion house founded in 1854 by armani.

#49 by armani watches (120.32.223.146) At 2011-11-25 14:09,

Want to become more charming and faddish? Go to visit Louis Vuitton Outlet webpage and select the most suitable products for yourself.

#50 by louis vuitton outlet (59.60.127.84) At 2011-12-01 09:41,

<< Home

ศรีเดช ปัญจขันธ์
View full profile