Taulukon nimeäminen ja asetukset

Katso ensin ohje taulukon muotoilemisesta.

Kun taulukko on muotoiltu, sille on hyvä antaa kuvaava nimi, jotta siihen on helppo viitata laskennassa. Nimi annetaan Rakenne-valikon kohdassa Taulukon nimi. Valikon saa esiin, kun valitsee jonkin solun muotoillusta taulukosta.

Excel antaa virheilmoituksen, jos käyttäjä yrittää antaa taulukolle sellaisen nimen, joka on jo käytössä. Kuvassa nimeksi annetaan TilauksetHedelmät.

Nimissä saa käyttää kirjaimia, numeroita sekä alaviivaa. Sanat voi erotella haluamallaan tavalla tai kirjoittaa pötköön. Kaikki seuraavat ovat sallittuja nimiä:

  • TilauksetHedelmät
  • Tilaukset_hedelmät
  • tilauksethedelmät


Kuva: Taulukon nimeäminen ja asetuksetTaulukon nimeäminen ja asetukset

Taulukon kokoa on mahdollista kasvattaa tai pienentää taulukon oikeasta alakulmasta löytyvällä sinisellä kolmiolla sekä Rakenne-valikon kohdasta Muuta taulukon koko.

Taulukkoon voi halutessaan laitaa päälle myös Summa-rivin, jolla on helppo laskea sarakekohtaisesti summia, lukumääriä, keskiarvoja ja paljon muuta.


Caduseus Consulting avustaa ja kouluttaa monenlaisissa IT-tarpeissa!

Mikäli Excel-työ takkuilee ja haluatte ammattilaisapua jonkin projektin kanssa, voitte tilata asiantuntijapalvelua hintaan 45 €/h (+ alv). Kaikista toimeksiannoista voidaan antaa myös kiinteähintainen kokonaistarjous.

Katso myös hintalaskuri edullisille tilauskoulutuksille ja tilaa organisaatiollenne suosittu Excel helpoksi työelämässä-koulutus.


