Excel2級攻略法2

時間短縮の技を簡略的に説明します。

 

可視セルのコピー

1.コピーしたいセル範囲を選択

2.”Alt”+”;”(セミコロン)

3.コピー

 

●関数入力中に英数入力のまま名前付けした範囲を入力する

1. “F3”を押す

2.””(矢印キー)で選択

3.”Enter”で入力

●左右どちらかのデータがある行までコピー

1.セルを選択

2.右下の■をダブルクリック

 

●行数が多い範囲の選択

1.選択したい範囲の一番上のセルを選択

2.”Ctrl”+”Shift”+”” (矢印キー)で下のデータのあるところまで選択

”Ctrl”+”Shift”+”” (矢印キー)で右のデータのあるところまで選択)

 

●バブルチャート等、手動でのデータ選択が必要な場合

手動でのデータ選択の場合、” ={1}”のせいで選択が大変だと思ってる人向け

“Tab”を使って移動すれば簡単にデータ選択が可能

例:系列名選択→“Tab”→系列Xの値選択→“Tab”→系列Yno値選択→“Tab”→系列のバブルサイズ選択

●グラフ・図形の書式設定画面は毎回閉じる必要はない(Word使用可)

例:図形1の書式設定が終わったら書式設定画面を閉じずに、図形2を選択すると図形1の書式設定がそのまま行える

 

名もなき冒険者

コメントをお書きください

コメント: 12
  • #1

    Cheryl Hatchell (木曜日, 02 2月 2017 01:42)


    Pretty portion of content. I just stumbled upon your blog and in accession capital to claim that I get actually loved account your blog posts. Anyway I'll be subscribing to your augment and even I achievement you get admission to persistently quickly.

  • #2

    Brooke Sinha (木曜日, 02 2月 2017 18:31)


    We are a group of volunteers and starting a new scheme in our community. Your web site offered us with valuable information to work on. You have done an impressive job and our entire community will be grateful to you.

  • #3

    Jada Alejo (木曜日, 02 2月 2017 18:49)


    You ought to take part in a contest for one of the finest websites online. I most certainly will highly recommend this blog!

  • #4

    Wonda Iversen (土曜日, 04 2月 2017 01:26)


    I am now not certain where you're getting your info, but good topic. I must spend a while learning more or working out more. Thanks for excellent information I used to be on the lookout for this information for my mission.

  • #5

    Carry Tubb (土曜日, 04 2月 2017 18:19)


    I constantly spent my half an hour to read this webpage's articles daily along with a mug of coffee.

  • #6

    Erminia Correia (土曜日, 04 2月 2017 22:09)


    I'm not sure where you're getting your info, but great topic. I needs to spend some time learning more or understanding more. Thanks for fantastic info I was looking for this info for my mission.

  • #7

    Jenise Linsley (日曜日, 05 2月 2017 13:45)


    Saved as a favorite, I really like your site!

  • #8

    Kelsie Hermanson (月曜日, 06 2月 2017 02:52)


    Please let me know if you're looking for a writer for your weblog. You have some really great posts and I think I would be a good asset. If you ever want to take some of the load off, I'd absolutely love to write some content for your blog in exchange for a link back to mine. Please shoot me an email if interested. Thank you!

  • #9

    Vickie Silveira (月曜日, 06 2月 2017 20:22)


    I�m not that much of a online reader to be honest but your sites really nice, keep it up! I'll go ahead and bookmark your website to come back later. All the best

  • #10

    Makeda Foret (水曜日, 08 2月 2017 17:08)


    Hello friends, its enormous post regarding tutoringand fully defined, keep it up all the time.

  • #11

    Hobert Brundige (木曜日, 09 2月 2017)


    Hi there! I understand this is sort of off-topic however I had to ask. Does managing a well-established blog such as yours take a lot of work? I'm completely new to running a blog but I do write in my journal daily. I'd like to start a blog so I will be able to share my personal experience and views online. Please let me know if you have any suggestions or tips for brand new aspiring bloggers. Appreciate it!

  • #12

    Isis Rusin (木曜日, 09 2月 2017 21:14)


    Hi there, I found your blog by way of Google at the same time as looking for a similar matter, your web site got here up, it seems to be great. I've bookmarked it in my google bookmarks.
    Hello there, just changed into alert to your blog via Google, and located that it is truly informative. I am gonna watch out for brussels. I'll be grateful when you continue this in future. Numerous folks might be benefited out of your writing. Cheers!

ひまわり工房へのお問合せ

石川県小松市園町ハ36番地1

小松織物会館1F

 

ひまわり工房

 

TEL:0761-24-3313

 

月曜日~金曜日

9:00~17:15

 

お問合わせはこちらから