51 kommenttia.

  1. Lasonya

    lokakuu 4, 2020 at 06:28

    Hello, i read your blog occasionally and i own a similar
    one and i was just curious if you get a lot of spam responses?

    If so how do you protect against it, any plugin or anything you can suggest?

    I get so much lately it’s driving me mad so any
    support is very much appreciated.

  2. instagram private profile viewer

    lokakuu 5, 2020 at 19:00

    Hi there are using WordPress for your blog platform? I’m new to the blog world but I’m
    trying to get started and create my own. Do you require any html coding expertise to make your own blog?
    Any help would be really appreciated!

  3. privateinstaviewer view private instagram profiles easily

    lokakuu 5, 2020 at 23:05

    great points altogether, you simply won a new reader. What
    might you suggest in regards to your submit that you made some
    days ago? Any sure?

  4. private profile viewer

    lokakuu 6, 2020 at 01:42

    Thanks for finally writing about > blog topic < Liked it!

  5. instagram private profile viewer 2020

    lokakuu 6, 2020 at 04:46

    What a stuff of un-ambiguity and preserveness of precious know-how
    about unexpected feelings.

  6. insta private viewer

    lokakuu 6, 2020 at 07:03

    First of all I want to say wonderful blog! I had a quick question which I’d
    like to ask if you don’t mind. I was curious to know how you center
    yourself and clear your head before writing. I have had a difficult time clearing my thoughts in getting my thoughts out.

    I do take pleasure in writing but it just seems like the first 10 to 15 minutes are wasted simply just
    trying to figure out how to begin. Any recommendations or hints?

  7. privateinstaviewer view private instagram profiles easily

    lokakuu 6, 2020 at 08:01

    When I originally commented I appear to have clicked the -Notify me when new comments are added- checkbox and now
    every time a comment is added I receive four emails
    with the same comment. Perhaps there is an easy method you are able to remove me from
    that service? Appreciate it!

  8. private profile viewer

    lokakuu 6, 2020 at 10:45

    Pretty component of content. I just stumbled upon your web site and in accession capital to say that I get in fact enjoyed account your weblog posts.
    Anyway I will be subscribing on your augment and even I achievement you get right of entry to constantly fast.

  9. instagram private profile viewer 2020

    lokakuu 6, 2020 at 16:55

    Thanks for finally talking about > blog topic < Loved it!

  10. instagram private viewer

    lokakuu 6, 2020 at 19:54

    Thanks for your marvelous posting! I definitely enjoyed reading it, you might be a great author.I will
    remember to bookmark your blog and will eventually come back from now on. I want to encourage you to definitely continue your great posts, have a nice morning!

  11. private instagram viewer

    lokakuu 6, 2020 at 20:37

    Pretty! This was an incredibly wonderful post. Many
    thanks for providing this info.

  12. instagram private viewer

    lokakuu 6, 2020 at 20:43

    Thanks for finally writing about > blog topic < Loved it!

  13. private insta viewer

    lokakuu 6, 2020 at 22:23

    We are a group of volunteers and opening a new scheme in our community.
    Your site offered us with valuable information to work on. You’ve done a formidable job and our whole community will be grateful to you.

  14. private instagram viewer

    lokakuu 6, 2020 at 22:53

    These are truly great ideas in regarding blogging.
    You have touched some good factors here. Any way keep up wrinting.

  15. instagram private viewer

    lokakuu 7, 2020 at 00:20

    Hi, everything is going fine here and ofcourse every one is sharing data, that’s in fact good, keep up writing.

  16. instagram private profile viewer

    lokakuu 7, 2020 at 01:09

    Admiring the commitment you put into your blog and detailed information you
    offer. It’s awesome to come across a blog every once in a while that isn’t the same outdated rehashed information. Great read!
    I’ve saved your site and I’m including your RSS feeds to my Google account.

  17. privateinstaviewer

    lokakuu 7, 2020 at 04:12

    Greetings I am so glad I found your site, I really found you by mistake,
    while I was looking on Bing for something else,
    Regardless I am here now and would just like to say
    kudos for a tremendous post and a all round enjoyable blog (I also love the theme/design),
    I don’t have time to go through it all at the moment
    but I have book-marked it and also added in your RSS feeds, so
    when I have time I will be back to read a great deal more, Please do keep
    up the excellent job.

  18. instagram private viewer

    lokakuu 7, 2020 at 06:43

    Fastidious respond in return of this question with solid arguments and telling everything concerning that.

  19. privateinstaviewer view private instagram profiles easily

    lokakuu 7, 2020 at 08:34

    each time i used to read smaller posts that as well clear their motive, and that is also happening with this post which
    I am reading here.

  20. private insta viewer

    lokakuu 7, 2020 at 11:32

    I’d like to thank you for the efforts you’ve put in penning this site.
    I am hoping to check out the same high-grade content by you later on as well.
    In fact, your creative writing abilities has inspired me to get my own, personal blog
    now 😉

  21. privateinstaviewer.com

    lokakuu 7, 2020 at 15:22

    That is a great tip particularly to those new to the blogosphere.
    Brief but very precise information… Many thanks for sharing this one.
    A must read article!

  22. private instagram viewer

    lokakuu 7, 2020 at 18:50

    Thank you for the good writeup. It if truth be told was a enjoyment account it.
    Glance complicated to more introduced agreeable from you!
    By the way, how can we be in contact?

  23. private insta viewer

    lokakuu 7, 2020 at 21:11

    You made some good points there. I checked on the net for additional information about
    the issue and found most individuals will go along with your views on this website.

  24. private instagram viewer free

    lokakuu 7, 2020 at 23:10

    With havin so much content do you ever run into any issues of plagorism
    or copyright infringement? My site has a lot of completely unique content I’ve
    either authored myself or outsourced but it seems a lot of it is
    popping it up all over the internet without my authorization. Do you know any ways to help protect against content from being ripped off?
    I’d really appreciate it.

  25. instagram private profile viewer

    lokakuu 7, 2020 at 23:24

    Hi, yup this paragraph is really pleasant and I have learned lot of
    things from it on the topic of blogging. thanks.

  26. private instagram viewer free

    lokakuu 8, 2020 at 00:49

    If some one wants to be updated with most recent technologies therefore he must be
    pay a quick visit this website and be up to date every day.

  27. instagram private account viewer

    lokakuu 8, 2020 at 05:35

    At this time I am going to do my breakfast, after having my breakfast coming over
    again to read other news.

  28. private insta

    lokakuu 8, 2020 at 08:51

    This is a great tip especially to those new to the blogosphere.
    Simple but very accurate info… Many thanks for sharing this one.
    A must read article!

  29. Daniella

    lokakuu 8, 2020 at 17:25

    This design is steller! You obviously know how to keep a reader amused.
    Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Wonderful job.
    I really loved what you had to say, and more than that,
    how you presented it. Too cool!

  30. private instagram video download

    lokakuu 9, 2020 at 00:22

    An impressive share! I have just forwarded this onto a friend who was doing a little
    research on this. And he actually ordered me lunch due to the fact
    that I discovered it for him… lol. So allow me
    to reword this…. Thanks for the meal!! But yeah, thanx for spending the time to talk about this matter here on your web page.

  31. private instagram video downloader

    lokakuu 9, 2020 at 01:33

    of course like your web site however you have to test the spelling on quite a few of
    your posts. Many of them are rife with spelling problems and I find it very troublesome to inform the reality on the
    other hand I will definitely come back again.

  32. private instagram profile view

    lokakuu 9, 2020 at 03:33

    Hi there! Do you use Twitter? I’d like to follow you if that would be okay.
    I’m undoubtedly enjoying your blog and look forward to new posts.

  33. instagram private kullanıcı adları

    lokakuu 9, 2020 at 05:05

    Sweet blog! I found it while searching on Yahoo News.
    Do you have any suggestions on how to get listed in Yahoo News?

    I’ve been trying for a while but I never seem to get
    there! Cheers

  34. private instagram inspect element

    lokakuu 9, 2020 at 05:20

    I think the admin of this site is truly working hard for his web site, because here every information is quality based stuff.

  35. private instagram bios funny

    lokakuu 9, 2020 at 05:58

    I think the admin of this web site is actually working hard in support of his web page, since here
    every stuff is quality based material.

  36. private instagram account viewer free

    lokakuu 9, 2020 at 09:12

    Touche. Solid arguments. Keep up the great effort.

  37. private instagram image downloader

    lokakuu 9, 2020 at 09:41

    You need to be a part of a contest for one of the best sites online.
    I most certainly will recommend this web site!

  38. private instagram groups

    lokakuu 9, 2020 at 10:32

    Hey there are using WordPress for your site platform?
    I’m new to the blog world but I’m trying to get started and create my own.
    Do you need any coding knowledge to make your own blog?
    Any help would be greatly appreciated!

  39. private jet instagram

    lokakuu 9, 2020 at 12:06

    Having read this I thought it was rather enlightening. I appreciate you spending some time and energy to put this article together.
    I once again find myself spending a significant
    amount of time both reading and posting comments. But so what, it
    was still worthwhile!

  40. private instagram account bio

    lokakuu 9, 2020 at 12:15

    I do consider all of the concepts you’ve offered for your post.

    They are really convincing and can definitely work.

    Nonetheless, the posts are very short for beginners.
    May you please lengthen them a little from subsequent time?
    Thank you for the post.

  41. private instagram followed by close friends

    lokakuu 9, 2020 at 12:47

    Woah! I’m really enjoying the template/theme of this site.
    It’s simple, yet effective. A lot of times it’s hard to get that “perfect balance” between user friendliness and appearance.
    I must say you’ve done a great job with this. Additionally, the blog loads super fast for me on Safari.
    Excellent Blog!

  42. instagram private chat screenshot

    lokakuu 9, 2020 at 12:51

    Greetings! Very useful advice within this post!
    It’s the little changes which will make the greatest changes.
    Thanks for sharing!

  43. privat konto instagram bilder sehen

    lokakuu 9, 2020 at 14:19

    Excellent article. Keep posting such kind of information on your page.
    Im really impressed by your blog.
    Hello there, You have done a fantastic
    job. I will certainly digg it and in my opinion suggest to my friends.
    I am sure they’ll be benefited from this site.

  44. private instagram meme accounts

    lokakuu 9, 2020 at 14:42

    Thanks for any other magnificent article. The place else may anyone get that type of info in such a perfect means of writing?
    I’ve a presentation next week, and I am at the
    look for such information.

  45. private instagram viewer

    lokakuu 9, 2020 at 20:30

    My brother recommended I might like this web site. He was entirely right.
    This post actually made my day. You cann’t imagine just how much
    time I had spent for this info! Thanks!

  46. how to view private instagram profiles 2020

    lokakuu 9, 2020 at 22:17

    I pay a quick visit daily a few web sites and sites to read articles, except this webpage offers quality based

  47. Mitzi

    lokakuu 10, 2020 at 01:56

    I feel this is one of the most significant info for me.
    And i am glad studying your article. However want to
    observation on few basic things, The web site taste is ideal, the articles is in point of
    fact great : D. Good activity, cheers

  48. 바카라사이트

    lokakuu 14, 2020 at 04:13

    Fantastic beat ! I would like to apprentice even as you amend your website,
    how can i subscribe for a blog website? The account
    helped me a appropriate deal. I had been tiny bit familiar of this
    your broadcast offered vivid transparent concept바카라사이트



Sähköpostiosoitettasi ei julkaista. Pakolliset kentät on merkitty *